How To Insert , Update multiple checkboxes to mysql?

Question

I have a form with 80 checkboxes.. Its a options form for car.. For example

Colour: black , red , white , yellow etc.. How should i design my database for many options?

should i create 80 column in table? or use implode() and save in a one column or multiple rows? but when i need i should update it...

Car_id |  black | red | white | yellow  |..... | option80 |
1            true     true

how should i do ? Thank you for your help

A table for car that has a column linked to a table called color, this way 1 column has a relationship with another table and so on. — Lawrence Cherone
– Lawrence Cherone, Commented Jan 17, 2013 at 9:21

Tikkes · Accepted Answer · 2013-01-17 09:23:39Z

2

Check out normalization. That might help.

Anyway, to help you get on your way, here's a basic setup for that.

+-----TABLE CAR------+
ID
NAME

+-----TABLE COLOR------+
ID
COLOR

+-----TABLE CAR_COLOR------+
CAR_ID
COLOR_ID

This makes sure you have a link table between CAR and COLOR

Hope this was helpful

answered Jan 17, 2013 at 9:23

Tikkes

4,6874 gold badges38 silver badges66 bronze badges

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

2 Comments

OMahoooo Over a year ago

how can i update it ? maybe there are 40 options checked? its gonna be car_id 1 , color_id 1 | car_id 1 , color_id 2

Tikkes Over a year ago

exactly, that's how the link table is used.

QArea · Accepted Answer · 2013-01-21 09:14:43Z

0

If you plan to do in the future selection of the item by color, then it is better to create related tables:

table of cars (car_id, car_name)

table of colors (color_id, color_name)

table of relation colors and cars (car_id, color_id)

(sql - join)

And if you plan to just use as a characteristic of the car, then one cell with all the flowers separated "|" and when you create insert in the database use implode(), and select from the database explode()

answered Jan 21, 2013 at 9:14

QArea

5,0231 gold badge16 silver badges23 bronze badges

Collectives™ on Stack Overflow

How To Insert , Update multiple checkboxes to mysql?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related