开发者

Create a list from SQL database using HTML/PHP

开发者 https://www.devze.com 2022-12-20 13:41 出处:网络
Im trying to create a drop down list/menu of users from my SQL database table. Could anyone help me with the code please? The code below is just for a normal list with options 1 & 2. How do i make

Im trying to create a drop down list/menu of users from my SQL database table. Could anyone help me with the code please? The code below is just for a normal list with options 1 & 2. How do i make the list retrieve all the items in a specific table using html/php/sql. Sorry im not very experienced with this, thanks in advance.

<select name="user" id="user"&g开发者_如何学运维t;
<option value="a" selected="selected">1</option>
<option value="b">2</option>
</select>


there are several ways but i'll show mine

First, take the data you want to retrieve from query:

$query = mysql_query("SELECT name, id FROM users");

Then echo a select followed by a while cycle to iterate the various options:

<?php
echo "<select name='user'>";
while ($temp = mysql_fetch_assoc($query) {
    echo "<option value='".$temp['id']."'>".$temp['name']."</option>";
}
echo "</select>";
?>

The result should be:

<select name="user">
   <option value='1'>User name 1</option>
   <option value='2'>User name 2</option>
</select>

Hope this was useful for you :)


PHP Dynamic Drop-down

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号