Home > Article > Backend Development > How to connect to the database using PHP and how to add data
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.
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()); }
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.
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);
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!