Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > Example of session login verification in php

Example of session login verification in php

WBOY
Release： 2016-07-25 09:05:17
Original
898 people have browsed it
  4. Login
  21. 用户名：
    密码：
    Cookie保存时间：

复制代码

二、登录检测页

  2. @mysql_connect("localhost", "root","1981427") //选择数据库之前需要先连接数据库服务器
  3. or die("数据库服务器连接失败");
  4. @mysql_select_db("test") //选择数据库mydb
  5. or die("数据库不存在或不可用");
  6. //获取用户输入
  7. $username = $_POST['username'];
  8. $passcode = $_POST['passcode'];
  9. //执行SQL语句获得Session的值
  10. $query = @mysql_query("select username, userflag from users "
  11. ."where username = '$username' and passcode = '$passcode'")
  12. or die("SQL语句执行失败");
  13. //判断用户是否存在，密码是否正确
  14. if($row = mysql_fetch_array($query))
  15. {
  16. session_start(); //标志Session的开始
  17. //判断用户的权限信息是否有效，如果为1或0则说明有效
  18. if($row['userflag'] == 1 or $row['userflag'] == 0)
  19. {
  20. $_SESSION['username'] = $row['username'];
  21. $_SESSION['userflag'] = $row['userflag'];
  22. echo "欢迎登录，点击此处进入欢迎界面";
  23. }
  24. else //如果权限信息无效输出错误信息
  25. {
  26. echo "用户权限信息不正确";
  27. }
  28. }
  29. else //如果用户名和密码不正确，则输出错误
  30. {
  31. echo "用户名或密码错误";
  32. }
  33. ?>
复制代码

三、注销登录页

  2. unset($_SESSION['username']);
  3. unset($_SESSION['passcode']);
  4. unset($_SESSION['userflag']);
  5. echo "注销成功";
  6. ?>
复制代码

4. Successful login prompt page

  2. session_start();
  3. if(isset($_SESSION['username']))
  4. {
  5. @mysql_connect("localhost", "root","1981427") //Select You need to connect to the database server before the database
  6. or die("Database server connection failed");
  7. @mysql_select_db("test") //Select the database mydb
  8. or die("The database does not exist or is unavailable");
  9. //Get Session
  10. $username = $_SESSION['username'];
  11. //Execute the SQL statement to obtain the value of userflag
  12. $query = @mysql_query("select userflag from users "
  13. ."where username = '$username'")
  14. or die("SQL statement execution failed");
  15. $row = mysql_fetch_array($query);
  16. //Judge the permission information in the current database and compare it with the information in the Session. If they are different, update the Session information
  17. if($row[ 'userflag'] != $_SESSION['userflag'])
  18. {
  19. $_SESSION['userflag'] = $row['userflag'];
  20. }
  21. //Output different welcome messages according to the value of Session
  22. if( $_SESSION['userflag'] == 1)
  23. echo "Welcome administrator".$_SESSION['username']."Log in to the system";
  24. if($_SESSION['userflag'] == 0)
  25. echo "Welcome User ".$_SESSION['username']."Log in to the system";
  26. echo "Logout";
  27. }
  28. else
  29. {
  30. echo "You do not have permission to access this page";
  31. }
  32. ?>
Copy code


Related labels：
php中session登录验证的例子
source：php.cn
Previous article：php: Solution to Call to undefined function curl_init() Next article：Learn PHP design pattern singleton pattern
Statement of this Website
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
Latest Articles by Author
Latest Issues
How to extract Google OAuth user data and store it in Firebase Firestore using getRedirectResult method? I'm using Firebase Authentication to authenticate users on a website with two methods: ema...
From 2024-04-02 15:32:42
0
1
367
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template