PHP实现简易用户登录系统

吾爱主题阅读：149 2021-10-19 13:27:00 评论：0

PHP简易用户登录系统，供大家参考，具体内容如下

最近刚刚看到PHP连接数据库的实例，于是做了一个简易的用户系统

直接上代码

连接数据库：connect.php

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 <?php $servername = "localhost" ; $username = "formbd" ; $password = "formbd" ; $dbname = "form" ; // 创建连接 $conn = new mysqli( $servername , $username , $password , $dbname ); // 检测连接 if ( $conn ->connect_error) { die ( "连接失败: " . $conn ->connect_error); } ?>

用户注册前端页面:reg.html

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 <!doctype html> < html lang = "en" > < head > < meta charset = "UTF-8" > < title >用户注册页面</ title > </ head > < body > < form action = "reg.php" method = "post" > < p >用户名:< input type = "text" name = "name" ></ p > < p >密码: < input type = "text" name = "password" ></ p > < p >< input type = "submit" name = "submit" value = "注册" > < a href = "login.html" >< input type = "button" name = "login" value = "已有账号，返回登录" ></ a > </ p > </ form > </ body > </ html >

注册后端处理:reg.php

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 <?php header( "Content-Type: text/html; charset=utf8" ); if (!isset( $_POST [ 'submit' ])){ exit ( "错误执行" ); } //判断是否有submit操作 $name = $_POST [ 'name' ]; //post获取表单里的name $user_password = $_POST [ 'password' ]; //post获取表单里的password include ( 'connect.php' ); //链接数据库 $q = "insert into user(id,username,password) values (null,'$name','$user_password')" ; //向数据库插入表单传来的值的sql $sql = "select * from user where username = '$name'" ; if (( $conn ->query( $sql ))== $name ) { echo '用户名已存在' ; $result = $conn ->query( $sql ); /*echo " <script> setTimeout(function(){window.location.href='reg.html';},1000); </script> ";*/ } else { $conn ->query( $q ); echo "注册成功" ; echo " <script> setTimeout( function (){window.location.href= 'login.html' ;},1000); </script> "; } $conn ->close(); //关闭数据库 ?>

用户登录前端页面:login.html

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 <!doctype html> < html lang = "en" > < head > < meta charset = "UTF-8" > < title >登陆</ title > </ head > < body > < form name = "login" action = "login.php" method = "post" > < p >用户名< input type = text name = "name" ></ p > < p >密码< input type = password name = "password" ></ p > < p >< input type = "submit" name = "submit" value = "登录" > < a href = "reg.html" >< input type = "button" name = "reg" value = "注册" ></ a > </ p > </ form > </ body > </ html >

登录后端处理:login.php

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 <?PHP header( "Content-Type: text/html; charset=utf8" ); if (!isset( $_POST [ "submit" ])){ exit ( "错误执行" ); } //检测是否有submit操作 include ( 'connect.php' ); //链接数据库 $name = $_POST [ 'name' ]; //post获得用户名表单值 $passowrd = $_POST [ 'password' ]; //post获得用户密码单值 if ( $name && $passowrd ){ //如果用户名和密码都不为空 $sql = "select * from user where username = '$name' and password='$passowrd'" ; //检测数据库是否有对应的username和password的sql $result = $conn ->query( $sql ); //执行sql $rows = $result ->fetch_assoc(); //返回一个数值 if ( $rows ){ //0 false 1 true header( "refresh:0;url=success.php" ); //如果成功跳转至success.php页面 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秒后跳转到登录页面重试; } $conn ->close(); //关闭数据库 ?>

登录成功后:success.php

PS:功能未完善

1 2 3 4 5 <?php include 'connect.php' ; session_start(); //声明变量 $username = isset( $_SESSION [ 'nmae' ]) ? $_SESSION [ 'name' ] : "" ; ?>

1 2 3 4 5 6 7 8 9 10 11 12 <!doctype html> < html lang = "en" > < head > < meta charset = "UTF-8" > < title >登陆成功</ title > </ head > < body > 欢迎光临 <? php echo $username;?> <? php ?> </ body > </ html >

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持服务器之家。

原文链接：https://blog.csdn.net/qq_41679358/article/details/107203465

可以去百度分享获取分享代码输入这里。

声明

1.本站遵循行业规范，任何转载的稿件都会明确标注作者和来源；2.本站的原创文章，请转载时务必注明文章作者和来源，不尊重原创的行为我们将追究责任；3.作者投稿可能会经我们编辑修改或补充。