PHP and PDO: How to insert data into a MySQL database

PHP and PDO: How to insert data into a MySQL database

Overview:
This article will introduce how to use PHP's PDO extension to insert data into a MySQL database. PDO is a database access abstraction layer for PHP that can interact with a variety of databases, including MySQL.

Steps:

1. Connect to MySQL database:
   Before using PDO to insert data, we need to establish a connection with the MySQL database first. Below is a sample code showing how to connect to a MySQL database.

// 设置数据库连接参数
$host = 'localhost';
$dbname = 'database_name';
$username = 'username';
$password = 'password';

// 连接到数据库
try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "成功连接到数据库";
} catch (PDOException $e) {
    echo "连接数据库失败: " . $e->getMessage();
}

2. Prepare SQL statement:
   Before inserting data, we need to prepare a SQL statement. SQL statements are used to specify operations to be performed, including inserting data, updating data, or deleting data. Below is a sample code that shows how to prepare a SQL statement to insert data.

// 准备插入数据的SQL语句
$sql = "INSERT INTO table_name (column1, column2, column3) VALUES (:value1, :value2, :value3)";

In the above SQL statement, table_name is the name of the table to be inserted into, column1, column2, column3 is the name of the column to be inserted. VALUES (:value1, :value2, :value3) is used to specify the data to be inserted, where :value1, :value2, :value3 is a placeholder, we will Use placeholders in place of real data.

3. Bind parameters:
   Before executing the SQL statement, we need to bind the placeholder with the real data. Below is a sample code showing how to bind parameters.

// 绑定参数
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':value1', $value1);
$stmt->bindParam(':value2', $value2);
$stmt->bindParam(':value3', $value3);

In the above code, $stmt->bindParam(':value1', $value1) is used to place :value1 The symbol is bound to the $value1 variable.

4. Perform the insertion operation:
   After binding the parameters, we can perform the insertion operation. Below is a sample code showing how to perform an insert operation.

// 执行插入操作
try {
    $value1 = 'John';
    $value2 = 'Doe';
    $value3 = 'john@example.com';

    $stmt->execute();
    echo "成功插入数据";
} catch (PDOException $e) {
    echo "插入数据失败: " . $e->getMessage();
}

In the above code, we set $value1, $value2, $value3 to the data to be inserted, and then call $stmt->execute () method to perform the insertion operation.

5. Close the database connection:
   After inserting data, we need to close the connection with the database and release resources. Below is a sample code showing how to close the connection.

// 关闭数据库连接
$pdo = null;

In the above code, we set $pdo to null to close the connection to the database.

Summary:
This article introduces how to use PHP's PDO extension to insert data into a MySQL database. Specific steps include connecting to the MySQL database, preparing SQL statements, binding parameters, performing insert operations, and closing the database connection. By studying this article, you will be able to have a good grasp of how to use PDO to insert data into a MySQL database.

The above is the detailed content of PHP and PDO: How to insert data into a MySQL database. For more information, please follow other related articles on the PHP Chinese website!