铁人赛 Day14-- MySQL函式 -- 查询资料分页(我傻眼，昨天没上传到)

前言

我明明记得我昨天就PO==，结果今天看到通知才发现被中断了，算了哈哈，那我这边就慢慢PO好了，把自我挑战组顾好好了哈哈

(附上我的会员登入程序码

<?php
    session_start();
    require_once 'db.php';
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
    <style>
        body{   /*boy身体的设定*/
            padding: 0;
            margin: 0;
            list-style: none;
            background-color:rgb(238, 231, 137)
        }
        .banner{
            background-color: darkkhaki;
            position: relative;
            width: 100%;
            height: 80px;
        }
        .banner .list1{
            position: absolute;
            right: 50px;
            width: auto;
            font-weight: 900;
            font-size: 20px;
            margin: 21px 0;
        }
        .banner .list1 a{
            text-decoration: none;
            color: #000;
            padding: 0 20px;
            transition: .3s;
        }
        .banner .text:hover {
            background-color: #fff;
            border-radius: 30px;
            font-size: 25px;
        }
        .orderlogo img{
            position: absolute;
            margin-left: 20px;
            margin-top: 10px;
            z-index: 1;
            width: 60px;
            height: 60px;
        }
        .ordertext{
            position: absolute;
            z-index: 1;
            margin-left: 90px;
            margin-top: 20px;
        }
        .ordertext h2{
            font-weight: 900;
            margin: 0;
        }
        .danger{
            text-align: center;
            position: absolute;
            margin-left: 990px;
            margin-top: -590px;
            font-weight:900;
            color: red;
            z-index: 1;
        }
        .body1{
            width: 100%;
            height: 500px;
            position: relative;
            background-color:rgb(238, 231, 137)
        }
        .orderpic img{
            position: absolute;
            left: 10px;
            top: 200px;           
            width: 800px;
            height: 300px;
            border-radius:30px;
        }
        .ordertext1{
            position: absolute;
            left: 30px;
        }
        .login{
            background-color:#fff ;
            width: 300px;
            height: 400px;
            border: #000 1px solid;
            position: relative;
            top: 12%;
            left: 70%;
        }
        .login h2{
            text-align: center;
            font-weight: 900;
        }
        .login-buttom{
            position: absolute;
            left: 50px;
            margin: 10px 0 0;
        }
        .login-buttom a{
            padding: 0 0 0 20px;
        }
        .input{
            padding: 0 0 0 50px;
        }
        .password1 p{
            margin: 0;
        }
        .join{
            position: absolute;
            right:  15px;
            bottom: 10%;
        }
        .text p{
            margin: 0 0 0 50px;
            font-weight: 900;
        }
        .flooter{
            background: darkkhaki;
            position: relative;
            width: 100%;
            height: 100px;
        }
        .copyright{
            text-align: center;
            padding: 55px 0 0;
        }
        .copyright h2{
            font-size: 20px;
            font-weight: 900;
        }
    </style>
</head>
<body>
        <div class="orderlogo">
            <a href="member.php"><img srcset="logo.png"></a>
            <div class="ordertext">
                <h2>订Bang当</h2>
            </div>
        </div>

        
        <div class="banner">
            <nav class="list1">
                <a href="" class="text">开始订餐</a>
                <a href="" class="text">我的订单</a>
            </nav>
        </div>


    <?php
        if(isset($_SESSION["is_login"]) && $_SESSION["islogin"] == TRUE):
        header('Location: backend.php');
    ?>

    <?php else:?>
    <form method="post" action="check_login.php">
        <div class="body1"> 
            <div class="orderpic">
                <div class="ordertext1">
                    <h2>欢迎使用订Bang当系统，你一"订"会有个非常好的体验的</h2>
                    <ul>
                        <li>简单方便又好用</li>
                        <li>快速寻找周遭餐厅</li>
                        <li>午餐轻松订啦!!</li>
                        <li>连小学生看到都会用!!</li>
                        <li>谁还在跟你慢慢用纸抄XD</li>
                    </ul>               
                </div>

                <div class="pic">
                    <img srcset="点餐.jpg ">                    
                </div>
            </div> 
            <div class="login">
                <h2>会员登入</h2>
                <div class="login-input">
                    <div class="text account">
                        <p>帐号 :</p>
                    </div>    
                    <div class="input account1">
                        <input placeholder="请输入帐号" name="username" id="username" type="text">
                    </div>
                </div>

                <div class="input"></div>    
                    <div class="text password">
                        <p>密码 :</p>
                    </div>    
                    <div class="input password1">
                        <input placeholder="请输入密码" name="password" id="password" type="text">
                        <p>
                            <input type="checkbox" name="rememberme"  id="rememberme" value="true" class="checked">记住我的帐号密码
                        </p>
                        <div class="login-buttom">
                            <button type="submit">登入</button>
                            <a href="">忘记密码?</a>
                        </div>

                    </div>

                    <div class="join">
                        <hr size="5"/>
                        <p >还没有会员帐号，注册帐号免费又容易</p>
                        <p align="center">
                            <a href="joinus.php" ><--马上申请会员--></a>
                        </p>
                    </div>                    
                </div>
            </div>       
        </div>`    

        <?php
            //有讯息
            if(isset($_SESSION['msg']))
            {
                //就印出
                echo "<p class='danger'> {$_SESSION['msg']} </p>";
            }
            session_unset();
        ?>
        
    </form>
    <?php endif;?>

        <div class="flooter">
            <div class="copyright">
                <h2>&copy; Copyright by </h2>
            </div>
        </div>

</body>
</html>

<<: 【Side Project】做Side Project前的准备

>>: [Day 02] 环境建置(一) - 安装VS Code、NodeJS