Code example for php mysql to implement user login function-PHP Tutorial-php.cn

Code example for php mysql to implement user login function

WBOY

Release： 2016-07-25 08:58:37

Original

1440 people have browsed it

This article introduces a piece of code that combines PHP with MySQL to implement the user login function. It is suitable for reference by beginners. It is also useful for studying the implementation method of PHP user login.

Following the last php mysql to add the user's function code, today let's learn how php implements user login and logout functions, and saves the user's login status by tracking the session session.

1, login page login.php

<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<title>用户登录_bbs.it-home.org</title></head>
<body>
<center>
 <table width=50% border=1>
 <form action=loginchk.php method=post>
  <tr>
   <td>
   <div align=center><strong>用户登陆</strong>
   </div>
   <hr>
   <p align=center>请输入你的用户名:
   <input type=text name=username></p>
   <p align=center>请输入你的密码:
   <input type=password name=pwd></p>
   <div align=center>
    <input type=submit value=提交>
    <input type=reset value=清除>
   </div>
    </td>
  </tr>
 </form>
 </table>
</center>
</body>
</html>

Copy after login

Code description: A very simple login interface, POST data to the loginchk.php page for user verification.

2. Login detection page loginchk.php

<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<title>用户登录检测_bbs.it-home.org</title>
</head>
<body>
<center>
<?php
 $name = $_POST['username'];
 $pwd = $_POST['pwd'];  //获取用户名和密码
 
 $link = mysql_connect("localhost","root","wutianshen");
 if(!$link){
  echo "数据库连接失败！";
  mysql_error();
 } //连接数据库，多写一个mysql_errro()绝对有好处，捕获错误消息
 
 mysql_select_db("user");
 $exec = "SELECT * FROM myuser WHERE lname='$name'"; //sql语句，查询用户名称！
 $result = mysql_query($exec);
 $rows = mysql_num_rows($result);
 if($rows>0){
  $row = mysql_fetch_assoc($result);
  $lname=$row['lname'];
  $rname=$row['rname'];
  $lpwd=$row['lpwd'];
  if($lpwd==$pwd){
   session_start();
   $_SESSION['olname']=$lname;
   $_SESSION['olrname']=$rname;   //上面几段就是密码效验，都比较简单，哈哈！~
   echo "用户登陆成功!";
   echo "<hr><p>登陆用户是：".$rname."<p>";
   echo "<br>现在你可以转到用户中心";
  }else{
   echo "用户登陆失败！<hr><p>";
   echo "用户名或密码不正确！！";
   echo "<br>请重新登陆";
  }
 }else{
  echo "用户登陆失败！<hr><p>";
  echo "当前用户不存在！";
  echo "<br>";
 }
?>
</center>
</body>
</html>

Copy after login

That’s it. I hope the above PHP user login function module can help everyone master and implement user login and detection. Programmer's Home, I wish you all the best in your studies and progress.