php sessions and db insert

[crazy8]

Ok it seems there was some problems last time I posted (sorry about that guys) so Ill give it another shot. I am creating a form which is 3 pages long (step1.php, step2.php, and step3.php) then after all the forms are filled out I need to display all the data on a "final.php" page so the visitor can double check their input for errors and if any errors, beable to correct them (via back button) and if not, submit the forms and enter the data into the db. With that said here is some snippets of my forms...


This is "step1.php"
[PHP]<form name="step1" method="post" action="basic2. php">
<?php include ('db_scripts/db_connect_inse rt.php'); ?>
<table border="0" cellpadding="2" cellspacing="0" width="100%">
<tbody><tr>
<td colspan="2"><b> Please enter a valid e-mail address. You will need to confirm your e-mail address to activate your account.</b>
</td>
...
<td class="required ">Company Name</td>
<td class="required "><input type="text" name="comp_name " size="20" maxlength="15" /></td>
...
<td class="required ">Establish ment Type</td>
<td class="required ">
<select name="comp_type ">
<option selected>- Select One -</option>
<option value="bars">Ba r</option>
<option value="clubs">C lub</option>
<option value="coffee_s hops">Coffee Shop</option>
<option value="resturan ts">Resturant </option>
</select>
</td>
...
<td class="required ">Address</td>
<td class="required "><input type="text" name="comp_addr ess" size="30" maxlength="30" /></td>
...
<td class="required ">Phone Number</td>
<td><input type="text" name="comp_phon e" size="20" maxlength="40" /></td>
...
<td class="required ">Email Address</td>
<td><input type="text" name="comp_emai l" size="30" maxlength="20" /></td>
...
<td class="required ">Website Address</td>
<td><input type="text" name="comp_web" size="30" maxlength="20" /></td>
...
<td class="required ">Descripti on</td>
<td><textarea name="comp_desc " cols="30" rows="12"></textarea></td>
...
<td class="verdana1 1" align="right" width="125"><p> </td>
<td><input onClick="basic2 .php" type="submit" name="submit" value="Go to step 2" /></td>
</tbody>
</table>

</form>[/PHP]

and here is "step2.php"
[PHP]<div align="left"><h 2><font color="#b80101" >Types of Cuisine</font></h2></div>
<fieldset align="center">
<table>
<tr>
<td><input type="checkbox" id="foods[]" name="afghan"/></td><td>Afghan</td>
<td><input type="checkbox" id="foods[]" name="caribbean "/></td><td>Caribbea n</td>
<td><input type="checkbox" id="foods[]" name="greek"/></td><td>Greek</td>
<td><input type="checkbox" id="foods[]" name="korean"/></td><td>Korean</td>
<td><input type="checkbox" id="foods[]" name="pizza"/></td><td>Pizza</td>
<td><input type="checkbox" id="foods[]" name="swedish"/></td><td>Swedish</td>

</tr>

<tr>
<td><input type="checkbox" id="foods[]" name="american"/></td><td>American </td>
<td><input type="checkbox" id="foods[]" name="chinese"/></td><td>Chinese</td>
<td><input type="checkbox" id="foods[]" name="indian"/></td><td>Indian</td>
<td><input type="checkbox" id="foods[]" name="lebanese"/></td><td>Lebanese </td>
<td><input type="checkbox" id="foods[]" name="peruvian"/></td><td>Peruvian </td>
<td><input type="checkbox" id="foods[]" name="sweets"/></td><td>Sweets</td>

</tr>

<tr>
<td><input type="checkbox" id="foods[]" name="appetizer s"/></td><td>Appetize rs</td>
<td><input type="checkbox" id="foods[]" name="cuban"/></td><td>Cuban</td>
<td><input type="checkbox" id="foods[]" name="irish"/></td><td>Irish</td>
<td><input type="checkbox" id="foods[]" name="mediterra nean"/></td><td>Mediterr anean</td>
<td><input type="checkbox" id="foods[]" name="portugues e"/></td><td>Portugue se</td>
<td><input type="checkbox" id="foods[]" name="thai"/></td><td>Thai</td>

</tr>

<tr>
<td><input type="checkbox" id="foods[]" name="brazilian "/></td><td>Brazilia n</td>
<td><input type="checkbox" id="foods[]" name="french"/></td><td>French</td>
<td><input type="checkbox" id="foods[]" name="italian"/></td><td>Italian</td>
<td><input type="checkbox" id="foods[]" name="mexican"/></td><td>Mexican</td>
<td><input type="checkbox" id="foods[]" name="southwest ern"/></td><td>South Western</td>
<td><input type="checkbox" id="foods[]" name="turkish"/></td><td>Turkish</td>

</tr>

<tr>
<td><input type="checkbox" id="foods[]" name="cajun&cre ole"/></td><td>Cajun & Creole</td>
<td><input type="checkbox" id="foods[]" name="german"/></td><td>German</td>
<td><input type="checkbox" id="foods[]" name="japanese"/></td><td>Japanese </td>
<td><input type="checkbox" id="foods[]" name="middle_ea stern"/></td><td>Middle Eastern</td>
<td><input type="checkbox" id="foods[]" name="spanish"/></td><td>Spanish</td>
<td><input type="checkbox" id="foods[]" name="vietnames e"/></td><td>Vietname se</td>

</tr>
</table>
</fieldset>
<input onClick="basic3 .php" type="submit" name="submit" value="Go to step 3" />[/PHP]

