Re: Selecting checkboxes based on SQL query

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

 



I should have been more explicit in my description...

The SQL command that returns the array is not the same one that creates the checkboxes.... they are two different sql queries and I would prefer to keep them that way.

I actually have it working for a form submit with a custom function I got off the web. But the custom function relies on the array it's working on to look like this:

[cb] => Array ( [0] => 1 [1] => 6 [2] => 2 [3] => 4 [4] => 3 )


So, to use my existing function, how do I get the following array to look like the above one:

Array ( [0] => Array ( [cb] => 2 ) [1] => Array ( [cb] => 6 ) [2] => Array ( [cb] => 1 ) )


 --Rick


On Feb 23, 2012, at 2:08 PM, Fatih P. wrote:

On Thu, Feb 23, 2012 at 8: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



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


replace the name part as following

input type="checkbox" name="cb[put_the_id_here]" value="1".


when dumping into html from array


foreach ($sql_result as $value) {
  if ($value == $selected) {
          input type checkbox name=cb[$value['id']] value=$value['id']
checked=checked
  } else {
       input type checkbox name=cb[$value['id']]   value=$value['id']
  }
}

hope this helps


--
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