Create a table in mysql
Table Name:memberid int primarykey, autoincrement
Firstname varchar(20)
Lastname varchar(20)
Email varchar(50)
Country varchar(20)
Mobile varchar(10)
Passwd varchar(15)
Create Login box
<body>
<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" >
<h2 class="form-signin-heading"> Login</h2>
<input type="text" name="Uname" size="20" placeholder="Username">
<input type="password" name="Passwd" size="20" placeholder="Password"></br>
<input type="submit" value="Log In" >
</body>
PHP Script
<?php
if(isset($_POST)&&!empty($_POST))
{
session_start();
@$uname = $_SESSION['login'];
$connect = mysql_connect("localhost","root","");
mysql_select_db("login");
$username = mysql_real_escape_string(stripslashes($_POST['Uname']));
$passwd = mysql_real_escape_string(stripslashes($_POST['Passwd']));
$select = mysql_query("SELECT * FROM member WHERE Uname = '$username' AND Passwd = '$passwd';");
$numrow = mysql_num_rows($select);
if($numrow!=0)
{
$_SESSION['login'] =$username;
header("location:adminhome.php");
}
else
{
$_SESSION['login'] = "false";
echo "<p>Login Failed, Username or Password Incorrect.</p>";
}
}
?>
No comments:
Post a Comment