Home  >  Article  >  Backend Development  >  How to connect to the database using PHP and how to add data

How to connect to the database using PHP and how to add data

PHPz
PHPzOriginal
2023-03-29 11:30:39637browse

PHP (Hypertext Preprocessor) is a popular server-side programming language that is often used to create dynamic web pages, and connecting to a database is one of the most common tasks in PHP development. This article will introduce how to use PHP to connect to the database and how to add data.

  1. Connect to the database

First, you need to use the mysqli_connect() function in PHP to connect to the database. This function accepts four parameters: database hostname, username, password, and the name of the database to connect to. The following is sample code:

$server = "localhost"; // 主机
$username = "root"; // 用户名
$password = "password"; // 密码
$dbname = "mydb"; // 数据库名称

// 创建连接
$conn = mysqli_connect($server, $username, $password, $dbname);

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

Next, you can use the mysqli_query() function to add new data to the database. This function accepts two parameters: the connection object and the SQL query statement to be executed. Here is the sample code:

// 定义要添加的数据
$name = "John";
$age = 30;
$email = "john@example.com";

// SQL 查询语句
$sql = "INSERT INTO users (name, age, email) VALUES ('$name', '$age', '$email')";

// 执行查询
if (mysqli_query($conn, $sql)) {
    echo "新数据添加成功";
} else {
    echo "添加数据时出错:" . mysqli_error($conn);
}

In the above example, users is the table name, name, age and email is the column name. VALUES The following values ​​are the actual data to be added.

  1. Complete sample code

The following is the complete sample code, including connecting to the database and adding data:

$server = "localhost"; // 主机
$username = "root"; // 用户名
$password = "password"; // 密码
$dbname = "mydb"; // 数据库名称

// 创建连接
$conn = mysqli_connect($server, $username, $password, $dbname);

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

// 定义要添加的数据
$name = "John";
$age = 30;
$email = "john@example.com";

// SQL 查询语句
$sql = "INSERT INTO users (name, age, email) VALUES ('$name', '$age', '$email')";

// 执行查询
if (mysqli_query($conn, $sql)) {
    echo "新数据添加成功";
} else {
    echo "添加数据时出错:" . mysqli_error($conn);
}

// 关闭连接
mysqli_close($conn);
  1. Summary

Using PHP to connect and operate databases is a very common task. This article introduces how to connect to the database and how to add data. By studying this article, you can start using PHP to connect and operate databases.

The above is the detailed content of How to connect to the database using PHP and how to add data. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn