PHP header location not working correctly

Question

I have a mysqli query and if the query is sucessfully run, I want to go to the url, else it is redirected to a different URL.

The problem is that the header loacation is not working and i cannot see why not.

Here is the code :

<!-- ADD -->

<?php

if(isset($_POST['add_category']))
{

// Set a variable to each form input name 
$category = $conn->real_escape_string($_POST['category']);
// Pass variables to database table 


    if (mysqli_query($conn, "INSERT INTO categories(category_name) VALUES('$category')")) {
        header("Location: admin.php?menu=1&alert=1");

    } else {
        header("Location: admin.php?menu=1&alert=2");
    }
}

?>

<!-- DEL -->
<?php

if(isset($_GET['del']))
{    
$id = $_GET['del'];

if (mysqli_query($conn, "DELETE FROM categories WHERE id='$id'")) {

    header("Location: admin.php?menu=1&alert=3");

}

}
?>

<!-- UPDATE -->

I have tried replaceing the first header location with just a echo string and this outputs showing the query runs correctly, the issue must be with the header location. Thankyou for any help

`error_reporting(E_ALL); ini_set('display_errors', '1');` then: http://stackoverflow.com/questions/8028957/how-to-fix-headers-already-sent-error-in-php — AbraCadaver, Nov 02 '16 at 23:59
are you making sure there is [absolutely no output to the screen](http://stackoverflow.com/a/8028987/1028804)? — Memor-X, Nov 03 '16 at 00:00
@AbraCadaver it was a rhetorical question, i just figured i get the answer link of the question — Memor-X, Nov 03 '16 at 00:15

score 0 · Answer 1 · answered Nov 03 '16 at 00:00

0

It's the whitespace outside the <?php and ?> tags.

header() must be called before any actual output is sent, either by normal HTML tags, blank lines in a file, or from PHP

Remove whitespace before and put a die() after the header() call

answered Nov 03 '16 at 00:00

Jaime

1,402
7
15

2

and `` – AbraCadaver Nov 03 '16 at 00:08
@AbraCadaver yep. Brain farted since it was a comment – Jaime Nov 03 '16 at 01:57

PHP header location not working correctly

1 Answers1