Please enable JavaScript to view this site.

Navigation: Advanced topics > Events > Sample events > Database

Select multiple values to show as individual database entries

Scroll Prev Next More


To select multiple values from checkboxes or a list field and have them appear as individual database entries, use the following code in the Add page: Before Record Added event.




if ($values["fieldname"])
$arr = explode(",",$values["fieldname"]);
// This is the name of the multi check box or
// list select field, its value becomes $arr
for ($i=0;$i<count($arr);$i++)
$strInsert = "insert into TableName (field) values ('".$arr[$i]."')";
// add more fields from the add page to be inserted into database
header("Location: MyPage_list.php");
// Exit and Redirect to the list page after updating database

See also:

JavaScript API:getSelectedRecordKeys()

Database API: DB::Exec

Redirect to another page


Created with Help+Manual 7 and styled with Premium Pack Version 3 © by EC Software