php留言板后台管理-查看代码
$lianjie = mysql_connect("localhost","root","xiaolie") or die("连接失败");
mysql_query("set names utf8");
if($lianjie)
{
mysql_select_db("xiaolie");
if(!@$_GET["id"])
{
$jieguo = "select * from zhuce";
$fasong = mysql_query($jieguo) or die(mysql_error());
echo "
编号 | 用户名称 | 性别 | 年龄 | 注册时间 | 详细信息 |
while($nr=mysql_fetch_array($fasong))
{
echo "
".$nr["id"]."".$nr["name"]."".$nr["xingbie"]."".$nr["nianling"]."".$nr["zc_shijian"]." 查看";}
echo "
";}
else
{
$jieguo = "select * from zhuce where id=".$_GET["id"];
$fasong = mysql_query($jieguo);
$nr = mysql_fetch_array($fasong);
echo "编号:".$nr["id"]."
用户名称:".$nr["name"]."
性别:".$nr["xingbie"]."
年龄:".$nr["nianling"]."
注册时间:".$nr["zc_shijian"]."
";
echo "继续查询";
}
}
?>