Populate a Drop down box from a mySQL table in PHP

by

You will need to make sure that if you’re using a test environment like WAMP set your username as root.
Here is an example which connects to a MySQL database, issues your query, and outputs <option> tags for a <select> box from each row in the table.

<?php

mysql_connect('hostname', 'username', 'password');
mysql_select_db('database-name');

$sql = "SELECT PcID FROM PC";
$result = mysql_query($sql);

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

?>

More Related Contents:

  1. Laravel – only a zero is saved to the database
  2. storing user_id in session variable
  3. I am seeing this error on submitting form Error: query was empty [closed]
  4. Reference: What is a perfect code sample using the MySQL extension? [closed]
  5. Convert from MySQL datetime to another format with PHP
  6. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  7. How do I set ORDER BY params using prepared PDO statement?
  8. Passing an array to a query using a WHERE clause
  9. PHP/MySQL Insert null values
  10. How can I get enum possible values in a MySQL database?
  11. Mechanisms for tracking DB schema changes [closed]
  12. Can you add an if statement in ORDER BY?
  13. Error while sending QUERY packet
  14. How to sort rows of HTML table that are called from MySQL
  15. PDO fetch one column from table into 1-dimensional array
  16. PHP: Calling MySQL Stored Procedure with Both INPUT AND OUTPUT Parameters (NOT “INOUT”)
  17. Detect mysql update/insertion failure due to violated unique constraint
  18. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  19. Get all mysql selected rows into an array
  20. Select from mysql table WHERE field=’$array’?
  21. How to bind SQL variables in PHP?
  22. PHP – Secure member-only pages with a login system
  23. MySQL ORDER BY IN()
  24. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  25. php password_verify() hash and pass won’t match
  26. MySQL query using an array [duplicate]
  27. PHP mySQL – Insert new record into table with auto-increment on primary key
  28. When should I close a database connection in PHP?
  29. php connection pooling mysql [duplicate]
  30. PHP/MySQL Pagination

Leave a Comment