forum

Home / DeveloperSection / Forums / insert different type multiple values selected in checkbox in database

Ask Question

insert different type multiple values selected in checkbox in database

Geethu gopal208621-Aug-2015
How to insert different type multiple values selected in checkbox in database ,
<?php
$checkbox1 = $_POST['batch']; 
$checkbox2 = $_POST['particular_name']; 
if(@isset($_REQUEST["sub"]))
{
     for ($i=0; $i<sizeof($checkbox1);$i++) {
     for ($j=0; $j<sizeof($checkbox2);$j++) {
    $query = "INSERT INTO table(`batch`,`particular_name`) values('".$checkboxi[$i]."','".$checkbox2[$j]."')";
    mysql_query($query) or die(mysql_error());
    }
    ?>
its not workin pls help me

phpmysql 
Updated on 27-Aug-2015
Geethu gopal

Geethu gopal

Follow

Can you answer this question?

Answer

1 Answers

Sunil Singh

Sunil Singh

27-Aug-2015

try this code

<?php 
$checkbox1=$_POST['batch']; 
$checkbox2=$_POST['particular_name']; 
if(@isset($_REQUEST["sub"])) 
{ 
if(is_array($checkbox1)&&is_array($checkbox2)){ 
 foreach($checkbox1 as $val) 
 { 

  foreach($checkbox2 as $Value) 
  { 
     $query = "INSERT INTO table(`batch`,`particular_name`) VALUES('".$val."','".$Value."')"; 
      mysql_query($query) or die(mysql_error()); 
  } 
 } 

} 
} 
?>

Liked By