Redirect to another page

Anon

Everyone :

I have a site entry page in which the user types their id & password. The FORM sends the data to this page. If the ID and PASSWORD is valid, the user is redirected to the test.php3 page. My problem is that it doesn't work because of the include statement. The include contains the mySQL connect info. If I hard code these variables, which I don't want to do, and remove the include, it works fine. Does anyone have any suggestions on how I can correct or rework this code?

Sincerely,
Dale Williams

<?
include("stuff.inc");

mysql_connect($host, $user, $password);
mysql_select_db($database);

$result = mysql_query("SELECT....");

if (mysql_num_rows($result) > 0) {
header("Location:http://$HTTP_HOST/$DOCROOT/test.php3");

} else {
something else

}
?>

Anon

Ummm it should work, unless the included stuff.inc file prints out any response to the user then it will fail because headers must alway be the first thing sent to the user.

BTW, I use this same methood for handing all my staic values on my sites.

If your not sure about the stuff.inc file just toss a copy of it on here and I'll have a looksee (sans database password code of course)

Anon

Shaun :

Thanks for the reply. My stuff.inc file is as follows:

<?
$host = "localhost";
$user = "root";
$password = "";
$database = "dktest";
?>

Sincerely,
Dale Williams

Shaun Hawkes wrote:

Ummm it should work, unless the included stuff.inc file prints out any response to the user then it will fail because headers must alway be the first thing sent to the user.

BTW, I use this same methood for handing all my staic values on my sites.

If your not sure about the stuff.inc file just toss a copy of it on here and I'll have a looksee (sans database password code of course)

Anon

Make sure there is no white space following the ?>, otherwise, I can't see any reason this wouldn't work.

Anon

Or before the <?php for that matter.

Anything that the php.exe would see as something to be sent to the user would cause a problem if it were sent before the header() function.

Anon

Thanks for the help. Eventhough I didn't see any problem with white spaces in my file, I recreated the stuff.inc from scratch and now everything seems to be working okay.

Sincerely,
Dale Williams

Anon

Nice to hear... guess it was one of those mysterious invisible typo's ehe <G>