Re: Selecting checkboxes based on SQL query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Feb 23, 2012 at 7:49 PM, Rick Dwyer <rpdwyer@xxxxxxxxxxxxx> wrote:
> Hello all.
>
> I perform a SQL query like the following:
>
> $sql = 'select * from my_table where id="10"
>
> It returns the the following array for 3 records:
>
>
> Array ( [0] => Array ( [cb] => 2 ) [1] => Array ( [cb] => 6 ) [2] => Array (
> [cb] => 1 ) )
>
> The values of CB in the above array are the values of html checkboxes on a
> page.
>
> input type="checkbox" name="cb[ ]" value="1"...
> input type="checkbox" name="cb[ ]" value="2"...
> input type="checkbox" name="cb[ ]" value="3"...
> input type="checkbox" name="cb[ ]" value="4"... etc
>
> If the above array's cb value matches the value of a checkbox on the page, I
> need the default state of the checkbox to be checked.... so I know I'm going
> to have some ternary logic in each html checkbox.  But I don't know how to
> create a custom function from the above array to provide that logic.  I've
> tried some tutorials, but with no success as the array I am receiving is not
> like those in the tutorials.
>
> Any help would be greatly appreciated.
>
> Thank you.
>
>
>  --Rick
>

How about this:

input type="checkbox" name="cb[ ]" value="1" <?php
if(in_array(array('cb' => 1))) echo "checked"; ?>...
input type="checkbox" name="cb[ ]" value="2" <?php
if(in_array(array('cb' => 2))) echo "checked"; ?>...
input type="checkbox" name="cb[ ]" value="3" <?php
if(in_array(array('cb' => 3))) echo "checked"; ?>...
input type="checkbox" name="cb[ ]" value="4" <?php
if(in_array(array('cb' => 4))) echo "checked"; ?>... etc

- Matijn

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux