How can data be added to a database using PHP?

2 years ago
Ava Mitchell
2 minutes

In PHP, you can add data to a database by using SQL statements or using database manipulation functions.

The steps for adding data to a database using SQL statements are as follows:

  1. Connect to the database: Use either the mysqli_connect() function or the PDO class to connect to the database.
  2. Prepare SQL statement: Write SQL statement to insert data.
  3. Execute SQL statements: Use the mysqli_query() function or relevant methods of the PDO class to execute SQL statements.
  4. Close the database connection: Use the mysqli_close() function or relevant methods of the PDO class to close the database connection.

Here is an example of adding data to a database using the mysqli function.

<?php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");

// 检查连接是否成功
if (!$conn) {
    die("连接数据库失败: " . mysqli_connect_error());
}

// 准备SQL语句
$sql = "INSERT INTO table_name (column1, column2, column3)
VALUES ('value1', 'value2', 'value3')";

// 执行SQL语句
if (mysqli_query($conn, $sql)) {
    echo "数据添加成功";
} else {
    echo "数据添加失败: " . mysqli_error($conn);
}

// 关闭数据库连接
mysqli_close($conn);
?>

Another approach is to use database manipulation functions, such as using the PDO class for operations. Here is an example of adding data to a database using the PDO class:

<?php
// 连接数据库
$dsn = "mysql:host=localhost;dbname=database";
$username = "username";
$password = "password";

try {
    $conn = new PDO($dsn, $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

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

    // 执行SQL语句
    $stmt = $conn->prepare($sql);
    $stmt->bindParam(':value1', $value1);
    $stmt->bindParam(':value2', $value2);
    $stmt->bindParam(':value3', $value3);

    $value1 = 'value1';
    $value2 = 'value2';
    $value3 = 'value3';

    $stmt->execute();

    echo "数据添加成功";
} catch (PDOException $e) {
    echo "数据添加失败: " . $e->getMessage();
}

// 关闭数据库连接
$conn = null;
?>

There are two common ways to add data to a database in PHP, and the choice between them depends on individual needs and preferences.

bannerAds