redirects and error

[jeff5656]

I get this error :Warning: Cannot modify header information - headers already sent by (ou..."

 

Now I read that I get this error if there is any HTML prior to this command, but as you can see below, I don't have any HTML!  So how do I correctly redirect after the following code is run?

 

include "../connectdb.php";
$this_month=$_POST['which_month'];
$query = "UPDATE staffsched SET ";
$set = array();
foreach($_POST as $field => $value){
    $field = mysql_real_escape_string($field);
    $value = mysql_real_escape_string($value);
    $set[] = "`{$field}` = '{$value}'";

}


$query .= implode(", ",$set) . " WHERE `which_month` = '".$this_month."'";
mysql_query($query) or die(mysql_error());

header("Location: editcurrent.php");
?>

[gevans]

get rid of any white space before <?php

[PFMaBiSmAd]

The error message tells you where the output is occurring that is preventing the header. The output can be anything and is not specifically just HTML. It can be a space, new-line, UTF-8 BOM, HTML...

 

Post the whole error message and the code is mentions if you want any specific help.

[phpSensei]

There is many spaces before that include file, and correct me if I'm wrong but is that where the header begins?

 

anyways, I am wondering if this is possible in PHP

 

$set[] = "`{$field}` = '{$value}'";

 

That seems completely off to me.

[gevans]

the white space after <?php isn't important, as long as it isn#t print or echo etc....

 

That code looks fine, just adding a string made of two variables to an array?

[Maq]

Sticky time, please read...

[PFMaBiSmAd]

There is nothing wrong with that line of code.

[jeff5656]

Sorry I see no spaces:  The very very first line of this code (called commit.php) is <?php:

 

<?php include "../connectdb.php";
$this_month=$_POST['which_month'];
$query = "UPDATE staffsched SET ";
$set = array();
foreach($_POST as $field => $value){
    $field = mysql_real_escape_string($field);
    $value = mysql_real_escape_string($value);
    $set[] = "`{$field}` = '{$value}'";

}


$query .= implode(", ",$set) . " WHERE `which_month` = '".$this_month."'";
mysql_query($query) or die(mysql_error());

header("Location: editcurrent.php");
?>

 

Here is the exact error message that someone requested:

 

Warning: Cannot modify header information - headers already sent by (output started at /home/content/j/e/f/jeffjn/html/connectdb.php:2) in /home/content/j/e/f/jeffjn/html/schedules/commit.php on line 16

[PFMaBiSmAd]

Read the error 

 

output started at /home/content/j/e/f/jeffjn/html/connectdb.php:2

Something at or before line 2 in connectdb.php is causing output.

[Maq]

Use this code, let the page load, and VIEW SOURCE to see if there is any output being generated.

 

$this_month=$_POST['which_month'];
die();
?>

 

 

[phpSensei]

There is nothing wrong with that line of code.

 

If you are talking to me, I've never seen a variable being set like that with to '='s. Its okay, I learn something new everyday.

 

Post the first few line of codes in the connectdb.php page.

[gevans]

$set[] = "`{$field}` = '{$value}'";

 

The second equals is just part of a string, it has nothing to do with assigning a variable

[PFMaBiSmAd]

He's not setting a variable, he is dynamically forming an sql UPDATE query.

[gevans]

Yes, by assigning a string in an array, and using that string as part of the query, I understand.

[phpSensei]

OH man im dumb, i didnt see the double quote.

 

 

edit: I thought I saw this: $var = 'sdsads' = '{$dsf}' = $this;

 

I need to grab my glasses