How to show dynamic checkbox from database using PHP and MySQL

4 years ago
by Vetrivel Samidurai
3,650 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>
R for Rabbit Large L Size Premium Feather Diaper for Baby 9 to 14 kgs (24 Pack Offer)
4.2 out of 5 stars(5563)
₹469.00 (as of December 5, 2024 16:03 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 Powder For Baby, 700G
4.4 out of 5 stars(91020)
₹289.00 (as of December 5, 2024 16:03 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.)
CERELAC Baby Cereal | No Refined Sugar | Rice for 6-24 months baby | Omega 3 Iron Protein Calcium for babies | Instant infant Cereal | Travel Friendly | 300g
5.0 out of 5 stars(2)
₹265.00 (as of December 5, 2024 16:03 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.)
CERELAC Baby Cereal | No Refined Sugar | Wheat for 6-24 months baby | Omega 3 Iron Protein Calcium for babies | Instant infant Cereal | Travel Friendly | 300g
₹260.00 (as of December 5, 2024 16:03 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 Soft Cleansing Baby Wipes with Lid | 80 Wipes x Pack of 3 - 240 Wipes | Extra Thick & Moist Wet Wipes for Baby's | Prevents Rashes & Redness with Goodness of Aloe Vera, Vitamin E & Jojoba Oil
4.4 out of 5 stars(126897)
₹215.00 (as of December 5, 2024 16:03 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.)
Veltiro Silicone Edge Protector Strip, Baby Proofing, Pre-Tape Adhesive Corner Protectors for Furniture Bumper Against Sharp Corners for Cabinets, Tables, Stair Drawers (10 * 10MM x 3Meter)

Now retrieving the price.

(as of December 5, 2024 16:03 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 Extra Absorb Baby Diapers, Large (L), 64 Count, 9-14kg
4.3 out of 5 stars(52518)
₹867.00 (as of December 5, 2024 16:03 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.)
UrbanLeaf Premium Microfiber Kids Bath Towels Quick Drying Towels for Unisex Kids Cartoon Print Baby Towel for Boys and Girls (70 x 140 Cms, Pack of 1) - Purple
4.9 out of 5 stars(27)
₹399.00 (as of December 5, 2024 16:03 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.)
KriVat Baby Nail Trimmer Electric 6-in-1 Set for Kids Safe Effective Baby Manicure for Newborn Infant Toddler or Adults Toes and Fingernails, Kids Nail Care (Multi-Color-Pink+Blue) Pack of 1 (BLUE-PINK)
4.3 out of 5 stars(14)
₹280.00 (as of December 5, 2024 16:03 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 Baby Easy Dry Diaper Pants With 12 Hrs Absorption Medium (M) Size 74 Count, 7-12 Kgs - M (74 Pieces)
3.7 out of 5 stars(2371)
₹549.00 (as of December 5, 2024 16:03 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(11806)
₹399.00 (as of December 6, 2024 03:58 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.)
Callas Multi-Purpose Laptop Table with | Cup Holder | Drawer | Mac Holder | Study Table/Bed Table/Breakfast Table/Foldable and Portable Wooden Table (CA-39-Black)
3.9 out of 5 stars(301)
₹399.00 (as of December 6, 2024 03:58 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.)
Sounce 25 Pcs Spiral Cable Protectors & Wire Protectors Spring Wire for All Wired Accessories for USB Charger, Data Cable, Headphones, MacBook, Laptop, Elastic Cord Saver (Multi-Color)
4.2 out of 5 stars(2060)
₹129.00 (as of December 6, 2024 03:58 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 X 60W Type C to Type C Unbreakable Nylon Braided Cable, 2M Fast Charging Cable for iPhone 15 series, iPad, Samsung Galaxy & other Type C Devices(White)
4.3 out of 5 stars(1167)
₹198.00 (as of December 6, 2024 03:58 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.)
Safari Omega spacious/large laptop backpack with Raincover, college bag, travel bag for men and women, Black, 30 Litre
4.0 out of 5 stars(3815)
₹629.00 (as of December 6, 2024 03:58 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