PHP - How do you get the values of a dropdown from SQL

Question

Say I've got a dropdown list on my site like this:

<select>
<option value="test">Volvo</option>
<option value="icles">Saab</option>
<option value="lol">Mercedes</option>
<option value="hax">Audi</option>
</select>

But I don't want the above values, what if I want to get the values from an SQL table, how would I do this? Obviously this would be PHP but could someone give me an example?

You need to extract those key => value pair from a table, and then simply use `foreach` to display them — Yang, Nov 05 '14 at 15:45
possible duplicate of [Populate a Drop down box from a mySQL table in PHP](http://stackoverflow.com/questions/5189662/populate-a-drop-down-box-from-a-mysql-table-in-php) — Gergo Erdosi, Nov 05 '14 at 15:46
If this is a drop-down list, then what is this `ul > li > ul > li`? — Yang, Nov 05 '14 at 15:47
@Ares There are jquery plugins for so-called drop-down lists, and those drop-down lists look consists of `ul > li`, not of selectbox. — Yang, Nov 05 '14 at 15:50
@bad_boy ow... I see what you mean now... I thought you saw them in the OP's question :)) — Ares Draguna, Nov 05 '14 at 15:55

score 2 · Accepted Answer · answered Nov 05 '14 at 15:45

2

you will have to do it like this:

first select the values:

$result = "SELECT * from table";

then you will have to foreach() those values and create your selectbox like this:

echo '<select>';
foreach($result as $res) {
   echo '<option value="'.$res['somevalue'].'">' . $res['car_name'] . '</option>';
}
echo '</select>';

and you're done :D

answered Nov 05 '14 at 15:45

Ares Draguna

1,641
2
16
32

In your code, $result is a string. You can't use it in a foreach() – I wrestled a bear once. Nov 05 '14 at 15:48
You could be more cool, and do not print html tags, like ` – Yang Nov 05 '14 at 15:48
@user3092432 you were downvoted by other users because you did not post something that you have tried... there are some rules on how to post. Please accept answer if it indeed helped you – Ares Draguna Nov 05 '14 at 15:49
@Adelphia the user did not specifically asked for that, I just gave him a really STANDARD example ;) – Ares Draguna Nov 05 '14 at 15:50
@Ares user can't downvote because it requires at least 125 reputation – Yang Nov 05 '14 at 15:51
@bad_boy I was talking about other users who downvoted his question – Ares Draguna Nov 05 '14 at 15:51
@Adelphia in your answer you provide a PDO example... how do you know he uses PDO? Maybe he uses mysqli... or better yet, mysql function... Is this why you got downvoted? – Ares Draguna Nov 05 '14 at 15:52
plus... broken code? That is not a code at all... who would name the table `"table"` and column `"somevalue"`? Jeez... it is JUST an example, not working code – Ares Draguna Nov 05 '14 at 15:54
@Adelphia I didn't donwvote you ;) sorry but that is not mine – Ares Draguna Nov 05 '14 at 15:55
@user3092432 please accept this answer if it helped you, or Adelphia's answer so we can get this over with. Thank you! – Ares Draguna Nov 05 '14 at 15:58

PHP - How do you get the values of a dropdown from SQL

1 Answers1