Water
Water
Programming language:PHP
2021-03-24 11:21:24
0
Q:

drop down php form retrieve data from database

Adam
Adam
Code: PHP
2021-06-28 10:15:05 
<!DOCTYPE html>
<html>
<head>
  <title>PHP Retrieve Data from MySQL using Drop Down Menu</title>
</head>
<body>

<form>
  City:
  <select>
    <option disabled selected>-- Select City --</option>
    <?php
        include "dbConn.php";  // Using database connection file here
        $records = mysqli_query($db, "SELECT city_name From tblcity");  // Use select query here 

        while($data = mysqli_fetch_array($records))
        {
            echo "<option value='". $data['city_name'] ."'>" .$data['city_name'] ."</option>";  // displaying data in option menu
        }	
    ?>  
  </select>
</form>

<?php mysqli_close($db);  // close connection ?>

</body>
</html>
0

Tags

Related

New to Communities?

Join the community