Untitled

<?php
$servername = "localhost";
$username = "test";
$password = "Qwe@123456";
$dbname = "mydb";
$conn = mysqli_connect($servername,$username,$password,$dbname);
if (!$conn){
   die("Connection failed: " . mysqli_connect_error());
}
mysqli_query("set names utf8");
$data = mysqli_query("select * from mydb");
?>
<!DOCTYPE html>
<head>
<meta charset = "utf-8" >
<title>reverse mysql to php </title>
</head>

<body>
<p>

</p>
<table width = "700" border ="1">
  <tr>
     <td>ID</td>
     <td>f</td>
     <td>direction</td>
  </tr>

<?php

for($i = 1;$i<=mysqli_num_rows($data);$i++) {
$rs = mysqli_fetch_row($data);
?>

  <tr>
     <td><?php echo $rs[0]?></td>
     <td><?php echo $rs[1]?></td>
     <td><?php echo $rs[2]?></td>
  </tr>
<?php
}
?>
</table>
<p>&nbsp;</p>
</body>
</html>