登录-注册网页实现

数据库 php 前端 2023-08-31 21:08:23 678人浏览安东尼

摘要

re.PHP(登录的前端界面) 登录页面 .home{ text-align: center; font-wei

re.PHP(登录的前端界面)

<!DOCTYPE html><html><head>    <meta charset="utf-8">    <title>登录页面</title>    <style>        .home{            text-align: center;            font-weight: bold;        }        h2 {            color: red;            font-size: 40px;        }        .db_name,        .db_pass {            margin-bottom: 10px;            font-size: 20px;        }        .submit {            font-size: 20px;            margin-bottom: 10px;        }        .login{            font-size: 20px;            margin-left: 300px;        }        .ch{            font-size: 20px;            margin-left: 420px;        }    </style></head><body>    <h2>欢迎来到您的登录界面！</h2>    <fORM action="judge.php" method="POST" class="form">        <div class="home">            <div>                <span>账&nbsp;&nbsp;号:<input type="text" required class="db_name" name="db_name" /></span><br>                <span>密&nbsp;&nbsp;码:<input type="passWord" required class="db_pass" name="db_pass" /></span><br>            </div>            <div>                <input type="submit" value="登录" class="submit" />            </div>            <span class="login">还没有账号？<a href="login.php">注册账号</a></span><br>            <span class="ch"><a href="ch.php">修改密码</a></span>        </div>    </form></body></html>

judge.php(登录的后端代码)

$db_name = $_POST['db_name'];$db_pass = $_POST['db_pass'];if(!empty($db_name) && !empty($db_pass)){    $coon = Mysqli_connect('localhost',root','root','admin');    //查询数据    $sql_select = "SELECT db_name,db_pass FROM db_user WHERE db_name = '$db_name' AND db_pass = '$db_pass'";    $ret = mysqli_query($coon,$sql_select);    $row = mysqli_fetch_assoc($ret);    if($db_name == $row['db_name'] && $db_pass == $row['db_pass']){        header("location:panel.php");    }    else{        echo "";    }else{        //判断两次密码是否相等        if ($db_pass == $db_pass_1) {            //插入数据的语句，用于将内容插入数据库的列中            $sql_pw = "INSERT INTO db_user(db_name,db_pass) VALUES ('$db_name','$db_pass')";            //执行SQL语句            $row = mysqli_query($coon, $sql_pw);            //关闭结果集，作用是释放资源            mysqli_free_result($row);            //提示用户注册成功            echo "";            //返回登录界面，也代表注册成功            header('location:re.php');        } else {            echo "";        }    }}

ch.php(修改密码的前端界面)

<!DOCTYPE html><html><!-- 该界面是用户用来修改密码的界面 --><head>    <meta charset="utf-8">    <title>修改密码</title>    <style>        .home {            text-align: center;            font-weight: bold;        }        h2 {            color: red;            font-size: 40px;        }        .db_name,        .db_pass,        .db_newpass,        .db_oldpass {            margin-bottom: 10px;            font-size: 20px;        }        .submit {            font-size: 20px;            margin-bottom: 10px;            margin-left: 35px;        }        .hint {            color: red;        }        .re {            margin-left: 50px;            font-size: 20px;        }    </style></head><body>    <h2>欢迎来到您的修改密码界面！</h2>    <form action="ch_db.php" method="POST" class="form">        <div class="home">            <div>                <span>账&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;号:<input type="text" required class="db_name" name="db_name" /></span><br>                <span>原&nbsp;密&nbsp;码:<input type="password" required class="db_pass" name="db_pass" /></span><br>                <span>新&nbsp;密&nbsp;码:<input type="password" required class="db_newpass" name="db_newpass" /></span><br>                <span>重复密码<input type="password" required class="db_newpass" name="db_repass" /></span>            </div>            <div>                <input type="submit" value="提交" class="submit" /><br>            </div>            <div>                <span class="hint">小提示:密码成功后会自动返回登录界面！</span><br>                <span class="re"><a href="index.php">返回登录</a></span>            </div>        </div>    </form></body></html>

ch_db.php(修改密码的后端代码)

$coon = mysqli_connect('localhost', 'root', 'root', 'admin');//这是判断修改密码的界面$db_name = $_POST['db_name'];$db_pass = $_POST['db_pass'];$db_newpass = $_POST['db_newpass'];$db_repass = $_POST['db_repass'];$sql_judge = "SELECT db_name,db_pass FROM db_user WHERE db_name='$db_name' AND db_pass = '$db_pass'";$row_judge = mysqli_query($conn,$sql_judge);$ret_judge = mysqli_fetch_assoc($row_judge);if($db_name == $ret_judge['db_name'] && $db_pass == $ret_judge['db_pass']){    if($db_newpass == $db_repass && $db_pass != $db_newpass){        $sql_newjudge = "UPDATE db_user SET db_pass = '$db_newpass' WHERE db_name = '$db_name'";        mysqli_query($conn,$sql_newjudge);        echo "";    }    else{        echo "";    }}else{    echo "";}panel.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></head><body>    </body></html><?php$coon = mysqli_connect('localhost','root','root','admin');echo "我的账户";$sql = "SELECT * FROM `db_user` ORDER BY id ASC";$rows = mysqli_query($coon,$sql);echo "登录成功！
";?>