Ad:

PHP Discussion Thread
Unsolved
Views: 1306

Sep 1st, 2010

Inserting multiple checkbox to database

Expand Post »

Hi,
Iam new to PHP I need some help I am trying to insert multiple checkboxes values
<td>
<input name="myvar[]" type="checkbox" value="abc">
abc<br/>
<input name="myvar[]" type="checkbox" value="def">
def<br>
<input name="myvar[]" type="checkbox" value="ghi">
ghi</td>
along with other datas to the database, and I dont know how to do this
I wrote query for inserting other datas to db,(but i dont know how to include the loop value from the checkbox along with this).
$Details=mysql_query("insert into Example values('$ID','$data1','$data2'......) please explain I am new in this field

Similar Threads

insert multiple rows in database in MS SQL
Store checkbox value in database in PHP
insert multiple checkbox data into MySQL in PHP
how to insert multiple rows in a database using java code in Java
Retain multiple checkbox selection upon refresh or while using pagination in JavaScript / DHTML / AJAX

micahgeorge

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

16 posts
since Sep 2010

Permalink

Sep 5th, 2010

Re: Inserting multiple checkbox to database

assuming you had:

html Syntax (Toggle Plain Text)
<input type="text" name="person" value="John"/>
<input name="sport[]" type="checkbox" value="baseball">
<input name="sport[]" type="checkbox" value="basquetball">
<input name="sport[]" type="checkbox" value="football">
<input name="sport[]" type="checkbox" value="hocket">
<input type="text" name="person" value="John"/>
<input name="sport[]" type="checkbox" value="baseball">
<input name="sport[]" type="checkbox" value="basquetball">
<input name="sport[]" type="checkbox" value="football">
<input name="sport[]" type="checkbox" value="hocket">

then:

php Syntax (Toggle Plain Text)
foreach($_POST['sport'] as $value)
{
  $sql = sprintf("INSERT INTO `Atletes`(`personId`,`sportName`) VALUES('%s','%s')"
                ,mysql_real_escape_string($_POST['person'])
                ,mysql_real_escape_string($value)
                );
}
foreach($_POST['sport'] as $value)
{
  $sql = sprintf("INSERT INTO `Atletes`(`personId`,`sportName`) VALUES('%s','%s')"
                ,mysql_real_escape_string($_POST['person'])
                ,mysql_real_escape_string($value)
                );
}

hielo

Reputation Points: 116

Solved Threads: 243

Veteran Poster

Offline

1,123 posts
since Dec 2007

Permalink

Sep 10th, 2010

Re: Inserting multiple checkbox to database

thanks heilo,I was able to insert the values, and it will take different rows in the database right?like baseball in one row then basketball in the second row.... and will you please help me in displaying the value from the database too,

micahgeorge

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

16 posts
since Sep 2010

Permalink

Sep 11th, 2010

Re: Inserting multiple checkbox to database

Quote ...

it will take different rows in the database right?like baseball in one row then basketball in the second row

correct

but this might be better:

PHP Syntax (Toggle Plain Text)
<input name="sport[3][]" type="checkbox" value="baseball">
<input name="sport[3][]" type="checkbox" value="basquetball">
<input name="sport[3][]" type="checkbox" value="football">
<input name="sport[3][]" type="checkbox" value="hocket">
 
<input name="sport[7][]" type="checkbox" value="baseball">
<input name="sport[7][]" type="checkbox" value="basquetball">
<input name="sport[7][]" type="checkbox" value="football">
<input name="sport[7][]" type="checkbox" value="hocket">
<input name="sport[3][]" type="checkbox" value="baseball">
<input name="sport[3][]" type="checkbox" value="basquetball">
<input name="sport[3][]" type="checkbox" value="football">
<input name="sport[3][]" type="checkbox" value="hocket">

<input name="sport[7][]" type="checkbox" value="baseball">
<input name="sport[7][]" type="checkbox" value="basquetball">
<input name="sport[7][]" type="checkbox" value="football">
<input name="sport[7][]" type="checkbox" value="hocket">

where 3 and 7 are the corresponding personId. So to do the insert:

php Syntax (Toggle Plain Text)
foreach($_POST['sport'] as $personId=>$sports)
{
  foreach( $sports as $value)
  {
   $sql = sprintf("INSERT INTO `Atletes`(`personId`,`sportName`) VALUES('%s','%s')"
                ,mysql_real_escape_string( $personId)
                ,mysql_real_escape_string($value)
                );
  }
}
foreach($_POST['sport'] as $personId=>$sports)
{
  foreach( $sports as $value)
  {
   $sql = sprintf("INSERT INTO `Atletes`(`personId`,`sportName`) VALUES('%s','%s')"
                ,mysql_real_escape_string( $personId)
                ,mysql_real_escape_string($value)
                );
  }
}

Quote ...

and will you please help me in displaying the value from the database too,

all you have to do is to execute a select statement:

php Syntax (Toggle Plain Text)
$result=mysql_query("SELECT personId,sportName FROM Athletes") or die( mysql_error() );
while($row=mysql_fetch_assoc($result))
{
  echo sprintf(PHP_EOL.'<div><input type="textbox" name="sport[%s][]" value="%s"/></div>',  $row['personId'], $row['sportName'] );
}
$result=mysql_query("SELECT personId,sportName FROM Athletes") or die( mysql_error() );
while($row=mysql_fetch_assoc($result))
{
  echo sprintf(PHP_EOL.'<div><input type="textbox" name="sport[%s][]" value="%s"/></div>',  $row['personId'], $row['sportName'] );
}

hielo

Reputation Points: 116

Solved Threads: 243

Veteran Poster

Offline

1,123 posts
since Dec 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: extension uppercase problem

Next Thread in PHP Forum Timeline: order by time

DaniWeb Message

Cancel Changes

User Name
Password