Warning: Cannot modify header information

Question

I know that this has been asked a thousand times and I still can't find mey error.

<body><?php
$con = mysql_connect("xxxxxxxxx","xxxxxxxxxxx","xxxxxxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("xxxxxxxxxxx", $con);

$sql="INSERT INTO mytable (row1, row2)
VALUES
('$_POSTrow1]','$_POST[row2]')";




if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
header("Location: compsubmit.php}"); 



mysql_close($con)
?></body>

And the obligatory warning... Don't directly use user input in your SQL statement! Read about prepared statements and SQL injection. — enricog, Apr 15 '11 at 10:34

score 5 · Answer 1 · answered Apr 15 '11 at 10:29

5

<body>

Thats the error. That is obviously an output.

answered Apr 15 '11 at 10:29

KingCrunch

128,817
21
151
173

There is a closing body tag too, just missed it when copying – Nige Parkin Apr 15 '11 at 10:31
@Nige: That really doesnt matter. Everything outside the PHP-tags `` are send to the browser. `` _is_ outside and it occurs _before_ `header()`. – KingCrunch Apr 15 '11 at 10:32
1

Thanks @KingCrunch. Feeling pretty daft now, but won't make the same mistake. – Nige Parkin Apr 15 '11 at 10:40

score 1 · Answer 2 · answered Apr 15 '11 at 10:32

You use the header() function. You can not send any output to the browser before using this function. And your <body> is an output.

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. The same problem exists when using a single PHP/HTML file.

score 0 · Answer 3 · edited Aug 12 '12 at 03:42

0

add this code : ob_start(); at head of your file.. this would fix the problem...

when i got this problem many times.. adding ob_start() cleared the probelm.

edited Aug 12 '12 at 03:42

answered Apr 15 '11 at 10:31

balanv

10,686
27
91
137

Output buffering is not a band-aid. – Aug 12 '12 at 03:43

score 0 · Answer 4 · answered Apr 15 '11 at 11:35

0

here <body> is an error, but this error can also occur if the file encoding is UTF with BOM - the way to avoid is to encode it without BOM

answered Apr 15 '11 at 11:35

k102

7,861
7
49
69

score -2 · Answer 5 · answered Apr 15 '11 at 10:32

-2

Might sound silly but have you used output buffering ?

answered Apr 15 '11 at 10:32

Oliver Bayes-Shelton

6,135
11
52
88

Warning: Cannot modify header information

5 Answers5

Linked

Related