THEMA:

Hi Team,
I have a checkbox-group called wtgroup with a list of days and assigned values like unix-days (1 to 6 and sunday is 0).
Saving the date writes the list of values comma seperated into the databes (f.e 2,4,5,6)
No I like to load the data from database and preset the checkboxes aligned to the values of the database.
How can I do this? For a single checkbox I found solution, but it should be a checkbox-group now.
Thanks a lot

Hello,

this is very similar to selectlists.

Assuming you want to preset the the checkboxoptions with all users in your db, you can do the following in a before form piece:

$this->execPieceByName('ff_InitLib');
global $listdata;
//fetch the data from DB
$rows = ff_select("SELECT id, username FROM jos_users");

// create the group definition string
$listdata = "0;Please select a value;0\n";

for ($i = 0; $i < count($rows); $i++) {
$listdata .= "0;{$rows[$i]->username};{$rows[$i]->id}\n";
}



Now go to your checkboxgroup and add the following line to the group definition field:

<?php global $listdata; return $listdata; ?>

This example will generate checkboxgroup options based on the values which are fetched from the user table.
So all you need to do is customize the $listdata string as desired.


Let me know if this helps.

Regards,
Syno