How to create a login system in php

Every website owner wants to have a good secure login system for his website but find it difficult to design. Today i am sharing with you how to create a login system in php here you will step by step learn how to create a login system just in few minutes. For making this login system you don't need to be a professional anyone can create it by just following the given steps.

Create a Login System

Here we will create a simple login system with php and mysql scripts.

Requirements

PHP

MySQL

Any Code editor

Overview

We will create three php files in this login system with the help of php and mysql rest portion is concerned with connectivity of php pages to the database tables.

Steps to create login system

Step 1. Create table members in database login

Create a database 'login' and create a table 'members' in the database and insert one entry to check the system.

CREATE TABLE `members` (
`id` int(4) NOT NULL auto_increment,
`username` varchar(65) NOT NULL default '',
`password` varchar(65) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
-- 
-- Dumping data for table `members`
--
INSERT INTO `members` VALUES (1, 'ayush', '1234');

Step 2. Create a login form 'main_login.php'

Very first thing we need is a login form where user can insert his username and password we will create a login form with name 'main_login.php'

<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<form name="form1" method="post" action="check_login.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="3"><strong>Member Login </strong></td>
</tr>
<tr>
<td width="78">Username</td>
<td width="6">:</td>
<td width="294"><input name="myusername" type="text" id="myusername"></td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td><input name="mypassword" type="text" id="mypassword"></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="Login"></td>
</tr>
</table>
</td>
</form>
</tr>
</table>

Step 3. Create a file check_login.php

After having a login form we have to check that data entered in the login form is correct or not for this we will write a seprate php script in a file that is check_login.php.

This system will check whether the information provided by the user is correct or not by matching it with the information present on the database if the information is right then access will be granted by this script otherwise will access will not be granted.

<?php

$host="localhost"; // Host name 
$username=""; // Mysql username 
$password=""; // Mysql password 
$db_name="login"; // Database name 
$tbl_name="members"; // Table name 

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

// username and password sent from form 
$myusername=$_POST['myusername']; 
$mypassword=$_POST['mypassword']; 

// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);

// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){

// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword"); 
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>

Step 4. Create a file login_success

Now we have form where user will insert his username and password and a script that will check it now we have to give access to the user if he has provided the right username and password for that we have created another script that is login_success.php this will give the access to the user in the form of session.

<?php
session_start();
if(!session_is_registered(myusername)){
header("location:main_login.php");
}
?>

<html>
<body>
Login Successful
</body>
</html>

Step 5. Create logout.php

Now our system is ready and will function properly now we have to take last step that is to create a logout script that will exit the session.

<?php 
session_start();
session_destroy();
?>

About Ayush Tyagi

Ayush Tyagi is professional web-designer and the founder of Howtodohtd.com, who love to learn new things and share them.

3 comments

Click here for comments

Unknown

admin

July 15, 2015 at 4:31 PM × This comment has been removed by a blog administrator.

October 16, 2015 at 1:18 AM ×

PHP is one of the fastest growing web scripting languages on the Internet today, and for good reason. PHP (which stands for Hypertext Preprocessor) was designed explicitly for the web.
php