How to store checkbox values in a database

Hello,

I don't know the best way of storing checkboxes values in a data base. So I did a quick research and found that it could be stored as numbers: http://stackoverflow.com/questions/1352622/search-friendly-way-to-store-checkbox-values-in-mysql

Now suppose I have 7 choices as check boxes.
How do I know how may many were checked and what are they.

or else, Is there a better way to store check boxes values in a data base?

I was thinking to store them in one text field (but all together looks ugly) What do you think?

table name: Hobbies
field 1: usrID
field 2: hoppyType (check box value)

---
Thanks in advance.

Solution: How to store checkbox values in a database

If you already have your field "Hobbies" created, you can just ALTER it for the new checkboxes:

ALTER TABLE Hobbies ADD cycling TINYINT NOT NULL DEFAULT '0';
ALTER TABLE Hobbies ADD photography TINYINT NOT NULL DEFAULT '0';
ALTER TABLE Hobbies ADD bug_collecting TINYINT NOT NULL DEFAULT '0';

etc...

Popular Tags

Browse All Tags