Home > Article > Backend Development > Code example for php mysql to implement user login function

Code example for php mysql to implement user login function

WBOYOriginal: 2016-07-25 08:58:371432browse

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>

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>

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.

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：8 mistakes you shouldn’t make during programmer interviewsNext article：8 mistakes you shouldn’t make during programmer interviews

See more

Code example for php mysql to implement user login function

Related articles