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.