PHP 用户登录简易版

数据库表:

PHP 用户登录简易版

PHP:

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title></title>
</head>
<body>

	<form action="<?php $_SERVER['PHP_SELF'];?>" method="POST">
		<input type="text" name="username" placeholder="用户名">
		<br>
		<input type="password" name="password" placeholder="密码">
		<br>
		<input type="submit" value="提交">
	</form>


	<?php 
    
        $username = $_POST['username'];
        $password = $_POST['password'];

        //连接数据库
        $conn = mysqli_connect('localhost','root','root') or die('连接失败');
        mysqli_select_db($conn , 'user');

        if ( $username && $password ) {
            //进行查询验证
            $query = mysqli_query($conn,"SELECT * FROM alluser WHERE username='$username' AND password='$password' LIMIT 1");

            if( $row = mysqli_fetch_array($query) ){
            	//条件成立
                header('location:result.php');
            }else{
                echo '<script>alert("错误!")</script>';
            }
        }

    ?>

</body>
</html>