MySQL Insert Data

How to Insert Data into a MySQL Database using PHP （如何使用PHP将数据插入MySQL数据库）

In this article, we will guide you through the steps of inserting data into a MySQL database using PHP. With the use of PHP and MySQL, it is possible to build dynamic, interactive websites and web applications. （在本文中，我们将指导您完成使用PHP将数据插入MySQL数据库的步骤。使用PHP和MySQL ，可以构建动态的交互式网站和Web应用程序。）

Prerequisites #

Prerequisites （前提条件）

Before we start, there are a few prerequisites that you should have in place:

• A web server with PHP installed （-安装了PHP的Web服务器）

• A MySQL database （MySQL数据库）

• Access to the PHPMyAdmin interface or similar database management tool （-访问PHPMyAdmin界面或类似的数据库管理工具）

Establishing a Connection #

Establishing a Connection （建立联系）

The first step in inserting data into a database using PHP is to establish a connection to the database. This is done by using the mysqli_connect() function, which requires the following parameters:

• The name of the database server （数据库服务器的名称。）

• The username used to access the database （-用于访问数据库的用户名）

• The password for the database user （-数据库用户的密码）

• The name of the database to connect to （-要连接的数据库的名称）

Here is an example of how to establish a connection to a database:

<?php

$server = "localhost";
$username = "root";
$password = "password";
$database = "database_name";

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

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

?>

Writing the SQL Statement #

Writing the SQL Statement （编写SQL语句）

Once a connection to the database has been established, the next step is to write the SQL statement that will be used to insert the data into the database. （建立与数据库的连接后，下一步是编写SQL语句，该语句将用于将数据插入数据库。）

Here is an example of a SQL statement that inserts data into a database table:

INSERT INTO table_name (column1, column2, column3)
VALUES ('value1', 'value2', 'value3');

Executing the SQL Statement #

Executing the SQL Statement （执行SQL语句）

Once the SQL statement has been written, the next step is to execute it. This is done by using the mysqli_query() function, which requires the following parameters:

• The connection to the database （-与数据库的连接）

• The SQL statement to be executed （-要执行的SQL语句）

Here is an example of how to execute the SQL statement:

<?php
$sql = "INSERT INTO table_name (column1, column2, column3)
VALUES ('value1', 'value2', 'value3')";

if (mysqli_query($conn, $sql)) {
   echo "New record created successfully";
} else {
   echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
?>

Closing the Connection #

Closing the Connection （关闭连接）

Once the data has been inserted into the database, it is important to close the connection to the database. This is done using the mysqli_close() function, which requires the following parameter:

• The connection to the database （-与数据库的连接）

Here is an example of how to close the connection to the database:

<?php

mysqli_close($conn);

?>

Conclusion #

Conclusion （小结）

In this article, we have shown you how to insert data into a MySQL database using PHP. By following these steps, you should be able to insert data into your database with ease. If you have any questions or need further assistance, please do not hesitate to ask. （在本文中，我们向您展示了如何使用PHP将数据插入MySQL数据库。按照这些步骤，您应该能够轻松地将数据插入数据库。如果您有任何疑问或需要进一步的帮助，请随时联系我们。）