Creating a MySQL Table with PHP

In this tutorial, we will demonstrate how to create a MySQL table using PHP. PHP is a server-side scripting language that allows you to interact with databases, including MySQL. By utilizing PHP, you can add, retrieve, and manipulate data within your database.

Setting up a MySQL Connection

Before we can create a MySQL table, we need to establish a connection to the database. This can be done using the mysqli_connect() function. The function requires three parameters: the server name, username, and password.

<?php

$server = "localhost";
$username = "username";
$password = "password";

$conn = mysqli_connect($server, $username, $password);

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";

?>

Creating a MySQL Table

Once a connection has been established, we can proceed to create a table. The mysqli_query() function is used to execute SQL statements, including the creation of a table.

The following is an example of how to create a table with three columns: id, name, and email.

<?php

$sql = "CREATE TABLE users (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR(30) NOT NULL,
email VARCHAR(50)
)";

if (mysqli_query($conn, $sql)) {
    echo "Table created successfully";
} else {
    echo "Error creating table: " . mysqli_error($conn);
}

?>

Conclusion

In this tutorial, we have demonstrated how to create a MySQL table using PHP. By utilizing the mysqli_connect() and mysqli_query() functions, you can establish a connection to the database and execute SQL statements, including the creation of tables. With these tools, you can manage and manipulate your database with ease.


Do you find this helpful?