[Resolved] only show selected checkboxes in form handler

laugharne

I have a form with select , text and checkboxes. I want only selected check boxes to be processed by the form handler- at the moment when submitted all checkboxes are displayed, selected being marked "yes". The form handler also adds values to mysql database.(I have edited code for this post) All works fine, except I cannot work how to not display checkboxes that are not selected in form handler. The form handler also works out a cost of all selected items

Form Code is :
<?php # Script 12.5 - index.php
// This is the main page for the site.

// Include the configuration file for error management and such.

require_once ('config.inc');

<tr>
  <td width="35%">Norton Anti-Virus &pound;35
  <input type="checkbox" name="nav" value="1"></td>
  <td width="31%">Microsoft Office-Student &pound;105
  <input type="checkbox" name="mso" value="1"></td>
  <td width="34%">Dragon Naturally Speaking &pound;138
  <input type="checkbox" name="dns" value="1"></td>
</tr>
  <p>
<input type="hidden" name="submitted" value="yes" />

<input type="submit" value="submit" />
</p>

FORM HANDLER
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" media="screen">@import url(includes/layout.css);</style>

</head>
<body>

<?php

// Set the page title and include the HTML header.
$page_title = 'Computers for DSA';
include_once ('header.html');
require_once ('mysql_connect.php');
?>
<?php
// Welcome the user (by name if they are logged in).
echo '<h1>Dear';
if (isset($SESSION['first_name'])) {
echo ", {$SESSION['first_name']}!";
}
echo '</h1>';

Computer Store Quotation Form
You have selected the following items. Please check, and if confirmed click
Order Button . To Print this order
click print. To alter click back
Student Name and College:

Originator: 
<?php
if ($origin) echo "$origin";?>
Student Name and College: 
<?php
if ($studname) echo "$studname";?>
 
System: 
<?php
if($systems == None) echo " none";//if new product added start by adding name as opposite with if options
if($systems == 2) echo " Intel Celeron,256Mb Ram, 40Gb HDD,Int Modem,CDRW, Windows Home";
if($systems == 3) echo " P4 3.06Ghz, 256Mb Ram, 80Gb HDD,Int Modem, Windows Home";

?>

Ram Upgrade to 512mb : 
<?php
if($ramup ==1) echo "yes";

?>

CD-RW Upgrade to DVD-RW : 
<?php
if($dvd ==1) echo "yes";

  </strong></font></P>

Monitor: 
<?php
if($monitor == None) echo " none";
if($monitor == 2) echo " TFT 15";
if($monitor == 3) echo " TFT 17";
if($monitor == 4) echo " TFT 19";

?>

Printer : 
<?php
if($printer == None) echo " none";
if($printer == 2) echo " Epson C66";
if($printer == 3) echo " Epson C86";
if($printer == 4) echo " HP 3845";

?>

Scanner : 
<?php
if($scanner == None) echo " none";
if($scanner == 2) echo " Canonlide 35";
if($scanner == 3) echo " Epson Perfection 2480";

?>

3 Year Extended Warranty : 
<?php
if($exw ==1) echo "yes";

?>

Norton Anti-Virus : 
<?php
if($nav ==1) echo "yes";

?>

Microsft Office Student Version : 
<?php
if($mso ==1) echo "yes";

?>

Dragon Naturally Speaking Preferred v7 : 
<?php
if($dns ==1) echo "yes";

?>

Omni Page Pro : 
<?php
if($opp==1) echo "yes";

?>

AutoCad Student : 
<?php
if($atc ==1) echo "yes";

?>

Revit Series 2 Student Edition : 
<?php
if($rev ==1) echo "yes";

?>

Text Help Read : 
<?php
if($thr ==1) echo "yes";

?>

Inspiration V7.5 : 
<?php
if($insp ==1) echo "yes";

?>

Franklin Spell Checker DMQ : 
<?php
if($fsc ==1) echo "yes";

?>

External Mouse : 
<?php
if($exmo ==1) echo "yes";

?>

Mouse Support : 
<?php
if($mosup ==1) echo "yes";

?>

USB Soundcard : 
<?php
if($usbsc ==1) echo "yes";

?>

Digital Dictaphone : 
<?php
if($digdic ==1) echo "yes";

?>

External Microphone for Digital Dictaphone : 
<?php
if($exmic ==1) echo "yes";

Any help appreciated, I have tried a couple of options, but just get errors.

<?php

devinemke

only checked checkboxes will be returned to the form handler so you can simply use [man]isset[/man] to validate. here's a very simple example:

<?
if (!isset($_POST['submit']))
{
	echo '
	<form action="" method="POST">
	checkbox #1 <input type="checkbox" name="checkboxes[]" value="1"><br>
	checkbox #2 <input type="checkbox" name="checkboxes[]" value="2"><br>
	checkbox #3 <input type="checkbox" name="checkboxes[]" value="3"><br>
	checkbox #4 <input type="checkbox" name="checkboxes[]" value="4"><br>
	checkbox #5 <input type="checkbox" name="checkboxes[]" value="5"><br>
	<input type="submit" name="submit" value="submit">
	</form>
	';
}
else
{
	if (isset($_POST['checkboxes']))
	{
		echo 'you checked the following ' . count($_POST['checkboxes']) . ' box(es):<br><br>';
		foreach ($_POST['checkboxes'] as $value)
		{
			echo $value . '<br>';
		}
	}
	else
	{
		echo 'you did not check any boxes';
	}
}
?>

laugharne

Thanks, but not sure it is what I want to do- I am not bothered if a checkbox is selected, or none are. I had looked at isset, with regard to each.
?>

