getting data from mysql to drop down menu 28select box 29

Solutions on MaxInterview for getting data from mysql to drop down menu 28select box 29 by the best coders in the world

showing results for - "getting data from mysql to drop down menu 28select box 29"

29 Jul 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

show a second dropdown based on previous dropdown selection in php get data from database in dropdown list php how to populate dropdown list with array values in php php dynamic select 2foption from mysql table get the selected value of dropdown php get data from select option php

queries leading to this page

drop down php form retrieve data from database how to retrieve data from database whenever select in drop down list in php retrieve data from database in table form from selected option php how to get form data from dropdown in php how to retrieve data from database when you select dropdown in php get data in drop down from db php select dropdown value from database in php php form to select data from database how to get drop down data on id in sql server code in php get dropdown data from database php how to retrieve data from database using php from a selected drop down list dropdown data from database php display only 5 data from database in dropdown menu in php get data from drop down in php getting data from mysql to drop down menu 28select box 29