passing on variable names

Sul

I've got a form on a page, where user inputs some data, and the action of the form is another php page, which inputs the data into the database. How do I pass on the info inputted into the form onto the action page?

I've got something like:

<form method=post action="add.php">

   <input type=text size=40 name=email>

   <input type=submit name="submit" value="submit">

</form>

I think the page is meant to automatically pass some global variables like $email (from the email input), but mine doesn't seem to be working.

dalecosp

See the "Newbies forum FAQ and bookmarked threads" sticky post above, #1.

Sul

Okay, now I'm getting an error:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in ****\add.php on line 11

from the following code...I have no idea what's wrong.


if ($_POST['submit'] == "submit")
{
$query = "insert into guestbook (name, location, email, url, comments) values
		  ($_POST['name'],$_POST['location'],$_POST['email'],$_POST['url'],$_POST['comments'])";

mysql_query($query) or die (mysql_error());
}

dalecosp

I'd put all those vars into local variables. Also, you should single quote the parameters fed to the database, i.e. $query="insert into foo values '$bar', '$baz', '$qux'"; That's probably the source of the error message. You can't put $_POST['foo'] into a double-quoted (parsed) string statement....

The way you have it will be pretty confusing, 'cause you'll need to escape the double quote to put in the array and key.

$query = "insert into guestbook (name, location, email, url, comments) values ('".$_POST['name']."', '".$_POST['location']."', 

// etc. it's a quoter's nightmare....

Sul

Thanks! Got it working now 🙂