Database information and code

Database display:

sql execution:

CREATE TABLE `user` (

`id` int( 4) NOT NULL auto_increment,

`username` varchar(33) NOT NULL,

`password` varchar(33) NOT NULL,

PRIMARY KEY (`id` )

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

微信图片_20180227163625.png

Required code files:

微信图片_20180227164115.png

<!DOCTYPE html>
 <html lang="en">
 <head>
 <meta charset="UTF-8">
 <title>Title</title>
 </head>
 <body>
 <hr size="1">
 <form action="add.php" method="post" >
    用户：<input type="text" name="username"/><br>
    密码：<input type="password" name="password" /><br>
    确认密码：<input type="password" name="repassword" /><br>
    <input type="submit" name="register" value="注册">
 </form>

add.php:

<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2018/2/27 0027
 * Time: 上午 11:06
 */
header('Content-type:text/html;charset=utf-8');
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    if (empty($_POST['username'])){
        echo "<script>alert('用户名不能为空！');location.href='login.html';</script>";
    }else {
        $username = $_POST['username'];
    }
    if (empty($_POST['password'])){
        echo "<script>alert('密码不能为空！');location.href='login.html';</script>";
    }else{
        $password = $_POST['password'];
    }
    if (empty($_POST['repassword'])){
        echo "<script>alert('确认密码不能为空！');location.href='login.html';</script>";
    }else{
        $repassword = $_POST['repassword'];
    }
    if ($password != $repassword) {
        echo "<script>alert('两次输入密码不一致！');location.href='login.html';</script>";
    }
}
$mysqli = new mysqli('localhost', 'root', 'root', 'student');
$result = $mysqli->query("SELECT password FROM user WHERE username = "."'$username'");
$rs=$result->fetch_row();
if(!empty($rs)){
    echo "<script>alert('用户已存在！');location.href='login.html';</script>";
}else {
    $mysqli = new mysqli('localhost', 'root', 'root', 'student');
    $sql = "INSERT INTO user (username,password) VALUES ('$_POST[username]', '$_POST[password]')";
    $rs = $mysqli->query($sql);
    if (!$rs) {
        echo "<script>alert('注册失败！');location.href='login.html';</script>";
    } else {
        echo "<script>alert('注册成功！返回登录页面');location.href='login.html';</script>";
    }
}

<!DOCTYPE html>
 <html lang="en">
 <head>
 <meta charset="UTF-8">
 <title>Title</title>
 </head>
 <body>
 <hr size="1">
 <form action="success.php" method="post" >
    用户：<input type="text" name="username"/><br>
    密码：<input type="password" name="password" /><br>
    <input type="submit" name='login' value="登录">
 </form>

success.php:

<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2018/2/27 0027
 * Time: 上午 10:47
 */
header('Content-type:text/html;charset=utf-8');
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    if (empty($_POST['username'])){
        echo "<script>alert('用户名不能为空！');location.href='login.html';</script>";
    }else {
        $username=$_POST['username'];
    }
    if (empty($_POST['password'])){
        echo "<script>alert('密码不能为空！');location.href='login.html';</script>";
    }else{
        $password=$_POST['password'];
    }
}
$mysqli = new mysqli('localhost', 'root', 'root', 'student');
$result = $mysqli->query("SELECT password FROM user WHERE username = "."'$username'");
$rs=$result->fetch_row();
if (!empty($rs)){
    if ($password != $rs[0]) {
        echo "<script>alert('密码错误！');location.href='login.html';</script>";
    }else{
        $expire=3600;
        ini_set('session.gc_maxlifetime', $expire);//保存1小时
        if (empty($_COOKIE['PHPSESSID'])) {
            session_set_cookie_params($expire);
            session_start();
        }else{
            session_start();
            setcookie('PHPSESSID', session_id(), time() + $expire);
        }
        if(isset($_SESSION['username'])){
            exit("您已经登入了，请不要重新登入！用户名：{$_SESSION['username']}---<a href='logout.php'>注销</a>");
        }else{
            $_SESSION['username']=$_POST['username'];
        }
        echo "<script>alert('登录成功！');</script><br>";
        echo "您好！{$_SESSION['username']},欢迎回来！";
        echo "<a href='logout.php'>注销</a>";
    }
}else{
    echo "<script>alert('没有此用户！');location.href='login.html';</script>";
}

logout.php:

<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2018/2/27 0027
 * Time: 上午 11:44
 */
header('Content-type:text/html;charset=utf-8');
session_start();
if(isset($_SESSION['username'])){
    session_unset($_SESSION['username']);
    session_destroy();//销毁一个会话中的全部数据
    setcookie(session_name(),'');//销毁与客户端的联系
    echo "<script>alert('注销成功！');location.href='login.html';</script>";
}else{
    echo "<script>alert('注销失败！');</script>";
}

Continuing Learning

new file

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <hr size="1"> <form action="add.php" method="post" > 用户：<input type="text" name="username"/><br> 密码：<input type="password" name="password" /><br> 确认密码：<input type="password" name="repassword" /><br> <input type="submit" name="register" value="注册"> </form>

submit Reset Code

Automatic operation

Database information and code

ElementaryImperial CMS enterprise imitation website tutorial

ElementaryNewbies with zero foundation in WordPress build personal blogs and corporate websites

ElementaryUltimate CMS zero-based website building instruction video

ElementaryFront-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]

IntermediateVue3.0 from 0 to build a universal backend management system project practice

ElementaryZero-based front-end course [Vue advanced learning and practical application]

ElementaryWEB front-end tutorial [HTML5+CSS3+JS]

ElementaryQuick introduction to apipost

IntermediateVue3+TypeScript practical tutorial-enterprise-level project practice

ElementaryLet's briefly talk about starting a business in PHP

IntermediateVUE e-commerce project (front-end & back-end dual project actual combat)

ElementaryApipost practical application [api, interface, automated testing, mock]