In this post, you will be learning about how to filter or find the data from database using multiple checkbox in php mysql.
We are using bootstrap v5 to design this user interface.
First, we are fetching all the brands lists in multiple checkbox and then check the checkbox to filter your data. (You can take an example of Product List)
Note: For better and detailed understanding. please watch out the Video above.
CREATE TABLE `a_products` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`brand_id` int(11) NOT NULL,
`name` varchar(100) NOT NULL,
`price` varchar(50) NOT NULL,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`)
);
<!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">
<div class="col-md-12">
<div class="card mt-3">
<div class="card-header">
<h4>How to Filter or Find or Search data using Multiple Checkbox in php</h4>
</div>
</div>
</div>
<!-- Brand List -->
<div class="col-md-3">
<form action="" method="GET">
<div class="card shadow mt-3">
<div class="card-header">
<h5>Filter
<button type="submit" class="btn btn-primary btn-sm float-end">Search</button>
</h5>
</div>
<div class="card-body">
<h6>Brand List</h6>
<hr>
<?php
$con = mysqli_connect("localhost","root","","phptutorials");
$brand_query = "SELECT * FROM a_brands";
$brand_query_run = mysqli_query($con, $brand_query);
if(mysqli_num_rows($brand_query_run) > 0)
{
foreach($brand_query_run as $brandlist)
{
$checked = [];
if(isset($_GET['brands']))
{
$checked = $_GET['brands'];
}
?>
<div>
<input type="checkbox" name="brands[]" value="<?= $brandlist['id']; ?>"
<?php if(in_array($brandlist['id'], $checked)){ echo "checked"; } ?>
/>
<?= $brandlist['name']; ?>
</div>
<?php
}
}
else
{
echo "No Brands Found";
}
?>
</div>
</div>
</form>
</div>
<!-- Brand Items - Products -->
<div class="col-md-9 mt-3">
<div class="card ">
<div class="card-body row">
<?php
if(isset($_GET['brands']))
{
$branchecked = [];
$branchecked = $_GET['brands'];
foreach($branchecked as $rowbrand)
{
// echo $rowbrand;
$products = "SELECT * FROM a_products WHERE brand_id IN ($rowbrand)";
$products_run = mysqli_query($con, $products);
if(mysqli_num_rows($products_run) > 0)
{
foreach($products_run as $proditems) :
?>
<div class="col-md-4 mt-3">
<div class="border p-2">
<h6><?= $proditems['name']; ?></h6>
</div>
</div>
<?php
endforeach;
}
}
}
else
{
$products = "SELECT * FROM a_products";
$products_run = mysqli_query($con, $products);
if(mysqli_num_rows($products_run) > 0)
{
foreach($products_run as $proditems) :
?>
<div class="col-md-4 mt-3">
<div class="border p-2">
<h6><?= $proditems['name']; ?></h6>
</div>
</div>
<?php
endforeach;
}
else
{
echo "No Items Found";
}
}
?>
</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>
