PHP从数据库中下载数据 [英] PHP Drop Down Data from Database
本文介绍了PHP从数据库中下载数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在根据我的数据库为数据设置 select field
。所以,基本上,我想让它为我的数据库中的所有用户下拉菜单。所以喜欢而不是做:
I am trying to make an select field
for data according to my database. So, basically, I want it to have a dropdown menu for all the users in my database. So like instead of doing:
<select>
<option>1st User in Db</option>
<option>2nd User in Db</option>
</select>
它只是自动显示所有。
我尝试获取$ row ['uname'],并将其设置为$ user,但是在下拉列表中仅显示MY用户。
I tried fetching a $row['uname'], and setting it as $user, but then it only shows MY user in the dropdown.
它只显示我的帐户,而不是所有其他帐户。有谁知道该怎么做?谢谢!
It only shows my account, admin, instead of all the other ones. Anyone know how to do this? Thanks!
推荐答案
<?php
session_start();
include 'config.php';
$user = $_SESSION['username'];
$qry=("SELECT `rank`, `uname` FROM users WHERE uname='$user'");
$result=mysql_query($qry);
$row = mysql_fetch_assoc($result);
$rank = $row["rank"]
if ($_SESSION['loggedin'] == true) {
if ($rank >= 3) {
$qry=("SELECT `rank`, `uname` FROM users");
$result=mysql_query($qry);
echo "
<form action='' method='POST'>
<select>";
while ($row = mysql_fetch_assoc($result)) {
$rank = $row['rank'];
$users = $row['uname'];
$lol = ucwords($users);
echo "<option>$lol</option>";
}
echo "</select>
</form>
";
} else {
echo "Your level is not 3, but you are logged in.";
}
} else {
echo "Please login.";
}
这篇关于PHP从数据库中下载数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文