PHP Login Script Tutorial

by devman
Posted July 30th, 2010 at 9:52 am
Hello there! If you are new here, you might want to subscribe to the RSS feed for updates on this topic, or follow us on Twitter.
Name: Email:


Learn to create a simple login system with php + mysql script, this tutorial easy to follow, teach you step by step.

Overview

In this tutorial create 3 files
1. main_login.php
2. checklogin.php
3. login_success.php

Step
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 '',
  PRIMARY KEY (`id`)
  ) TYPE=MyISAM AUTO_INCREMENT=2 ;
-- 
  -- Dumping data for table `members`
  -- 

INSERT INTO `members` VALUES (1, 'john', '1234');

Step2:

Create file main_login.php


View In Browser

|—|——————— code ——————–|—|

<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
  <tr>
<form name="form1" method="post" action="checklogin.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>&nbsp;</td>
  <td>&nbsp;</td>
  <td><input type="submit" name="Submit" value="Login"></td>
  </tr>
  </table>
  </td>
</form>
  </tr>
  </table>

Step3:

Create file checklogin.php

|—|——————— code ——————–|—|

<?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 
  $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";
}
?>

Step4:

Create file login_success.php

|—|——————— code ——————–|—|

// Check if session is not registered , redirect back to main page. 
// Put this code in first line of web page. 
  <? 
  session_start();
  if(!session_is_registered(myusername)){
  header("location:main_login.php");
  }
  ?>
  <html>
  <body>
  Login Successful
  </body>
  </html>

Step5:

Logout.php

If you want to logout, create this file

// Put this code in first line of web page. 
<? 
session_start();
session_destroy();
?>

Step6:

For PHP5 User – checklogin.php

|—|——————— code ——————–|—|

<?php
ob_start();
$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");
 // Define $myusername and $mypassword 
  $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";
}
ob_end_flush();
?>

Step7:

Encrypting Password – Make your Login More Secure

Read more about encrypting password here

Popularity: 100% [?]

http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/digg_48.png http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/reddit_48.png http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/dzone_48.png http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/stumbleupon_48.png http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/delicious_48.png http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/blinklist_48.png http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/blogmarks_48.png http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/furl_48.png http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/technorati_48.png http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/myspace_48.png http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/facebook_48.png http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/yahoobuzz_48.png http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/sphinn_48.png http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/mixx_48.png http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/twitter_48.png http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/jamespot_48.png http://www.tutorialspalace.com/wp-content/plugins/sociofluid/images/meneame_48.png

Random Posts



Hello there! If you are new here, you might want to subscribe to the RSS feed for updates on this topic, or follow us on Twitter.
Name: Email:


11 ResponsesLeave a comment
  • Jhon Mary
    July 31, 2010 at 7:42 am

    Great Blog here my friend! Very informative, I appreciate all the information that you just shared with me very much and I’ll be back to read more in the future.

  • Tutorial Lounge
    August 2, 2010 at 11:20 am

    short and useful tutorial with informative tips. thanks

  • tinnitis
    August 9, 2010 at 11:50 pm

    Well I found this on Digg, and I like it so I dugg it!

Add a commentGet a Gravatar

* Name

* Email Address

Website Address

You can usethese tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
Sponsors
Advertise with us!
Around The Site
Free Subscription

Enter your email address:

 
Links
A Logo design contest at Loogmyway.com
Blog Promoters
Blogroll
Friends Links
Galleries
Site Sponsors
Categories
Tags
Archives
Community News
Read More News
Add News




Captcha
To prevent spam, please type the text (all uppercase) from this image in the textbox below.

Get Adobe Flash playerPlugin by wpburn.com wordpress themes