First create a login form in html you can use any editoe i prefer Notepad++
Save the file with .htm extension.
Here is the code for Form -:
<html>
<head>
<title>Login Form example</title>
</head>
<body>
<form method="post" action="validate.php" >
<table border="1" >
<tr>
<td><label for="users_email">Email</label></td>
<td><input type="text"
name="users_email" id="users_email"></td>
</tr>
<tr>
<td><label for="users_pass">Password</label></td>
<td><input name="users_pass"
type="password" id="users_pass"></input></td>
</tr>
<tr>
<td><input type="submit" value="Submit"/>
<td><input type="reset" value="Reset"/>
</tr>
</table>
</form>
</body>
</html>
Now create a PHP file and save it with validate.phpHere is the PHP code :-
<?php
// Grab submitted information
$email = $_POST["users_email"];
$pass = $_POST["users_pass"];
// Connect to the database
$con = mysql_connect("localhost","root","");
// Make sure we connected successfully
if(! $con)
{
die('Connection Failed'.mysql_error());
}
// Select the database to use
mysql_select_db("my_dbname",$con);
$result = mysql_query("SELECT users_email, users_pass FROM users WHERE users_email = $email");
$row = mysql_fetch_array($result);
if($row["users_email"]==$email && $row["users_pass"]==$pass)
echo"You are a validated user.";
else
echo"Sorry, your information is not valid, Please try again.";
?>
No comments:
Post a Comment