接上一篇前端的简单后端php+mysql(没有做安全防护)

1 效果图展示

 

 

 

 

 2 代码分享

代码结构：

 login_back.php:

<?php
header("Content-type:text/html;charset=utf-8");
session_start();
include "../func/function.php";
include "../func/mysql_func.php";
include "../func/upload_function.php";
$username=$_POST['userName'];
$password=$_POST['userPwd'];
//登录
$sql="select * from user where user_name='$username' and user_pwd='$password'";
$user=query($sql);
if (count($user)!=0){
    //保存用户状态数据
    //将用户名存放在session之中
    $_SESSION['userName']=$username;
    //修改登录时间
    $lastlogintime=time();
    $sql="update user set last_login_time=$lastlogintime where user_name='$username'";
    execute($sql);
    alter("登录成功","../index.php");
}
else{
    alter("登录失败","../login_view.php");
}

reg_back.php:

<?php
header("Content-type:text/html;charset=utf-8");
include "../func/function.php";
include "../func/mysql_func.php";
include "../func/upload_function.php";
//接收数据
$userName=$_POST["userName"];
$userPwd=$_POST["userPwd"];
$ruserPwd=$_POST["ruserPwd"];
$userGender=$_POST["userGender"];
$userLike=$_POST["userLike"];
$userPhone=$_POST["userPhone"];
$userBirthday=$_POST["userBirthday"];
$user=$_POST["user"];
//数据检验
//检验用户名
$pattern="/^[a-zA-Z_]\\w{5,9}$/";
if(preg_match($pattern,$userName)==0){
    alter("用户名错误","../reg_view.php");
}
//检验密码
$pattern="/^\\d{6,12}$/";
if(preg_match($pattern,$userPwd)==1){
    alter("密码不能是纯数字","../reg_view.php");
}
$pattern="/^\\s{6,9}$/";
if(preg_match($pattern,$userPwd)==1){
    alter("密码不能包含空白字符","../reg_view.php");
}
//检验重复密码
if($userPwd!=$ruserPwd){
    alter("重复密码错误","../reg_view.php");
}
//检查性别
$genderarr=array("1","2");
if (!in_array($userGender,$genderarr)){
    alter("性别错误","../reg_view.php");
}
//检查生日
$pattern="/^\\d{4}-\\d{2}-\\d{2}$/";
if(preg_match($pattern,$userBirthday)==0){
    alter("生日格式错误","../reg_view.php");
}
//检查手机号
$pattern="/^1[3456789]\\d{9}$/";
if (preg_match($pattern,$userPhone)==0){
    alter("手机号格式错误","../reg_view.php");
}
//检查个人简介
$pattern="/fuck|shit|lj|sb|你妈/";
if (preg_match($pattern,$user)){
    alter("含铭感词汇","../reg_view.php");
}
//上传头像
//文件目录初始化
$savepath="";
if ($_FILES['userheader']['error']==0){
    $savepath=upload($_FILES['userheader']);
}
else{
    alter("头像上传失败!","../reg_view/php");
}
//处理爱好数据
//将数组转换为字符串
$userLike=implode(",",$userLike);
$create_time=time();
//入数据库
$sql="insert into user(user_name, user_pwd, user_gender, user_like, user_birthday, user_phone, user_info, create_time,user_header)
                  values('$userName','$userPwd',$userGender,'$userLike','$userBirthday',$userPhone,'$user',$create_time,'$savepath')";
//执行sql
if (execute($sql)){
    alter("注册成功!","../login_view.php");
}
else{
    alter("注册失败","../reg_view.php");
}
以及比较有意思的弹窗：

<?php
header("Content-type:text/html;charset=utf-8");
/**
 * 输出数组
 * @param $array
 * @return void
 */
function pre($array){
    echo "<pre>";
    print_r($array);
    echo "</pre>";
}

/**
 * @param $msg
 * @param $url
 * @return void
 */
function alter($msg,$url){
    echo '
    <style>
    *{
        margin: 0;
        padding: 0;
    }
    .box{
        width: 500px;
        height: 200px;
        border: 1px solid red;
        margin: 200px auto;
        background-color: aqua;
        border-radius: 10px;
        box-shadow: 0 0 5px 2px black ;
    }
    .box p{
        text-align: center;
        font-family: 幼圆;
        font-size: 20px;
        font-weight: 600;
        margin-top: 50px;
    }
</style>
    <div class="box">
        <p id="alter">'.$msg.'</p>
        <p id="time">3</p>
    </div>
    <script>
        var sec=3;
        var time=document.getElementById("time");
        time.innerText=sec;
        setInterval(function (){
            sec--;
            time.innerText=sec;
            if (sec<=0){
                window.location="'.$url.'";
            }
        },1000)
        die;
    </script>';
}

3 之后会更新一个好玩的用JS写的点名器，over