PHP MySQL Insert Multiple Records

Using MySQLi  add multiple records to MySQL

With the mysqli_multi_query() function, you must run more than one SQL statement.

The \”student\” table gets three new rows from the following examples:

?php
$servername = \”localhost\”;
$username = \”username\”;
$password = \”password\”;
$dbname = \”school\”;

// Create connection
$link = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$link) {
die(\”Connection failed: \” . mysqli_connect_error());
}

$sql = \”INSERT INTO student (firstname, lastname, email)
VALUES (\’ram\’, \’lal\’, \’ramlal@example.com\’);\”;
$sql .= \”INSERT INTO student (firstname, lastname, email)
VALUES (\’shyam\’, \’lal\’, \’shyam@example.com\’);\”;
$sql .= \”INSERT INTO student (firstname, lastname, email)
VALUES (\’ajay\’, \’lal\’, \’ajay@example.com\’)\”;

if (mysqli_multi_query($link, $sql)) {
echo \”New records created successfully\”;
} else {
echo \”Error: \” . $sql . \”<br>\” . mysqli_error($link);
}

mysqli_close($link);
?>