Got a bizarre "header("Location.....) bug >>

SpockBert

Puzzled by this so thought I'd post it here see if anyone has ever had this problem. I've got a simple bit of code at the end of my php script that I've used many times before in other scripts with no problems but for some reason this one isn't working, it will not redirect to www.google.com

if(mysql_query($sql, $conn)){

header("Location: http://www.google.com");				

} else {
	echo "oops";
}

But to test the if statement, if I have something like this...

if(mysql_query($sql, $conn)){

echo "please redirect";
	header("Location: http://www.google.com");				

} else {
	echo "oops";
}

The echo statement appears fine.

I've tried pasting the exact header code into a brand new file and it works ok, just not within this if statement!

Same problem with both IE and Firefox.

any ideas? 😉

bubblenut

error_reporting(E_ALL); should show up your problem.

kanikilu

The header statement must be before any browser output (ie. an echo).

SpockBert

kanikilu wrote:
The header statement must be before any browser output (ie. an echo).

ok but even if I remove the echo above it still dont work!

If i have something really simple like:

<?php

header("Location: http://www.google.com");

?>

It works fine, soon as thats within the if statement nothing happens.

bubblenut

Have you set the error_reporting to E_ALL yet? :rolleyes:

inerte

Put an exit(); after header()

header("Location: http://www.google.com");
exit();

SpockBert

if(mysql_query($sql, $conn)){

header("Location: http://www.google.com");
exit();				

} else {
	echo "oops";
}

sigh...still dont work!

if(mysql_query($sql, $conn)){

header("Location: http://www.google.com");
echo error_reporting(E_ALL);
exit();				

} else {
	echo "oops";
}

still no joy 🙁

Isn't this the most stupid bug ever? such a simple bit of code, amazed its not working. Not as if I'm doing something new, used this code loads of times.

SpockBert

echo error_reporting(E_ALL);

returns "81" by the way.

inerte

Can you redirect to other pages? I think what's happening is that your browser isn't accepting the header.

Try a clean file, with just mysql_connect, select_db the $sql variable, the query and the if(). Can you redirect now?

mrhappiness

inerte wrote:
Put an exit(); after header()
header("Location: http://www.google.com");
exit();

you did that?

SpockBert

aHHH got it!

It was earlier echo statements outside the if statement earlier on in the script that it didn't like, stripped them out and its working fine now.

Thanks for your help everyone, I should have read kanikilu's post more carefully 😉

Lesson learned, no echos when you wanna redirect!

Weedpacket

No output of any sort when you want to send headers.

thorpe

you can usually work around this by using output buffering