header location not working?

[phpGrasshopper]

My first post! Need a little help on a very simple script.

<?php

$host = "yada";
$user = "blah";
$database = "blahblah";

$id = mysql_connect($host,$user);
mysql_select_db($database, $id);

//while (list ($key, $val) = each ($HTTP_POST_VARS)) {
//    echo "<br>$key: $val";
//}

$title=$HTTP_POST_VARS["title"];
$startDate=$HTTP_POST_VARS["startDate"];
$endDate=$HTTP_POST_VARS["endDate"];
$description=$HTTP_POST_VARS["description"];
$address=$HTTP_POST_VARS["address"];
$city=$HTTP_POST_VARS["city"];
$state=$HTTP_POST_VARS["state"];
$zip=$HTTP_POST_VARS["zip"];
$phone=$HTTP_POST_VARS["phone"];
$email=$HTTP_POST_VARS["email"];
$web=$HTTP_POST_VARS["web"];

$sql = "INSERT INTO calender(ID,title,startDate,endDate,description,address,city,state,zip,phone,email,web) VALUES('','$title','$startDate','$endDate','$description','$address','$city','$state','$zip','$phone','$email','$web')";
$result = mysql_query($sql);


Header("Location: view.php");

?>

The above code does NOT forward to view.php after everything else is finished. Doesn't return an error - doesn't do anything. Just stays on the current (blank) page.

Also, is there a better way to assign values to each of my post vars?
If I don't declare them like this:
$web=$HTTP_POST_VARS["web"];
then I can't refer to them by name. Example, I can't use the variable $web unless I declare it as above -- even though it was passed as a post var with the name of web already?

Hmmm...

Thanks everyone

EDIT: I'm using "Small HTTP Server" and PHP 4 on windows 98, if that helps.

[rect]

try use header() with a lowercase 'h'. an easier way to get all your variables set would be to do this.

//php >= 4.1.0
extract($_POST);

//php < 4.1.0
extract($HTTP_POST_VARS); 

basically the extract funtion takes in an array, and will create variables based on each key in the array. if you look up the extract() funtion in the php manual, you will see that you can add prefixes to the variables as well if needed. extract is one the best functions IMO.

[phpGrasshopper]

extract() works great Thanks.

Lower case header still won't work. Any other ideas?

[Technosailor]

not sure what is wrong, but one thing...you need to have a password in your db connection.

$id = mysql_connect($host,$user,$password); 

That might help ya...


Sketch

[rect]

make sure that there is nothing printed to the browser before it gets to the header() line. no html or prints. maybe that's it?

[Technosailor]

Originally posted by rect
make sure that there is nothing printed to the browser before it gets to the header() line. no html or prints. maybe that's it?

But he said there was no error. If there was no error then it couldn't be a header problem. Most likely his query never executed because the db connection was a dud and that would cause the script to simply die.

Sketch

[phpGrasshopper]

Well, the connection works fine...and it is inserting data into my table, so it can't be that?

Maybe the server software doesn't support redirects or something? What free PHP server software do you folks use?

[seanf]

Originally posted by Sketch
But he said there was no error

He/she may have PHP setup to log errors instead of displaying them

Sean

[rect]

Originally posted by phpGrasshopper
Maybe the server software doesn't support redirects or something? What free PHP server software do you folks use?

the header() function sends instructions to the browser, so it doesn't rely on the server for that. i use apache for my webserver and it is free, so you can check that out.

[DR_LaRRY_PEpPeR]

Originally posted by rect
an easier way to get all your variables set would be to do this.

//php >= 4.1.0
extract($_POST);

//php < 4.1.0
extract($HTTP_POST_VARS); 

using extract() totally defeats the purpose of accessing your variables via the arrays and not using register_globals. any variable that a user adds to the URL, etc. will be introduced as a variable in your script. i think it's much better to do it the way he was doing it, as HE controls what variables are created in the script, not the user. the only thing i would do is use references, since it's faster:

$title = &$HTTP_POST_VARS['title']; 

etc.

Originally posted by phpGrasshopper
What free PHP server software do you folks use?

Apache.