先看看页面效果
1、用户列表界面
image.png
2、添加用户界面
image.png
3、编辑用户界面
image.png
工具:phpStorm + wampServer + chrome浏览器
1、用户列表界面代码userList.php 先查询用户结果集 再将之展示
/**
* Created by PhpStorm.
* User: zhengjiayuan
* Date: 2018/7/12
* Time: 17:57
*/
$mysqli = new mysqli('localhost','root','','article');
if ($mysqli->connect_errno){
// 错误数 > 0 输出错
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){
// 查询结果条数 > 0
// 将每一行 一行一行 放进 rows
while ($row = $mysqli_result->fetch_assoc()){
$rows[] = $row;
}
}
?>
文章发布系统用户列表-添加用户
编号 | 用户名 | 年龄 | 操作 |
<?php echo $i++;?> | <?php echo $row['username'];?> | <?php echo $row['age'];?> | 更新| |
2、添加用户界面addUser.php 这个主要前端代码 添加用户请求给doAction.php
/**
* Created by PhpStorm.
* User: zhengjiayuan
* Date: 2018/7/12
* Time: 18:27
*/
?>
文章发布系统添加用户
用户名 | |
密码 | |
年龄 | |
3、处理请求代码 doAction.php 处理添加用户、更新用户、删除用户
/**
* Created by PhpStorm.
* User: zhengjiayuan
* Date: 2018/7/12
* Time: 18:36
*/
header('content-type:text/html;charset=utf-8');
$mysqli = new mysqli('localhost','root','','article');
if ($mysqli->connect_errno){
// 错误数 > 0 输出错误
die($mysqli->connect_error);
}
// 设置数据库编码
$mysqli->set_charset("utf8");
$username = $_POST['username'];
$username = $mysqli->escape_string($username); // 转义用户输入的单引号 或者 双引号
$password = md5($_POST['password']);
$age = $_POST['age'];
// 请求方式 添加或者更新或删除
$act = $_GET['act'];
$id = $_GET['id'];
switch ($act){
case 'addUser':
// 添加用户
$sql = "insert into user(username,age) values ('$username','$age')";
$res = $mysqli->query($sql);
if ($res){
echo "
location.href='userList.php';
";
}else{
echo "
location.href='addUser.php';
";
}
break;
case 'delUser':
// 删除用户
$sql = "delete from user where id = ".$id;
$res = $mysqli->query($sql);
if ($res){
$mes = "删除成功";
}else{
$mes = "删除失败";
}
$usel = 'userList.php';
echo "
location.href='$usel';
";
break;
case 'editUser':
// 编辑用户
$sql = "update user set username = '$username',age = '$age' where id = '$id'";
$res = $mysqli->query($sql);
if ($res){
$mes = "更新成功";
}else{
$mes = "更新失败";
}
$usel = 'userList.php';
echo "
location.href='$usel';
";
break;
}
4、更新用户界面 editUser.php 根据传参过来的id先查询用户信息进行展示,再将用户的修改请求转发doAction.php进行展示
/**
* Created by PhpStorm.
* User: zhengjiayuan
* Date: 2018/7/12
* Time: 18:27
*/
header('content-type:text/html;charset=utf-8');
$mysqli = new mysqli('localhost','root','','article');
if ($mysqli->connect_errno){
// 错误数 > 0 输出错误
die($mysqli->connect_error);
}
$mysqli->set_charset("utf8");
$id = $_GET['id'];
// 获取对应id用户的信息
$sql = "select id,username,age from user where id = ".$id;
$mysqli_result = $mysqli->query($sql);
if ($mysqli_result && $mysqli_result->num_rows>0){
$row = $mysqli_result->fetch_assoc();
}
?>
文章发布系统编辑用户
用户名 | |
密码 | |
年龄 | |