PHP Insert Multiple Records Into MySQL

Insert is the process of inserting data into the table. INSERT statement adds new rows into already present table. The present chapter “PHP Insert Multiple Records Into MySQL” shows how to insert various records into the Database.

Example -

<!DOCTYPE html>
<html>
    <body>
        <?php 
            $HostName = "localhost"; 
            $UserName = "root"; 
            $Password = "password"; 
            $dbname="accounts"; 
              
            // Create connection 
            $connection = new mysqli($HostName, $UserName, $Password, $dbname); 
              
            // Check connection 
            if ($connection->connect_error) 
            {
                die("Connection failed: " . $connection->connect_error);
            } 
  
            //Inserting records into the database
            $sql = "INSERT INTO users2 (Username, Password, First, Last)
            VALUES ('Adam', 'password1', 'Adam', 'Gilchrist'),
             ('John', 'password2', 'John', 'Kennedy'),
            ('Michael', 'password3', 'Michael', 'Jackson')";
  
            if ($connection->multi_query($sql) === TRUE) 
            {
                echo "New records created successfully";
            } 
            else
            {
                echo "Error: " . $sql . "<br>" . $connection->error;
            }
  
            $connection->close();
        ?>
    </body>
</html>

Multiple SQL statements must be executed with the mysqli_multi_query() function.