<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "School";
$conn = new mysqli($servername, $username, $password, $dbname);
$sql = "SELECT * FROM Details";
 
if($conn == false)
{
    die("ERROR: Could not connect." .connect_error());
}
 
else
{
   if($result = $conn->query($sql))
   {
      if($result->num_rows > 0)
      {
        echo "<table border=1>";
          echo "<tr>";
              echo "<th>Admission</th> <th>Name</th> <th>Section</th> <th>Medium</th> <th>Transport</th> <th>Ambition</th>";
          echo "</tr>";
 
	while($row =$result->fetch_assoc())
	{
            echo "<tr>";
                echo "<td>" . $row['Admission'] . "</td>";
                echo "<td>" . $row['Name'] 	. "</td>";
                echo "<td>" . $row['Section'] 	. "</td>";
                echo "<td>" . $row['SubMedium'] . "</td>";
                echo "<td>" . $row['Transport'] . "</td>";
                echo "<td>" . $row['Ambition'] 	. "</td>";          
	    echo "</tr>";
        }
        echo "</table>";        
    } 
 
    else
    {
        echo "<br>"."No records matching your query were found.";
    }
 
  } 
  else
  {
    echo "<br>"."ERROR: Could not able to execute $sql. " . error($conn);
  } 
}
mysqli_close($conn);
?>