close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Checkbox and list values appear as "Array"

Thread began 3/05/2012 3:45 pm by Gary Young | Last modified 3/06/2012 3:29 pm by Jason Byrnes | 1348 views | 6 replies |

Gary Young

Checkbox and list values appear as "Array"

Hi,

I am running CSS FB 2.0.1, I created a form with a check box element and a list element, the checkbox allows a single select and the list is a multiple select, when the form is submitted the contents are loaded to a database, the values of the fields are not written to the database and both fields display a value of 'Array' in the email. I also have a select menu on the page which submits and displays correctly and writes its value to the DB table.

performers.php

Regards,

Gary

Sign in to reply to this post

Jason ByrnesWebAssist

add the following code at line 1 of the page:

php:
<?php

if($_SERVER["REQUEST_METHOD"] == "POST")     {
    foreach(
$_POST as $key => $val) {
        if(
is_array($_POST[$key])) $_POST[$key] = implode(", "$_POST[$key]);
    }
}
?>
Sign in to reply to this post

Gary Young

Thanks Jason, I'll give it a shot.

Sign in to reply to this post

Gary Young

Hi Jason,

Thank you, That worked great for the email portion of the form, however it still is not writing the values to the database fields. I have attached the page for inspection so you can let me know where I went wrong.

Thanks,

Gary

Attached Files
performers.zip
Sign in to reply to this post

Jason ByrnesWebAssist

for a multiple select list or checkbox group to pass info, the name of the element needs to end with "[]" to create an array.

when selecting the binding for the multi select or checkbox group, the binding code will include the "[]" at the end, for example:

<?php echo((isset($_POST["classification[]"]))?$_POST["classification[]"]:"") ?>

but will need to be removed from the binding code:
<?php echo((isset($_POST["classification"]))?$_POST["classification"]:"") ?>

in the insert record behavior, inspect the code that is in the value for the columns that are getting the multi select and checkbox group, and remove the "[]" characters from it.

Sign in to reply to this post

Gary Young

Thank you Jason for not just giving me the answer I needed, but for explaining in enough detail to hel me avoid making the same mistake again, but not too much to make a non coders head spin!

Much appreciated

Sign in to reply to this post

Jason ByrnesWebAssist

you're welcome.

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

Content

rating

Layout

rating

Ease of use

rating

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