数据库信息与代码 登录

数据库信息与代码

数据库展示:

sql执行:

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

所需要的代码文件:

微信图片_20180227164115.png

register.html:

<!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>";
    }
}

login.html:

<!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>";
}


下一节
<!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>
提交 重置代码
章节 评论 笔记 课件
  • 取消 回复 发送
  • 取消 发布笔记 发送