Checkbox value

Tezread

I have some checkboxes which if you leave unchecked, result in an Undefined index error message.

How can I get round this so there is some kind of default value that is entered apart from the checked or unchecked value:


    <td>VDE (Volunteer Development England) Quality Mark</td>
    <td>&nbsp;</td>
    <td><input type="checkbox" name="list_quality_sys_29" value="Heard of this"></td>
    <td><input type="checkbox" name="list_quality_sys_30" value="Relates to organisation"></td>

Tezread

I found another post on this since posting this thread and I have a way around though it is long.

To quote Roger Ramjet:

"If you don't click a checkbox, it is not posted with the form. So by omitting a checkbox you omit the corresponding var, This means the the value is missing from your query string, but the column name is present. Query fails through wrong number of values for the column list."

The following code addresses this

if (isset($_POST['list_quality_sys_1'])) { 
   $list_quality_sys_1 = -1; 
} else { 
   $list_quality_sys_1 = 0; 
}

What can I do If I have thirty something vars though.
I think the 'foreach' function can be used but in what capacity?

tunage

You could send a hidden variable telling you how many checkboxes there are, then use a for loop to check if each name exists.

$num = $_POST['num_of_checkboxes'];

for ($i=0; $i<$num; $i++)
{
    $check_name = "list_quality_sys_" . $i;

if (isset($_POST[$check_name])) echo "it was checked!";
else echo "it wasnt checked!";
}

Tezread

is this finding out the number of checkboxes based on the names of the checkboxes in the form i.e list_quality_sys_1, list_quality_sys_2 etc

tunage

On your form you have a hidden variable called $num_of_checkboxes

Eg if $num_of_checkboxes = 40, you have checkboxes called list_quality_sys_1 up to list_quality_sys_40

Then on the next page the for loop checks to see if each name exists (at present it will loop through from list_quality_sys_0 to list_quality_sys_39) but you get the idea..

rincewind456

This is a modified version of Tunage's code that should work for you

$num = $_POST['num_of_checkboxes']; // this can be like this or be an integer ie $num =37;

for ($i=1; $i<=$num; $i++)  {

if (isset($_POST['list_quality_sys_' . $i]))

$_POST['list_quality_sys_' . $i] = 'Y';

else $_POST['list_quality_sys_' . $i] = 'N'; 

 }

This will then set any boxes that have not been checked to N and any that have to Y, ready to be inserted to the Database.

Tezread

OK- ive tried tunage's apprach and come out with an undefined error message e.g:

Notice: Undefined index: num_of_checkboxes in /disk1/home3/mindseye/public_html/nottsvcs_short_1_4_formhandler.php on line 193

Notice: Undefined index: list_quality_sys_1 in /disk1/home3/mindseye/public_html/nottsvcs_short_1_4_formhandler.php on line 202

Notice: Undefined index: list_quality_sys_2 in /disk1/home3/mindseye/public_html/nottsvcs_short_1_4_formhandler.php on line 203

Here is my code:

<?php
include("connect.php");
error_reporting(E_ALL); 
ini_set('display_errors', '1'); 

if (isset($_POST['Submit'])) {

$contact = $_POST['contact'];
$nameorg = $_POST['nameorg'];
$telephone = $_POST['telephone'];

$num = $_POST['num_of_checkboxes']; 

for ($i=0; $i<$num; $i++) 
{ 
    $check_name = "list_quality_sys_" . $i; 

if (isset($_POST[$check_name])) echo "it was checked!"; 
else echo "it wasnt checked!"; 
} 
$list_quality_sys_1 = $_POST['list_quality_sys_1'];
$list_quality_sys_2 = $_POST['list_quality_sys_2'];

$sql = "INSERT INTO nottsvcs (contact, nameorg, telephone,
,list_quality_sys_1, list_quality_sys_1)"

VALUES (
,'$contact'
,'$nameorg'
,'$telephone'
,'$list_quality_sys_1'
,'$list_quality_sys_1'

)"

or die (mysql_error());

//execute query and store the result

$res = mysql_query($sql,$connection);
echo $res;
if ($res) {
echo "Your survey has been submitted - thankyou<BR /><BR />";
exit;
} else {
echo "There was a problem with your post - please click the back button and try again.<BR /><BR />";
}
}
?>