1.用户注册前台html>
body {
background-color: #1b6d85;
}
.container {
width: 50%;
height: 50%;
margin-top: 100px;
background-color: #e6e6e6;
}
用户注册用户注册
用户
">
邮箱
">
输入密码
">
确认密码
">
注册
2.注册后台处理 register.php<?php
header('content-type:text/html;charset=utf-8');
//1.创建错误数组来保存错误
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
$error=[];
}
//2.检测用户名
if (empty($_POST['name']))
{
$error[] = '请输入密码';
}else
{
$Name=trim($_POST['name']);
}
//3.检测邮箱
if (empty($_POST['email']))
{
$error[] = '请输入邮箱';
}else
{
$Email=trim($_POST['email']);
}
//4.检测密码
if (empty($_POST['password1']))
{ //检测第一次输入的密码
$error[] = '请输入密码';
}else
{
if (empty($_POST['password2']))
{ //检测第二次输入的密码
$error[] = '未输入校验码';
}else
{
if ($_POST['password1'] == $_POST['password2'])
{ //检测两次密码是否相等
$Psd = trim($_POST['password1']);
}else
{
$error[] = '两次输入密码不一致';
}
}
}
//如果$error为空,则代表数据无误,可以注册
if (empty($error))
{
//连接数据库
require 'inc/connect.php';
//创建sql语句
$sql="INSERT userLog SET `name`='{$Name}', `email`='{$Email}', `psd`=sha1('{$Psd}')";
if (mysqli_query($link,$sql))
{
echo '成功添加了'.mysqli_affected_rows($link).'条记录,新增主键id为'.mysqli_insert_id($link);
}else
{
echo '添加失败'.mysqli_error($link);
}
//关闭连接
mysqli_close($link);
}else
{
//打印出错信息
foreach($error as $message)
{
echo '
'.$message.'
';}
}
3.用户信息导出view.php<?php
$pageTitle='用户信息列表';
include 'inc/header.php';
require 'inc/connect.php';
$sql="SELECT `id`, `name`,`email` FROM `userLog` WHERE `id` >= 1 ";
$result=mysqli_query($link,$sql);
$rows=[]; //创建一个空白数组
if ($result && mysqli_num_rows($result)>0)
{
while ($row=mysqli_fetch_array($result,MYSQLI_ASSOC))
{
//检测是否查询到数据
// echo '
';
// print_r($row);
$rows[] = $row;
}
}else
{
echo '数据表为空,没有数据';
}
//释放结果集
mysqli_free_result($result);
//关闭连接
mysqli_close($link);
?>
用户信息
ID | Name | 0peration | |
<?php echo $row['id'] ?> | <?php echo $row['name'] ?> | <?php echo $row['email'] ?> | " role="button">编辑 '" role="button" >删除 |
4.1用户更新页面editor.php<?php
$pageTitle = '用户修改';
include 'inc/header.php';
//获取id
$id = $_GET['id'];
//1.连接数据库
require 'inc/connect.php';
//2.sql语句
$sql = "SELECT * FROM `userLog` WHERE`id`=".$id;
$result = mysqli_query($link,$sql);
if ($result && mysqli_num_rows($result)>0)
{
$row = mysqli_fetch_array($result,MYSQLI_ASSOC);
}
//echo '
';
//print_r($row) ;
//关闭
mysqli_close($link);
?>
用户修改
" method="post">用户
" readonly>
邮箱
">
输入密码
" readonly>
更新
4.2 更新脚本 doeditor.php<?php
$pageTitle = '更新处理';
include 'inc/header.php';
//获取新的email
if ($_SERVER['REQUEST_METHOD']=='POST')
{
//创建错误数组来保存错误信息
$error=[];
//这里只检测用户提交的邮箱,关于用户名和密码都是只读的
if (empty($_POST['email']))
{
$error[]='未检测到邮箱,请检查';
}else
{
$Email = trim($_POST['email']);
}
}
//如果$error为空,则进行下一步
if (empty($error))
{
//连接数据库
require 'inc/connect.php';
//sql语句
$sql="UPDATE `userLog` SET `email`='{$Email}' WHERE `id`={$_GET['id']}";
//执行该语句
$result = mysqli_query($link,$sql);
if ($result)
{
echo '成功的更新了'.mysqli_affected_rows($link).'条记录';
}else
{
echo '更新失败'.mysqli_error($link);
}
mysqli_close($link);
}else
{
foreach ($error as $value)
{
echo $value;
}
}
5.删除脚本 delete.php<?php
require 'inc/connect.php';
$sql="DELETE FROM `userLog` WHERE `id`={$_GET['id']}";
$result = mysqli_query($link,$sql);
if ($result)
{
echo '成功删除了'.mysqli_affected_rows($link).'条记录';
}else
{
echo '删除失败';
}
//关闭
mysqli_close($link);