facebook twitter youtube
in PHP - 27 Feb, 2009, This Tutorial Has Been Viewed 295,353 Times.
by admin - 11 comments
Simple PHP Login Script
VN:F [1.9.22_1171]
Rating: 8.3/10 (13 votes cast)

This is simple PHP login script

Our 1st step is to Create table “mydata” in database “test”.

———————————————————————–

CREATE TABLE ‘mydata’ (
`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 ;


– Inserting data for table `mydata`

INSERT INTO `mydata` VALUES (1, ‘test’, ‘pass123′);

———————————————————————–

2. Create file main_login.php.

———————————————————————–

<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> </td>
<td> </td>
<td><input type=”submit” name=”Submit” value=”Login”></td>
</tr>
</table>
</td>
</form>
</tr>
</table>

———————————————————————–
3. Create file checklogin.php.

Dont forget to create a database named TEST

———————————————————————–

<?php
$host=”localhost”;
// Host name
$username=”root”; // Mysql username
$password=”"; // Mysql password
$db_name=”TEST”; // Database name
$tbl_name=”mydata”; // 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
$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”;
}
?>

———————————————————————–
4. Create file login_success.php.

———————————————————————–

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

<html>
<body>
You Have Successfully Logged In.<br>

<a href=”logout.php”>Log Out </a></body>
</html>

———————————————————————–
5. Create file logout.php

———————————————————————–

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

session_destroy();
?>

VN:F [1.9.22_1171]
Rating: 8.3/10 (13 votes cast)
Simple PHP Login Script, 8.3 out of 10 based on 13 ratings

Incoming search terms:




coded by nessus

Leave a Reply

  • //25 Mar 2009

    a good one..

    VA:F [1.9.22_1171]
    Rating: 3.5/5 (2 votes cast)
  • //25 Mar 2009

    Good a very simple script for loging in using php….nice

    VA:F [1.9.22_1171]
    Rating: 5.0/5 (1 vote cast)
  • //26 Mar 2009

    very simple login script i have ever seen..

    VA:F [1.9.22_1171]
    Rating: 5.0/5 (2 votes cast)
  • //08 Apr 2009

    gud one

    VA:F [1.9.22_1171]
    Rating: 3.5/5 (2 votes cast)
  • //13 Nov 2009

    Work very fine and it’s was so easy to use !

    Thank’s a lot !!!

    VA:F [1.9.22_1171]
    Rating: 4.0/5 (2 votes cast)
  • //18 Dec 2009

    this login script is very helpful for new visitor must see this code

    VA:F [1.9.22_1171]
    Rating: 5.0/5 (1 vote cast)
  • //27 Jan 2010

    gud one!
    TQ

    VA:F [1.9.22_1171]
    Rating: 5.0/5 (1 vote cast)
  • //13 Mar 2010

    it’s really awesome. i have never seen before…

    Thanks for easy script

    VA:F [1.9.22_1171]
    Rating: 4.0/5 (2 votes cast)
  • //01 Jun 2010

    whaaaaaaaaaaa………….

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
  • //15 Jun 2010

    your a Genius….. Thnks to made us life easier…..

    VA:F [1.9.22_1171]
    Rating: 5.0/5 (1 vote cast)
  • //10 Nov 2012

    First and easy script.

    VA:F [1.9.22_1171]
    Rating: 5.0/5 (1 vote cast)
Close
Please support the site
By clicking any of these buttons you help our site to get better