本款删除数据代码是一款根据用户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>查看数据';
?>本文地址：
转载随意，但请附上文章地址:-)
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Dreamweaver CS6
Visual web development tools
DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software
SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
Zend Studio 13.0.1
Powerful PHP integrated development environment
ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment
