Posted by Ben Peddell on 06/26/07 23:21

GD wrote:
> Newbie question = how to send variable form one page to the other
>
> i have a page with a very simple login. i want to be able to use the
> username variable to great the user by username when he reaches the
> page where he is redirected to. and at the same time get the ID field
> from my table which is and INT and PRIMARY_KEY.
>
> i've tried using a regular vairable and calling it back from the
> second page, but the second page doesn't read the first page's
> variable.
>
> btw, i'm using the login server behaviour that comes with dramweaver
> cs3 that adds the following code:
>
> $LoginRS__query=sprintf("SELECT username, password FROM information
> WHERE username=%s AND password=%s",
> GetSQLValueString($loginUsername, "text"),
> GetSQLValueString($password, "text"));
>
> $LoginRS = mysql_query($LoginRS__query, $WebParashaDB) or
> die(mysql_error());
> $loginFoundUser = mysql_num_rows($LoginRS);
> if ($loginFoundUser) {
> $loginStrGroup = "";
>
> //here is where i need to enter my text
>
>
> //declare two session variables and assign them
> $_SESSION['MM_Username'] = $loginUsername;
> $_SESSION['MM_UserGroup'] = $loginStrGroup;
>
> if (isset($_SESSION['PrevUrl']) && false) {
> $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];
> }
> header("Location: " . $MM_redirectLoginSuccess );
> }
> else {
> header("Location: ". $MM_redirectLoginFailed );
> }
> }
> ?>
>
> any help would be appreciated.
>
> thank you very much,
> GD
>

Does this look more like what you want?

// Get the loginUsername and password from the request
$loginUsername = $_REQUEST['loginUsername'];
$password = $_REQUEST['password'];
// Create a query using the loginUsername and password
// We want the username, usergroup and ID
$LoginRS__query=sprintf("SELECT username, usergroup, ID
FROM information
WHERE username=%s AND password=%s",
GetSQLValueString($loginUsername, "text"),
GetSQLValueString($password, "text"));
// Execute the query or die with the mysql error
$LoginRS = mysql_query($LoginRS__query, $WebParashaDB) or
die(mysql_error());
// If there is at least one row, then we have succeeded.
$loginFoundUser = mysql_num_rows($LoginRS);
if ($loginFoundUser) {

//here is where i need to enter my text

// Fetch the data from the row
$loginRow = mysql_fetch_assoc($LoginRS);
// declare three session variables and assign them
$_SESSION['MM_Username'] = $loginRow['username'];
$_SESSION['MM_UserGroup'] = $loginRow['usergroup'];
$_SESSION['MM_ID'] = $loginRow['ID'];
// FALSEd out: If there was a previous URL, then go to it.
if (isset($_SESSION['PrevUrl']) && false) {
$MM_redirectLoginSuccess = $_SESSION['PrevUrl'];
}
// Redirect to the Login Success page
header("Location: " . $MM_redirectLoginSuccess );
}
// Otherwise
else {
// Redirect to the Login Failed page
header("Location: ". $MM_redirectLoginFailed );
}
}

[Back to original message]