DaniWeb Forum Index > Web Development > PHP

How to insert checkbox data into mysql?

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Apr 2008

Posts: 75

Reputation: danishbacker is an unknown quantity at this point

Solved Threads: 5

danishbacker danishbacker is offline

Offline

Junior Poster in Training

Re: How to insert checkbox data into mysql?

#11

May 27th, 2009

Happy to hear that ur problem was partially solved
Try this

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$insertSQL = sprintf("INSERT INTO $table (id,name) VALUES (%d, %s)", $ch[0], $var);
 
$Result = mysql_query($insertSQL) or die(mysql_error());
$insertSQL = sprintf("INSERT INTO $table (id,name) VALUES (%d, %s)", $ch[0], $var);

$Result = mysql_query($insertSQL) or die(mysql_error());

otherwise u may need to use some other variable.

www.peipians.com
bizarreinnovations.com

•

Join Date: May 2009

Posts: 77

Reputation: Tulsa is an unknown quantity at this point

Solved Threads: 15

Tulsa

Offline

Junior Poster in Training

Re: How to insert checkbox data into mysql?

#12

May 27th, 2009

hi

you can do this in the loop like

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
foreach($array as $val)
{
echo $val;
$query="insert into table (filed) value ($val)";
$result=mysql_query($query);
}
foreach($array as $val)
{
echo $val;
$query="insert into table (filed) value ($val)";
$result=mysql_query($query);
}

if you want to insert selected value in to diffrent row then you can do like this

Thanks

•

Join Date: Apr 2009

Posts: 257

Reputation: BzzBee is an unknown quantity at this point

Solved Threads: 37

BzzBee

Offline

Posting Whiz in Training

Re: How to insert checkbox data into mysql?

#13

May 27th, 2009

you can use foreach loop for it. If you just required values then the

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
foreach($array as $val)
foreach($array as $val)

is enough or if you want to use index of array as well you can use

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
foreach($array as $key=>$val)
foreach($array as $key=>$val)

BzzBee

http://www.homenwomen.com/

•

Join Date: May 2009

Posts: 13

Reputation: shena is an unknown quantity at this point

Solved Threads: 0

shena

Offline

Newbie Poster

Re: How to insert checkbox data into mysql?

#14

May 27th, 2009

•

Originally Posted by danishbacker

Happy to hear that ur problem was partially solved
Try this
Help with Code Tags

PHP Syntax (Toggle Plain Text)
$insertSQL = sprintf("INSERT INTO $table (id,name) VALUES (%d, %s)", $ch[0], $var);
 
$Result = mysql_query($insertSQL) or die(mysql_error());
$insertSQL = sprintf("INSERT INTO $table (id,name) VALUES (%d, %s)", $ch[0], $var); $Result = mysql_query($insertSQL) or die(mysql_error());
otherwise u may need to use some other variable.

Hi,
Thanks for helping. Actually, this is wat i got:
Notice: Undefined variable: var in C:\wamp\www\test\checkbox.php on line 44
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(id,name) VALUES (3, )' at line 1

Why its a SQL syntax error, due to different php version/style of coding is it? I created two fields for the table called table which are:
id(int)
name(varchar)

If i can insert the values into database, then my problem is considered solved. Hope for kind reply. Thanks!

•

Join Date: May 2009

Posts: 13

Reputation: shena is an unknown quantity at this point

Solved Threads: 0

shena

Offline

Newbie Poster

Re: How to insert checkbox data into mysql?

#15

May 28th, 2009

•

Originally Posted by Tulsa

hi

you can do this in the loop like
Help with Code Tags

PHP Syntax (Toggle Plain Text)
foreach($array as $val)
{
echo $val;
$query="insert into table (filed) value ($val)";
$result=mysql_query($query);
}
foreach($array as $val) { echo $val; $query="insert into table (filed) value ($val)"; $result=mysql_query($query); }
if you want to insert selected value in to diffrent row then you can do like this

Thanks

Hi Tulsa,

Thanks for the explanations on multiple values selection. How do i insert the selected values in one row under the same field?

thanks!

•

Join Date: May 2009

Posts: 77

Reputation: Tulsa is an unknown quantity at this point

Solved Threads: 15

Tulsa

Offline

