masyarakat Belajar Perpustakaan Alatan Masa lapang
cari
Melayu

Maklumat dan kod pangkalan data

Paparan pangkalan data:

pelaksanaan sql:

BUAT JADUAL `pengguna` (

`id` int(4) BUKAN NULL auto_increment,

var(3

) NOT `kata laluan ` varchar(33) BUKAN NULL,

KUNCI UTAMA (`id`)

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

微信图片_20180227163625.png

Fail yang diperlukan

微信图片_20180227164115.png

:

daftar. 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>";
    }
}

log masuk.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>";
}

:

<?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>";
}
Meneruskan pembelajaran
||
<!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>
serahkanTetapkan Semula Kod
Bahagian sebelumnya bahagian seterusnya
Senarai Tutorial
dapatkan bantuan
  • Cadangan kursus
  • Muat turun perisian kursus
Perisian kursus tidak tersedia untuk dimuat turun pada masa ini. Kakitangan sedang menganjurkannya. Sila beri perhatian lebih kepada kursus ini pada masa hadapan~

Pelajar yang telah menonton kursus ini juga sedang belajar

Tutorial video perdana dunia ThinkPHP 5.1 terkini (60 hari untuk menjadi kursus latihan dalam talian pakar PHP)  492316 permainan