How do I insert multiple checkbox values into a table

Question

I cant seem to find or figure out a working solution to insert multiple checkbox values from a form into a table  The closes I have come is inserting the value of merely one checkbox value into a table  Kindly point out how I can insert multiple checkbox values and not merely one   Find below what I have so far   My form    lt html gt   lt body gt   lt form method  post  action  chk123 php  gt  Flights on   lt br  gt   lt input type  checkbox  name  Days  value  Daily  gt Daily lt br gt   lt input type  checkbox  name  Days  value  Sunday  gt Sunday lt br gt   lt input type  checkbox  name  Days  value  Monday  gt Monday lt br gt   lt input type  checkbox  name  Days  value  Tuesday  gt Tuesday  lt br gt   lt input type  checkbox  name  Days  value  Wednesday  gt Wednesday lt br gt   lt input type  checkbox  name  Days  value  Thursday  gt Thursday  lt br gt   lt input type  checkbox  name  Days  value  Friday  gt Friday lt br gt   lt input type  checkbox  name  Days  value  Saturday  gt Saturday  lt br gt   lt input type  submit  name  submit  value  submit  gt   lt  form gt   lt  body gt   lt  html gt    My php file to read and insert the values into a table    lt  php     Make a MySQL Connection mysql connect  localhost    root       or die mysql error     mysql select db  test   or die mysql error       checkBox     POST  Days     if isset   POST  submit           for   i 0   i lt sizeof  checkBox    i                           query  INSERT INTO example  orange  VALUES        checkBox  i                            mysql query  query  or die  mysql error                    echo  Complete         gt

User · Answer

I think you should   POST      i tried it and it work      tks

User · Answer

You need to declare the array in the HTML via   lt input type  checkbox  name  Days    value  Daily  gt    Also you can insert multiple items with one query like this   query    INSERT INTO example  orange  VALUES    for   i 0   i lt count  checkBox    i         query            checkBox  i            query   rtrim  query       mysql query  query  or die  mysql error          Also keep in mind that mysql   functions are officially deprecated and hence should not be used in new code  You can use PDO or MySQLi instead  See this answer on SO for more information

User · Answer

You should specify    lt input type  checkbox  name  Days    value  Daily  gt Daily lt br gt    as array   Add    to all names Days and work at php with this like an array   After it  you can INSERT values at different columns at db  or use implode and save values into one column     Didn t tested it  but you can try like this  Don t forget to replace mysql with mysqli    lt html gt   lt body gt   lt form method  post  action  chk123 php  gt  Flights on   lt br  gt   lt input type  checkbox  name  Days    value  Daily  gt Daily lt br gt   lt input type  checkbox  name  Days    value  Sunday  gt Sunday lt br gt   lt input type  checkbox  name  Days    value  Monday  gt Monday lt br gt   lt input type  checkbox  name  Days    value  Tuesday  gt Tuesday  lt br gt   lt input type  checkbox  name  Days    value  Wednesday  gt Wednesday lt br gt   lt input type  checkbox  name  Days    value  Thursday  gt Thursday  lt br gt   lt input type  checkbox  name  Days    value  Friday  gt Friday lt br gt   lt input type  checkbox  name  Days    value  Saturday  gt Saturday  lt br gt   lt input type  submit  name  submit  value  submit  gt   lt  form gt   lt  body gt   lt  html gt       lt  php     Make a MySQL Connection mysql connect  localhost    root       or die mysql error     mysql select db  test   or die mysql error       checkBox   implode        POST  Days      if isset   POST  submit                   query  INSERT INTO example  orange  VALUES        checkBox                   mysql query  query  or die  mysql error           echo  Complete         gt

User · Answer

I think this should work         lt input type  checkbox  name  Days    value  Daily  gt Daily lt br gt   lt input type  checkbox  name  Days    value  Sunday  gt Sunday lt br gt

[php] How do I insert multiple checkbox values into a table?

Examples related to php

Examples related to mysql

Examples related to checkbox

Examples related to multipleselection