Junior Poster in Training

Re: How to insert checkbox data into mysql?

#16

May 28th, 2009

hi

you can insert multiple value in one row as comma separated value.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$array=$_post['list_box'];
$string=implode(',',$array);
$array=$_post['list_box'];
$string=implode(',',$array);

so now your selected option stored in $string variable as a comma separated ok

Thanks

•

Join Date: May 2009

Posts: 13

Reputation: shena is an unknown quantity at this point

Solved Threads: 0

shena

Offline

Newbie Poster

Re: How to insert checkbox data into mysql?

#17

May 29th, 2009

Hi,

Could anyone tell me where did i go wrong with this code, i managed to connect the php with sql server but i couldnt insert the values into database. I get this error:

INSERT INTO table (name) VALUES ('FT')Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table (name) VALUES ('FT')' at line 1

Help with Code Tags

(Toggle Plain Text)

<form action="write.php" method="post">

PRODUCT TYPE:
<input type="checkbox" value="FT" name="tile[]">:FLOOR TILES
<input type="checkbox" value="HT" name="tile[]">HOMOGENEOUS TILES
<input type="checkbox" value="WT" name="tile[]">:WALL TILES
<input type="checkbox" value="PT" name="tile[]">:POLISHED TILES
<br>

<input name="confirm" type=submit id="confirm" style='border:1px solid #000000;font-family:Verdana, Arial, Helvetica, sans-serif ;font-size:9px;' value='Confirm'>

</form>

This is write.php

<?php

$con = mysql_connect("localhost","root");

if (!$con)
{
	die('Could not connect: ' . mysql_error());
}

mysql_select_db("test_venus", $con);

if(isset($_POST['tile']))
{      
	foreach($_POST['tile'] as $value) 
	{         
 		$insert="INSERT INTO table (name) VALUES ('$value')";     
 		mysql_query($insert);    	
		echo $insert;
 	}
}

if (!mysql_query($insert, $con))
{
  die('Error: ' . mysql_error());
}

mysql_close($con) 

?>

I tried this for a long time for an answer to this problem, and I couldn't find anything that really helped. I feel that there is no wrong in my codings, but yet i couldnt solve it or may be i dont get to realise. So, any guidance would be gratefully recieved.
Thanks!

•

Join Date: Apr 2008

Posts: 75

Reputation: danishbacker is an unknown quantity at this point

Solved Threads: 5

danishbacker danishbacker is offline

Offline

Junior Poster in Training

Re: How to insert checkbox data into mysql?

#18

May 29th, 2009

try this.

Help with Code Tags

PHP Syntax (Toggle Plain Text)

$insert="INSERT INTO `table` (name) VALUES ('$value')";

U have given "table" as table name and "name" as field name.
Both have special meaning in sql. So if u are using it u need to add `` like
eg :-`$tableName`

Better try to avoid using these names. Also i recommend you to use SQLyog.
The community version is free. You can get it from http://www.webyog.com

It is better first try ur sql statements in SQLyog. This will help u t o avoid these type of mistakes.

Last edited by danishbacker; May 29th, 2009 at 1:07 am.

www.peipians.com
bizarreinnovations.com

•

Join Date: May 2009

Posts: 77

Reputation: Tulsa is an unknown quantity at this point

Solved Threads: 15

Tulsa

Offline

Junior Poster in Training

Re: How to insert checkbox data into mysql?

#19

May 29th, 2009

hi

you have test the value of list box by the echo right ?
so now problem only insert query ok.

Help with Code Tags

PHP Syntax (Toggle Plain Text)

$insert="INSERT INTO table (name) VALUES ('$value')";

table is the table name right.
so as per my view mysql not allow to use this reserved key word use to us.

so you need to use table name diffrent rather than 'table' ok
i hope this will solve your problem

Thanks

•

Join Date: May 2009

Posts: 13

Reputation: shena is an unknown quantity at this point

Solved Threads: 0

shena

Offline

Newbie Poster

Re: How to insert checkbox data into mysql?

#20

May 29th, 2009

Hi danish,
Thanks a lot for the answer. It did work. But, i juz want to clarify that what i did (insertion method - without `` for the table name), did work for other scripts, why cant i do the same for this script?
Is this an alternate way?