qn16

 <?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 = "SELECT *FROM STUDENT";

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

if($result->num_rows > 0)

{

while($row = $result->fetch_assoc())

{

echo $row["SID"] ." - ".$row["SNAME"] ."-".$row["GRADE"]

."<br>";

}

}

else

echo "Zero Record Found!";

?>