checkbox multiple select insert in php mysql Insert Value From CheckBox In Database mysql In PHP

PHP 0 Comments

checkbox multiple select insert in php mysql Insert Value From CheckBox In Database mysql In PHP
How do I insert multiple checkbox values into a table how to insert multiple checkbox id and value in a multiple column of mysql using php Insert multiple checkbox value in a single column and row of MySQL using PHP How to insert multiple checkbox into different column row in Mysql


<title> PHP Form<</title>  
<body bgcolor="pink">  
<h3>Insert Value From Checkboxes</h3>  
<form action="checkbox . php" method="post">  
<input type="checkbox" name="chkl[ ]" value="Vineet Saini">topic 1<br />  
<input type="checkbox" name="chkl[ ]" value="Ravi Sharma">topic 2<br />  
<input type="checkbox" name="chkl[ ]" value="Rahul Dube">topic 3<br />  
<input type="checkbox" name="chkl[ ]" value="Rajesh Verma">Rajesh Verma<br />  
<input type="checkbox" name="chkl[ ]" value="Priyanka Sachan"> Priyanka Sachan<br />  
<input type="submit" name="Submit" value="Submit">  

include ("config . php");  
$checkbox1 = $_POST['chkl'] ;  
if ($_POST["Submit" ]=="Submit")  
for ($i=0; $i<sizeof ($checkbox1);$i++) {  
$query="INSERT INTO employee (name) VALUES ('".$checkboxl[$i]. "')";  
mysql_query($query) or die(mysql_error());  
echo "Record is inserted";  

insert multiple items with one query like this

$query = "INSERT INTO example (orange) VALUES ";
for ($i=0; $i<count($checkBox); $i++)
    $query .= "('" . $checkBox[$i] . "'),";
$query = rtrim($query,',');
mysql_query($query) or die (mysql_error() );

implode and save values into one column


// Make a MySQL Connection
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());

$checkBox = implode(',', $_POST['Days']);

    $query="INSERT INTO example (orange) VALUES ('" . $checkBox . "')";     

    mysql_query($query) or die (mysql_error() );

    echo "Complete";



onclick all select and insert in mysql php

 <script src=""></script>

    foreach($_POST['check_list'] as $check) {
           // echo $check; //echoes the value set in the HTML form for each checked checkbox.
                         //so, if I were to check 1, 3, and 5 it would echo value 1, value 3, value 5.
                         //in your case, it would echo whatever $row['Report ID'] is equivalent to.
				// echo $check . ",";
				//$chk .= "'" . $check."', ";
				 //echo $check_e;	 
				$chk .= $check . ",";	 
					//$value = $check;						 
	$coursecatidcat = rtrim($chk,", ");
echo $coursecatidcat;

<div class="form-group">
										<div class="form-group">Title</div><div class="form-group">Title</div>
                                           <!-- <label> Bank <input type="checkbox" name="vehicle" value="Bike"> </label>
                                           <label> SSC <input type="checkbox" name="vehicle" value="Bike"> </label>-->
$(document).ready(function () {
    $("#ckbCheckAll").click(function () {
        $(".checkBoxClass").prop('checked', $(this).prop('checked'));
										 Select  <input type="checkbox" id="ckbCheckAll" /> ,
										  Bank  <input type="checkbox" class="checkBoxClass" id="Checkbox1" value="1" name="check_list[]" />
										  SSC  <input type="checkbox" class="checkBoxClass" id="Checkbox1" value="12" name="check_list[]" />

click and download file

on click checkbox select all and one by obe select