<td><a href="editUser.php">更新</a>|
<a href="doAction.php?act=delUser&id=<?php echo $row['id'];?>">删除</a></td>
$id = isset($_GET['id']) ? $_GET['id'] : "";
case 'delUser':
$sql = "DELETE FROM user WHERE id=" . $id;
$res = $mysqli->query($sql);
if ($res) {
$mes = "删除成功";
} else {
$mes = "删除失败";
}
$url = "test.php";
echo "<script type='text/javascript'>
alert('{$mes}');
location.href='{$url}';
</script>";
exit();
break;
test.php
<?php
$mysqli = new mysqli('localhost', 'root', '', 'test');
if ($mysqli->connect_errno) {
die('CONNECT ERROR : ' . $mysqli->connect_error);
}
$sql = "SELECT id,username,age FROM user";
$mysqli_result = $mysqli->query($sql);
if ($mysqli_result && $mysqli_result->num_rows > 0) {
while ($row = $mysqli_result->fetch_assoc()) {
$rows[] = $row;
}
}
?>
<html>
<head>
<title>Document</title>
</head>
<body>
<h2>用户列表-<a href="addUser.php">添加用户</a></h2>
<table border="1" cellpadding="0" cellspacing="0" width="80%" bgcolor="#ABCDE">
<tr>
<td>编号</td>
<td>用户名</td>
<td>年龄</td>
<td>操作</td>
</tr>
<?php $i = 1;
foreach ($rows as $row): ?>
<tr>
<td><?php echo $i ?></td>
<td><?php echo $row['username']; ?></td>
<td><?php echo $row['age']; ?></td>
<td><a href="editUser.php">更新</a>|<a href="doAction.php?act=delUser&id=<?php echo $row['id'];?>">删除</a></td>
</tr>
<?php $i++;endforeach; ?>
</table>
</body>
</html>
doAction.php
<?php
header("Content-type:text/html;charset=utf-8");
$mysqli = @new mysqli('localhost', 'root', '', 'test');
if ($mysqli->connect_errno) {
die($mysqli->connect_error);
}
$mysqli->set_charset('utf8');
$username = isset($_POST['username']) ? $_POST['username'] : "";
$username = $mysqli->escape_string($username);//转义
$password = isset($_POST['password']) ? md5($_POST['password']) : "";
$age = isset($_POST['age']) ? $_POST['age'] : "";
$act = isset($_GET['act']) ? $_GET['act'] : "";
$id = isset($_GET['id']) ? $_GET['id'] : "";
switch ($act) {
case "addUser":
$sql = "INSERT INTO user(username,password,age) VALUES('{$username}','{$password}','{$age}') ";
$res = $mysqli->query($sql);
if ($res) {
$insert_id = $mysqli->insert_id;
echo "<script type='text/javascript'>
alert('添加成功，网站的第{$insert_id}位用户');
location.href='test.php';</script>";
} else {
echo "<script type='text/javascript'>
alert('添加失败，请重新添加');
location.href='addUser.php';</script>";
}
break;
case 'delUser':
$sql = "DELETE FROM user WHERE id=" . $id;
$res = $mysqli->query($sql);
if ($res) {
$mes = "删除成功";
} else {
$mes = "删除失败";
}
$url = "test.php";
echo "<script type='text/javascript'>
alert('{$mes}');
location.href='{$url}';
</script>";
exit();
break;
}
?>
Paste_Image.png
Paste_Image.png
