Setting Checkbox Variables

[obrienkev]

Hi all,

I have many checkboxes like below. I want to set variables for each users selection and insert that value into DB.

How do I set the variables?

Thanks.

 <tr>
 <td>Equities</td>
 <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>
 <td><textarea rows="3" cols="15"></textarea></td>
 </tr>
 <tr>
 <td>Bonds</td>
 <td><input type="checkbox" name="bonds[close]" id="bonds[close]" value="close" /></td>
 <td><input type="checkbox" name="bonds[bid]" id="bonds[bid]" value="bid" /></td>
 <td><input type="checkbox" name="bonds[ask]" id="bonds[ask]" value="ask" /></td>
 <td><input type="checkbox" name="bonds[mean]" id="bonds[mean]" value="mean" /></td>
 <td><input type="checkbox" name="bonds[manual]" id="bonds[manual]" value="manual" /></td>
 </tr> 

[Dan Grossman]

PHP will populate two associative arrays for you:

$_POST Array
(
    [equities] => Array
        (
            [close] => close
            [bid] => bid
            [ask] => ask
            [mean] => mean
            [manual] => manual
        )

    [bonds] => Array
        (
            [close] => close
            [bid] => bid
            [ask] => ask
            [mean] => mean
            [manual] => manual
        )

)

Only checkboxes that were checked will be present in the array -- unchecked boxes will not have keys/indexes at all.

[mudshark]

Only checkboxes that were checked will be present in the array -- unchecked boxes will not have keys/indexes at all.

... which might explain the problem you're having here...

[obrienkev]

sorry head not right today.

how do I use those arrays?? To insert into database?

thanks.

[Dan Grossman]

$close = isset($_POST['equities']['close']) ? 1 : 0; 

[obrienkev]

So do I have to repeat that for each array item?

[Dan Grossman]

Since you need to get a value for each one to insert into your database, yes. Simply looping over the array won't work since there won't be entries for the checkboxes that weren't checked.

That code will assign $close 1 if the equities[close] checkbox was checked, 0 if it wasn't (and thus isn't in the array at all). You can change those values to whatever you want to put in your database when a checkbox is checked or unchecked.

[obrienkev]

OK. Thanks. Do you spot a syntax error somewhere? Get a blank page now when add the below code...

 // Check Pricing Variables
 $_POST Array
 (
     [equities] => Array
         (
             [close] => close
             [bid] => bid
             [ask] => ask
             [mean] => mean
             [manual] => manual
         )
 
     [bonds] => Array
         (
             [close] => close
             [bid] => bid
             [ask] => ask
             [mean] => mean
             [manual] => manual
         )
                 
     [futures] => Array
         (
             [close] => close
             [bid] => bid
             [ask] => ask
             [mean] => mean
             [manual] => manual
         )
                 
     [options] => Array
         (
             [close] => close
             [bid] => bid
             [ask] => ask
             [mean] => mean
             [manual] => manual
         )
 
 )
 $equity_close = isset($_POST['equities']['close']) ? 1 : 0;
 $equity_bid = isset($_POST['equities']['bid']) ? 1 : 0;
 $equity_ask = isset($_POST['equities']['ask']) ? 1 : 0;
 $equity_mean = isset($_POST['equities']['mean']) ? 1 : 0;
 $equity_manual = isset($_POST['equities']['manual']) ? 1 : 0; 

[Dan Grossman]

You don't want to add that Array ( ) stuff up top. That was just me showing you what arrays were created from posting your form. That's not actual code.

[obrienkev]

ok. Thanks.