Hi Geeks
Today we are going to see how to retrieve selected and unselected checkbox from the mysql database using php
<?php
include "config.php";
?>
<!doctype html>
<html>
<head>
<?php
if(isset($_POST['submit'])){
if(!empty($_POST['lang'])) {
$lang = implode(",",$_POST['lang']);
// Insert and Update record
$checkEntries = mysqli_query($con,"SELECT * FROM languages");
if(mysqli_num_rows($checkEntries) == 0){
mysqli_query($con,"INSERT INTO languages(language) VALUES('".$lang."')");
}else{
mysqli_query($con,"UPDATE languages SET language='".$lang."' ");
}
}
}
?>
</head>
<body>
<form method="post" action="">
<span>Select languages</span><br/>
<?php
$checked_arr = array();
// Fetch checked values
$fetchLang = mysqli_query($con,"SELECT * FROM languages");
if(mysqli_num_rows($fetchLang) > 0){
$result = mysqli_fetch_assoc($fetchLang);
$checked_arr = explode(",",$result['language']);
}
// Create checkboxes
$languages_arr = array("PHP","JavaScript","JAVA","HTML");
foreach($languages_arr as $language){
$checked = "";
if(in_array($language,$checked_arr)){
$checked = "checked";
}
echo '<input type="checkbox" name="lang[]" value="'.$language.'" '.$checked.' > '.$language.' <br/>';
}
?>
<input type="submit" value="Submit" name="submit">
</form>
</body>
</html>
AIRSEE Baby Nail Trimmer Electric Nail Drill Safe File,Baby Nail Clippers with Light & 6 Grinding Pads Polishing Shape Tools for Newborn Toddler or Adults Toes and Fingernails, Kids Nail Care (Blue)
₹299.00 (as of April 30, 2026 16:38 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)Birch & Co. Baby Feeding Bowl and Spoon Set, Stainless Steel Food Bowls - 320ml, 304 Stainless Steel Baby Food Container with Double Wall Vacuum Insulation, BPA-Free Leak-Proof for School & Travel,Green
₹999.00 (as of April 30, 2026 16:38 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)Himalaya Gentle Baby Shampoo (400 ml)| Tear-free formula|with hibiscus, chickpea, and vetiver|Cleanses, softens, and nourishes hair|No Parabens|No SLS|No SLES|No synthetic colors
₹230.00 (as of April 30, 2026 16:38 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)ParentNest Adjustable Baby Support Cushion with Dual Side Bolsters | Natural Filled Comfort Pillow for Supervised Rest & Lounging |Breathable Fabric | Nursery Essential (0–12 Months)
₹999.00 (as of April 30, 2026 16:38 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)Little Angel Baby Easy Dry Diaper Pants With 12 Hrs Absorption Large Size, 9-14 Kgs - L (62 Pieces)
₹514.00 (as of April 30, 2026 16:38 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)LuvLap Portable Folding Baby Toilet Seat, Reusable Potty Training Seats for 1 to 5 Years, Fits All Western Toilets, Non Slip Silicone Pads, Travel Friendly, Easy to Carry with Free Travel Bag, Blue
₹299.00 (as of April 30, 2026 16:38 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)Pampers Happy Sleep Pant Style Baby Diapers, Large (L), 42 Count, 1 Pampers = 1 Night Sleep, with Anti Rash Shield, 9-14 Kg Diapers
₹459.00 (as of April 30, 2026 16:38 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)Sebamed Baby Body Lotion|pH 5.5|Vegan|400 ml
Now retrieving the price.
(as of April 30, 2026 16:38 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Greetings! This is my first visit to your blog! We are a team
of volunteers and starting a new initiative in a community in the same niche.
Your blog provided us valuable information to work on. You have done a extraordinary job!
Greetings from Colorado! I’m bored at work so I decided to
browse your blog on my iphone during lunch break.
I really like the information you present here and can’t wait to take a
look when I get home. I’m amazed at how fast your blog loaded on my mobile ..
I’m not even using WIFI, just 3G .. Anyhow, very good site!
I relish, lead to I discovered exactly what I was looking for.
You’ve ended my four day long hunt! God Bless you man. Have a great day.
Bye
Hey there! I’ve been following your web site for a while now and finally got the bravery to go ahead and
give you a shout out from Porter Texas! Just wanted to say keep up the fantastic work!