PHP code to populate records in a table

<?php
 //database connect
 $db=mysqli_connect("localhost","root","","mycompanyhr");

   //checking database connection
 if ($db==false) {
   echo "Connect failed: ". mysqli_connect_error($db);
   exit();
 }
 else {
   echo "Connection successful";
 }

$sql="select EMPNO, FIRSTNAME, LASTNAME, WORKDEPT, PHONENO
  from employee";

$rs=mysqli_query($db,$sql);
if($rs==false){
 echo ("Query cannot be executed!<br>");
 echo ("SQL Error : ".mysqli_error($db));
}
else{
 echo "<table border=1>";
 echo "<tr>";
 echo "<td>Employee no</td>";
 echo "<td>Firstname</td>";
 echo "<td>Lastname</td>";
 echo "<td>Department</td>";
 echo "<td>Extension</td>";
 echo "</tr>";
 echo "</table>";
 while($rekod=mysqli_fetch_array($rs)){
   echo " Employee no: ".$rekod['EMPNO']."<br>";
   echo " First name: ".$rekod['FIRSTNAME']."<br>";
   echo " Last name: ".$rekod['LASTNAME']."<br>";
   echo " Department code: ".$rekod['WORKDEPT']."<br>";
   echo " Phone no: ".$rekod['PHONENO']."<hr>";
 }
}
?>