multiple radio input

[kpowning]

I'm trying to now use a radio buttons to input the information that the customer wants more information on into my table with a column named: Interested. Now i get an error stating Column 'Interested In' cannot be null. How can I let my customers select more than one radio button as well??? I can't get this to work please help...............................

Script:

<p><u><strong>I'm interested in the following home automation area (Please
Select One):</strong></u></p>
<p align="left">
<label>
<input type="radio" name="interest[]" value="1">
Total Home Automation</label>
<br>
<label>
<input type="radio" name="interest[]" value="2">
Lighting / Scene Control</label>
<br>
<label>
<input type="radio" name="interest[]" value="3">
HVAC (Heating & Air Conditioning) Control</label>
<br>
<label>
<input type="radio" name="interest[]" value="4">
Whole House Audio</label>
<br>
<label>
<input type="radio" name="interest[]" value="5">
Home Theater</label>
<br>
<label>
<input type="radio" name="interest[]" value="6">
Advanced Irrigation</label>
<br>
<label>
<input type="radio" name="interest[]" value="7">
Enhanced Security Control</label>
<br>
<label>
<input type="radio" name="interest[]" value="8">
Touch-Screen Operation Upgrade</label>
<br>
<label>
<input type="radio" name="interest[]" value="9">
Advance Remote Access (Control via Phone and/or Internet)</label>
<br>
</p>

[ingchun]

why don't you use checkbox to let user select more than one option?

<input type="checkbox" name="interest[]" value="1">

[kpowning]

i tried that, but i had the same problem... it would only submit array in the column in the table. plus, only the last checked box would be submitted... any other ideas,,,,pleeeeeaaaasssseee???

[sarah]

Implode the array into a comma delimited string before it goes into the database?

$interest = implode(",", $interest);

[kpowning]

Thanks for your posting, but still it won't work. All I'm gettiing is wrong parameters for implode....

[enterume]

kpowning, I can only assume you are trying to get input from user to fill in the form, and save it into a single field(eg:Interest) at your db. if so, after the user submit, try the code below:

assume that your global_register is ON at php.ini

 
<?
$data_count = count($interest);
for ($x=0; $x<$count; $x++) {
	if (!empty($data)) $data .= ",".$data;
	$data .= $interest[$x];
}

//by now, you should have all the checkbox value at $data
?>

assume that your global_register is OFF at php.ini

<?
$data_count = count($_POST["interest"]);
for ($x=0; $x<$count; $x++) {
	if (!empty($data)) $data .= ",".$data;
	$data .= $_POST["interest"][$x];
}

//by now, you should have all the checkbox value at $data
?>

Checking for Interest if null

<?
if (count($_POST["interest"]) < 0) {
   //your error handling
}

or

<?
if (count($interest) < 0) {
   //your error handling
}

getting result from db
you should either use 'explode' or 'split' for each Interest, by ',' string.

Hope the stuff above is what you want.

[kpowning]

Thanks for the info... Now I'm getting column interest cannot be null... Any ideas???

Sorry, I'm really new in .php and if you need to see the scripting, I can send you it in an email or however you would like...

Thanks,
Kyle

[enterume]

yes, you can do , check my previous posting at Checking for Interest if null .

if the count() is <1, it mean the $interest array is empty, and you can set your error handling, whether redirect back to the same page and indicate the user that the required section is not filled. Or javascript pop up indication message.

[sarah]

What happens if you try to print $interest[0]?

[kpowning]

same thing. Interest cannot be null.. Thanks for the help though.. Any other ideas?