I'm using the following PHP login (I've sanitized the site info). It's not redirecting me to the members page. ALSO, I don't know if the get_magic_quotes is turned on.
<?php
// Connects to your Database
mysql_pconnect("site.IP.ad
dress", "site.name", "site.password") or die(mysql_error());
mysql_select_db("site.data
.base") or die(mysql_error());
//Checks if there is a login cookie
if(isset($_COOKIE['site.id
']))
//if there is, it logs you in and directes you to the members page
{
$username = $_COOKIE['site.ID'];
$pass = $_COOKIE['Site.ID'];
$check = mysql_query("SELECT * FROM users WHERE username = '$username'")or die(mysql_error());
while($info = mysql_fetch_array( $check ))
{
if ($pass != $info['password'])
{
}
else
{
header("Location: members.php");
}
}
}
//if the login form is submitted
if (isset($_POST['submit'])) { // if form has been submitted
// makes sure they filled it in
if(!$_POST['username'] | !$_POST['pass']) {
die('You did not fill in a required field.');
}
// checks it against the database
if (!get_magic_quotes_gpc()) {
$_POST['email'] = addslashes($_POST['email']
);
}
$check = mysql_query("SELECT * FROM users WHERE username = '".$_POST['username']."'")
or die(mysql_error());
//Gives error if user dosen't exist
$check2 = mysql_num_rows($check);
if ($check2 == 0) {
die('That user does not exist in our database.
<a href=add.php>Click Here to Register</a>');
}
while($info = mysql_fetch_array( $check ))
{
$_POST['pass'] = stripslashes($_POST['pass'
]);
$info['password'] = stripslashes($info['passwo
rd']);
$_POST['pass'] = md5($_POST['pass']);
//gives error if the password is wrong
if ($_POST['pass'] != $info['password']) {
die('Incorrect password, please try again.');
}else
{
// if login is ok then we add a cookie
$_POST['username'] = stripslashes($_POST['usern
ame']);
$hour = time() + 3600;
setcookie(site.id, $_POST['username'], $hour);
setcookie(site.id, $_POST['pass'], $hour);
//then redirect them to the members area
header("Location: members.php");
}
}
}
else
{
// if they are not logged in
?>
<form action="<?php echo $_SERVER['PHP_SELF']?>" method="post">
<table border="0">
<tr><td colspan=2><h1>Login</h1></
td></tr>
<tr>
<td>Name:</td>
<td>
<input type="text" name="username" maxlength="40">
</td></tr>
<tr><td>Password:</td><td>
<input type="password" name="pass" maxlength="50">
</td></tr>
<tr><td colspan="2" align="right">
<input type="image" name="login2" src="assets/images/login.g
if" align="right" style="margin-right:6px;ma
rgin-top:6
px;" />
</td>
</tr>
</table>
</form>
<?php
}
?>
Start Free Trial