drop down php form retrieve data from database
<!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>
Are there any code examples left?
New code examples in category PHP
Relative searches
how to get form data from dropdown in php
get dropdown data from database php
get data from drop down in php
get data in drop down from db php
how to retrieve data from database when you select dropdown in php
retrieve data from database in table form from selected option php
how to retrieve data from database using php from a selected drop down list
dropdown data from database php
how to retrieve data from database whenever select in drop down list in php
drop down php form retrieve data from database
select dropdown value from database in php
display only 5 data from database in dropdown menu in php
how to get drop down data on id in sql server code in php
