# MySQL, PHP: sending multiple checkbox values

**URL:** <https://forum.kirupa.com/t/mysql-php-sending-multiple-checkbox-values/115160>\
**Category:** Uncategorized\
**Created:** [July 6, 2004, 3:24am UTC](https://forum.kirupa.com/t/mysql-php-sending-multiple-checkbox-values/115160 "2004-07-06T03:24:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Carixpig](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/carixpig/32/304_2.png) [@Carixpig](https://forum.kirupa.com/u/Carixpig)\
**Post date:** [July 6, 2004, 3:24am UTC](https://forum.kirupa.com/t/mysql-php-sending-multiple-checkbox-values/115160/1 "2004-07-06T03:24:33Z")

</div>

Hi all,

I can’t seem to work out how to insert multiple checkbox values into a mysql database with php.

As you know, check boxes are for selecting multiple options in the same group. I have a form with three checkboxes, but when I submit the form, only the bottom-most checked box value is inserted into the database.

How do I get them all the checked options in there?

Thanks,  
Carixpig

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 8, 2004, 12:23am UTC](https://forum.kirupa.com/t/mysql-php-sending-multiple-checkbox-values/115160/2 "2004-07-08T00:23:02Z")

</div>

Thanks all for your help.

I used print\_r($\_POST) to see what I was sending, and it got me a little further. The data with multiple values prints like so:

…[entry\_type] =\> Array ( [0] =\> homepage [1] =\> investor …

where I’ve checked the “homepage” checkbox and “investor” checkbox. Then the data that appears in the mysql table is “Array”, not “homepage” or “investor”.

So using my actionscript knowledge, I included a for loop in the sql query on the php page, so the page goes:

```php

<?
require 'include.php';

$entry_date = $_POST["entry_date"]; 
$entry_title = $_POST["entry_title"]; 
$entry_summary = $_POST["entry_summary"]; 
$entry_body = $_POST["entry_body"];
$entry_type = $_POST["entry_type"]; 

//print_r($_POST);

$cid = mysql_connect($DBhost,$DBuser,$DBpass);
mysql_select_db($DBName); 
if (!$cid) { print "Error: " . mysql_error() . "
"; }

if ($_SERVER['REQUEST_METHOD'] == "POST") {

$sql = " INSERT INTO itl_news (";
	$sql .= "entry_date, "; 
	$sql .=	"entry_title, "; 
	$sql .=	"entry_summary, ";
	$sql .=	"entry_body, "; 
	$sql .=	"entry_type)";
	$sql .=	"VALUES ";
	$sql .= "('$entry_date', ";
	$sql .=	"'$entry_title', ";
	$sql .=	"'$entry_summary', ";
	$sql .=	"'$entry_body' ";
for($i = 0; $i <= 1; $i++)
	{	
	$sql .= " '$entry_type[$i]')";
	}
$result = mysql_query($sql, $cid);

if (mysql_error()) { print "Database Error: $sql " . mysql_error(); } 

print "New Entry Added for <b>$entry_date</b> ($entry_type announcement).";

mysql_close();

}
?>

```

By the look of it, my application of the for loop is incorrect (as my printed data tells me) and it creates bad syntax in the sql query.

I just want to add a string of values to the entry\_type column in the mysql table. Eg. “homepage investor” or “investor” or “homepage investor customer”.

Thanks so far for all your help.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 8, 2004, 2:07am UTC](https://forum.kirupa.com/t/mysql-php-sending-multiple-checkbox-values/115160/3 "2004-07-08T02:07:40Z")

</div>

if this is all going to the same table field you could easely use serialize()

```php

#example
$entry_type = serialize($_POST["entry_type"]); 

```