My SQL

My SQL

<?php

$c=mysql_connect("localhost","root","");

?>

Save as conn.php

<?php

include 'conn.php';

$db="create database student";

if(mysqli_query($c,$db))

{

echo "created";

}

else

{

echo "no create";

}

?>

<?php

$l=  mysqli_connect("localhost","root","","student");

if($l==false)

{                     

die("error".mysqli_connect_error());

}

$sql="CREATE TABLE admission(id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,s_name VARCHAR(30))";

if(mysqli_query($l,$sql))

{

echo "yes";

}

else

{

echo "error".mysqli_error($l);

}

?>

<?php

$li= mysqli_connect("localhost","root","","student");

$sql = "INSERT INTO admission (s_name) VALUES ('Peter')";

if(mysqli_query($li,$sql))

{

echo "yes";

}

else

{

echo "No";

}

?>

<?php

$c= mysqli_connect("localhost","root","","student");

$sql = "INSERT INTO admission (s_name) VALUES ('asha'),('usha') ";

if(mysqli_query($c,$sql))

{

echo "yes";

}

?>