Qn 15

 <?php

$server = "localhost";

$user = "root";

$password = "";

$database = "SUJIT";

$conn = new mysqli($server,$user,$password,$database);

if($conn->connect_error)

{

die("unable to connect to database");

}

$sql = "CREATE TABLE STUDENT(

        SID INT PRIMARY KEY,

        SNAME VARCHAR(20),

        GRADE INT      

              )";

$result = $conn->query($sql);

if($result === TRUE)

echo "Table created Successfully!";

$sql = "INSERT INTO STUDENT(SID,SNAME,GRADE) VALUES(1,'SUJIT THAPA' , 12)";

$result = $conn->query($sql);

if($result === TRUE)

{

echo " Data Inserted Successfully!";

}

$conn->close();

?>