April 2, 2011

A Simple PHP Login Script Example

Sponsored Links

I’m developing a damn keen interest in PHP programming these days. The most wonderful tool and the heart of the web, PHP. Well you can’t take all alone with PHP. You need to be hand wash in JAVA-Script too, at which I’m not good for now.


Now am gonna follow PHP tips and tools post too!

Today I’m up here with a simple PHP Login Script, which is very similar concept which you might have seen sticked at many websites such as Facebook!

Now lets have an overview of it:

In this tutorial you’ll have to create 3 files
1. main_login.php  // Sticked with Login form
2. checklogin.php // The thing that will work with your Username and Password
3. login_success.php // What you’ll see once login is successful!

Steps you need to follow:
1. Create table "members" in database "test".
2. Create file main_login.php.
3. Create file checklogin.php.
4. Create file login_success.php.
5. Create file logout.php

Step1: Create table "members"

CREATE TABLE `members` (
`id` int(4) NOT NULL auto_increment,
`username` varchar(65) NOT NULL default '',
`password` varchar(65) NOT NULL default '',

-- Insert DATA into newly created DATABASE TABLE--

INSERT INTO `members` VALUES (1, 'Mohit', 'mypassword');

// A screenshot of PHP MY ADMIN SCREEN

Step2: Create file "main_login.php"

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

Step3: Create file checklogin.php

$host="localhost"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name="test"; // 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

// 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'";

// Mysql_num_row is counting table row
// If result matched $myusername and $mypassword, table row must be 1 row

// Register $myusername, $mypassword and redirect to file "login_success.php"
else {
echo "Wrong Username or Password";

Step4: Create file login_success.php

// Check if session is not registered , redirect back to main page.
// Put this code in first line of web page.
Login Successful

Step5: Create file Logout.php

// Put this code in first line of web page.


This is the simple and perfect example of a PHP Login Script. Drop your comments. ;) Credit


oto on May 21, 2011 at 10:24 AM said...

Hi there! Nice tutorial

jyothish said...

good one.....but simple... thank u..

Mcbain11 on July 1, 2011 at 11:14 PM said...

best and simplest one yet but cant figure out why it just goes blank when it goes to login check and doesnt return to another page when its successfull email me at mcbain-games@hotmail.com if you can help please.

Mohit Tripathi on July 5, 2011 at 9:52 AM said...

@Mcbain You should check into the sessions, there could be some issue with that.

Anonymous said...

too much like

Anonymous said...

Thanks a lot for sharing!

I, too, can't figure out why I get a blank page when successful. I'm new to PHP and I'd appreciate more insights on what you meant by "check into the sessions" in your reply. email: a.alhaimi1 AT gmail DOT com

Post a Comment

Have something to share? Comment it!

Not relevant? Take help with Search.

Custom Search


Updates on your Mobile

Updates on your Mobile
Go to m.techeguide.com from your mobile to get free access to updates, anytime & anywhere.

Recent Comments

Subscribed Yet?

Subscibe for email updates

© 2009 TecheGuide. The content is copyrighted to the author Mohit Tripathi and may not be republished on other websites. | View Privacy Policy |