Untitled

<!DOCTYPE html>
<html>
<body>
<style>
table, td, th
{
border: 1px solid black;
width: 33%;
text-align: center;
background-color:lightblue;
}
</style>

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "UP";
$a=array();

// Create connection
// Opens a new connection to the MySQL server

$conn = mysqli_connect($servername, $username, $password, $dbname);

if ($conn->connect_error)

die("Connection failed: " . $conn->connect_error);

$sql = "SELECT * FROM student";
//      performs a query against the database
 $result = $conn->query($sql);

echo "<br>";
echo "<center> BEFORE SORTING </center>";
 echo "<table align='center'>";
echo "<tr>";

echo "<th>USN</th><th>NAME</th><th>Address</th></tr>";
 if ($result->num_rows> 0)
{
 while($row = $result->fetch_assoc())
 {
 echo "<tr>";
 echo "<td>". $row["usn"]."</td>";
 echo "<td>". $row["name"]."</td>";
 echo "<td>". $row["address"]."</td></tr>";
 array_push($a,$row["usn"]);
 }
}
else
 echo "Table is Empty";
 echo "</table>";
$n=count($a);

$b=$a;
for ( $i = 0 ; $i< ($n - 1) ; $i++ )
{
 $pos= $i;
 for ( $j = $i + 1 ; $j < $n ; $j++ )
 {
  if ( $a[$pos] > $a[$j] )
  $pos= $j;
 }

 if ( $pos!= $i )
 {
  $temp=$a[$i];
  $a[$i] = $a[$pos];
  $a[$pos] = $temp;
 }
}

$c=array();
$d=array();
$result = $conn->query($sql);

if ($result->num_rows> 0)// output data of each row
{
while($row = $result->fetch_assoc()) {

for($i=0;$i<$n;$i++) {
if($row["usn"]== $a[$i]) {
$c[$i]=$row["name"];
$d[$i]=$row["address"];
}
}
}
}
echo "<br>";
echo "<center> AFTER SORTING <center>";
echo "<table border='2'>";
echo "<tr>";

echo "<th>USN</th><th>NAME</th><th>Address</th></tr>";
for($i=0;$i<$n;$i++)
{
 echo "<tr>";
 echo "<td>". $a[$i]."</td>";
 echo "<td>". $c[$i]."</td>";
 echo "<td>". $d[$i]."</td></tr>";
}
echo "</table>";
$conn->close();
?>
</body>
</html>