Insert Multiple query using php

I am going to explain how to insert multiple queries using php. It will reduce the time and increase the DB performance. Executes one or multiple queries which are concatenated by a semicolon.

DB Connection

$con=mysqli_connect("localhost","my_user","my_password","my_db");

Example Query

$query  = "INSERT INTO MyGuests (firstname, lastname, email) VALUES ('John', 'Doe', 'john@example.com');";

$query .= "INSERT INTO MyGuests (firstname, lastname, email) VALUES ('Mary', 'Moe', 'mary@example.com');";

$query .= "INSERT INTO MyGuests (firstname, lastname, email) VALUES ('Julie', 'Dooley', 'julie@example.com')";

insert_multiple($con,$query);

Multiple Insert Query Function

function insert_multiple($con,$query) {
   if (mysqli_multi_query($conn, $sql)){
      echo "New records created successfully";
   } else {
      echo "Error: " . $sql . "<br>" . mysqli_error($conn);
   }
  mysqli_close($conn);
}