MySQL Create Table

Creating a MySQL Table with PHP （使用PHP创建MySQL表）

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. （在本教程中，我们将演示如何使用PHP创建MySQL表。PHP是一种服务器端脚本语言，允许您与数据库（包括MySQL ）进行交互。通过使用PHP ，您可以在数据库中添加、检索和操作数据。）

Setting up a MySQL Connection #

Setting up a MySQL Connection （设置MySQL连接）

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 #

Creating a MySQL Table （创建MySQL表）

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. （建立连接后，我们可以继续创建表。mysqli_query ()函数用于执行SQL语句，包括创建表。）

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 #

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. （在本教程中，我们演示了如何使用PHP创建MySQL表。通过使用mysqli_connect ()和mysqli_query ()函数，可以建立与数据库的连接并执行SQL语句，包括创建表。使用这些工具，您可以轻松管理和操作数据库。）