can I code it? I want to redirect my website users to member.php page right after logged in.How can I code it?
HTML SYNTAX FROM INDEX.PHP
<html>
<form id='para' action='login.php' method='POST'>
<table>
<tr>
<td><p>
<p>
Email<br>
<input name='email' type='text' size="20" />
</td>
<td><p>
<p>
Password<br>
<input name='password' type='password' size="20" />
</td>
<td>
<br><p>
<p>
<input font='Bookman Old Style' type='submit' value='Log in' />
</td>
</tr>
</table>
</form>
</html>
PHP SYNTAX LOGIN.PHP
<?php
session_start();
$username = $user = (isset($_POST['username'])) ? $_POST['username'] : '';
$password = $user = (isset($_POST['password'])) ? $_POST['password'] : '';
if ($username&&$password)
{
//connection to mysql
$connect = mysql_connect("localhost","root","") or die("Couldn't connect..");
//connecting database
mysql_select_db("phplogin") or die("Couldn't find db");
//selecting data from table
$query = mysql_query("SELECT * FROM users WHERE username='$username'");
//checking username
$numrows = mysql_num_rows($query);
if ($numrows!=0)
{
while ($row = mysql_fetch_assoc($query))
{
$dbusername = $row['username'];
$dbpassword = $row['password'];
}
//check to see if they match
if ($username==$dbusername&&md5($password)==$dbpasswo rd)
{
echo "You are logged in $username. <a href='user.php'>Click here</a> to enter the member page.";
$_SESSION['username']=$dbusername;
}
else
echo "Incorrect password..";
}
else
die("That user doesn't exist");
}
else
die("Please enter a username and password.");
?>
Bookmarks