PHP Redirect stopped working?

Question

I have wrote a script to update a MySql DB from a form.

After the DB has been updated I want the page to auto redirect to another page.

This has been working fine however since switching hosting provider non of my sites re-directs work.

Here is the code:

<?php
$servername = "localhost";
$username = "XXX";
$password = "XXX";
$dbname = "XXX";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

 $id= $_POST[id];
 $dob=$_POST[dob];

$sql=("update users set dob='$dob' where id='$id'")or die('Error 23 ' . mysql_error());

if ($conn->query($sql) === TRUE) {
    echo "Updated successfully<br /><br />";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}
?>
<?php
header("location:index.php?action=updated");  ?>

When I run the code the DB updates but the page just displays Updated successfully?

u can move the redirect code, i:e the header function to if part after displaying the message updated successfully — Gautam
– Gautam, Commented Sep 30, 2015 at 17:25
is there any .htaccess file in your domain root folder? if so then remove it and then see you header is working or not? — Payer Ahammed
– Payer Ahammed, Commented Sep 30, 2015 at 17:27
try header with absolute path like header('Location: http://www.example.com/index.php?action=updated'); — Payer Ahammed
– Payer Ahammed, Commented Sep 30, 2015 at 17:32

Gautam · Accepted Answer · 2015-09-30 17:32:15Z

2

try using javascript to redirect like below:

if ($conn->query($sql) === TRUE) {
    echo "<script>
          alert('Updated successfully');
          window.location.href = 'index.php?action=updated';
         </script>";
}

answered Sep 30, 2015 at 17:32

Gautam

1,0566 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3263028 Over a year ago

Perfect, it redirects. Any idea why I cant use PHP to do this anymore?

Gautam Over a year ago

if u use header function it will directly redirect you without giving the message that it is updated successfully.

Jan · Accepted Answer · 2015-09-30 17:33:04Z

0

Don't echo anything and try to redirect afterwards. Instead simply redirect without any echoing.

if ($conn->query($sql) === TRUE) {
    header("location:index.php?action=updated");
    exit;
} else
    echo "Error: " . $sql . "<br>" . $conn->error;

answered Sep 30, 2015 at 17:33

Jan

43.3k11 gold badges57 silver badges87 bronze badges

1 Comment

user3263028 Over a year ago

It still isn't redirecting?

Payer Ahammed · Accepted Answer · 2015-09-30 17:46:59Z

0

try this :

<?php 
ob_start();
header('Location: http://www.example.com/index.php?action=updated', true); 
?>

edited Sep 30, 2015 at 17:46

answered Sep 30, 2015 at 17:42

Payer Ahammed

9171 gold badge5 silver badges17 bronze badges

2 Comments

user3263028 Over a year ago

Nope does not re-direct?

Payer Ahammed Over a year ago

use <?php ob_start(); ?> this before header

Collectives™ on Stack Overflow

PHP Redirect stopped working?

3 Answers 3

2 Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related