Inserting fields and checkbox values into a mysql db

chriscapetown

Hey,

I have about 5 pages, first page has a couple of fields and all the other pages have different checkboxes on them, pages going in sequence, like you can see in the link below:

http://taxmon.designrobot.co.za/dialup/step1.html

The method im thinking of, is to insert the field values into the table, and then use an update query on the same ID for the rest of the pages containing checkboxes, but not sure how to go about it!

Im thinking about basing it on this code:

$color = $_POST['color'];
$self = $_SERVER['PHP_SELF'];

#connect to mysql
$conn=@mysql_connect( "localhost", "user", "pass" )
    or die( "Error connecting to MySQL" );

#select specified database
$rs = @mysql_select_db( "capetownalive", $conn )
    or die( "Error connecting to db" );


if(!empty($_POST['color']) && is_array($_POST['color'])) {
    $_POST['color'] = array_map('mysql_real_escape_string', $_POST['color']);
    $colors = implode('\'), (\'', $_POST['color']);

$query = 'INSERT INTO colors (color) VALUES (\'' . $colors . '\')';
$rs = mysql_query($query);
} else {
    // they didn't specify a color, or there was a problem with the data type
}

Really desperate to get this working, would really appreciate any advice or comments.

Thanks alot
Chris

bradgrafelman

I would recommend you instead store the data in a session and only INSERT data into the DB on the final page. That way you avoid partially-completed rows and ensure that users can't edit existing rows' data.

Also, I removed the MySQL login credentials from your post above; I don't know if they were valid or not, but you might want to be more careful about what you post for the world to see... 😉

chriscapetown

That does sound like a better way of going about it..

If I start a session, how do I before proceeding to the next page make sure the values of the fields/checkboxes are being stored?

chriscapetown

Ok I done a bit more looking around and I came up with this, but want to know if it will work fine... Can anyone see a error in the below code? I would fill up the other cases with more tables of inputs, but want to know if I can just stick table code in like this?

<body> 
<?php 
 $thisPage = ( isset($_POST['showpage']) and ctype_digit($_POST['showpage'])? $_POST['showpage'] : '1' ); 

if ( $thisPage == '7' ) { 
  // This is the last page - show/process results here 
  foreach( $_POST as $name => $value ) { 
    print "$name - $value<br>";
	echo "Your quote was generated successfully. It has been sent to Tax Monitor and one of our representatives will contact you with further details.";


} 

else { 
  // Other page - Create form and hidden inputs 
  print '<form method="post" action="'.$_SERVER['php_SELF'].'">'; 

  foreach ( $_POST as $name => $value ) { 
    print '<input type="hidden" name="'.$name.'" value="'.$value.'">'; 

  switch ( $thisPage ) { 


  case '6': 
    print '<input type="hidden" name="showpage" value="5">'; 
    // Put PAGE 4 inputs here 
		// END PAGE 6
    break; 

  case '5': 
    print '<input type="hidden" name="showpage" value="5">'; 
    // Put PAGE 4 inputs here 
		// END PAGE 5
    break; 

  case '4': 
    print '<input type="hidden" name="showpage" value="5">'; 
    // Put PAGE 4 inputs here 
		// END PAGE 4
    break; 

  case '3': 
    print '<input type="hidden" name="showpage" value="4">'; 
    // Put PAGE 3 inputs here 
		// END PAGE 3
    break; 

  case '2': 
    print '<input type="hidden" name="showpage" value="3">'; 
    // Put PAGE 2 inputs here 

// END PAGE 2


break; 

  case '1': 
  default: 
    print '<input type="hidden" name="showpage" value="2">'; 

// Start PG 1
echo "<table width="100%" border="0" cellpadding="0" cellspacing="0" class="tableform">
  <tr>
    <td colspan="3" class="tableheader">Contact Details</td>
  </tr>
  <tr>
    <td colspan="3">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="3"><img src="../imgs/spacer.gif" width="57" height="4" /></td>
  </tr>
  <tr>
    <td width="5%" class="formtext"><img src="../imgs/dialup/bullet.gif" width="10" height="10" /></td>
    <td width="34%" class="formtext">Full Name: </td>
    <td width="61%"><input type="text" name="textfield" class="textbox"/></td>
  </tr>
  <tr>
    <td class="formtext"><img src="../imgs/dialup/bullet.gif" width="10" height="10" /></td>
    <td class="formtext">Email Address: </td>
    <td><input name="textfield2" type="text" class="textbox" /></td>
  </tr>
  <tr>
    <td class="formtext"><img src="../imgs/dialup/bullet.gif" width="10" height="10" /></td>
    <td class="formtext">Contact Number: </td>
    <td><input name="textfield3" type="text" class="textbox" /></td>
  </tr>
  <tr>
    <td class="formtext"><img src="../imgs/dialup/bullet.gif" width="10" height="10" /></td>
    <td class="formtext">Company:</td>
    <td><input name="textfield4" type="text" class="textbox" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td height="18"><img src="../imgs/spacer.gif" width="57" height="2" /></td>
    <td>&nbsp;</td>
  </tr>
</table>";
// END PG 1


break; 
  } 
  print '</form>'; 
} 
?> 
</body>

chriscapetown

anyone? :\

chriscapetown

Please because its Christmas day and im still puzzling will someone try help me ?:glare:

laserlight

Ok I done a bit more looking around and I came up with this, but want to know if it will work fine.

Try it out yourself and see if it works.

Please because its Christmas day and im still puzzling will someone try help me ?

We tend to be partying or out with friends on Christmas day... I'm just in between the two :p