PHP jQuery Ajax implements user login and logout, jqueryajax

User login and logout functions are used in many places, and in some projects, we need to use Ajax to log in and log in After success, only part of the page is refreshed, thus improving the user experience. This article will use PHP and jQuery to implement the login and logout functions.

Prepare database

In this example we use Mysql database to create a user table with the following table structure:

CREATE TABLE `user` ( 
 `id` int(11) NOT NULL auto_increment, 
 `username` varchar(30) NOT NULL COMMENT '用户名', 
 `password` varchar(32) NOT NULL COMMENT '密码', 
 `login_time` int(10) default NULL COMMENT '登录时间', 
 `login_ip` varchar(32) default NULL COMMENT '登录IP', 
 `login_counts` int(10) NOT NULL default '0' COMMENT '登录次数', 
 PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Copy after login

Then insert a piece of user information data into the user table:

INSERT INTO `user` (`id`, `username`, `password`, `login_time`, `login_ip`, `login_counts`) 
 VALUES(1, 'demo', 'fe01ce2a7fbac8fafaed7c982a04e229', '', '', 0);

Copy after login

index.php

After the user enters the user name and password, the user will be prompted to log in successfully and the relevant login information will be displayed. If the user clicks "Exit", the user will exit to the user login interface.
Enter index.php. If the user is logged in, the login information will be displayed. If the user is not logged in, the login box will be displayed to ask the user to log in.

<div id="login"> 
   <h3>用户登录</h3> 
   <&#63;php 
   if(isset($_SESSION['user'])){ 
   &#63;> 
   <div id="result"> 
    <p><strong><&#63;php echo $_SESSION['user'];&#63;></strong>，恭喜您登录成功！</p> 
    <p>您这是第<span><&#63;php echo $_SESSION['login_counts'];&#63;></span>次登录本站。</p> 
    <p>上次登陆本站的时间是：<span><&#63;php echo date('Y-m-d H:i:s',$_SESSION['login_time']);&#63;> 
</span></p><p><a href='#' id='logout'>【退出】</a></p> 
   </div> 
   <&#63;php }else{&#63;> 
   <div id="login_form"> 
     <p><label>用户名：</label> <input type="text" class="input" name="user" id="user" /></p> 
     <p><label>密 码：</label> <input type="password" class="input" name="pass" id="pass" /> 
</p> 
     <div class="sub"> 
       <input type="submit" class="btn" value="登 录" /> 
     </div> 
   </div> 
   <&#63;php }&#63;> 
</div>

Copy after login

Note that the statement should be added to the index.php file header: session_start; at the same time, introduce the jquery library in the head part and include global.js. You can also write a beautiful CSS style for the login box. Of course, this example has been slightly written I made a simple style, please check the source code.

<script type="text/javascript" src="js/jquery.js"></script> 
<script type="text/javascript" src="js/global.js"></script>

Copy after login

global.js

The global.js file includes the jquery code to be implemented. The first thing to do is to let the input box get the focus. As soon as it is opened like Baidu and Google, the mouse cursor will be in the input box. The usage code is as follows:

$(function(){ 
  $("#user").focus(); 
});

Copy after login

The next thing to do is to present different styles when the input box gains and loses focus. For example, in this example, different border colors are used. The code is as follows:

$("input:text,textarea,input:password").focus(function() { 
  $(this).addClass("cur_select"); 
}); 
$("input:text,textarea,input:password").blur(function() { 
  $(this).removeClass("cur_select"); 
});

Copy after login

User login: After the user clicks the login button, it must first verify that the user's input cannot be empty, and then send an Ajax request to the background login.php. When the background verification login is successful, the logged-in user information is returned: such as the number of user logins and the last login time; if the login fails, login failure information is returned.

$(".btn").live('click',function(){ 
  var user = $("#user").val(); 
  var pass = $("#pass").val(); 
  if(user==""){ 
    $('<div id="msg" />').html("用户名不能为空！").appendTo('.sub').fadeOut(2000); 
    $("#user").focus(); 
    return false; 
  } 
  if(pass==""){ 
    $('<div id="msg" />').html("密码不能为空！").appendTo('.sub').fadeOut(2000); 
    $("#pass").focus(); 
    return false; 
  } 
  $.ajax({ 
    type: "POST", 
    url: "login.php&#63;action=login", 
    dataType: "json", 
    data: {"user":user,"pass":pass}, 
    beforeSend: function(){ 
      $('<div id="msg" />').addClass("loading").html("正在登录...").css("color","#999") 
.appendTo('.sub'); 
    }, 
    success: function(json){ 
      if(json.success==1){ 
        $("#login_form").remove(); 
        var div = "<div id='result'><p><strong>"+json.user+"</strong>，恭喜您登录成功！</p> 
        <p>您这是第<span>"+json.login_counts+"</span>次登录本站。</p> 
        <p>上次登录本站的时间是：<span>"+json.login_time+"</span></p><p> 
        <a href='#' id='logout'>【退出】</a></p></div>"; 
        $("#login").append(div); 
      }else{ 
        $("#msg").remove(); 
        $('<div id="errmsg" />').html(json.msg).css("color","#999").appendTo('.sub') 
.fadeOut(2000); 
        return false; 
      } 
    } 
  }); 
});

Copy after login

When I make an Ajax request, the data transmission format is json, and the returned data is also json data. I use JS to parse the json data to get the user information after login, and then append it to the #login element through append to complete. Login operation.
User exit: When "Exit" is clicked, an Ajax request is sent to login.php, all Sessions are logged out in the background, and the page returns to the login interface.

$("#logout").live('click',function(){ 
  $.post("login.php&#63;action=logout",function(msg){ 
    if(msg==1){ 
       $("#result").remove(); 
       var div = "<div id='login_form'><p><label>用户名：</label> 
       <input type='text' class='input' name='user' id='user' /></p> 
       <p><label>密 码：</label> <input type='password' class='input' name='pass' 
id='pass' /></p> 
       <div class='sub'><input type='submit' class='btn' value='登 录' /></div> 
       </div>"; 
       $("#login").append(div); 
    } 
  }); 
});

Copy after login

login.php

According to the request submitted by the front desk, when logging in, the user name and password entered by the user are obtained, and compared with the corresponding user name and password in the database. If the comparison is successful, the user's login information will be updated and assembled json data is passed to the front desk.

session_start(); 
require_once ('connect.php'); 
 
$action = $_GET['action']; 
if ($action == 'login') { //登录 
  $user = stripslashes(trim($_POST['user'])); 
  $pass = stripslashes(trim($_POST['pass'])); 
  if (emptyempty ($user)) { 
    echo '用户名不能为空'; 
    exit; 
  } 
  if (emptyempty ($pass)) { 
    echo '密码不能为空'; 
    exit; 
  } 
  $md5pass = md5($pass); //密码使用md5加密 
  $query = mysql_query("select * from user where username='$user'"); 
 
  $us = is_array($row = mysql_fetch_array($query)); 
 
  $ps = $us &#63; $md5pass == $row['password'] : FALSE; 
  if ($ps) { 
    $counts = $row['login_counts'] + 1; 
    $_SESSION['user'] = $row['username']; 
    $_SESSION['login_time'] = $row['login_time']; 
    $_SESSION['login_counts'] = $counts; 
    $ip = get_client_ip(); //获取登录IP 
    $logintime = mktime(); 
    $rs = mysql_query("update user set login_time='$logintime',login_ip='$ip', 
login_counts='$counts'"); 
    if ($rs) { 
      $arr['success'] = 1; 
      $arr['msg'] = '登录成功！'; 
      $arr['user'] = $_SESSION['user']; 
      $arr['login_time'] = date('Y-m-d H:i:s',$_SESSION['login_time']); 
      $arr['login_counts'] = $_SESSION['login_counts']; 
    } else { 
      $arr['success'] = 0; 
      $arr['msg'] = '登录失败'; 
    } 
  } else { 
    $arr['success'] = 0; 
    $arr['msg'] = '用户名或密码错误！'; 
  } 
  echo json_encode($arr); //输出json数据 
} 
elseif ($action == 'logout') { //退出 
  unset($_SESSION); 
  session_destroy(); 
  echo '1'; 
}

Copy after login

When the front-end request exits, just log out of the session and return 1 to the front-end JS for processing. Note that get_client_ip() in the above code is a function to obtain the client IP. Due to space limitations, it cannot be listed. You can download the source code to view it.

Okay, a complete set of user login and logout procedures is completed. There are inevitable shortcomings. Everyone is welcome to criticize and correct.

The above is the entire content of this article, I hope you all like it.