How to show dynamic checkbox from database using PHP and MySQL

4 years ago
by Vetrivel Samidurai
3,841 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

01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
<?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>
AIRSEE Baby Nail Trimmer Electric Nail Drill, Safe Baby Nail File,Baby Nail Clippers with Light &6 Grinding Pads Polishing Shape Tools for Newborn Toddler or Adults Toes and Fingernails, Kids Nail Care, Polish Trim (Blue)
2.3 out of 5 stars(4)
₹299.00 (as of May 7, 2025 11:44 GMT +05:30 - More info)
I K IMPEX Paxk of 200 Diaper Disposal Plastic Bags for Baby Adult Diaper Disposal,Self-Adhesive Strips to Seal in Odours, Waterproof & Leak-Proof, Suitable for Elderly Nappy Care at Home and Travel
4.9 out of 5 stars(51)
₹360.00 (as of May 7, 2025 11:44 GMT +05:30 - More info)
Novo Baby Silicon Corner Protector for Sharp Edges – Baby Proofing Edge Guards for Tables, and Furniture. Corner Protector for Baby Safety, Designed to Protect Little Ones (Transparent, Pack of 12)
4.0 out of 5 stars(84)
₹199.00 (as of May 7, 2025 11:44 GMT +05:30 - More info)
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.0 out of 5 stars(20767)
₹563.00 (as of May 7, 2025 11:44 GMT +05:30 - More info)
Pampers Premium Care Pant Style Baby Diapers | Medium (M size) | 54 Count | Voted India's Softest | All-in-1 with 360 Cottony Softness Diapers | 7-12kg
4.4 out of 5 stars(57965)
₹903.00 (as of May 7, 2025 11:44 GMT +05:30 - More info)
Tedibar Baby Bathing Bar | For Baby’s Sensitive Skin | Gentle Cleansing, Skin-friendly, pH 5.5, 75gm, Pack of 3
4.4 out of 5 stars(4534)
₹504.00 (as of May 7, 2025 11:44 GMT +05:30 - More info)
Mee Mee Baby Liquid Detergent 1 L | Ph balanced, Free from Harsh Chemicals, Safe for mother's hands & baby's skin | Anti-Bacterial, Removes Stains & Odor with One Drop, Hypoallergenic
4.4 out of 5 stars(14605)
₹222.00 (as of May 7, 2025 11:44 GMT +05:30 - More info)
The Cheeky Kidzz Baby Skin Care Powder Talcum Puff Case Cum Container Box Reusable Refillable for Toddlers Kids and Infants for Baby Body And Face Grooming BPA Free (DESIGN 1)
5.0 out of 5 stars(11)
₹299.00 (as of May 7, 2025 11:44 GMT +05:30 - More info)
Himalaya Gentle Baby Shampoo (400 ml)
4.3 out of 5 stars(58739)
₹237.00 (as of May 7, 2025 11:44 GMT +05:30 - More info)
Little's Baby Diapers XL Size (Extra Large) Pants Style | 12-17 kg | 54 Count - Pack of 1 | Super Jumbo Baby Diaper with Leakage Guard, Wetness Indicator & 12 Hours Absorption
3.9 out of 5 stars(80070)
₹567.00 (as of May 7, 2025 11:44 GMT +05:30 - More info)
ZEBRONICS Blanc Slim Wireless Mouse with Rechargeable Battery, BT + 2.4GHz, 4 Buttons, 800/1200/1600 DPI, Silent Operation, Multicolor LED Lights
4.0 out of 5 stars(2719)
₹372.00 (as of May 7, 2025 02:27 GMT +05:30 - More info)
Portronics Toad One Bluetooth Mouse with 2.4 GHz & BT 5.3 Dual Wireless, 6 Buttons, Rechargeable, RGB Lights, Connect 3 Devices, Ergonomic Design for Laptop, Smartphone, Tablet (Black)
4.2 out of 5 stars(4101)
₹518.00 (as of May 7, 2025 02:27 GMT +05:30 - More info)
Safari Omega Pro 35L Laptop Backpack with Raincover, 3 compartments, bottle holder, organizer, school bag for boys and girls, college bag for women and men, office bag, travel bag
4.0 out of 5 stars(5615)
₹619.00 (as of May 7, 2025 02:27 GMT +05:30 - More info)
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(9488)
₹329.00 (as of May 7, 2025 02:27 GMT +05:30 - More info)
Zebronics ZEB-KM2100 Multimedia USB Keyboard Comes with 114 Keys Including 12 Dedicated Multimedia Keys & with Rupee Key
3.7 out of 5 stars(41306)
₹219.00 (as of May 7, 2025 02:27 GMT +05:30 - More info)
4 Comments
  • Share