How to show dynamic checkbox from database using PHP and MySQL

5 years ago
by Vetrivel Samidurai
4,357 Views
1 min read

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>
CHRUTRA Latest Automatic Breast Pump Efficient Electric Milk Pump for Breastfeeding Mothers Comfortable, Portable, Quiet Suction Pump Ideal Postpartum Nursing Solution
4.2 out of 5 stars(42517)

Now retrieving the price.

(as of June 14, 2026 22:33 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.)
Philips Avent Natural Response Baby Feeding Bottle - 125Ml Baby Milk Bottle for Newborns and Up, Bpa Free, 0+ Months (Model SCY900/01)
4.5 out of 5 stars(45536636)
₹465.00 (as of June 14, 2026 22:33 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.)
Mamypoko pants All night absorb| Pant Style Baby Diapers Large Size(L), 62 Count, Ideal for 9-14Kgs|1 Diaper= Upto All night Absorption|Wider Crisscross Sheet|Gentle Coco Care| 12hr Leakage Protection| Prevents Heaviness.
3.4 out of 5 stars(3455033)
₹550.00 (as of June 14, 2026 22:33 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.)
STOFFIER GARTEN Baby Teether Toy for 3+ Months, BPA-Free Food Grade Silicone Teething Ring, Soft Chew Toy for Teething Relief, Easy Grip Sensory Teether for Infants 6–12 Months, Newborn Baby Gift for Boys & Girls
4.0 out of 5 stars(40547)
₹189.00 (as of June 14, 2026 22:33 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.)
Mamypoko pants All night absorbPant Style Baby Diapers Large Size(L), 40 Count, Ideal for 9-14Kgs1 DiaperWider Crisscross SheetGentle Coco Care12hr Leakage ProtectionPrevents Heaviness.
3.6 out of 5 stars(3656460)
₹379.00 (as of June 14, 2026 22:33 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 Pant Style Baby Diapers, Large (L), 62 Count, For babies of Upto 9-14Kg with Aloe Vera Lotion for rash protection, with upto 12hr protection, Diapers
3.8 out of 5 stars(38518416)
₹572.00 (as of June 14, 2026 22:33 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 Baby Diaper Pants | 62 Baby Diapers | Large | 9-14 Kg | 12 Hrs Absorption | Cushiony Cotton Soft Fabric | Phthalates-Free | Triple Leak Guard
3.9 out of 5 stars(39548217)
₹489.00 (as of June 14, 2026 22:33 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.)
F4FIVE Baby Tummy Time Water Mat (0–12 Months) – Inflatable Leakproof Sensory Play Gym, Jumbo Ocean Octopus Design, Water-Filled Activity Floor Playmat for Newborns, Infants & Toddlers, Indoor Outdoor Baby Toy & Gift
4.7 out of 5 stars(4755)
₹229.00 (as of June 14, 2026 22:33 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 Baby Liquid Detergent 1 L | pH Balanced, Free from Harsh Chemicals, Safe for Mother’s Hands & Baby’s Skin | Anti-Bacterial, Removes Stains & Odor with One Drop, Hypoallergenic | Mild Scent
4.5 out of 5 stars(4558255)
₹229.00 (as of June 14, 2026 22:33 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.)
StarAndDaisy Baby Carry Nest Combo Set for 0–12 Months | Baby Lounger, Bedding Nest & Mosquito Net | Soft Mattress with Side Cushions.
4.3 out of 5 stars(43520)
₹999.00 (as of June 14, 2026 22:33 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.)
ZEBRONICS Blanc Slim Wireless Mouse with Rechargeable Battery, BT + 2.4GHz, 4 Buttons, 800/1200/1600 DPI, Silent Operation, Multicolor LED Lights
4.0 out of 5 stars(4058168)
₹409.00 (as of June 14, 2026 22:41 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.)
SANDISK Ultra Dual Drive Luxe Type-C 128GB, OTG, Upto 400MB/s, Pendrive, Silver, 5Y Warranty (SDDDC4-128G-I35)
4.2 out of 5 stars(42538125)
₹2,300.00 (as of June 14, 2026 22:41 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.)
Wayona Type C to Type C 6FT/2M 65W Long Fast Charging Cable Compatible with iPhone 17, Air, iPhone 16,15 Pro/Max Series Macbook Air/Pro Samsung Galaxy S25, Ultra/S24/ S23 Flip Fold OnePlus (2M, Grey)
4.2 out of 5 stars(4259926)
₹359.00 (as of June 14, 2026 22:41 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.)
FEDUS Cat6 Ethernet Cable, 10M High Speed 550MHZ / 10 Gigabit Speed UTP LAN Cable, Network Cable Internet Cable RJ45 Cable LAN Wire, Patch Computer Cord Gigabit Category 6 Wires for Modem,WHITE
4.4 out of 5 stars(44520188)
₹289.00 (as of June 14, 2026 22:41 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.)
SanDisk Cruzer Blade 16GB, USB 2.0, Flash drive, Pendrive, Red, 5Y Warranty (SDCZ50-016G-I35)
4.3 out of 5 stars(435273997)
₹569.00 (as of June 14, 2026 22:41 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.)
4 Comments
  • Share