<?php
$sql = array();
foreach( $data as $row ) {
$sql[] = '("'.mysql_real_escape_string($row['name']).'", '.$row['email'].')';
}
mysql_query('INSERT INTO test (name, email) VALUES '.implode(',', $sql));
?>
Using MySQLIi :
<?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "test";// Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); }$sql = "INSERT INTO test (name, email) VALUES ('Saurabh', 'saurabh@coding4developers.com');"; $sql .= "INSERT INTO test (name, email) VALUES ('Gaurav', 'gaurav@coding4developers.com');"; $sql .= "INSERT INTO test (name, email) VALUES ('Sachin', 'sachin@coding4developers.com');";if ($conn->multi_query($sql) === TRUE) { echo "New records created successfully"; } else { echo "Error: " . $sql . "<br>" . $conn->error; }$conn->close(); ?>