$HTTP_POST_VARS

mets21

Hi,
Im developing an online recruitment website. Applicants need to fill in a C.V. comprises of many forms over many pages - ie, they fill in their personal details, then click 'submit and continue', to get to the next page where they fill in their academic qualifications, etc.
My problem is that only data from the first page goes into my database, where I use one big table for all the information about each applicant. (using inset into). The following pages use update, where User_Name = '$User_Name. Im tryin to get User_Name on each page using the $User_Name = $HTTP_POST_VARS["User_Name"], and then declaring the variable User_Name in a hidden text field on each page. However, I am not quite sure how the HTTP_POST_VARS works...
please can anyone help me?

<?
if($Submitone){
$db = mysql_connect("mysql.cs.nott.ac.uk", "msh99d", XXX);
mysql_select_db("msh99d");
$q = "update Applicant set EmailAddress = '$EmailAddress', FirstName = '$FirstName', Lastname = '$LastName', Address1 = '$Address1', Address2 = '$Address2', Postcode = '$Postcode', PhoneNo = '$PhoneNo', FaxNo = '$FaxNo', DateOfBirth = '$DateOfBirth', Gender = '$Gender'
where UserName = '$User_Name'";
$result = mysql_query($q);
$User_Name = $HTTP_POST_VARS["User_Name"];
}
?>

Thanx,
Mets

edwardsbc

Shouldn't you be setting $User_Name before you try to use it in the UPDATE query?

Depending on your PHP config, what you have here may work, as the default behaviour of PHP was to automatically register globals. In otherwords this line:

$User_Name = $HTTP_POST_VARS["User_Name"];

was done by PHP automatically. Newer versions of PHP don't register globals (unless you specifically tell it to). And in fact, the latest version depricates $HTTP_POST_VARS for $_POST. Please see this page:

<http://www.php.net/manual/en/language.variables.predefined.php>

I think you are close to on track. This is the general sequence for passing it with posts (using GET/URLs is also possible).

PAGE_ONE.PHP
...
<input type="text" name="User_Name" ...

PAGE_TWO.PHP
...
$User_Name=$HTTP_POST_VAR['User_Name'];
... Use it as needed ...
echo "<input type=\"hidden\" name=\"User_Name\" value=\"$User_Name\">"; ...

PAGE_THREE.PHP
...
(Repeat page 2)

mets21

Thanx very much for your reply - it helped me sort out the code, so it now works....for some of my pages...oh well, better than nothing I suppose.
Cheers!
Mets