Facebook Twitter Reset

This Tutorial Has Been Viewed 24,435 Times.

Simple PHP Login Script

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.13_1145]
Rating: 8.3/10 (12 votes cast)
VN:F [1.9.13_1145]
Rating: +5 (from 5 votes)
Simple PHP Login Script, 8.3 out of 10 based on 12 ratings

Incoming search terms:




You will also be interested in ,

10 Responses to “Simple PHP Login Script”

  1. March 25, 2009 at 4:36 am #

    a good one..

    VA:F [1.9.13_1145]
    Rating: 3.5/5 (2 votes cast)
    VA:F [1.9.13_1145]
    Rating: +1 (from 1 vote)
  2. gfsfcvknwln
    March 25, 2009 at 7:16 pm #

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

    VA:F [1.9.13_1145]
    Rating: 5.0/5 (1 vote cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)
  3. March 26, 2009 at 5:09 pm #

    very simple login script i have ever seen..

    VA:F [1.9.13_1145]
    Rating: 5.0/5 (1 vote cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)
  4. April 8, 2009 at 6:56 am #

    gud one

    VA:F [1.9.13_1145]
    Rating: 5.0/5 (1 vote cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)
  5. November 13, 2009 at 11:10 pm #

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

    Thank’s a lot !!!

    VA:F [1.9.13_1145]
    Rating: 5.0/5 (1 vote cast)
    VA:F [1.9.13_1145]
    Rating: +1 (from 1 vote)
  6. umair
    December 18, 2009 at 12:02 pm #

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

    VA:F [1.9.13_1145]
    Rating: 5.0/5 (1 vote cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)
  7. n
    January 27, 2010 at 9:10 am #

    gud one!
    TQ

    VA:F [1.9.13_1145]
    Rating: 5.0/5 (1 vote cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)
  8. saravana
    March 13, 2010 at 10:24 am #

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

    Thanks for easy script

    VA:F [1.9.13_1145]
    Rating: 4.0/5 (2 votes cast)
    VA:F [1.9.13_1145]
    Rating: +1 (from 1 vote)
  9. June 1, 2010 at 3:27 pm #

    whaaaaaaaaaaa………….

    VA:F [1.9.13_1145]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)
  10. Areen
    June 15, 2010 at 5:00 pm #

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

    VA:F [1.9.13_1145]
    Rating: 5.0/5 (1 vote cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)

Leave a Comment

Spam protection by WP Captcha-Free

Affordable Seo PackagesSeo BlogEdu Backlinks
More in shell (2 of 4 articles)