Redirecting after queries are finished

netfrugal

I have a php file that performs a few UPDATE statements in succession. I want the page to redirect after the last statement is finished updating the database.

However, when I use:

header("location: nextpage.php");

exit;

I get the warning : Cannot modify header information - headers already sent...

Is there a way to perform this script at all? or is there another way to make this work better?

NogDog

You cannot use header() (or any other function that output headers such as setcookie) once any kind of output is sent. As stated on the header page:

Remember that header() must be called before any actual output is sent, either by normal HTML tags, blank lines in a file, or from PHP. It is a very common error to read code with include(), or require(), functions, or another file access function, and have spaces or empty lines that are output before header() is called.

netfrugal

Any idea on how I can automatically redirect the page somewhere else after the queries are complete?

NogDog

netfrugal wrote:
Any idea on how I can automatically redirect the page somewhere else after the queries are complete?

Yes: use header(). Just make sure nothing is outputting text before you call it. You can "cheat" by starting your script with ob_start() to buffer output, but the vast majority of the time that's just extra processing and memory usage that isn't needed with a little tweaking of code flow/logic and making sure there are no extraneous blank lines/spaces outside of the <?php tags.