Redirecting to another web page

Anon

Help!!

When validating a login using MySQL, how would I redirect to another page upon a successful login?

Anyone!!!!

Anon

Pass your header call in the next page after you have verified the username/password against the database.
example:

if (($username==$mysql_username) and ($password==$mysql_password){

Header("Location: pagetwo.php");

}
else {
Header("Location: error.php");
}

you will probably want to sophisticate this a bit, but it should work. check on www.evilwalrus.com for 'authentication the easy way' for a working example
stuart

Anon

At the top of my validate.php script I validate the login name/password entered with the MySQL database. If the login is correct, I redirect using the code you suggested however the following error is displayed:

Warning: Cannot add header information - headers already sent by (output started at ../include/casisheader.inc:20) in C:\HTTPD\HTDOCS\casis\validate.php on line 33

The "casisheader.inc" contains the connection details for the database etc.

Any ideas?

Anon

The complete code is:

<?
require "../include/casisstart.inc";
require "../include/casisheader.inc";

// txtPassword, txtUserID are taken from a FORM

$EncryptedPassword = md5($txtPassword);
$Result = mysql_query("SELECT firstname, lastname, emailaddress, password FROM register WHERE loginname = '$txtUserID';");

while ($Row = mysql_fetch_array($Result)) {
$FirstName = $Row["firstname"];
$LastName = $Row["lastname"];
$UserEmailAddress = $Row["emailaddress"];
$Password = $Row["password"];
}

mysql_free_result($Result);

if ($EncryptedPassword == $Password) {
unset($LoginName);
unset($LoginPassword);
unset($UserName);
unset($EmailAddress);
$LoginName = $txtUserID;
$LoginPassword = $txtPassword;
$UserName = $FirstName." ".$LastName;
$EmailAddress = $UserEmailAddress;
session_register("LoginName");
session_register("LoginPassword");
session_register("UserName");
session_register("EmailAddress");

// Redirect to home page after a successful login

Header("Location: index.php");

} else {

require "../include/casisheader.inc";
require "../include/casispageheader.inc";

}

Anon

Sure. You can't issue a header if anything has been output already. This means that you can't explicitly echo or print anything, and even a single space or newline before the opening <?php or closing ?> will be output.
Remember, too, that include-files go back to html mode, so they also
have to start immediately with a php tag and and the same way.

Anon

hi bob

to save yourself a bit of typing instead of this:while ($Row = mysql_fetch_array($Result)) {
$FirstName = $Row["firstname"];
$LastName = $Row["lastname"];
$UserEmailAddress = $Row["emailaddress"];
$Password = $Row["password"];
}

use:

while ($Row = mysql_fetch_array($Result, MYSQL_ASSOC))

then when u want to echo or use databse values just use $Row["password"]

etc

HTH :0)

ash

Anon

The error points out the fact that headers where already been sent, so another header information is refused.

When working with headers in PHP, make sure that your <? PHP ?> header code comes before any other HTML tags, at the very top of the document.

Slaven