Top Ad unit 728 × 90

How to Create Login Page in PHP/MySQL



To make some follow up with my registration page tutorial, I decided to create another tutorial on how to create a login page using PHP/MySQL. The Features of my login page contain input validation using PHP session. One unique feature also with my login page is the logout function, it is unique because unlike with other login page once the user click the logout button and click the back button of the browser, their system allows the user to go back as if it still logged in, which is not appropriate for security reason. But here in my login page once the user click the logout button, the user can no longer go back to their previous page. The only way to go back to the previous page is to login again.

To start this tutorial let’s follow some steps below.

Creating Our Database

First we are going to create our database which stores our data.
To create a database:
1. Open phpmyadmin
2. Click create table and name it.
3. Then name the database as "simple_login".
4. After creating a database name, click the SQL and paste the following code.
  1. CREATE TABLE IF NOT EXISTS `member` (
  2. `mem_id` int(11) NOT NULL AUTO_INCREMENT,
  3. `username` varchar(30) NOT NULL,
  4. `password` varchar(30) NOT NULL,
  5. `fname` varchar(30) NOT NULL,
  6. `lname` varchar(30) NOT NULL,
  7. `address` varchar(100) NOT NULL,
  8. `contact` varchar(30) NOT NULL,
  9. `picture` varchar(100) NOT NULL,
  10. `gender` varchar(10) NOT NULL,
  11. PRIMARY KEY (`mem_id`)
  12. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

Creating Our Form

Next step is to create a form and save it as index.php. To create a form, open your HTML code editor and paste the code below in the upper part of the document or above the html tag. The code below is use to disallow the user to go back as if it still logged in.
  1. <?php
  2. //Start session
  3. //Unset the variables stored in session
  4. unset($_SESSION['SESS_MEMBER_ID']);
  5. unset($_SESSION['SESS_FIRST_NAME']);
  6. unset($_SESSION['SESS_LAST_NAME']);
  7. ?>
Paste the code bellow after the body tag of the HTML document
  1. <form name="loginform" action="login_exec.php" method="post">
  2. <table width="309" border="0" align="center" cellpadding="2" cellspacing="5">
  3. <tr>
  4. <td colspan="2">
  5. <!--the code bellow is used to display the message of the input validation-->
  6. <?php
  7. if( isset($_SESSION['ERRMSG_ARR']) && is_array($_SESSION['ERRMSG_ARR']) && count($_SESSION['ERRMSG_ARR']) >0 ) {
  8. echo '<ul class="err">';
  9. foreach($_SESSION['ERRMSG_ARR'] as $msg) {
  10. echo '<li>',$msg,'</li>';
  11. }
  12. echo '</ul>';
  13. unset($_SESSION['ERRMSG_ARR']);
  14. }
  15. ?>
  16. </td>
  17. </tr>
  18. <tr>
  19. <td width="116"><div align="right">Username</div></td>
  20. <td width="177"><input name="username" type="text" /></td>
  21. </tr>
  22. <tr>
  23. <td><div align="right">Password</div></td>
  24. <td><input name="password" type="text" /></td>
  25. </tr>
  26. <tr>
  27. <td><div align="right"></div></td>
  28. <td><input name="" type="submit" value="login" /></td>
  29. </tr>
  30. </table>
  31. </form>

Creating our Connection

Next step is to create a database connection and save it as "connection.php". This file is used to connect our form to database.
  1. <?php
  2. $mysql_hostname = "localhost";
  3. $mysql_user = "root";
  4. $mysql_password = "";
  5. $mysql_database = "simple_login";
  6. $prefix = "";
  7. $bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database");
  8. mysql_select_db($mysql_database, $bd) or die("Could not select database");
  9. ?>

Writing Our Login Script

Next step is to create our login script that validates our input data and save it as login_exec.php.
  1. <?php
  2. //Start session
  3.  
  4. //Include database connection details
  5. require_once('connection.php');
  6.  
  7. //Array to store validation errors
  8. $errmsg_arr = array();
  9.  
  10. //Validation error flag
  11. $errflag = false;
  12.  
  13. //Function to sanitize values received from the form. Prevents SQL injection
  14. function clean($str) {
  15. $str = @trim($str);
  16. $str = stripslashes($str);
  17. }
  18. }
  19.  
  20. //Sanitize the POST values
  21. $username = clean($_POST['username']);
  22. $password = clean($_POST['password']);
  23.  
  24. //Input Validations
  25. if($username == '') {
  26. $errmsg_arr[] = 'Username missing';
  27. $errflag = true;
  28. }
  29. if($password == '') {
  30. $errmsg_arr[] = 'Password missing';
  31. $errflag = true;
  32. }
  33.  
  34. //If there are input validations, redirect back to the login form
  35. if($errflag) {
  36. $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  37. header("location: index.php");
  38. exit();
  39. }
  40.  
  41. //Create query
  42. $qry="SELECT * FROM member WHERE username='$username' AND password='$password'";
  43. $result=mysql_query($qry);
  44.  
  45. //Check whether the query was successful or not
  46. if($result) {
  47. if(mysql_num_rows($result) > 0) {
  48. //Login Successful
  49. $member = mysql_fetch_assoc($result);
  50. $_SESSION['SESS_MEMBER_ID'] = $member['mem_id'];
  51. $_SESSION['SESS_FIRST_NAME'] = $member['username'];
  52. $_SESSION['SESS_LAST_NAME'] = $member['password'];
  53. header("location: home.php");
  54. exit();
  55. }else {
  56. //Login failed
  57. $errmsg_arr[] = 'user name and password not found';
  58. $errflag = true;
  59. if($errflag) {
  60. $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  61. header("location: index.php");
  62. exit();
  63. }
  64. }
  65. }else {
  66. die("Query failed");
  67. }
  68. ?>

Creating Our Authentication File

Next step is to create our authentication file and save it as auth.php. this code is use to disallow the user to go back as if it still logged in.
  1. <?php
  2. //Start session
  3. //Check whether the session variable SESS_MEMBER_ID is present or not
  4. if(!isset($_SESSION['SESS_MEMBER_ID']) || (trim($_SESSION['SESS_MEMBER_ID']) == '')) {
  5. header("location: index.php");
  6. exit();
  7. }
  8. ?>

Creating Our Home page

Next step is to create a homepage and save it as home.php.
  1. <?php
  2. require_once('auth.php');
  3. ?>
  4. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  5. <html xmlns="http://www.w3.org/1999/xhtml">
  6. <head>
  7. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  8. <title>Untitled Document</title>
  9. <style type="text/css">
  10. <!--
  11. .style1 {
  12. font-size: 36px;
  13. font-weight: bold;
  14. }
  15. -->
  16. </style>
  17. </head>
  18.  
  19. <body>
  20. <p align="center" class="style1">Login successfully </p>
  21. <p align="center">This page is the home, you can put some stuff here......</p>
  22. <p align="center"><a href="index.php">logout</a></p>
  23. </body>
  24. </html>
That’s all you have already created your login page with unique features. Hope this code will help you, see you guys in my next tutorial.
How to Create Login Page in PHP/MySQL Reviewed by Unknown on 10:17:00 AM Rating: 5
All Rights Reserved by What's Up Today © 2014 - 2015
Powered By Blogger, Designed by Sweetheme

Contact Form

Name

Email *

Message *

Powered by Blogger.