php mysql 删除记录, url传值删除数据
本款删除数据代码是一款根据用户url地址栏传过来的参数,再去mysql数据库中执行删除操作,PHP实例代码如下:
<?php
$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("<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['id']; & nbsp; < / td > < tdheight = "22" > & nbsp; < ? phpecho $row['name']; & nbsp; < / td > < tdheight = "22" > & nbsp; < ? phpecho $row['city']; & nbsp; < / td > < tdheight = "22" > & nbsp; < ? phpecho $row['created_time']; & nbsp; < / td > < tdheight = "22" > & nbsp; < aonclick = "javascript：if(confirm('确定要删除用户信息吗?')) return true; else return false;"href = "13-13.php?id=<?php echo $row['id']; " > 删除 < / a > & nbsp; < / td > < / tr > < ? php
}
}
mysql_close($conn);
?>
</table>
</body>
</center>
</html>
<?php
if (!isset($_get['id'])) {
echo '参数错误！';
exit;
}
$id = $_get['id'];
if (emptyempty($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("<br/>error: <b>" . mysql_error() . "</b><br/>sql：" . $sql);
if (!mysql_num_rows($result)) {
echo '用户id错误！';
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 '数据删除成功，返回<a href="13-12.php">13-12.php</a>查看数据';
?>本文地址：http://www.phprm.com/develop/fs4304.html
转载随意，但请附上文章地址:-)