Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,164,285 members, 7,857,147 topics. Date: Tuesday, 11 June 2024 at 12:29 PM

Free Php Login Script Tutorial - Nairaland / General - Nairaland

Nairaland Forum / Nairaland / General / Free Php Login Script Tutorial (1861 Views)

Www.2go .com 2go Signup,download, 2go Login / Www.2go .com 2go Signup,download, 2go Login / Free Php Login Script Tutorial (2) (3) (4)

(1) (Reply)

Free Php Login Script Tutorial by geniusng(m): 6:16pm On Apr 08, 2010
Let me teach you how to create a simple login system with php + mysql script, this tutorial is easy to follow, follow it you step by step.

Overview
In this tutorial, let us create 3 files
1. main_login.php
2. checklogin.php
3. login_success.php

Step[/b]1. Create table "members" in database "test".
2. Create file main_login.php.
3. Create file checklogin.php.
4. Create file login_success.php.

[b](1) 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');


(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="password" 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>

(3) Create file checklogin.php
<?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"winkor die("cannot connect"wink;
mysql_select_db("$db_name"winkor die("cannot select DB"wink;

// 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"wink;
session_register("mypassword"wink;
header("location:login_success.php"wink;
}
else {
echo "Wrong Username or Password";
}
?>

(4) 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.
<?
session_start();
if(!session_is_registered(myusername)){
header("location:main_login.php"wink;
}
?>

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

That's it, if you have any question feel free to call me or mail me info at codedwebmaster dot com

(1) (Reply)

Do They Have These Hyena Guys In Lagos As Well Or Only Abuja? / 9999 Carol Singers, New World Record To Be Set! / Share A Coke With Someone

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 16
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.