[RESOLVED] How to redirect page without using header?

Techissue2008

I need to redirect user to another php page after submitting a form which insert data into DB.

<html>......

<input type="submit" name="submit" value="Submit" />

<?php
if(isset($_POST['submit']))
{

$query = "INSERT INTO table1 (id, month, year) VALUES ('$id', '$month', '$year')";
mysql_query($query) or die('Error, query failed. ' . mysql_error());
header('Location: index2.php' );
ob_end_flush();
exit();
}
else
{
	header('Location: index2.php' );
	ob_end_flush();
	exit();
}
?>
</html>

It shows error:

Cannot modify header information - headers already sent by

How can I fix it?

laserlight

Structure your code such that you only begin printing output (e.g., HTML code and even blank lines) after the headers are sent. In the case of a location header, you do not want to print output anyway, so you should follow it with [man]exit[/man].

Techissue2008

I do not understand, how should I fix it?

laserlight

I do not understand, how should I fix it?

The problem is demonstrated by this:

<h1>Hello world!</h1>
<?php
header('location: http://www.example.com');
exit;
?>

The problem is that the HTML code causes output to be sent, and output cannot be sent before the headers are sent.

To fix the problem, do something like this:

<?php
if (isset($_POST['submit']))
{
    // Connect to database server and select database
    // ...

$query = "INSERT INTO table1 (id, month, year) VALUES ('$id', '$month', '$year')";
mysql_query($query) or die('Error, query failed. ' . mysql_error());
header('Location: index2.php');
exit();
}
?>
<html>......

<input type="submit" name="submit" value="Submit" />

By the way, note that the location URL should be an absolute URL. This is mentioned in the PHP manual's entry on [man]header/man.

Techissue2008

I did what you said.

header('Location: http://localhost/test/index2.php');

When I open index1.php, it redirected to index2.php at once. index1.php did not show up.

laserlight

Techissue2008 wrote:
When I open index1.php, it redirected to index2.php at once. index1.php did not show up.

That's the very idea behind sending a location header. If you want to display index1.php for a short time, and then redirect the page, then you should be using clientside scripting instead.

Techissue2008

no matter I use header or js, the result is the same

if(isset($_POST['submit']))
{
$query = "INSERT INTO table1 (product, month, year) VALUES ('$product', '$month', '$year')";
mysql_query($query) or die('Error, query failed. ' . mysql_error());
//header('Location: http://localhost/index2.php' );
echo("<script language='javascript'>window.location='index2.php';</script>");
ob_end_flush();
exit();
}
else
{
//header('Location: http://localhost/index2.php' );
echo("<script language='javascript'>window.location='index2.php';</script>");
ob_end_flush();
exit();
}
?>

laserlight

Techissue2008 wrote:
no matter I use header or js, the result is the same

Strictly speaking, this should go in the clientside scripting forum, but the problem is that you need to add a delay.