Fetching data from MySQL database to HTML dropdown list

by

To do this you want to loop through each row of your query results and use this info for each of your drop down’s options. You should be able to adjust the code below fairly easily to meet your needs.

// Assume $db is a PDO object
$query = $db->query("YOUR QUERY HERE"); // Run your query

echo '<select name="DROP DOWN NAME">'; // Open your drop down box

// Loop through the query results, outputing the options one by one
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
   echo '<option value="'.htmlspecialchars($row['something']).'">'.htmlspecialchars($row['something']).'</option>';
}

echo '</select>';// Close your drop down box

More Related Contents:

  1. Getting links from db and displaying them in another div [closed]
  2. HTML Form/PHP connected but MySQL is empty
  3. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  4. Php charset information [duplicate]
  5. Save the data into a database and return another value from database using PHP
  6. Math Symbol From Mysql To HTML? [closed]
  7. Thank you for helping [closed]
  8. Is the following code valid? [closed]
  9. How to insert images into a database using PHP [closed]
  10. How to retrieve images from MySQL database and display in an html tag
  11. Preserve Line Breaks From TextArea
  12. HTML – Change\Update page contents without refreshing\reloading the page
  13. “slash before every quote” problem [duplicate]
  14. mysql_fetch_array() expects parameter 1 to be resource problem [duplicate]
  15. Using PHP to populate a dropdown? [duplicate]
  16. Dynamic table in HTML using MySQL and php
  17. mysqli_query() expects at least 2 parameters, 1 given in? [duplicate]
  18. display data from SQL database into php/ html table [closed]
  19. Echo menu tree with recursive function
  20. How to display an BLOB image stored in MySql database?
  21. Sending HTML Code Through JSON
  22. Javascript function post and call php script
  23. PHP – Secure member-only pages with a login system
  24. PHP: Inserting Values from the Form into MySQL
  25. onbeforeprint() and onafterprint() equivalent for non IE browsers
  26. Creating dynamic tables in HTML using MySQL and PHP
  27. Turkish characters are not displayed correctly [duplicate]
  28. mysql_fetch_array skipping first row
  29. Using PHP to upload file and add the path to MySQL database
  30. MySQL PHP – SELECT WHERE id = array()? [duplicate]

Leave a Comment