How to Insert Multiple Checkbox Value into Database in PHP MySQL
In this post, you will be learning about how to insert multiple checkbox value in database using php mysql, Need to create a html form with multiple checkbox where on the form submit with method post we will insert or store the multiple checkbox data into database in php mysql.
I have used Bootstrap v5 to design the user interface.
So, Lets get started to: (How to insert multiple checkbox data in mysql database using php)
Note: For better and detailed understanding. please watch out the Video above.
Step 1: Create a table named demo into your Database (MySQL) as follows:
CREATE TABLE `demo` (
`id` int(11) NOT NULL,
`name` varchar(191) NOT NULL,
);
Step 2: Create a index.php file and paste the below html form design code:
<?php session_start(); ?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Funda of Web IT</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="container">
<div class="row justify-content-center">
<div class="col-md-8">
<?php
if(isset($_SESSION['status']))
{
?>
<div class="alert alert-warning alert-dismissible fade show" role="alert">
<strong>Hey!</strong> <?php echo $_SESSION['status']; ?>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
</div>
<?php
unset($_SESSION['status']);
}
?>
<div class="card mt-5">
<div class="card-header">
<h4>How to Insert Multiple Checkbox Values into Database in php</h4>
</div>
<div class="card-body">
<form action="code.php" method="POST">
<div class="form-group mb-3">
<input type="checkbox" name="brands[]" value="Red MI"> Red MI <br>
<input type="checkbox" name="brands[]" value="Samsung"> Samsung <br>
<input type="checkbox" name="brands[]" value="Nokia"> Nokia <br>
<input type="checkbox" name="brands[]" value="Vivo"> Vivo <br>
<input type="checkbox" name="brands[]" value="Karbon"> Karbon <br>
</div>
<div class="form-group mb-3">
<button type="submit" name="save_multiple_checkbox" class="btn btn-primary">Save Multiple Checkbox</button>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.5.1.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Now, when you click on the Submit button, the <form> contains action="code.php" so, lets go to Step 3 to write the code:
Step 3: Create a code.php file and paste the below code to insert multiple checkbox value in mysql database in php.
<?php
session_start();
$con = mysqli_connect("localhost","root","","phptutorials");
if(isset($_POST['save_multiple_checkbox']))
{
$brands = $_POST['brands'];
// echo $brands;
foreach($brands as $item)
{
// echo $item . "<br>";
$query = "INSERT INTO demo (name) VALUES ('$item')";
$query_run = mysqli_query($con, $query);
}
if($query_run)
{
$_SESSION['status'] = "Inserted Successfully";
header("Location: index.php");
}
else
{
$_SESSION['status'] = "Data Not Inserted";
header("Location: index.php");
}
}
?>
Thanks for reading...