Now last time I posted this I also added the third form but there was to much code posted here so the post had to get deleted. If this has to get deleted ill take an attempt to make the in here much shorter and simplified. Anyway what I am looking for cuz im such a noob, is to set these forms up with sessions and to do the db insert query when needed as described in the first paragraph. Thank you all so much in advance for your help.

[crazy8]

I still need help with the above question.

Thank you.

[pbmods]

Heya, Crazy8.

Let's have a look at the page that processes the checkboxes.

[crazy8]

Here is the form with the checkboxes. As you may (or may not) notice, after this page it need to goto step3.php (form 3) then from form 3 onto the 4th page which I want to display ALL the info from the forms...

[PHP]<form method="post" action="step3.p hp">
<div align="left"><h 2><font color="#b80101" >Types of Cuisine</font></h2></div>
<fieldset align="center">
<table>
<tr>
<td><input type="checkbox" name="food[]" value="afghan"/></td><td>Afghan</td>
<td><input type="checkbox" name="food[]" value="caribbea n"/></td><td>Caribbea n</td>
<td><input type="checkbox" name="food[]" value="greek"/></td><td>Greek</td>
<td><input type="checkbox" name="food[]" value="korean"/></td><td>Korean</td>
<td><input type="checkbox" name="food[]" value="pizza"/></td><td>Pizza</td>
<td><input type="checkbox" name="food[]" value="swedish"/></td><td>Swedish</td>

</tr>

<tr>
<td><input type="checkbox" name="food[]" value="american "/></td><td>American </td>
<td><input type="checkbox" name="food[]" value="chinese"/></td><td>Chinese</td>
<td><input type="checkbox" name="food[]" value="indian"/></td><td>Indian</td>
<td><input type="checkbox" name="food[]" value="lebanese "/></td><td>Lebanese </td>
<td><input type="checkbox" name="food[]" value="peruvian "/></td><td>Peruvian </td>
<td><input type="checkbox" name="food[]" value="sweets"/></td><td>Sweets</td>

</tr>

<tr>
<td><input type="checkbox" name="food[]" value="appetize rs"/></td><td>Appetize rs</td>
<td><input type="checkbox" name="food[]" value="cuban"/></td><td>Cuban</td>
<td><input type="checkbox" name="food[]" value="irish"/></td><td>Irish</td>
<td><input type="checkbox" name="food[]" value="mediterr anean"/></td><td>Mediterr anean</td>
<td><input type="checkbox" name="food[]" value="portugue se"/></td><td>Portugue se</td>
<td><input type="checkbox" name="food[]" value="thai"/></td><td>Thai</td>

</tr>

<tr>
<td><input type="checkbox" name="food[]" value="brazilia n"/></td><td>Brazilia n</td>
<td><input type="checkbox" name="food[]" value="french"/></td><td>French</td>
<td><input type="checkbox" name="food[]" value="italian"/></td><td>Italian</td>
<td><input type="checkbox" name="food[]" value="mexican"/></td><td>Mexican</td>
<td><input type="checkbox" name="food[]" value="southwes tern"/></td><td>South Western</td>
<td><input type="checkbox" name="food[]" value="turkish"/></td><td>Turkish</td>

</tr>

<tr>
<td><input type="checkbox" name="food[]" value="cajun&cr eole"/></td><td>Cajun & Creole</td>
<td><input type="checkbox" name="food[]" value="german"/></td><td>German</td>
<td><input type="checkbox" name="food[]" value="japanese "/></td><td>Japanese </td>
<td><input type="checkbox" name="food[]" value="middle_e astern"/></td><td>Middle Eastern</td>
<td><input type="checkbox" name="food[]" value="spanish"/></td><td>Spanish</td>
<td><input type="checkbox" name="food[]" value="vietname se"/></td><td>Vietname se</td>

</tr>
</table>
</fieldset>
<a href="step3.php "><img src="img/step3.gif" alt="" border="0"></a>
</form>[/PHP]

and right now I have alot of stuff on "step4" so if you want to see the script in its entirety let me know, as for JUST the code that is relivant to the step2.php stuff, this is what I have right now....

[PHP]<table border="0" cellpadding="2" cellspacing="0" width="100%">
<tbody><tr>
<td width="19%"><b> Types of Cuisine</b><br>
</td>
</tr>

<?php
if ($_SESSION['foods']) {
print "<h2>Select ed Foods</h2>";
print "<ul>";

foreach($_SESSI ON['foods'] as $val) {
print "<li>$val</li>";
}
print "</ul>";
}
?>

</tbody>
</table>[/PHP]

Thank you so much again for your patients and help.
Also incase it matters I am running php5 localy and php4 on a remote server. I have no controll over the remote server.

[crazy8]

did that help at all?

[crazy8]

Any thoughts on this one?

thanks

[pbmods]

Heya, Crazy8.

Here's what I would do in this situation. Change the names of your checkboxes to:

<td><input type="checkbox" name="food[greek]" /></td><td>Greek</td>
<td><input type="checkbox" name="food[thai]" /></td><td>Thai</td>
<td><input type="checkbox" name="food[martian]" /></td><td>Martian</td>
 

and so on.

When submitting the form, you can then loop through $_POST['food'] and look for keys that have values.

Change your PHP code to this:

<table border="0" cellpadding="2" cellspacing="0" width="100%">
<tbody><tr>
<td width="19%"><b>Types of Cuisine</b><br>
</td>
</tr>
 
<?php
if ($_SESSION['foods']) {
  print "<h2>Selected Foods</h2>";
  print "<ul>";
 
  foreach($_SESSION['foods'] as $key => $val) {
    print "<li>$key => $val</li>";
  }
  print "</ul>";
}
?>
 
</tbody>
</table>