How to show dynamic checkbox from database using PHP and MySQL

5 years ago
by Vetrivel Samidurai
4,189 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>
Mee Mee Wet Wipes for Baby Skin with Aloe Vera 72Pcs, Pack of 3 | Paraben Free, Fragrance Free, pH Balanced, Dermatologically Safe, Baby Wipes Combo | Pack With Lid
4.4 out of 5 stars(44587229)
₹198.00 (as of November 30, 2025 16:49 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 Natural Baby Body Wash
4.3 out of 5 stars(4355873)
₹265.00 (as of November 30, 2025 16:49 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 Boo Microfiber Coral Fleece Baby Face Towels, Soft and Absorbent Wash Clothes for Newborns, Infants and Toddlers, Cotton Wipes & Burp Cloths Size 25x25cm Multicolor (Pack of 5)
4.2 out of 5 stars(4259)
₹149.00 (as of November 30, 2025 16:49 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 Baby Shampoo (400 ml)
4.3 out of 5 stars(43563523)
₹226.00 (as of November 30, 2025 16:49 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.9 out of 5 stars(39522687)
₹532.00 (as of November 30, 2025 16:49 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 Desire Baby Wet Wipes With 99% Pure Water, Aloevera, Vit E & Chamomile | Rash Free, pH Balanced, Alcohol & Paraben Free Soft Cleansing Wet Tissue With Lid | 72 Wipes Each, Pack Of 3
5.0 out of 5 stars(5055)
₹169.00 (as of November 30, 2025 16:49 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.)
HANUSH 100% Muslin Cotton Baby Towel – Double Layer Soft Newborn Bath Wrap, Organic Muslin Bath Towel for Infants & Babies (Bath Towel)
5.0 out of 5 stars(50516)
₹459.00 (as of November 30, 2025 16:49 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(38569118)
₹519.00 (as of November 30, 2025 16:49 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.)
Jr. Sr. Baby Tape Style Diaper | Adjustable Fit For Babies | Newborn/Extra Small (NB/XS) Size (0-5kg), 72 Count | Pack of 1 | Upto 12 hr Absorption with Advanced Leak Protection | Soft & Comfy
4.0 out of 5 stars(40597)

Now retrieving the price.

(as of November 30, 2025 16:49 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.)
Huggies Natural Soft Premium Baby Diaper Pants, Our No.1 Soft Pants, Newborn/Extra Small (XS) Size (0-5 Kgs), Pack of 76 | Cloud Softness All over with India's 1st Cloud Touch Belt
4.4 out of 5 stars(4452944)
₹525.00 (as of November 30, 2025 16:49 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.)
Dyazo 6 Angles Adjustable Aluminum Ergonomic Foldable Portable Tabletop Laptop/Desktop Riser Stand Holder Compatible for MacBook, HP, Dell, Lenovo & All Other Notebook (Silver)
4.3 out of 5 stars(43517705)
₹339.00 (as of December 1, 2025 00:34 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 Type-C to Lightning USB Cable, 22.5W Fast Charging, 480Mbps Data Sync Cable Compatible with iPhone, iPad, Macbook, iMac, AirPods, 1.25m (ABTL-125 Black)
3.8 out of 5 stars(3855000)
₹129.00 (as of December 1, 2025 00:34 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.)
boAt Type C to C 65W Fast Charging Cable with 480 Mbps Data Transfer, Tangle-Free Cable in Premium Nylon Braided Design (Carbon Black)
4.1 out of 5 stars(415134)
₹149.00 (as of December 1, 2025 00:34 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.)
Dyazo Water Resistant Laptop Sleeve/Laptop case/laptop cover with Handle Compatible for 15 Inch to 15.6" Inches laptops & Notebooks - Grey
4.3 out of 5 stars(43519010)
₹285.00 (as of December 1, 2025 00:34 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.)
HP v236w USB 2.0 64GB Pen Drive, Metal
4.2 out of 5 stars(42581709)
₹529.00 (as of December 1, 2025 00:34 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