Using PHP to populate a dropdown? [duplicate]

by

What about something like this :

echo '<select name="select">';
while($row=mysql_fetch_array($result))
{
    echo '<option value="' . htmlspecialchars($row['column_for_value']) . '">' 
        . htmlspecialchars($row['column_for_label']) 
        . '</option>';
}
echo '</select>';

Of course, up to you to decide which items from $row should be used for the value and the text of each <option>

Just make sure you are escaping the data that comes from your DB — especially if it can contain HTML ; as you are outputting HTML, this can be done with htmlspecialchars or htmlentities.

Note that those might take a couple of additionnal parameters that I didn’t use in my example — setting those can be useful, depending on the charset you’re using.

More Related Contents:

  1. Fetching data from MySQL database to HTML dropdown list
  2. Get Text From Tag Using PHP
  3. How to add variation stock status to Woocommerce product variation dropdown
  4. How to set an option from multiple options or array with different values to views as selected in select box using PHP
  5. The best way passing value from jQuery to PHP
  6. how to set progress bar in file uploading using jquery? [closed]
  7. Writing PHP functions that has many parameters/modifiers [closed]
  8. Tagging systems [closed]
  9. Row count with PDO
  10. When do I use the PHP constant “PHP_EOL”?
  11. How do I compare two DateTime objects in PHP 5.2.8?
  12. HTML/PHP – Form – Input as array
  13. Print array to a file
  14. Removing array item by value [duplicate]
  15. Check whether the string is a unix timestamp
  16. What’s the best way to pass a PHP variable to Javascript? [duplicate]
  17. How to run array_filter recursively in a PHP array?
  18. Why am I getting mime-type of .csv file as “application/octet-stream”?
  19. Preg match text in php between html tags
  20. CodeIgniter default controller in a sub directory not working
  21. Alternative for mysql_num_rows using PDO
  22. Updating product stock programmatically in Woocommerce 3
  23. PHP: add seconds to a date
  24. PHP sending variables to file_get_contents()
  25. Upload doesn’t work right when the file is too big
  26. Is there a way to redefine a type hint to a descendant class when extending an abstract class?
  27. Ensuring valid UTF-8 in PHP
  28. How to get last insert id in Eloquent ORM laravel
  29. Use a PHP variable in JQuery
  30. Handling multiple file uploads in Sonata Admin Bundle

Leave a Comment