enter code here
p
<form action="" method="post">
<table>
<tr>
<td>Select route:</td>
<td>
<select name='route'>";
<?php
 $dbhost="localhost";
 $dbuser="root";
 $dbpass="";
 $db="system";

 $conn=new mysqli($dbhost,$dbuser,$dbpass,$db);
 if(!$conn){
 die("connection failed".mysqli_connect_error());
 }
      $sql="SELECT *FROM routes";
         $result=mysqli_query($conn,$sql);
           while($row = mysqli_fetch_array($result))
       {
   echo"<option value='".$row['route id']."'>".$row['route_name']."        </option>";
         }
      ?>

     </select>

p
</td>
</tr>
<tr>
<td>fare price to:</td>
<td><input type="text" name="route" placeholder=" route"></td>
</tr>
<tr>
<td>fare price from:</td>
<td> <input type="text" name="route" placeholder=" route"></td>
</tr>
</table>
<input type="submit" placeholder="Enter">
</form>
</div>
</body>
</html>