PHP MySQL

MySQL INSERT INTO 语句用于在表中插入新记录。有两种使用 INSERT INTO 语句的方法，如下所述。

以下语法指定要插入的列名称和相应的值。

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

以下语法仅指定值values。因此，必须按照与表中列相同的顺序指定值。

INSERT INTO table_name 
VALUES (value1, value2, value3, ...);

除此之外，为了连接到 MySQL 服务器，可以使用 mysqli_connect() 函数。建立连接后，可以使用 mysqli_multi_query() 函数执行多个查询，以在给定表中插入多条记录。

将数据插入 MySQL 数据库 - 面向对象风格

下面的示例演示了如何以面向对象的方式在名为"Employee"的表中插入多条新记录。

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDatabase";

//建立连接
$mysqli = new mysqli($servername, $username, $password, $dbname);

//检查连接
if ($mysqli->connect_errno) {
  echo "Failed to connect to MySQL: ". $mysqli->connect_error;
  exit();
}

//插入多条记录的查询
$sql = "INSERT INTO Employee (EmpID, Name, City, Age, Salary)
VALUES (7, 'Suresh', 'Mumbai', 29, 2900);";
$sql .= "INSERT INTO Employee (EmpID, Name, City, Age, Salary)
VALUES (8, 'Zayne', 'Oslo', 31, 3400);";
$sql .= "INSERT INTO Employee (EmpID, Name, City, Age, Salary)
VALUES (9, 'John', 'London', 28, 2800);";

//执行查询
if (!$mysqli->query($sql)) {
  echo "Error inserting records: ". $mysqli->error;
} else { 
  echo "New records inserted successfully.";
}

//关闭连接
$mysqli->close();
?>

将数据插入 MySQL 数据库 - 面向过程

获得相同的结果使用面向过程风格，可以使用以下脚本。

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDatabase";

//建立连接
$mysqli = mysqli_connect($servername, $username, $password, $dbname);

//检查连接
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: ". mysqli_connect_error();
  exit();
}

//插入多条记录的查询
$sql = "INSERT INTO Employee (EmpID, Name, City, Age, Salary)
VALUES (7, 'Suresh', 'Mumbai', 29, 2900);";
$sql .= "INSERT INTO Employee (EmpID, Name, City, Age, Salary)
VALUES (8, 'Zayne', 'Oslo', 31, 3400);";
$sql .= "INSERT INTO Employee (EmpID, Name, City, Age, Salary)
VALUES (9, 'John', 'London', 28, 2800);";

//执行查询
if (!mysqli_query($mysqli, $sql)) {
  echo "Error inserting records: ". mysqli_error($mysqli);
} else { 
  echo "New records inserted successfully.";
}

//关闭连接
mysqli_close($mysqli);
?>

完整 PHP MySQLi 参考

有关 PHP MySQLi 扩展的所有属性、方法和功能的完整参考，请参阅 PHP MySQLi 参考.