foreach hidden fields not working???

[jonathen]

Hi,

I recently adopted the foreach statement in a multi-form I am using as advised by one of the members here.

However, it does not appear to work - my form is 6 pages (1 file) which takes all fields from each page and carries them over using hidden fields (supposed to) and then dumps to db.

However, the dump to db is only dumping the last form fields page (page 5) - it is ignoring all the others (as if their values have been left blank)

This is how my script currently works (cut-down version):

echo "<form name='form1' action='form.php' method='get'>";
if (!isset($pageno))
{
  $pageno = "1";
echo "Name:<input type='text' name='name'>";
echo "E-mail:<input type='text' name='email'>";
echo "<input type='submit' name='cmdGo' value='Next >>'>";
echo "<input type='hidden' name='pageno' value='$pageno'>";
echo "</form>";
}
else if ($pageno == "1")
{
  $pageno = "2";

echo "<form name='form2' action='form.php' method='post'>";
echo "address:<input type='text' name='address'>";
echo "<input type='submit' name='cmdGo' value='Next >>'>";
echo "<input type='hidden' name='pageno' value='$pageno'>";
foreach($_POST as $key => $value) {
   echo "<input type=\"hidden\" name=\"" . $key . "\" value\"" . $value . "\">\n";
}
echo "</form>";
}

...and so on and so on, each new "page" beginning a new "form" with a different name, with a hidden field using "foreach" to grab all values from the previous pages' fields.

This goes on until the page 5, which has a submit button to finish the script, and then page 6 (confirmation) has the dump to db script:

}
  else if ($pageno == "5")
{
  $pageno = "6";
  echo "<form name='form6' action='form.php' method='get'>";
  foreach($_POST as $key => $value) {
   echo "<input type=\"hidden\" name=\"" . $key . "\" value\"" . $value . "\">\n";
}
  $link = mysql_connect("$db_host","$db_user","$db_pass") or die( "Unable to connect to database");
mysql_select_db("$db_name",$link) or die( "Unable to select database");
$query="insert into test (name,email,address) values 
('".$name."','".$email."','".$address."')";
mysql_query($query) or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."\n";;

Any ideas what I am doing wrong? Thanks in advance.

[cgraz]

Do you have globals on? you're inserting with the assumption that globals are on. if they're off you'll need to use $POST. To check if those values are even there, try this:

$query="insert into test (name,email,address) values ('".$name."','".$email."','".$address."')";
print $query . "<br>"; // I added this line
mysql_query($query) or die(mysql_error());

If the values aren't there, try changing those 3 variables using $_POST["var_name"], then print the query. What i'd also do is check the html source on your pages on each page of the form to see if the hidden inputs were even created. They most likely were. Also, were you the one who had 149 fields? If so, I would STRONGLY suggest using a loop to insert all those 149 fields instead of manually typing out the query.

Cgraz

[jonathen]

Hi, and thanks for answering.

Yes, globals are ON.
No, the hidden fields are not being brought across to each page.
Yes, I am the 149 field man (unfortunately) and I think it was you who advised using that foreach loop, which I am trying to use. However, it's not carrying the fields across (I have removed all hidden fields and replaced with the foreach code)

This is driving me nuts!

[cgraz]

What version of PHP is your server running? You may need to use $HTTP_POST_VARS rather than $_POST (depending on your php version)

Cgraz