Love2c0de Posted May 6, 2014 Share Posted May 6, 2014 Good afternoon, How would I handle inserting checkboxes into a mysql database? I have a form which has a list of services in checkbox format as well as other fields and I want to save the values to a database but I want to be able to query the database by service if needs be. How do I deal with multiple services from checkboxes? Would I create another table called 'services' for example with columns - 'service1','service2','service3' etc etc and a unique id relating to my contact table? Thank you for your help. Kind regards, L2c Link to comment https://forums.phpfreaks.com/topic/288274-handling-checkboxes/ Share on other sites More sharing options...
Barand Posted May 6, 2014 Share Posted May 6, 2014 You would have three tables Contact contactid | contactname | etc Service serviceid | servicename | etc ContactService id | contactid | serviceid ContactService would contain a row for each service offered by each contact Link to comment https://forums.phpfreaks.com/topic/288274-handling-checkboxes/#findComment-1478376 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.