Loading

php连接mysql数据库

phpmyadmin

首先在phpmyadmin新建一个数据库mydb，在此数据库下新建表users。然后在插入里输入以下内容：

现在在浏览界面，就成这样了：

后端

记得打开phpstudy的mysql服务，否则会报错

login.html:登录界面。当用户点击submit就会跳转到login.php进行查询。

<head>
    <meta charset="utf-8">
    <title>登录页面</title>
    <style>
        body {
            font-family: Arial, Helvetica, sans-serif;
        }

        form {
            border: 3px solid #f1f1f1;
        }

        input[type=text],
        input[type=password] {
            width: 100%;
            padding: 12px 20px;
            margin: 8px 0;
            display: inline-block;
            border: 1px solid #ccc;
            box-sizing: border-box;
        }

        button {
            background-color: #04AA6D;
            color: white;
            padding: 14px 20px;
            margin: 8px 0;
            border: none;
            cursor: pointer;
            width: 100%;
        }

        button:hover {
            opacity: 0.8;
        }
        .container {
        padding: 16px;
}
    </style>
</head>

<body>
        <form action="login.php" method="post">
            <div  class="container"">
                <label for="uname"><b>Username</b></label>
                <input type="text" placeholder="Enter Username" name="username" required>
                <label for="psw"><b>Password</b></label>
                <input type="password" placeholder="Enter Password" name="password" required>
                <button type="submit">Login</button>
                <label>  <input type="checkbox" checked="checked" name="remember"> Remember me</label>
            </div>
        </form>
    
</body>

</html>

login.php

<?php
    session_start();
    $_session=array();
    session_destroy();
    ?>
<?php
$username=$_POST['username'];
$password=$_POST['password'];

$conn=mysqli_connect('localhost','root','root','mydb');
$sql="select username,password from users where username='$username' and password='$password'";
$result=mysqli_query($conn,$sql);
$a=mysqli_fetch_array($result);

if($a['username']==$username && $username!=''){
    $_session['login']=true;
    header('Location:page.html');
}else{echo "登录失败，请重新登录或注册帐号！";}
?>

然后在浏览器访问

用户名输入tom,密码输入123.提示登录成功

posted @ 2023-10-24 09:39  y0uth  阅读(33)  评论(0)    收藏  举报