In this article, you going to see How to Retrieve Multiple Checkbox value from Database in PHP using Explode step by step and in detail.
If you are looking for this topic then you are at right place.
Let’s start with the topic regarding How to Retrieve Multiple Checkbox value from Database in PHP Using Explode.
Before start with the topic.
First we going to discuss regarding PHP explode.
It break down the string into an array.
Syntax for explode function is given below.
explode(separator,string,limit)| Parameter | Details |
| separator | the separator is Required. Represent from where to split the string |
| string | the string is Required. Represent string to break. |
| limit | the limit is Optional. Represent the number of array elements to return. |
How to retrieve multiple checkbox value from database in PHP using explode
With the help of example we going to check this.
To do this first create database name "phptutorial".
In that database, create table name "vehicle".
Execute below command to create table in database.
CREATE TABLE vehicle1 (
id int NOT NULL AUTO_INCREMENT,
company varchar(500) NOT NULL,
vehicle varchar(500),
PRIMARY KEY (id)
);
If you want know more about phpMyAdmin, check with below link book which is a step-by-step instructional guide to get you started easily with phpMyAdmin and teach you to manage and perform database functions on your database.
Mastering phpMyAdmin 3.4 for Effective MySQL Management
OR,
Mastering PHP, MySQL and JavaScript: A Step-by-Step Guide to Creating Dynamic Websites
Now our next point is to create file named config.php file database connection.
Also you can add code for database connection in the the top of file.
Below is code for database connection.
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "phptutorial";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
?>For database connection you have to provide server name, username, password, and database name.
Now our next step is pass the checkbox value to database.
Before that we have to check with below point.
Which tag is used to create a checkbox in a form?
The input type checkbox tag is used to create a checkbox in a form.
Main point regarding checkbox is used for selecting one or more choices.
Checkbox is display as square box.
It is a activated, when it is ticked.
Which tag creates a checkbox for a form in html?
Below is code snippet for checkbox tag.
<input type="checkbox"> defines a checkbox.How to add checkbox in html form?
Now our next point is adding of checkbox in html form.
Using below code snippet for adding checkbox.
<form action="" method="post">
<label>Company</label>
<select name="company">
<option value="">Please choose company</option>
<option value="Bajaj">Bajaj</option>
<option value="Tata">Tata</option>
<option value="BMW">BMW</option>
<select><br/><br/>
<label>Vehicle with you :</label><br/><br/>
<input type="checkbox" name="vehicle[]" value="Bike">
<label for="vehicle1"> I have a Bike</label><br>
<input type="checkbox" name="vehicle[]" value="Jeep">
<label for="vehicle2"> I have a Jeep</label><br>
<input type="checkbox" name="vehicle[]" value="Boat" checked>
<label for="vehicle3"> I have a Boat</label><br><br>
<input type="submit" name="submit" value="Submit">
</form> 
On Submit form, all the input type field is post the data and it get inserted into database.
Note : Use all checkbox same name as 'vehicle[]' with square bracket.
This checkbox value is post on submitting form and insert into database.
Use the insert statement to insert the value into the database.
To retrieve multiple checkbox value from database use the select statement.
As all checkbox value is insert as a single comma separated value.
How to explode checkbox value in PHP?
Use the below the code snippet for getting multiple checkbox value using explode.
<?php
// Explode under while loop.
$lastsqlRes = "SELECT LAST_INSERT_ID(), company, vehicle FROM vehicle";
$result2= mysqli_query($conn,$lastsqlRes);
while($row = mysqli_fetch_array($result2,MYSQLI_ASSOC)){
$var = explode(",",$row['vehicle']);
}
echo '<PRE>'; print_r($var);
?>Below is the complete code snippet for retrieve multiple checkbox value from database.
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "phptutorial";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
if(isset($_POST['submit']) && $_POST['submit'] =='Submit' && $_POST['company']!=''){
$company = $_POST['company'];
$vehiclearr = $_POST['vehicle'];
$vehicle =implode(',',$vehiclearr);
// SQL query
// output data of each row
$sql = "INSERT INTO `vehicle` (`id`, `company`, `vehicle`) VALUES ('','$company','$vehicle');";
if (mysqli_query($conn, $sql)) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}
?>
<?php
$lastsqlRes = "SELECT LAST_INSERT_ID(), company, vehicle FROM vehicle";
$result2= mysqli_query($conn,$lastsqlRes);
while($row = mysqli_fetch_array($result2,MYSQLI_ASSOC)){
$var = explode(",",$row['vehicle']);
}
?>
<!DOCTYPE html>
<html>
<body>
<div style="background-color:#e5bcbc;" align="center">
<h1>Retrieve Multiple Checkbox value from Database in PHP</h1>
<form action="" method="post">
<label>Company</label>
<select name="company">
<option value="">Please choose company</option>
<option value="Bajaj">Bajaj</option>
<option value="Tata">Tata</option>
<option value="BMW">BMW</option>
<select><br/><br/>
<label>Vehicle with you :</label><br/><br/>
<input type="checkbox" name="vehicle[]" <?php echo (in_array("Bike", $var)?'checked':''); ?> value="Bike">
<label for="vehicle1"> I have a Bike</label><br>
<input type="checkbox" name="vehicle[]" <?php echo (in_array("Jeep", $var)?'checked':''); ?> value="Jeep">
<label for="vehicle2"> I have a Jeep</label><br>
<input type="checkbox" name="vehicle[]" <?php echo (in_array("Boat", $var)?'checked':''); ?> value="Boat" checked>
<label for="vehicle3"> I have a Boat</label><br><br>
<input type="submit" name="submit" value="Submit">
</form>
<br/>
<div align="center">
<table class="table table-bordered" border="2" align="center" width="50%" >
<tr> <td colspan="5"><center><h3>Output Vehicles Inserted in Database</h3></center></td></tr>
<tr>
<tr><center><th>ID</th><th>Company</th><th>Vehicle</th></center></tr>
<?php $fetchqry = "SELECT * FROM vehicle";
$result1= mysqli_query($conn,$fetchqry);
$num = mysqli_num_rows($result1);
if($num > 0){
while($row = mysqli_fetch_array($result1,MYSQLI_ASSOC)){ ?>
<tr><td><p><?php echo $row['id']; ?></p></td><td><?php echo $row['company']?> </td>
<td><?php echo $row['vehicle']; ?></td></tr>
<?php
}
}
?>
</tr>
<tr>
<td>
<?php
echo '<PRE>'; print_r($var);
?>
</td>
</tr>
</table>
</div>
</div>
</body>
</html>OUTPUT :
How to show multiple checkbox checked in PHP from database?
Now we going to see displaying of multiple checkbox checked in PHP from database.
Using ternary operator using you can achieve this.
After fetching the data from the database for multiple checkbox as data for multiple checkbox is save as comma separated.
Used explode function to convert the single comma separated data into array.
Used the below code snippet for it.
<?php
$lastsqlRes = "SELECT LAST_INSERT_ID(), company, vehicle FROM vehicle";
$result2= mysqli_query($conn,$lastsqlRes);
while($row = mysqli_fetch_array($result2,MYSQLI_ASSOC)){
$var = explode(",",$row['vehicle']);
}
?>Then use the ternary operator to checked the multiple checkbox.
Use below code snippet to achieve this.
<input type="checkbox" name="vehicle[]" <?php echo (in_array("Bike", $var)?'checked':''); ?> value="Bike">
<label for="vehicle1"> I have a Bike</label><br>
<input type="checkbox" name="vehicle[]" <?php echo (in_array("Jeep", $var)?'checked':''); ?> value="Jeep">
<label for="vehicle2"> I have a Jeep</label><br>
<input type="checkbox" name="vehicle[]" <?php echo (in_array("Boat", $var)?'checked':''); ?> value="Boat">
<label for="vehicle3"> I have a Boat</label><br>OUTPUT:
How to get multiple checkbox value in PHP using array?
Go through the above all code snippet you come to understand regarding this.
Below is the code snippet for getting multiple checkbox value in PHP using array.
<?php
$lastsqlRes = "SELECT LAST_INSERT_ID(), company, vehicle FROM vehicle";
$result2= mysqli_query($conn,$lastsqlRes);
while($row = mysqli_fetch_array($result2,MYSQLI_ASSOC)){
$var = explode(",",$row['vehicle']);
}
print_r($var);
?>The output from above code snippet you will get array form.
Array
(
[0] => Jeep
[1] => Boat
)How to explode checkbox value in PHP?
Execute the select query to fetch comma separated checkbox value from database.
Use the while loop to get comma separated data and use explode to get checkbox value.
Below is code snippet for explode.
<?php
$lastsqlRes = "SELECT LAST_INSERT_ID(), company, vehicle FROM vehicle";
$result2= mysqli_query($conn,$lastsqlRes);
while($row = mysqli_fetch_array($result2,MYSQLI_ASSOC)){
$var = explode(",",$row['vehicle']);
}
print_r($var);
?>How to fetch data from database in PHP and display in checkbox?
Use the below code snippet to fetch data from database in PHP and display in checkbox.
<?php
$lastsqlRes = "SELECT LAST_INSERT_ID(), company, vehicle FROM vehicle";
$result2= mysqli_query($conn,$lastsqlRes);
while($row = mysqli_fetch_array($result2,MYSQLI_ASSOC)){
$var = explode(",",$row['vehicle']);
}
?>Use ternary operator to display in checkbox.
Please refer below code.
<input type="checkbox" name="vehicle[]" <?php echo (in_array("Bike", $var)?'checked':''); ?> value="Bike">How to upload multiple images in PHP and store in database
Conclusion:
Using above code snippet you can understand regarding PHP explode and its uses.
I hope you like this article and if you have any query, please comment below.