Serialize checkbox array, also get checkboxes with off-value

Question

I was wondering if this is possible. The serialize-string will be inserted in a mySQL-database, so it would be fine if all checkboxes would be inserted and not only the ones that is ticked(on).

it's possible to make on column in the database for each of the checkboxes, and use this if/else-statement:

if(isset($_GET['checkbox'])) {
                  // It's checked!
         }
         else {
                  // not checked!
         }

but its a bit unappropriate...

Your statement "the serialize string will be inserted in a mySQL database" is concerning. You don't mean you're going to have a varchar or text column that simply stores the serialized string, right? Each checkbox will really be its own independent column, right? — Tony Miller
– Tony Miller, Commented Apr 14, 2010 at 17:32
hum. that's what I meant, actually. that the serialized string will be stored in a varchar-column. is it better if I have one column for each checkbox..? — guzh
– guzh, Commented Apr 16, 2010 at 22:42

Quentin · Accepted Answer · 2010-04-14 16:46:55Z

2

Give all the checkboxes the same name (ending in [] since this is PHP)
Give all the checkboxes different values
Have an array of all possible values in the script (you can use the same array when generating the HTML for the form!)
Loop over it and use in_array to determine if you should set it to true or false
Pass the result to your database function

answered Apr 14, 2010 at 16:46

Quentin

949k136 gold badges1.3k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Serialize checkbox array, also get checkboxes with off-value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related