How to show dynamic checkbox from database using PHP and MySQL

4 years ago
by Vetrivel Samidurai
3,746 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>
Baby Disposable Diaper Bags With Dispenser, Waste Bags 4 Refill Rolls/60 Bags, Convenient and Quick Diaper Disposal, Unscented Leak & Odors Proof Diaper Trash Bags (4 Roll) (4 Roll + Case)
5.0 out of 5 stars(4)
₹275.00 (as of February 21, 2025 19:14 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)
4.4 out of 5 stars(29369)
₹199.00 (as of February 21, 2025 19:14 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 Baby Diapers, Large (L), 44 Count 9-14 kg
4.0 out of 5 stars(27203)
₹432.00 (as of February 21, 2025 19:14 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.)
Plumbunny 6 Layer 100% Cotton Blanket -Newborn Baby Blanket -Receiving & AC Blanket - 0-1 Year Baby -Unisex (40x40 in) (Pink)
₹499.00 (as of February 21, 2025 19:14 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.)
AVANI METROBUZZ Baby Cradle with Swing and Mosquito Net, Four Wheels for 0-13 Months Baby Boys and Girls (Blue)
4.0 out of 5 stars(22)
₹1,685.00 (as of February 21, 2025 19:14 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.)
Novo Baby Soft Plush Baby Bottle Feeding Cover Tote Bag Carrier Bag Bottle Cover with Strap Pack of 2 (Vally)
5.0 out of 5 stars(54)
₹279.00 (as of February 21, 2025 19:14 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 Complete Comfort Wonder Pants | Pant Style Baby Diapers XXL Size, 96 Count | India's Fastest Absorbing Diaper, Patented Dry Xpert Channel, Ideal for 15 to 25 Kgs
4.2 out of 5 stars(211381)
₹1,531.00 (as of February 21, 2025 19:14 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 Gentle Baby Shampoo (400 ml)
4.3 out of 5 stars(57710)
₹260.00 (as of February 21, 2025 19:14 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.)
URBANMONK Foam Strip for Flat Edge Protector | Flat Edge Guard Safety Strip | Baby Proof Corner Guard | Baby Protector for Safety in Floor | 2 Meter (Brown)
5.0 out of 5 stars(3)

Now retrieving the price.

(as of February 21, 2025 19:14 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.)
MyNewborn by 10club Reversible Print Soft Sherpa Fleece Baby Blanket | for Girls, Boys, Newborn, Nursery | All Season, AC Blanket | 0-12 Months | 74 X 100 X 1.5 cm | 410 GSM (Grey, Tractor)
4.2 out of 5 stars(34)
₹399.00 (as of February 21, 2025 19:14 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 64GB USB 2.0 Flash Drive
4.2 out of 5 stars(152316)
₹389.00 (as of February 21, 2025 18:02 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(71553)
₹179.00 (as of February 21, 2025 18:02 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.)
Seagate Expansion 1TB External HDD - USB 3.0 for Windows and Mac with 3 yr Data Recovery Services, Portable Hard Drive (STKM1000400)
4.4 out of 5 stars(30242)
₹5,249.00 (as of February 21, 2025 18:02 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 USB to Lightning 3A Fast Charging Braided Cable Compatible for iPhone 14,13, 12,11, X, 8, 7, 6, 5, iPad, Macbook, iMac, AirPods, 480Mbps Data Sync, 1.5Meter Long (RCL -15, Black)
4.0 out of 5 stars(71553)
₹179.00 (as of February 21, 2025 18:02 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.)
Apple USB-C to Lightning Cable (1m) ​​​​​​​
3.8 out of 5 stars(1789)
₹1,599.00 (as of February 21, 2025 18:02 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