<a href="editUser.php?id=<?php echo $row['id']; ?>">更新</a>
case 'editUser':
$sql = "UPDATE user SET username='{$username}',
password='{$password}',age='{$age}'
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>";
break;
editUser.php
<?php
$mysqli = new mysqli('localhost', 'root', '', 'test');
if ($mysqli->connect_errno) {
dir($mysqli->connect_error);
}
$mysqli->set_charset('utf8');
$id = isset($_GET['id']) ? $_GET['id'] : "";
$sql = "SELECT id,username,password,age FROM user WHERE id=" . $id;
$mysqli_result = $mysqli->query($sql);
if ($mysqli_result && $mysqli_result->num_rows > 0) {
$row = $mysqli_result->fetch_assoc();
}
?>
<html>
<head>
<title>editUser</title>
</head>
<body>
<h2>编辑用户</h2>
<form action="doAction.php?act=editUser&id=<?php echo $id; ?>" method="post">
<table border="1" cellspacing="0" cellpadding="0" bgcolor="#ABCDEF" width="80%">
<tr>
<td>用户名</td>
<td><input type="text" name="username" value="<?php echo $row['username']; ?>" placeholder="请输入用户名"
required="required"></td>
</tr>
<tr>
<td>密码</td>
<td><input type="password" name="password" placeholder="请输入密码" value=""></td>
</tr>
<tr>
<td>年龄</td>
<td><input type="number" value="<?php echo $row['age']; ?>" name="age" min="1" max="125"
placeholder="请输入合法年龄" required="required"></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="添加用户"></td>
</tr>
</table>
</form>
</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;
case 'editUser':
$sql = "UPDATE user SET username='{$username}',
password='{$password}',age='{$age}'
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>";
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?id=<?php echo $row['id']; ?>">更新</a>|<a
href="doAction.php?act=delUser&id=<?php echo $row['id']; ?>">删除</a></td>
</tr>
<?php $i++;endforeach; ?>
</table>
</body>
</html>
addUser.php
<html>
<head>
<title>addUser</title>
</head>
<body>
<h2>添加用户</h2>
<form action="doAction.php?act=addUser" method="post">
<table border="1" cellspacing="0" cellpadding="0" bgcolor="#ABCDEF" width="80%">
<tr>
<td>用户名</td>
<td><input type="text" name="username" placeholder="请输入用户名" required="required"></td>
</tr>
<tr>
<td>密码</td>
<td><input type="password" name="password" placeholder="请输入密码" required="required"></td>
</tr>
<tr>
<td>年龄</td>
<td><input type="number" name="age" min="1" max="125" placeholder="请输入合法年龄" required="required"></td>
</tr>
<tr>
<td colspan="2"><input type="submit"value="添加用户"></td>
</tr>
</table>
</form>
</body>
</html>
Paste_Image.png
Paste_Image.png
Paste_Image.png
