How to show dynamic checkbox from database using PHP and MySQL

3 years ago
by Vetrivel Samidurai
3,081 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>
Philips Avent Ultra Air Soother - 2 x Light, Breathable Baby Soothers for Babies Aged 0‑6 Months, BPA-Free with Steriliser Carry Case (Model SCF085/58) by Fratelli
4.5 out of 5 stars(22)
₹559.00 (as of April 28, 2024 00:10 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 Super Soft Cleansing Baby Wipes, 864 Count, Enriched with Aloe vera & Vitamin E, pH Balanced, Dermatologically Tested & Alcohol-free, Pack of 12, 72 count/pack
5.0 out of 5 stars(1)
₹505.00 (as of April 28, 2024 00:10 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.)
Kidsmate Musical Keyboard Mat Piano Gym Mat | Hanging Toys | Baby Crawling Mat for Newborn Baby| Interactive Lights, Engaging Tunes, and Developmental Bliss for Newborns to 12 Months (Blue)
3.2 out of 5 stars(65)
₹899.00 (as of April 28, 2024 00:10 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 Anti-Colic Baby Feeding Bottles by Fratelli | 9oz/260ml - Pack of 1 | SCY103/10
4.0 out of 5 stars(24)
₹399.00 (as of April 28, 2024 00:10 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 - 260ml Baby Milk Bottle Pack of 2, BPA Free for Babies 1 Month+ Teat, (Model SCY903/02)
4.8 out of 5 stars(581)
₹985.00 (as of April 28, 2024 00:10 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.)
Oasis Baby 100% Breathable Cotton Feeding/Nursing Apron With Pocket | Adjustable Neck Strap | Tie Back | Breastfeeding and Multipurpse Cloth - Pack of 1
₹299.00 (as of April 28, 2024 00:10 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.)
Bumtum Baby Chota Bheem Gentle Soft Moisturizing Wet Wipes With Lid | Aloe Vera & Chamomile Extracts | Paraben & Sulfate Free (Pack of 6, 72 Pcs. Per Pack)
4.1 out of 5 stars(3820)
₹279.00 (as of April 28, 2024 00:10 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.)
Zoliva Baby Feeding Pillow with Detachable Cover Breast Feeding & Nursing Pillow Newborn, Infant Support for Baby and Mom Cradle 0-24 Months Breastfeeding Bottle (Gray-Animals)
4.6 out of 5 stars(53)
₹799.00 (as of April 28, 2024 00:10 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 Gentle Wash 400ml|Ph 5.5| With Allantoin| No tears formula |Clinically tested
4.6 out of 5 stars(15300)
₹763.00 (as of April 28, 2024 00:10 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.)
Bumtum Chota Bheem Large Baby Diaper Pants, 62 Count, Leakage Protection Infused With Aloe Vera, Cottony Soft High Absorb Technology (Pack of 1)
3.8 out of 5 stars(9174)
₹479.00 (as of April 28, 2024 00:10 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 Adjustable Laptop Tabletop Stand Patented Riser Ventilated Portable Foldable Compatible with MacBook Notebook Tablet Tray Desk Table Book with Free Phone Stand (Black)
4.3 out of 5 stars(37113)
₹249.00 (as of April 28, 2024 16:04 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 Rockerz 255 Max in Ear Earphones with 60H Playtime,Eq Modes,Power Magnetic Earbuds,Beast Mode,Enx Tech,ASAP Charge(10 Mins=10 Hrs),Textured Finish,Dual Pair(Stunning Black),Bluetooth
4.1 out of 5 stars(196056)
₹1,099.00 (as of April 28, 2024 16:04 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, Laptops & other Type C devices, 480Mbps Data Sync, Quick Charge 3.0 (RCT15A, Black)
4.0 out of 5 stars(60680)
₹179.00 (as of April 28, 2024 16:04 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.)
Canon PIXMA PG47 Black Ink Cartridge
4.2 out of 5 stars(11057)
₹667.00 (as of April 28, 2024 16:04 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 basics Type A to Micro USB Braided Cable | 3A/18W Fast Charging and 480 Mbps Data Transfer Speed | 1.2m, Tangle Free Cable
4.1 out of 5 stars(107717)
₹109.00 (as of April 28, 2024 16:04 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