db3

<?php
$servername ="localhost";
$username="root";
$password="jit123";
$dbname="1jt14cs007db3";

$conn= new mysqli($servername,$username,$password,$dbname);

if($conn->connection_error)
    {
        die("CONN failed :" . $conn->connect_error);
    }
else
    {
        $sqlquery="select * from student";
        $result = $conn->query($sqlquery);
        if($result->num_rows>0)
        {echo "<table align=\"center\"border=1> <tr> <th> REG num </th> <th>STUDENT name</th><th>MAJOR</th><th>DOB</th></tr>";
            while($row=$result->fetch_assoc())
            {

                echo "<tr><td>$row[regno]</td><td>$row[name]</td><td>$row[major]</td><td>$row[dob]</td></tr>";

            }
            echo "</table>";
        }
        else echo "empty set";

    }


$conn->close();
?>