How to redirect in after executes the query php

Question

Here is my code:

    $id = $_GET['id'];
$data = $_POST['name'];
$data1 = $_POST['id'];
$c = 0;

foreach ($data1 as $key => $value) {
    $sql = "UPDATE ".$table_comp." SET score = " . $data[$c][$value] . " where id = " . $value .";" ;
    mysqli_query($connect,$sql);
    $c++;
} 
header('Location: http://www.csscorecard.com/admin/?id=$id');

I have problem in my redirect there is an error:

Warning: Cannot modify header information - headers already sent by (output started at /home/csscorecard/public_html/wp-content/themes/twentyseventeen/ajax/submit.php:3) in /home/csscorecard/public_html/wp-content/themes/twentyseventeen/ajax/submit.php on line 54

refer this [stackoverflow](https://stackoverflow.com/questions/8028957/how-to-fix-headers-already-sent-error-in-php?answertab=active#tab-top) — Nidhi, Jun 08 '17 at 05:02
Store it in a session variable, redirect, then use (session) variable as needed. — chris85, Jun 08 '17 at 05:05
there should be no HTML or echo present above your header code. — Bhavik, Jun 08 '17 at 05:08
Possible duplicate of [How to fix "Headers already sent" error in PHP](https://stackoverflow.com/questions/8028957/how-to-fix-headers-already-sent-error-in-php) — chris85, Jun 08 '17 at 05:23
Please check your code for any output before using `header('Location:http://www.somewhere.com');`. Even a whitespace can generate this error, so check code for output in `submit.php` line 3. — Ankit Singh, Jun 08 '17 at 05:55

score 1 · Accepted Answer · edited Jun 08 '17 at 05:06

1

use javascript instead of headers.

you can use this code to redirect

<?php

echo "<script>window.location.href = 'http://www.csscorecard.com/admin/?id=".$id."'</script>";

?>

edited Jun 08 '17 at 05:06

Enstage

2,106
13
20

answered Jun 08 '17 at 05:01

Divyank Munjapara

184
10

1

If we post the form using javascript then only we can use this..writing javascript in PHP script is not a valid way...`header` facilitates to Send a raw HTTP header – Nidhi Jun 08 '17 at 05:05
you are right @Nidhi, but he's seems to sending request through ajax. – Divyank Munjapara Jun 08 '17 at 06:09

Ahmed Ginani · Answer 2 · 2017-06-08T05:14:09.190

0

Its quite complex to give answer in this case without seeing whole file code. In many cases this error shown. but for header location you should put exit:

exit(header("Location: http://www.csscorecard.com/admin/?id=$id"));

edited Jun 08 '17 at 05:14

answered Jun 08 '17 at 05:08

Ahmed Ginani

6,522
2
15
33

1

Exit wont help if `header` is after* output. – chris85 Jun 08 '17 at 05:10

score 0 · Answer 3 · answered Jun 08 '17 at 05:57

0

You can add ob_start(); top of the file

answered Jun 08 '17 at 05:57

Farhad Hossen

263
1
6

How to redirect in after executes the query php

3 Answers3