How to Insert Multiple Record in PHP MySQL

TechVidvan Team
2 years ago
Program 1

<html>
<body>
    <center>
<pre>

<?php
        // Connection
        $servername="localhost";
        $username="root";
        $password="";
        $dbname="Library";
        $mycon=mysqli_connect($servername,$username,$password,$dbname);
        if($mycon->connect_error)
        die("Connection failed....");
       else
       {
             echo " Connection success<br>";
             $sql="insert into student values(105,'Ranu','Mtech');";
             $sql.="insert into student values(106,'Vishal','Btech');";
             $sql.="insert into student values(107,'Bittu','MCA')";
             $mycon->multi_query($sql);
             echo "Multiple record inserted......";
             $mycon->close();
       }
?>
</pre>
</center>
</body>
</html>