How To Add Checkbox In Sql Database

Updated date Jun 16, 2020

809k
v

In this article you volition see how to insert a value from a checkbox in the MySQL database.

Introduction

In the final article, you saw how to insert a value from a radio button in the MySQL database in PHP. Now in this article, you volition see how to insert a value from a checkbox in the MySQL database. Using a checkbox you lot tin insert multiple values in the MySQL database in PHP.

Starting time of all, nosotros will create a database and a table in MySQL.

Create Database

<?php
$con = mysql_connect ( "localhost" , "root" , "" ) ;
$ db="MCN" ;
if ( ! $con )
die ( ' Could not connect: ' . mysql_error( ) ) ;
if (mysql_query ( "CREATE DATABASE $db" , $con ) )
echo "Your Database Created Which Name is : $db" ;
}
else
{
echo "Error creating database: " . mysql_error( ) ;
}
mysql_close ($con ) ;
?>

Create Table

<?php
$con = mysql_connect ( "localhost" , "root" , "" ) ;
if ( ! $con )
dice ( ' Could not connect: ' .mysql_error ( ) ) ;
}
mysql_select_db ("MCN" , $con ) ;
$sql = "CREATE Tabular array EMPLOYEE
(
Name varchar ( 50) ,
)" ;
mysql_query($sql , $con ) ;
mysql_close ($con ) ;
?>

Create a config.php file

Now nosotros will create a config.php file for connecting the database to all PHP files.

<?php
$sDbHost = 'localhost' ;
$sDbName = 'mcn' ;
$sDbUser = 'root' ;
$sDbPud = '' ;
$ Conn = mysql_connect ($sDbHost , $sDbUser , $sDbPwd );
mysql_select_db ($sDbName , $Conn );
?>

Create the form.php file

Now we will create a form.php file past which we will insert a value through checkboxes in the MySQL database.

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

Create checkbox.php file

No, we will create a PHP file in which nosotros include a config.php file and write the insert control for inserting the data in the database.

<php
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" ;
}
?>

Output

For running the to a higher place code we will write in the web browser "

http://localhost/foldername/form.php

Now we select any checkbox. Suppose we select four checkboxes i.east. Vineet Saini, Ravi Sharma, Rahul Dube, Priyanka Sachan. And then nosotros will click on the submit push.

When we click on the submit button so you will get a message i.e. Record is inserted.

At present you volition see at that place are four records inserted in the database. Every bit in the following epitome.

Determination

So in this article, you saw how to insert multiple records in a MySQL database through a checkbox. Using this article ane can easily sympathize the insertion of multiple data in a MySQL database.

Some Helpful Resources

Insert Value From Radio Button in MySQL in PHP
Database Connectivity (Insert and Select) With MySQL in PHP
Insert Statement With PHP Script
How to Handle Null Values in MYSQL Server
Brandish Data in GridView Using MySQL