PHP+MySql注册登陆页面开发完整代码

展示：注册.html<!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-w

MUNG东隅

10197人浏览 · 2022-02-13 17:17:16

MUNG东隅 · 2022-02-13 17:17:16 发布

展示：

注册.html

<!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">
    <link rel="stylesheet" href="style.css">
    <title>注册</title>

</head>

<body>
    <div id="div1">
        <form enctype="\u4e00~\u9fa5" method="post" action="./login.php" name='form' id='form'>
            <table>
                <h2>注册</h2>
                <tr>
                    <td>
                        <p><span>账号:</span><input type="text" class="input" name='user' id='user'></p>
                    </td>
                </tr>

                <tr>
                    <td>
                        <p><span>密码:</span><input type="password" id='pasd' class="input" name='pasd'></p>
                    </td>
                </tr>
                <tr>
                    <td>
                        <input class="buttorn" type="submit" name='submit' id='submit' value="注册"
                            onclick="returncheck(form);">
                        <input class="buttorn" type="reset" name='reset' id='reset' value="重填">
                    </td>
                </tr>
            </table>
        </form>
    </div>


</body>

</html>

登陆.html

<!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">
    <link rel="stylesheet" href="style.css">
    <title>登陆</title>

</head>

<body>
    <div id="div1">
        <form enctype="\u4e00~\u9fa5" method="post" name='denglu' action='./login2.php'>
            <table>

                <h2>登录</h2>
                <tr>
                    <td>
                        <p><span>账号:</span><input type="text" name='username' class="input"></p>
                    </td>
                </tr>
                <tr>
                    <td>
                        <p><span>密码:</span><input type="password" name='password' pattern="\u4e00~\u9fa5" class="input"
                                maxlength="9" autofocus></p>
                    </td>
                </tr>
                <tr>
                    <td><input class="buttorn" type="submit" value="登录" readonly="readonly"><a href="./注册.html"><input
                                class="buttorn" onclick="window.location.href('./注册.html')" type="button" value="注册"
                                readonly="readonly"></a></td>
                </tr>
            </table>
        </form>
    </div>
</body>

</html>

welcom.html

<!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">
    <link rel="stylesheet" href="style.css">
    <title>welcome</title>
    <style>


    </style>
</head>

<body>
    <div id="div1">
        <h2>欢迎您！</h2>
    </div>
</body>

</html>

style.css

#div1 {
    background-image: url(./form_bg.jpg);
    background-position: left top;
    width: 1431px;
    height: 717px;
    background-repeat: no-repeat;
    position: relative;
}

body,
form,
h1,
p,
div {
    margin: 0px;
    padding: 0px;
}

body {
    font-family: 微软雅黑;
    font-size: 12px;
}

form {
    width: 600px;
    height: 400px;
    margin-top: 50px;
    margin-bottom: 50px;
    margin-left: auto;
    margin-right: auto;
    padding-left: 30px;
    position: absolute;
    left: 48%;
    top: 10%;
}

h2 {
    text-align: center;
    ;
    margin-top: 16px;
    margin-bottom: 16px;
    margin-left: -20px;
    margin-right: 150px;
    font-size: 40px;
}

p {
    margin-top: 20px;
}

span {
    width: 75px;
    display: inline-block;
    padding-right: 10px;
    text-align: right;
}

.input {
    width: 200px;
    height: 18px;
    border: 1px solid #38a1bf;
    padding: 2px;
}

#input {
    width: 100px;
    height: 24px;
}

.buttorn {
    width: 100px;
    height: 30px;
    background-color: #93b518;
    margin-top: 20px;
    margin-left: 75px;
    border-radius: 3px;
    font-size: 18px;
    font-family: 微软雅黑;
    color: white;
}

span {
    font-size: 20px;
}

login.php(注册用的)

<?php
header("Content-type:text/html;charest=utf-8");
session_start();
 if (!isset($_POST['user'])){
    echo "<script type='text/javascript'>alert('您的表单还没填完！');</script>";
    exit("错误执行");
}

include('./connect.php');

$user=$_POST['user'];
$pasd=$_POST['pasd'];

$result2=mysqli_query($conn,'select * from denglu where username=$user');
if($result2){
    echo "<script type='text/javascript'>alert('已存在该用户！');</script>";
}
else{
$result3=mysqli_query($conn,"insert into denglu(id,username,password) values(null,'$user','$pasd');");
echo "<script type='text/javascript'>alert('注册成功！');</script>";
}
mysqli_close($conn);//关闭数据库
?>

login2.php(登陆用的)

<?PHP
    header("Content-Type: text/html; charset=utf8");
    if(!isset($_POST["submit"])){
        exit("错误执行");
    }//检测是否有submit操作 

    include('./connect.php');//链接数据库
    $username = $_POST['username'];//post获得用户名表单值
    $passowrd = $_POST['password'];//post获得用户密码单值

    if ($name && $passowrd){//如果用户名和密码都不为空
             $sql = "select * from denglu where username = '$username' and password='$passowrd'";//检测数据库是否有对应的username和password的sql
             $result = mysqli_query($conn,$sql);//执行sql
             $rows=mysqli_num_rows($result);//返回一个数值
             if($rows){//0 false 1 true
                   header("refresh:0;url=welcome.html");//如果成功跳转至welcome.html页面
                   exit;
             }else{
                echo "用户名或密码错误";
                echo "
                    <script>
                            setTimeout(function(){window.location.href='login.html';},1000);
                    </script>

                ";//如果错误使用js 1秒后跳转到登录页面重试，让其从新进行输入
             }
             

    }else{//如果用户名或密码有空
                echo "表单填写不完整";
                echo "
                      <script>
                            setTimeout(function(){window.location.href='login.html';},1000);
                      </script>";
                        //如果错误使用js 1秒后跳转到登录页面重试，让其从新进行输入
    }

    mysqli_close($conn);//关闭数据库
?>

connect.php(连接数据库)

<?php
$dbhost = "127.0.0.1";
$dbuser = 'root';
$dbname = "denglu";	//数据库名称
$dbtable='denglu';
$dbpass = "";	//数据库密码
$conn=mysqli_connect($dbhost,$dbuser,$dbpass);
if($conn=mysqli_connect($dbhost,$dbuser,$dbpass)){
    echo "<script type='text/javascript'>alert('连接成功');</script>";
}
else{
    echo "<script type='text/javascript'>alert('连接失败');</script>";
}
$connt=mysqli_select_db($conn,$dbname);
?>