How to show dynamic checkbox from database using PHP and MySQL

5 years ago
by Vetrivel Samidurai
4,118 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>
LuvLap Pant Style Baby Diapers, X-Large (XL), 54 Count, For babies of Upto 12-17Kg with Aloe Vera Lotion for rash protection, with upto 12hr protection, Diapers
4.1 out of 5 stars(4153127)
₹628.00 (as of September 15, 2025 07: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 Milky Soft Baby Shampoo - 400ml, Tear Free Formula, with Milk Protein, Vitamin E & Coconut Oil, Shea Butter & Chamomile, Gentle Care for Baby's Soft Hair, No Paraben, Dermatologically Tested
4.8 out of 5 stars(48535)
₹189.00 (as of September 15, 2025 07:50 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.)
Birch & Co. Diaper Bag for Mothers for Travel – Baby Bag - Stylish Waterproof Baby Backpack with Insulated Compartments, Changing Mat, Spacious for Daily & Travel Use
4.9 out of 5 stars(49515)
₹1,499.00 (as of September 15, 2025 07:50 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 Natural Care Baby Soap-75g x 4 | BUY 3 GET 1 FREE | Tear Free Soap for Babies with Chamomile, Shea Butter & Coconut Oil | Gently Cleanses Newborn Sensitive Skin
5.0 out of 5 stars(505764)
₹236.55 (as of September 15, 2025 07:50 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's Baby Diapers XXL Size | Pants Style | 15-25 kg | 48 Count - Pack of 1 | Super Jumbo Baby Diaper with Leakage Guard, Wetness Indicator & 12 Hours Absorption
3.9 out of 5 stars(39582018)
₹572.00 (as of September 15, 2025 07: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 Natural Mosquito Repellent Fabric Roll-on for Babies-12ml, DEET Free 3-Way Protection from Mosquitoes, Fleas and Ants
₹89.00 (as of September 15, 2025 07:50 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.)
RUDRA CREATION Baby Bibs For New Born Baby Bibs - 3pcs | Baby bibs for 6 to 12 months | Bibs for new born baby 0 to 6 months | Waterproof
5.0 out of 5 stars(5051)
₹120.00 (as of September 15, 2025 07:50 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.)
Pampers Complete Skin Comfort Pants, Anti-rash blanket, Lotion with Vitamin E & Aloe Vera, Extra Large size baby diapers (XL) 56 Count, 12-17kg
4.3 out of 5 stars(435219932)
₹866.00 (as of September 15, 2025 07: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.)
StarAndDaisy Baby Mosquito Net for Sleeping with Pillow & Mattress, Foldable Bed Net with Zipper/Portable Mosquito Protection Tent for Baby/Infants & Toddlers (Ocean -Print)

Now retrieving the price.

(as of September 15, 2025 07:50 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 Wash (400ml)
4.4 out of 5 stars(44541707)
₹199.00 (as of September 15, 2025 07: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.)
SanDisk Ultra Dual Drive Luxe USB_c Type-C 128GB, OTG, Upto 400MB/S, Pendrive, Silver, 5Y Warranty (SDDDC4-128G-I35)
4.2 out of 5 stars(42534607)
₹1,249.00 (as of September 15, 2025 14:40 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.)
American Tourister Valex 28 Ltrs Large 5 Compartment Laptop Backpack with Bottle Pocket and Front Organizer- Black
4.3 out of 5 stars(4358543)
₹1,099.00 (as of September 15, 2025 14:40 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 682 Black Original Ink Advantage Cartridge
4.1 out of 5 stars(4157415)
₹828.00 (as of September 15, 2025 14:40 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.)
Portronics Konnect L POR-1403 Fast Charging 3A Type-C Cable 1.2 Meter with Charge & Sync Function for All Type-C Devices (White)
4.1 out of 5 stars(41530684)
₹119.00 (as of September 15, 2025 14:40 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 680 Original Ink Advantage Cartridge (Black)
4.1 out of 5 stars(41539654)
₹829.00 (as of September 15, 2025 14:40 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