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:

<html>
<body>
<form method="post" action="chk123.php">
Flights on: <br/>
<input type="checkbox" name="Days" value="Daily">Daily<br>
<input type="checkbox" name="Days" value="Sunday">Sunday<br>
<input type="checkbox" name="Days" value="Monday">Monday<br>
<input type="checkbox" name="Days" value="Tuesday">Tuesday <br>
<input type="checkbox" name="Days" value="Wednesday">Wednesday<br>
<input type="checkbox" name="Days" value="Thursday">Thursday <br>
<input type="checkbox" name="Days" value="Friday">Friday<br>
<input type="checkbox" name="Days" value="Saturday">Saturday <br>
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>

My php file to read and insert the values into a table:

<?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<sizeof($checkBox); $i++)
        {
            $query="INSERT INTO example (orange) VALUES ('" . $checkBox[$i] . "')";     

            mysql_query($query) or die (mysql_error() );
        }
    echo "Complete";

}

?>

each call to mysql_query is expensive, consider merging the query to a single insert by chaining the () after values. such as ('a'), ('b'), ('c'), ... — ohmusama
– ohmusama, Commented Nov 24, 2013 at 16:17
All mysql_*() functions are officially deprecated (no longer supported/maintained) and will be removed in the future. You should update your code using PDO or MySQLi to ensure future functionality. Also your code is vulnerable to SQL injection. — user1592648
– user1592648, Commented Nov 24, 2013 at 16:23

Viacheslav Kondratiuk · Accepted Answer · 2013-11-24 16:57:24Z

32

You should specify

<input type="checkbox" name="Days[]" value="Daily">Daily<br>

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.

<html>
<body>
<form method="post" action="chk123.php">
Flights on: <br/>
<input type="checkbox" name="Days[]" value="Daily">Daily<br>
<input type="checkbox" name="Days[]" value="Sunday">Sunday<br>
<input type="checkbox" name="Days[]" value="Monday">Monday<br>
<input type="checkbox" name="Days[]" value="Tuesday">Tuesday <br>
<input type="checkbox" name="Days[]" value="Wednesday">Wednesday<br>
<input type="checkbox" name="Days[]" value="Thursday">Thursday <br>
<input type="checkbox" name="Days[]" value="Friday">Friday<br>
<input type="checkbox" name="Days[]" value="Saturday">Saturday <br>
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>

<?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";

}

?>

edited Nov 24, 2013 at 16:57

answered Nov 24, 2013 at 16:07

Viacheslav Kondratiuk

8,9609 gold badges53 silver badges81 bronze badges

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

5 Comments

SirBT Over a year ago

Wonderful! I checked it and it saves several days in one column. How do I get each day to be saved on each row instead?

Viacheslav Kondratiuk Over a year ago

INSERT INTO example (column1, column2, ...) VALUES ($_POST['Days'][0], $_POST['Days'][1], ...)

SirBT Over a year ago

I am terribly sorry viakondratiuk, I meant on each row and not column

Viacheslav Kondratiuk Over a year ago

In that case just change your html and your code should work.

user1690536 Over a year ago

SirBT, Would you mind sharing the solution of saving the checkbox values in MySql in separate rows? It would help me understand how to write it correctly.

kero · Accepted Answer · 2017-05-28 10:56:00Z

4

You need to declare the array in the HTML via

<input type="checkbox" name="Days[]" value="Daily">

Also you can insert multiple items with one query like this

$query = "INSERT INTO example (orange) VALUES ";
for ($i=0; $i<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.

edited May 28, 2017 at 10:56

answered Nov 24, 2013 at 16:11

kero

10.7k5 gold badges44 silver badges52 bronze badges

Comments

Drudge Rajen · Accepted Answer · 2013-11-24 16:09:01Z

0

I think this should work .. :)

<input type="checkbox" name="Days[]" value="Daily">Daily<br>
<input type="checkbox" name="Days[]" value="Sunday">Sunday<br>

answered Nov 24, 2013 at 16:09

Drudge Rajen

8,0414 gold badges25 silver badges43 bronze badges

2 Comments

SirBT Over a year ago

kindly be a bit more specific.

Drudge Rajen Over a year ago

I think you will understand.. :(

Bear · Accepted Answer · 2020-04-29 17:22:20Z

-3

I think you should $_POST[][], i tried it and it work :)), tks

answered Apr 29, 2020 at 17:22

Bear

3173 silver badges2 bronze badges

1 Comment

Michael Bordash Over a year ago

Please provide a full answer with code example to help answer the question. Thanks!

Collectives™ on Stack Overflow

How do I insert multiple checkbox values into a table?

4 Answers 4

5 Comments

Comments

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related