【大学生自学】保姆级 PHP 注册+登录

建立用户数据库

 请根据自己需要增加字段。

新建注册页面

<!DOCTYPE HTML>
<html>
    <head>
        <meta charset="utf-8">
        <title>用户登入&注册</title>
    </head>
    
    <body>
        <h1>用户登入</h1>
        <form method="post" action="login.php">
            <div>用户名:<input type="text" name="username"></div>
            <div>密码:<input type="password" name="password"></div>
            <div><input type="submit" value="登入"></div>
        </form>
        <h1>用户注册</h1>
        <form method="post" action="reg.php">
            <div>用户名:<input type="text" name="username"></div>
            <div>密码:<input type="password" name="password"></div>
            <div><input type="submit" value="注册"></div>
        </form>
    </body>
</html>

注册 PHP

要将注册信息写入数据库,也就是 reg.php

<?php
    $username = $_POST['username'];
    $password = $_POST['password'];
    if (empty($username)) {
        echo "用户名为空!";
    } else {
        if (empty($password)) {
            echo "密码为空!";
        } else {
            $time = time();
            $servername = "localhost";
            $sqlusername = "数据库用户名";
            $sqlpassword = "数据库密码";
            $dbname = "数据库名";
            // 创建连接
            $conn = new mysqli($servername, $sqlusername, $sqlpassword, $dbname);
            // 检测连接
            if ($conn->connect_error) {
                die("连接失败: " . $conn->connect_error);
            }
            // 准备插入数据的SQL语句
            $sql = "INSERT INTO member (id, username, password, time) VALUES ('', '$username', '$password' ,'$time')";
            // 执行SQL语句
            if ($conn->query($sql) === TRUE) {
                echo "注册成功";
            } else {
                echo "注册失败: " . $sql . "<br>" . $conn->error;
                
            }
            // 关闭数据库连接
            $conn->close();
        }
    }

登录 PHP

先制作一个 member.php(用户中心,同样数据信息根据自己需要修改)

<?php session_start(); ?>
<!DOCTYPE HTML>
<html>
    <head>
        <meta charset="utf-8">
        <title>用户中心</title>
    </head>
    
    <body>
        <div>您好:<?php echo $_SESSION['username']; ?>,密码:<?php echo $_SESSION['password']; ?></div>
    </body>
</html>

login.php

<?php
    session_start();
    $username = $_POST['username'];
    $password = $_POST['password'];
    if (empty($username)) {
        echo "用户名为空!";
    } else {
        if (empty($password)) {
            echo "密码为空!";
        } else {
            $servername = "localhost";
            $sqlusername = "数据库用户名";
            $sqlpassword = "数据库密码";
            $dbname = "数据库名";
            $conn = new mysqli($servername, $sqlusername, $sqlpassword, $dbname);
            $query = "SELECT * FROM member WHERE username='$username' AND password='$password'";
            $result = mysqli_query($conn, $query);
            if (mysqli_num_rows($result) > 0) {
                // 用户名和密码匹配,登入成功
                while($row=mysqli_fetch_assoc($result)) {
                    $id = $row['id'];
                    $username = $row['username'];
                    $password = $row['password'];
                    $_SESSION['id'] = $id;
                    $_SESSION['username'] = $username;
                    $_SESSION['password'] = $password;
                    header("Location: member.php");
                }
                } else { ?>
    <script type="text/javascript">alert("用户名或密码错误");history.go(-1);</script>
    <?php } } } mysqli_close($conn); ?>

如果用户名和密码从数据库中查询都正确则跳转至 member.php

否则出现 “用户名或密码错误”

评论 1
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值