Naturally, I started with the simplest function. My first task was to perform a login operation, but it was not as simple as I thought.
1. The first thing is to connect and create the database.
I wrote this part in model.php
$userName='root'; $passWord=''; $host='localhost'; $dataBase='login'; //创建连接 $conn=mysqli_connect($host,$userName,$passWord,$dataBase);
Related recommendations: "php environment construction 》
2. Write the front page. In order to be proficient in the front-end framework, use the layui framework interface. There is a js code in front to determine whether the user name and password input are empty.
<!DOCTYPE html> <html> <script src="layui.js";></script> <link rel="stylesheet" href="layui.css" ;> <head> <meta charset="UTF-8"> <title>注册登录</title> </head> <script language=JavaScript> function InputCheck() { if (Login.username.value == "") { alert("请输入用户名!"); Login.username.focus(); return (false); } if (Login.password.value == "") { alert("请输入密码!"); Login.password.focus(); return (false); } } </script> <body style="background: #1E9FFF"> <div style="position: absolute; left: 50%; top: 50%;width: 500px; margin-left:-250px; margin-top: -200px"> <div style="background: #FFFFFF; padding: 20px;border-radius: 4px;box-shadow: 5px 5px 20px #444444" > <div> <form action="login.php" method="post" name="Login" οnsubmit="return InputCheck()"> <div style="color: gray"> <h2>注册登录系统</h2> </div> <hr> <div> <label>用户名</label> <div> <input type="text" name="username" id="username" placeholder="用户名" autocomplete="off"> </div> </div> <div> <label>密 码</label> <div> <input type="password" name="password" id="password" placeholder="密码" autocomplete="off"> </div> </div> <div> <div;> <input type="submit" value="登录"> <input type="button" value="注册"> </div> </div> </form> </div> </div> </div> </body> </html>
3. login.php is used to determine the correctness of the username and password. Regarding this point, I read many methods on the Internet, and there are all kinds of methods. Before I encountered any obstacles, I decided to use a simple form first. , which is to use SQL statements to query the result set of user name and password. If the result set is empty, the user does not exist.
<?php //数据库连接 require_once 'model.php'; //从登录页接受来的数据 $name=$_POST['username']; $pwd=$_POST['password']; $sql="select id,username,password from user where username='$name' AND password='$pwd';"; $result=mysqli_query($conn,$sql); $row=mysqli_num_rows($result); if(!$row){ echo "<script>alert('密码错误,请重新输入');location='login.html'</script>"; } else{ echo "<script>alert('登录成功');location='123'</script>"; };
4. File directory
5. The effect is as follows:
The above is the detailed content of How to implement login page in php. For more information, please follow other related articles on the PHP Chinese website!