【www.gdgbn.com--word】
代码如下$host = "localhost";
$user_name = "root";
$password = "admin";
$conn = mysql_connect($host,$user_name,$password);
if(!$conn)
{
die("数据库连接失败:".mysql_error());
}
mysql_select_db("test");
$sql = "select id,name,city,created_time from users";
$result = mysql_query($sql) or die("
error: ".mysql_error()."
产生问题的sql:".$sql);
?>
<script language="网页特效">
</script>
用户id
用户名称
来自城市
注册时间
操作
if($num = mysql_num_rows($result))
{
while($row = mysql_fetch_array($result,mysql_assoc))
{
?>
">删除
}
}
mysql_close($conn);
?>
代码如下
if(!isset($_get["id"]))
{
echo "参数错误!";
exit;
}
$id = $_get["id"];
if(empty($id))
{
echo "用户id不能为空!";
exit;
}
$host = "localhost";
$user_name = "root";
$password = "admin";
$conn = mysql_connect($host,$user_name,$password);
if(!$conn)
{
die("数据库连接失败:".mysql_error());
}
mysql_select_db("test");
//先判断是否存在该id的用户
$sql = "select * from users where id=$id";
$result = mysql_query($sql) or die("
error: ".mysql_error()."
sql:".$sql);
if(!mysql_num_rows($result))
{
echo "用户id错误!";
exit;
}
//删除用户数据
$sql = "delete from users where id=$id";
mysql_query($sql) or die("
error: ".mysql_error()."
sql:".$sql);
mysql_close($conn);
echo "数据删除成功,返回13-12.php查看数据";