php mysql 删除记录, url传值删除数据

WBOY
发布： 2016-05-25 16:42:35
原创
803 人浏览过
本款删除数据代码是一款根据用户url地址栏传过来的参数,再去mysql数据库中执行删除操作,PHP实例代码如下:
<?php
$host = &#39;localhost&#39;;
$user_name = &#39;root&#39;;
$password = &#39;admin&#39;;
$conn = mysql_connect($host, $user_name, $password);
if (!$conn) {
    die(&#39;数据库连接失败：&#39; . mysql_error());
}
mysql_select_db(&#39;test&#39;);
$sql = &#39;select id,name,city,created_time from users&#39;;
$result = mysql_query($sql) or die("<br/>error: <b>" . mysql_error() . "</b><br/>产生问题的sql：" . $sql);
?>
<html> 
<head> 
<title>13-12.php</title> 
<script language="网页特效"> 
 
</script> 
</head> 
<center> 
 
<body> 
<table width="75%" border="0" cellpadding="0" cellspacing="1" bgcolor="#7b7b84"> 
    <tr bgcolor="#8bbcc7">  
        <td height="33"><div align="center"><strong>用户id</strong></div></td> 
        <td><div align="center"><strong>用户名称</strong></div></td> 
        <td><div align="center"><strong>来自城市</strong></div></td> 
        <td><div align="center"><strong>注册时间</strong></div></td> 
        <td><div align="center"><strong>操作</strong></div></td> 
    </tr> 
 
<?php
if ($num = mysql_num_rows($result)) {
    while ($row = mysql_fetch_array($result, mysql_assoc)) {
?>
    <tr bgcolor="#ffffff">  
        <td height="22" align="right"><?php
        echo $row[&#39;id&#39;]; & nbsp; < / td > < tdheight = "22" > & nbsp; < ? phpecho $row[&#39;name&#39;]; & nbsp; < / td > < tdheight = "22" > & nbsp; < ? phpecho $row[&#39;city&#39;]; & nbsp; < / td > < tdheight = "22" > & nbsp; < ? phpecho $row[&#39;created_time&#39;]; & nbsp; < / td > < tdheight = "22" > & nbsp; < aonclick = "javascript：if(confirm(&#39;确定要删除用户信息吗?&#39;)) return true; else return false;"href = "13-13.php?id=<?php echo $row[&#39;id&#39;]; " > 删除 < / a > & nbsp; < / td > < / tr > < ? php
    }
}
mysql_close($conn);
?>
</table> 
</body> 
</center> 
</html> 
 
<?php
if (!isset($_get[&#39;id&#39;])) {
    echo &#39;参数错误！&#39;;
    exit;
}
$id = $_get[&#39;id&#39;];
if (emptyempty($id)) {
    echo &#39;用户id不能为空！&#39;;
    exit;
}
$host = &#39;localhost&#39;;
$user_name = &#39;root&#39;;
$password = &#39;admin&#39;;
$conn = mysql_connect($host, $user_name, $password);
if (!$conn) {
    die(&#39;数据库连接失败：&#39; . mysql_error());
}
mysql_select_db(&#39;test&#39;);
//先判断是否存在该id的用户
$sql = "select * from users where id=$id";
$result = mysql_query($sql) or die("<br/>error: <b>" . mysql_error() . "</b><br/>sql：" . $sql);
if (!mysql_num_rows($result)) {
    echo &#39;用户id错误！&#39;;
    exit;
}
//删除用户数据//开源代码phprm.com
$sql = "delete from users where id=$id";
mysql_query($sql) or die("<br/>error: <b>" . mysql_error() . "</b><br/>sql：" . $sql);
mysql_close($conn);
echo &#39;数据删除成功，返回<a href="13-12.php">13-12.php</a>查看数据&#39;;
?>
登录后复制
本文地址：
转载随意，但请附上文章地址:-)