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>
Himalaya Baby Body Lotion, For All Skin Types (400 ml)
₹222.00 (as of November 21, 2024 11:50 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.)
Zest 4 Toyz Play Mat For Baby Double Sided Waterproof & Extra Large Anti-Slip Folding Mats Infant Gym Water Resistant Play & Crawl Carpet For Babies Boys And Girls (White),1 Count
₹799.00 (as of November 21, 2024 11:50 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.)
Cetaphil Baby Mild Bar 100 gm
₹210.00 (as of November 21, 2024 11:50 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.)
TEDDYY Baby Easy Pant Diapers Extra Large 54 Count (Pack of 1), 12-17 kgs, 12 hrs Leak Protection, Anti - Bacterial
₹499.00 (as of November 21, 2024 11:50 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.)
Dbolt Jet Baby Activity Walker, 360° Wheels, Detachable Toy Bar, 6-18 Months, 15kg Capacity (Sea Green)
₹679.00 (as of November 21, 2024 11:50 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.)
BeyBee Waterproof Quick Dry Sheet for Baby| Bed Pad Anti-Piling Fleece Extra Absorbent Washable Matress Protector| Baby Bed Protector Sheet for Toddler Children, Medium Size, 100x70cm, Violet
₹249.00 (as of November 21, 2024 11:50 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.)
Mee Mee Caring Baby Wet Wipes with lid, 72 Pcs (Aloe Vera, Pack of 3)
₹216.00 (as of November 21, 2024 11:50 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.)
Silicone Baby Teething Fruit Shape Toy for 0-12 Months | BPA-Free Soothing Teether | Soft & Safe Gum Relief Toy for Babies (Pack of -2)
₹179.00 (as of November 21, 2024 11:50 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.)
Amazon Brand - Supples Premium Diapers, X-Large (XL), 54 Count, 12-17 Kg, 12 hrs Absorption Baby Diaper Pants
₹525.00 (as of November 21, 2024 11:50 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.)
Cetaphil Baby mild Bar 4 * 100 gm
₹899.00 (as of November 21, 2024 11:50 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.)
STRIFF World Map Extended Size (800 mm x 300 mm x 2 mm) Gaming Mouse Pad| Desk Mat | Stitched Edges| Non-Slip Rubber Base|Computer Laptop|Keyboard Mouse Pad for Office & Home (World Map)
₹193.00 (as of November 21, 2024 01:29 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.)
Ambrane Unbreakable 60W Fast Charging 1.5M Braided Type C to Type C Cable for Smartphones, Tablets, Laptops & Other Type C Devices, PD Technology, 480Mbps Data Sync (RCTT15, Black)
₹199.00 (as of November 21, 2024 01:29 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.)
Logitech B170 Wireless Mouse, 2.4 GHz with USB Nano Receiver, Optical Tracking, 12-Months Battery Life, Ambidextrous, PC/Mac/Laptop - Black
₹599.00 (as of November 21, 2024 01:29 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.)
TP-Link TL-WA850RE Single_Band 300Mbps RJ45 Wireless Range Extender, Broadband/Wi-Fi Extender, Wi-Fi Booster/Hotspot with 1 Ethernet Port, Plug and Play, Built-in Access Point Mode, White
₹1,299.00 (as of November 21, 2024 01:29 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!