External Mouse : 
<?php
if($exmo ==1) echo "yes";

At the moment if this checkbox is selected then the from handler will print YES. I would rather that the field "External Mouse" is not printed at all unless is Yes. Or if easier if not selected print NO. Maybe I have misunderstood the code you posted.
Charles

devinemke

Originally posted by laugharne
Maybe I have misunderstood the code you posted.

yes you have misunderstood. again if a checkbox/radio or not checked then it will not return anything so you need simply use [man]isset[/man] to conditionally display something on the form handler:

if (isset($_POST['exmo']))
{
	echo 'External Mouse: YES'; 
}

however, as my code illustrates, i suggest you code all these checkbox option as an array and loop thru it on the form handler to see what isset and what is not. as it is now you are hardcoding each option which seems a bit unwieldy.

perhaps i have misunderstood you?

laugharne

I hardcoded to help with my cost calculations, but will fiddle around and see if I can use your suggestion, without upsetting the below. This takes selected and produces total cost of selected and adds cost price into MYSQL. It all works, I just want to try and show the user only fields selected in drop down or selected in checkbox, rtaher than have a field like external mouse which if not selected will have nothing against it. I guess even a NO would be better. I will try, I am a beginner, and see what happens

<?php
$systems = array (1 => 0000, 2=> 49900, 3 => 59900);//add prices here as 00 i.e £10.00=1000
$monitor = array (1 => 0000, 2 => 20000, 3 => 25000,4 =>40000);//each option has a price except none
$printer = array (1 => 0000, 2 => 5000, 3 => 6000,4 => 7000);
$scanner = array (1 => 0000, 2 => 4000, 3 => 5000,4 => 6000);
$ramup = array(1 => 5000);
$dvd = array (1 => 5000);
$exw = array (1 => 12000);
$nav = array (1 => 3500);
$mso = array (1 => 10500);
$dns = array (1 => 13800);
$opp = array (1 => 7900);
$atc = array (1 => 12000);
$rev = array (1 => 12000);
$thr = array (1 => 14500);
$insp = array (1 => 6900);
$fsc = array (1 => 2900);
$exmo = array (1 => 1400);
$mosup = array (1 => 1300);
$usbsc = array (1 => 4900);
$digdic = array (1 => 9900);
$exmic = array (1 => 4000);

$systems_s = $POST ['systems'];//add new selection here as opp- if not will not post
$monitor_s = $POST ['monitor'];
$printer_s = $POST ['printer'];
$scanner_s = $POST ['scanner'];
$ramup_s =$POST ['ramup'];
$dvd_s =$POST ['dvd'];
$exw_s =$POST ['exw'];
$nav_s =$POST ['nav'];
$mso_s =$POST ['mso'];
$dns_s =$POST ['dns'];
$opp_s =$POST ['opp'];
$atc_s =$POST ['atc'];
$rev_s =$POST ['rev'];
$thr_s =$POST ['thr'];
$insp_s =$POST ['insp'];
$fsc_s =$POST ['fsc'];
$exmo_s =$POST ['exmo'];
$mosup_s =$POST ['mosup'];
$usbsc_s =$POST ['usbsc'];
$digdic_s =$POST ['digdic'];
$exmic_s =$_POST ['exmic'];

$systems_c = $systems[$systems_s];//add new option as opp-coding must be exact
$monitor_c = $monitor[$monitor_s];
$printer_c = $printer[$printer_s];
$scanner_c = $scanner[$scanner_s];
$ramup_c = $ramup[$ramup_s];
$dvd_c = $dvd[$dvd_s];
$exw_c = $exw[$exw_s];
$nav_c = $nav[$nav_s];
$mso_c = $mso[$mso_s];
$dns_c = $dns[$dns_s];
$opp_c = $opp[$opp_s];
$atc_c = $atc[$atc_s];
$rev_c = $rev[$rev_s];
$thr_c = $thr[$thr_s];
$insp_c = $insp[$insp_s];
$fsc_c = $fsc[$fsc_s];
$exmo_c = $exmo[$exmo_s];
$mosup_c = $mosup[$mosup_s];
$usbsc_c = $usbsc[$usbsc_s];
$digdic_c = $digdic[$digdic_s];
$exmic_c = $exmic[$exmic_s];
//add new to this array all will not add
$all_components = array($systems_c, $dvd_c,$ramup_c,$monitor_c, $printer_c, $scanner_c, $exw_c, $nav_c, $mso_c, $dns_c,$opp_c,
$atc_c, $rev_c, $thr_c, $insp_c, $fsc_c, $exmo_c, $mosup_c, $usbsc_c, $digdic_c, $exmic_c);

$cost = array_sum($all_components);

$cost_quid = $cost/100; //this brings toa £total by dividing by 100

echo ' £'. $cost_quid;
mysql_query("INSERT INTO dsa(origin,studname,systems,monitor, printer,scanner,ramup,dvd,exw,nav,mso,dns,opp,atc,rev,thr,insp,fsc,exmo,mosup,usbsc,digdic,exmic,cost_quid)
VALUES ('$origin','$studname','$systems_c','$monitor_c','$printer_c','$scanner_c','$ramup_c','$dvd_c','$exw_c','$nav_c','$mso_c','$dns_c','$opp_c','$atc_c','$rev_c','$thr_c','$insp_c','$fsc_c','$exmo_c','$mosup_c','$usbsc_c','$digdic_c','$exmic_c','$cost_quid')")

or die(mysql_error());

Thanks

Charles

laugharne

Thanks- it works- I am still hardcoding, but will look at re-writing, but works and adds up

Cheers

Charles