【www.gdgbn.com--php函数】
$link_id = mysql_connect("localhist","root","qwaszx") or die("连接失败!");
if($link_id)
{
mysql_select_db("my_test");
if(!$_GET[id])
{
$result = mysql_query("select * from userinfo");
echo "
编号
用户名称
性别
年龄
注册时间
操作
";
while($row = mysql_fetch_array($result))
{
echo "
".$row[id]."
".$row[uername]."
".$row[gender]."
".$row[age]."
".$row[regdate]."
编辑
";
}
echo "";
}else
{
if(!$_POST[ok])
{
$sql = "select * frim userinfo where id = ".$_GET[id];
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
?>
}else
{
$sql = "update userinfo set username = "".$_POST[username]."",gender = "".$_POST[gender]."",age = "".$_POST[age]."",regdate = "".$_POST[regdate].""where id = "".$_POST[id].""";
$result = mysql_query($sql);
if($result)
echo "记录已经成功修改
"继续修改记录;
else
echo "记录修改失败
返回";
}
}
}