drop down php form retrieve data from database

Solutions on MaxInterview for drop down php form retrieve data from database by the best coders in the world

showing results for - "drop down php form retrieve data from database"

09 Sep 2018

1<!DOCTYPE html>
2<html>
3<head>
4  <title>PHP Retrieve Data from MySQL using Drop Down Menu</title>
5</head>
6<body>
7
8<form>
9  City:
10  <select>
11    <option disabled selected>-- Select City --</option>
12    <?php
13        include "dbConn.php";  // Using database connection file here
14        $records = mysqli_query($db, "SELECT city_name From tblcity");  // Use select query here 
15
16        while($data = mysqli_fetch_array($records))
17        {
18            echo "<option value='". $data['city_name'] ."'>" .$data['city_name'] ."</option>";  // displaying data in option menu
19        }	
20    ?>  
21  </select>
22</form>
23
24<?php mysqli_close($db);  // close connection ?>
25
26</body>
27</html>
28

source

similar questions

get the selected value of dropdown php how to get data from html form in php fetch row in php php update sql database from form how to populate dropdown list with array values in php php select option selected from database how to set select option value dynamically in php updating a row from databse using php how to send input value in a database php how to download file from database php echo php dropdown from db and save it in a db edita row from databse using php get data from database in dropdown list php how to retrieve data from database using select option in laravel how to fetch data from database in php php code for fetching data from database php mysql update form with image upload get data from select option php php get selected value from dropdown without submit php get data from prepared select how to fetch data from url in php properly php form not reading from database

queries leading to this page

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 how to retrieve data from database using php from a selected drop down list get data in drop down from db php get data from select form php dropdown data from database php how to retrieve data from database whenever select in drop down list in php get dropdown data from database php get data from drop down in php retrieve data from database in table form from selected option php how to retrieve data from database when you select dropdown in php how to get form data from dropdown in php drop down php form retrieve data from database php form to select data from database select dropdown value from database in php drop down php form retrieve data from database