How to show dynamic checkbox from database using PHP and MySQL

4 years ago
by Vetrivel Samidurai
3,665 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>
Silicone Baby Teething Fruit Shape Toy for 0-12 Months | BPA-Free Soothing Teether | Soft & Safe Gum Relief Toy for Babies (Pack of -2)
5.0 out of 5 stars(2)
₹179.00 (as of December 20, 2024 19:08 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.)
3 in 1 Big Dream Baby Bed, Sleeping Bag & Carry Nest, Cotton Baby Bedding for New Born & Infant, Portable Bassinet, for Baby Carrying & Unisex Baby Sleeping Bed
₹330.00 (as of December 20, 2024 19:08 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 Extra Moisturizing Baby Wash 400ml | No tears formula |with Olive Oil, Aloe Vera & Milk | Cleanses and moisturizes baby’s skin
4.3 out of 5 stars(9392)
₹167.00 (as of December 20, 2024 19:08 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.)
THE BABY FEEDING COMPANY Breast Pump for Feeding Mothers Automatic Electrical Milk Feeding Pumping Rechargeable, Digital Touch Screen
5.0 out of 5 stars(1)
₹1,499.00 (as of December 20, 2024 19:08 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 99% Pure Water (Unscented) Baby Wipes with Lid I Natural Plant made cloth - Super thick Wet Wipes I 72 pcs/pack - Pack of 2 (Super Saver Pack)
4.5 out of 5 stars(15363)
₹399.00 (as of December 20, 2024 19:08 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.)
Zeccorp Edge Protector, Baby Proofing Edge Protector Strip, Soft Silicone Childproof Guards for Furniture, Desk, Table, Crib, Bed, Wall - Safety Bumper Cover for Sharp Corners & Edges (4 Meter)
5.0 out of 5 stars(88)
₹589.00 (as of December 20, 2024 19:08 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(28560)
₹205.00 (as of December 20, 2024 19:08 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.)
CAREIT Playards|Playpen for Kids up to 4 Years,Spacious 150x150 cm Baby Play Yard with Safety Lock & Hand Grip, Thick Padding & 360° Mesh Visibility, Portable Activity Center for Toddlers - Aqua Green
5.0 out of 5 stars(15)
₹4,399.00 (as of December 20, 2024 19:08 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 Apple for 6-24 months baby | Omega 3 Iron Protein Calcium for babies | Instant infant Cereal | Travel Friendly | 350g
4.8 out of 5 stars(14)
₹295.00 (as of December 20, 2024 19:08 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.)
TRAXITO 12 PCS Edge Protector for Furniture Table Corner Guards for Sharp Edges Silicon Corner Protector for Sharp Edges Gel Table Corner Protector and Soft PVC Transparent Corner Guard (12)
4.9 out of 5 stars(30)
₹289.00 (as of December 20, 2024 19:08 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(27483)
₹5,149.00 (as of December 21, 2024 05:17 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.)
Dell KB216-Black Multimedia Wired Keyboard with USB Interface, Plunger Keys Technology and Chiclet Key Style, Hot Key-Volume, Mute, Play/Pause, Backward, Forward, Warranty 1 Year.
4.3 out of 5 stars(36945)
₹559.00 (as of December 21, 2024 05:17 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 MacBook Air Laptop: Apple M1 chip, 13.3-inch/33.74 cm Retina Display, 8GB RAM, 256GB SSD Storage, Backlit Keyboard, FaceTime HD Camera, Touch ID. Works with iPhone/iPad; Space Grey
4.6 out of 5 stars(4777)
₹56,990.00 (as of December 21, 2024 05:17 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.)
Logitech M186 Wireless Mouse, 2.4GHz with USB Mini Receiver, 12-Month Battery Life, 1000 DPI Optical Tracking, Ambidextrous, Compatible with PC, Mac, Laptop
4.3 out of 5 stars(76406)
₹495.00 (as of December 21, 2024 05:17 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.)
ZEBRONICS PHERO Wired Gaming Mouse with up to 1600 DPI, Rainbow LED Lights, DPI Switch, High Precision, Plug & Play, 4 Buttons
4.3 out of 5 stars(26167)
₹169.00 (as of December 21, 2024 05:17 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