Hi all,

Not sure if it's really appropriate to post this here but judging by the complexity of the site I'm sure somebody can help me.

I am currently playing around with PHP and MySQL trying to create a simple (yeah right...) login script. I have been doing a lot of reading up and trying parts from numerous tutorials, this is the closest I've got.

Alas there seems to be a problem..

Quoting Firefox the problem seems to be

Quote:

Firefox has detected that the server is redirecting the request for this address in a way that will never complete.

---

<?php

$username = $_POST["username"]; 
$password = $_POST["password"]; 

$members = mysql_connect("localhost", "webuser", "remote213");
    if(!$members)
        {
            echo "<p>Unable to connect...?</p>";
        }

mysql_select_db("uremote", $members); 


$recieve = sprintf("SELECT * FROM uremoteusers WHERE Username='%s' AND Password='%s'", mysql_real_escape_string($username), mysql_real_escape_string($password)); 
$query = mysql_query($recieve);

session_start(); 

if($rows = mysql_num_rows($query)) 
{
    	session_register("user");
 	session_register("pass");

$pass = $password;
$user = $_SESSION["user"] = $username; 
    header("location: http://localhost/index.php");
}
else 
{
    @session_destroy();
    header("location: http://localhost/login.php"); 
}

?>

Quote:

Here's my login script:

//--- If username and password are being submitted from form, check against DB ---/
if (isset($_POST['txtUserName']) && isset($_POST['txtPassword'])) {
// select all entries (1) from database where username and password match
$login_query = "SELECT * FROM `t_users` WHERE user_id = '" . $_POST['txtUserName'] . "' AND user_password = '" . $_POST['txtPassword'] . "'";
$login_result = mysql_query($login_query);

// if there are more than 0 results, set session variables.
if (mysql_num_rows($login_result) > 0) {
$r = mysql_fetch_array($login_result);
$_SESSION['user_id'] = $r['user_id'];
$_SESSION['user_flag'] = $r['user_flag'];
$_SESSION['user_email'] = $r['user_email'];
$_SESSION['user_password'] = $r['user_password'];

// user_flag is a string, but it needs to be parsed into a
// associative array.
$strFlags = $_SESSION['user_flag'];
$arrFlags = explodeAssoc(":",$strFlags);
// the variable uf_status now holds value for user status
$_SESSION['uf_status'] = $arrFlags['status'];

// else, unset all variables.
} else {
unset($_SESSION['user_id']);
unset($_SESSION['user_flag']);
}
}
//--- End: If username and password are being submitted from form, check against DB ---/

---

Quote:

//--- Setup the Session ---/
$expireTime = 60*60*24*30; // 30 days
session_set_cookie_params($expireTime); // set cookie to expireTime
session_start(); // Start session and set variable.
//--- End: Setup the Session ---/

---

Quote:

<? if (isset($_SESSION['user_id'])) { ?>
PUT HTML HERE
<? } ?>

---