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>
