Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / how to insert multiple values selected in checkbox in database
Ask Question

How to insert multiple values selected in checkbox in database

pintu nayak 60640 27 Mar 2012
Dear all,
How to insert multiple values selected in checkbox in database.
Thanks
php php
Updated 27 Dec 2013
pintu nayak
pintu nayak

Other

Iam a student

Message

5 Answers

Phagu MAhato
Phagu MAhato 27 Dec 2013
Report Abuse 
$query= "INSERT INTO individual_skills(Skills_ID,Ind_ID) VALUES (" .$skills[$i]. ",".$_SESSION['Ind_ID'].")";
  for ($i=0; $i<sizeof($skills);$i++) {
  
  $query.= " VALUES (" .$skills[$i]. ",".$_SESSION['Ind_ID'].")";
  }
amy ya
amy ya 23 Sep 2013
Report Abuse
hi, i wanna ask a question..i've got the same problem..help me please..what should i replace 'things' with? my DB column or what...
<?php
    $checkBox = $_POST['things'];
    for($i=0; $i<sizeof($checkBox); $i++){
    $query = "INSERT INTO table(things) values('".$checkBox[$i]."')";
    mysql_query($query) or die(mysql_error());
    }
    ?>

Anonymous User
Anonymous User 29 Mar 2012
Report Abuse
Hi Pintu Nayak,
In this code, you've done a little mistake in 'form.php' file. Replace your code with following code:
'form.php' Code: 
<html>
<head>
<title> PHP Form</title>
</head>
<body>
<form action="checkbox.php" method="post">
<input type="checkbox" name="chk1[]" value="a">a<br />
<input type="checkbox" name="chk1[]" value="b">b<br />
<input type="checkbox" name="chk1[]" value="c">c<br />
<input type="checkbox" name="chk1[]" value="d">d<br />
<br>
<br>
<input type="submit" name="Submit" value="Submit">
</form>
</body>
</html>

Please marked as answer if this code will solve your problem.
pintu nayak
pintu nayak 28 Mar 2012
Report Abuse
Hello friend,
I want to insert the values of the checkbox when checked and then click the button.After clicking the button all the checked checkbox values will be inserted into the database.
My code
form.php
<html>
<head>
<title> PHP Form</title>
</head>
<body>
<form action="checkbox.php" method="post">
<input type="checkbox" name="chk1" value="a">a<br />
<input type="checkbox" name="chk1" value="b">b<br />
<input type="checkbox" name="chk1" value="c">c<br />
<input type="checkbox" name="chk1" value="d">d<br />
<br>
<br>
<input type="submit" name="Submit" value="Submit">
</form>
</body>
</html>

checkbox.php
<?php
session_start();
include("config.php");
$checkbox1 = $_POST['chk1'];
if($_POST["Submit"]=="Submit")
{
for ($i=0; $i<sizeof($checkbox1);$i++) {
$query="INSERT INTO check (type) VALUES ('".$checkbox1[$i]."')";
mysql_query($query) or die ('Error updating database');
echo "Record is inserted.";
}
}
?>

config.php
<?php
 $sDbHost = 'localhost';
 $sDbName = 'test';
 $sDbUser = 'root';
 $sDbPwd  = '';
$dbConn = mysql_connect ($sDbHost, $sDbUser, $sDbPwd) or die ('MySQL connect failed. ' . mysql_error());
mysql_select_db($sDbName,$dbConn) or die('Cannot select database. ' . mysql_error());
?>

Please help me iam new to php.
Thanks
Anonymous User
Anonymous User 28 Mar 2012
Report Abuse
Hi Pintu,
If you are talking about group of checkbox with same name and you want to insert values of those checkbox which is checked, then you have to write following script to retrive values of those checkbox.
      <?php
    $checkBox = $_POST['things'];
    for($i=0; $i<sizeof($checkBox); $i++){
    $query = "INSERT INTO table(things) values('".$checkBox[$i]."')";
    mysql_query($query) or die(mysql_error());
    }
    ?>

If this is not correct answer then please clarify your question that what you want to do with multiple checkbox in php.
MindStick Training