First we will create a simple Login form...........
database name : login
table name : members
<form name="form1" method="post" action="checklogin.php">
memeber login<br>
Usename<br>
<input name="myusername" type="text" id="myusernaame"><br>
password<br>
<input name="mypassword" type="text" id="mypassword"><br>
<input type="submit" name="Submit" value="Login">
</form>
code : checklogin.php
<?php
session_start();
$host="localhost";
$username="root";
$password="";
$db_name="login";
$tbl_name="members";
mysql_connect("$host","$username","$password") or die("cant connect");
mysql_select_db("$db_name") or die("cant connect");
$myusername=$_POST['myusername'];
$mypassword=$_POST['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);
$count=mysql_num_rows($result);
if($count==1){
//$_SESSION['logged']=TRUE;
$_SESSION['login_user']=$myusername;
header("location:login_success.php");
}
else{
echo "wrong username or password";
}
?>
code : login_success.php
<?php
session_start();
if(!$_SESSION['logged']){
header("location:main_login.php");
exit;
}
echo 'welcome, '.$_SESSION['login_user'];
?>
<html>
<body>
Login Successful
</body>
</html>
