[RESOLVED] Inserting Checkbox Values

obrienkev

Hi all,

I have a group of checkboxes as below.

How do I ensure that only the checked values are inserted into the database?

<td><input type="checkbox" name="equities_close" id="equities_close" value="close" /></td>
<td><input type="checkbox" name="equities_bid" id="equities_bid" value="bid" /></td>
<td><input type="checkbox" name="equities_ask" id="equities_ask" value="ask" /></td>
<td><input type="checkbox" name="equities_mean" id="equities_mean" value="mean" /></td>
<td><input type="checkbox" name="equities_manual" id="equities_manual" value="manual" /></td>

saraadmin

edit: sorry, misread post

Houdini

By first properly naming the checkboxes as array values (associative array in this case)

<td><input type="checkbox" name="equities[close]" id="equities[close]" value="close" /></td>
<td><input type="checkbox" name="equities[bid]" id="equities[bid]" value="bid" /></td>
<td><input type="checkbox" name="equities[ask]" id="equities[ask]" value="ask" /></td>
<td><input type="checkbox" name="equities[mean]" id="equities[mean]" value="mean" /></td>
<td><input type="checkbox" name="equities[manual]" id="equities[manual]" value="manual" /></td>

If Checked $POST['equities']['close']=close or $GET['equities']['close']=close ...

obrienkev

Thanks for that. Have set up the above form.

How do I process selected checkboxes?

Do I use foreach loop?

Thanks.

Houdini

Not really sure how you would want to go about processing the values but I used the below to assign all the values regardless of value by assigning a value and inserted them all into my database.

$close =($_POST['equities']['close']== 'close '? '1': '0');// $close =1 if checked 0 if not

Then inserted them into the database with a BOOLEAN datatype then if I just wanted those rows that were checked then query with the WHERE condition of close = 1

obrienkev

Thanks.

$options_close = isset($_POST['options']['close']) ? 'Yes' : 'No';
$options_bid = isset($_POST['options']['bid']) ? 'Yes' : 'No';
$options_ask = isset($_POST['options']['ask']) ? 'Yes' : 'No';
$options_mean = isset($_POST['options']['mean']) ? 'Yes' : 'No';
$options_manual = isset($_POST['options']['manual']) ? 'Yes' : 'No';