php $_post question

[spcomputing_com]

hi all,

im creating my own full-blown php/mysql guestbook 🙂 and it consists of 5 files:

• gb_form.php
  the guestbook form

• gb_review_entry.php

• allows the user to review entry before posting

• gb_add_entry.php

• adds the data to the database

• gb_results.php

• the guestbook entries

• config.php

• mysql connection information

when a user wants to sign the GB (we will call it GB for short) they start off at gb_form.php. now when they submit the form, they will be taken to gb_review_entry.php and whatever they entered in the form will be echoed on the screen using $POST (e.g. echo $POST["email_address"]).

now if they are not happy with what they have entered, there is a normal link back to the form again. however if they are ok with the entry, they click another button and it goes to gb_add_entry.php and the data is added to the database.

now that essay above is how i would like things to turn out (but they never do :rolleyes: ). my question is (at last 😃): will $POST carry the variables from the form to the review page and then again to the db add entry page? I always thought $POST could carry variables from one page to another and that's it, but I hope i am wrong.

If you know what i mean and the answer is no, do you have any other similar suggestions?

Thanks in advance 🙂 Hope you understand me.

phwoar, my fingers hurt 😃

[OhLordy]

You have a couple of options. You can either set the post data into a session or cookie and then collect it wherever you wish or you can build a hidden form to carry the post data arround. Decide which method you would prefer to use and then I can give a little more help.
Good Luck
Rob

[spcomputing_com]

I think I would like to use the hidden form field instead of using sessions. Do you have a bit of sample code I could start off with?

thank you 🙂

[spcomputing_com]

wait a minute, I think iv'e just clicked 😃

at the moment, im using:

<?
echo $_POST["emailaddress"];
?>

and repeated for each form field.

so if i do:

<input type="hidden" name="emailaddress" value="<?php echo $_POST["emailaddress"]; ?>">

that should work right?

[wolfpack52]

I am having the same issue. I cannot find the correct syntax to enter the $_POST variable into the database. Here is a snippit of php code

$query = "INSERT INTO table GUESTBOOK [(name, location, email, url, comments)] VALUES
('".$POST["name"]."', '".$POST"location"]."', '".$POST["email"]."', '".$POST["url"]."', '".$_POST["comments"]."')";
$result = mysql_query($query);
if ($result) echo mysql_affected_row()." Information entered into Guestboook.";

Can anyone point me in the right direction?

Thanks

[spcomputing_com]

why not try:

$name = $_POST["name"];
$email = $_POST["email"];
$url = $_POST["url"];
$msg = $_POST["msg"];

then when you insert the data into the DB, just use $name instead of $_POST["name"]

Hope this helps 😉

[wolfpack52]

That didnt seem to work either.

Any other suggestions?

Thanks in advance

[spcomputing_com]

My code below has always worked for me, try:

<?php
$host = 'localhost';
$user = 'dbuser';
$pass = 'dbpass';
$db = 'dbname';
mysql_connect($host, $user, $pass);
mysql_select_db($db);
function dbentry($FullName, $EMailAddress, $Location, $WebsiteName, $WebsiteURL, $DownloadedScript, $ScriptUpdates, $Referer, $Comments, $DateTime, $IP, $BrowserOS) {
global $link;
$query = "INSERT into php_scripts_dl (FullName, EMailAddress, Location, WebsiteName, WebsiteURL, DownloadedScript, ScriptUpdates, Referer, Comments, DateTime, IP, BrowserOS) VALUES('$FullName', '$EMailAddress', '$Location', '$WebsiteName', '$WebsiteURL', '$DownloadedScript', '$ScriptUpdates', '$Referer', '$Comments', '$DateTime', '$IP', '$BrowserOS')";
$result = mysql_query($query) or die("Could not insert data into database. MySQL Said: " . mysql_error());
return true;
}
{
dbentry($_POST["FullName"], $_POST["EMailAddress"], $_POST["Location"], $_POST["WebsiteName"], $_POST["WebsiteURL"], $_POST["DownloadedScript"], $_POST["ScriptUpdates"], $_POST["Referer"], $_POST["Comments"], $_POST["DateTime"], $_POST["IP"], $_POST["BrowserOS"]);
}
?>

you will need to change alot of the stuff to fit your own config etc etc. but the code itself works 😉 HTH