close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues


How to set multiple datas?

Thread began 6/12/2020 3:24 pm by Steve | Last modified 6/15/2020 10:12 am by Ray Borduin | 97 views | 3 replies |


How to set multiple datas?

I have two cases where I am asking WebAssist best practices before I head off to create arrays and write my own code.

1) I have a page with a number of checkboxes in a checkbox group that once selected will be used to email to all selected recipients

<input type="checkbox" class="form-check-input"  name="CheckboxGroupGCs[]" value="<?php echo($Contacts->getColumnVal("pcEmail")); ?>" id="CheckboxGroupVendors_<?php echo($Contacts->getColumnVal("pcID")); ?>">

It looks like the Send Mail behavior is set up to use results by imploding an array of results/values on $_POST:

$Email->addTo("".((isset($_POST["CheckboxGroupGCs"]))?implode(",",$_POST["CheckboxGroupGCs"]):"")  ."");

2) What about Inserting a record of all the selected values? I would like to assign two value on Insert ($target and $emailID). Each would insert as a unique row.

Is there something already built into the MySQLi Insert Behavior or should I loop the Insert Behavior, or collect all the records into an array then Insert while looping through the array?

Thanks in advance for the guidance,

Sign in to reply to this post


I see there is an Insert Multiple Records behavior so that effectively solves inserting many records.

Sign in to reply to this post

Ray BorduinWebAssist

Actually the regular insert would work as well. Just bind the value as an array and it will automatically convert it to insert multiple records.

Sign in to reply to this post
Did this help? Tips are appreciated...


Thanks Ray, yes the standard insert worked fine accepting an array which required making the checkbox name with the square braces[].

The Dynamic checkbox select if equal to did not work as well as it kept inserting independent values with each test:

<?php if (!(strcmp(($Companies->getColumnVal("companyID")),$Companies_assigned->getColumnVal('psaCompany')))) {echo "checked=\"checked\"";} ?>
<?php if (!(strcmp(($Companies_assigned->getColumnVal("psaCompany")),"Y"))) {echo "checked=\"checked\"";} ?>
<?php if (!(strcmp(($Companies_assigned->getColumnVal("psaProject")),"$Companies->getColumnVal(\'companyID\')"))) {echo "checked=\"checked\"";} ?>
name="CheckboxGroup1_<?php echo($wa_startindex); ?>"
value="<?php echo($Companies->getColumnVal("companyID")); ?>"
id="CheckboxGroup1_<?php echo($Companies->getColumnVal('companyID')); ?>_<?php echo($wa_startindex); ?>">

This was easiliy surmounted by putting the recordset in an array and using the PHP in_array function:

<input <?php if (in_array($Companies->getColumnVal("companyID"),$nameArray)) {
echo "checked=\"checked\"";
} ?>
value="<?php echo($Companies->getColumnVal("companyID")); ?>"
id="CheckboxGroup1_<?php echo($Companies->getColumnVal('companyID')); ?>">
Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...