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>
Pampers Active Baby Tape Style Baby Diapers, Newborn/Extra Small (NB/XS) Size, 72 Count, Adjustable Fit with 5 star skin protection, Up to 5kg Diapers
4.4 out of 5 stars(44546341)
₹881.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 | 72 Baby Diapers | Medium | 7-12 Kg | 12 Hrs Absorption | Cushiony Cotton Soft Fabric | Phthalates-Free | Triple Leak Guard
3.8 out of 5 stars(38569580)
₹479.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.)
Mother Sparsh Milky Soft Head to Toe Baby Wash & Baby Shampoo-400ml with Milk Protein & Shea Butter | Ph balanced & Paraben free 2 in 1 Moisturizing Natural Baby Body Wash & Shampoo
4.5 out of 5 stars(4551341)
₹240.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.)
APOLLINE INDIA® Baby Back Protector with Head Protective Hat Combo Helmet Backpack Soft Cushioning, Adjustable Shoulder Belt, ((6-18 Months) Back/Head Protector Combo, Owl)
3.9 out of 5 stars(3954)

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.)
Lactogen Pro 3, Follow-Up Formula with Iron, Whey Protein and Omega 3, After 12 Months Up to 18 Months, Bag-in-Box Pack, 1.2 kg (3 Units*400g)
4.4 out of 5 stars(4453904)
₹1,460.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.)
TEDDYY Easy Baby M Size Diaper Pant Style | 74 Count (Medium) | 7–12 kg (Pack of 1) | Long Protection Hours | Anti-Bacterial | Airy Breathable Fit | Rapid Soaker Channels with Wetness Indicator
3.6 out of 5 stars(3658980)
₹474.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.)
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.)
Novel Baby Wet Wipes 72 Wipes x Pack of 3 (216 Wipes) | Aloe Vera, Chamomile, Vitamin E Enriched | pH Balanced, Alcohol, Hypoallergenic & Paraben-Free | Soft Gentle Baby Wipes with Lid
4.8 out of 5 stars(4853)
₹169.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.)
Samsung Original Type C to C Cable - 3.28 Feet (1 Meter), Black
4.2 out of 5 stars(4256263)
₹393.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.)
Gesto Portable Fan Rechargeable with LED Light – Foldable Mini Fan, Small Fan,USB Charging Hand Fan with 1200mAh Battery & 3 Speed Modes | Travel, Makeup, Kitchen,Women’s Personal Pankhaa - Grey
4.2 out of 5 stars(4251284)
₹440.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.)
Dell MS116 Wired Mouse, 1000 DPI, Scrolling Wheel, 2 Buttons, 1 x USB, Optical LED Tracking, Plug and Play, Scrolling Wheel, Black
4.4 out of 5 stars(44547960)
₹290.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.)
Ambrane Unbreakable 3A Fast Charging 1.5m Braided Type C Cable for Smartphones, Tablets & other Type C devices, 480Mbps Data Sync, Quick Charge 3.0 (RCT15A, Black)
4.0 out of 5 stars(40537214)
₹179.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.)
ZEBRONICS Zeb-Comfort Wired USB Mouse, 3-Button, 1000 DPI Optical Sensor, Plug & Play, for Windows/Mac, Black
3.9 out of 5 stars(3959977)
₹99.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