Populate Dropdown From Database And Set Default Value May 29, 2024 Post a Comment Right now I have a working solution for populating an HTML /-dropdown with the content through PHP/MYSQLI from my database: listoption. The database: DASolution 1: You can do that like given below:<?php $result = $mysqli->query("select * from listoption"); $id = ($_GET['id'])? $_GET['id'] : ''; echo "<selectid='list'name='list'>"; while ($row = $result->fetch_assoc()) { $listoption_item = $row['listoption_item']; $sel = ($id == $row['id'])? 'selected="selected"':''; echo '<optionvalue="'.$listoption_item.'" '.$sel.'>'.$listoption_item.'</option>'; // $sel will deside when to set `selected` } echo "</select>"; ?>CopySolution 2: You can rewrite the code as follows:<?php$id = $_GET['id']; $select = ""; $result = $mysqli->query("select * from listoption"); echo"<select id='list' name='list'>"; while ($row = $result->fetch_assoc()) { $row_id = $row['ID']; if($row_id == $id){ $select = "selected"; } $listoption_item = $row['listoption_item']; echo'<option value="'.$listoption_item.'" selected="'.$select.'">'.$listoption_item.'</option>'; } echo"</select>"; ?>CopySolution 3: Use the following code:-<?php$selectedId = isset($_GET['id'])?$_GET['id']:0; $result = $mysqli->query("select * from listoption"); echo"<select id='list' name='list'>"; while ($row = $result->fetch_assoc()) { $listoption_item = $row['listoption_item']; echo'<option value="'.$listoption_item.' .(($selectedId>0)?:" selected ":"").'">'.$listoption_item.'</option>'; } echo "</select>"; ?> Copy Share Post a Comment for "Populate Dropdown From Database And Set Default Value" Top Question Input Type Datetime-local Is Not Working In Firefox I have an input type of datetime-local which is working fin… Google Org Chart Data Overflow Outside Of Div I'm using Google Org chart for a project and the conten… Using Bootstrap 4 Flexbox To Equally Divide Four Charts I am trying to plot four different stacked charts in one br… CSS Lighten Child Elements On Parent Mouseover here is my problem. I have a div which contains two other d… Div Is Shown In Wrong Position I have such code: Solution 1: Add margin: 0 auto … Some Weird Thing With Clear Both Via Css Pseudo :after Examine this code: HTML Sometext over here CSS .one { di… Disable Drop Down Option Using Jquery I need to disable options with value '- Sold Out -'… Element On Top Of Parent's Sibling I am trying to get an element to appear on top of its paren… Div Centering CSS I am struggling with my website, I am trying to get the div… Flex-box Only Display As Many Items That Fit In A Container I want to only use CSS to make it so I have a container whi… December 2024 (1) November 2024 (37) October 2024 (69) September 2024 (20) August 2024 (358) July 2024 (338) June 2024 (679) May 2024 (1294) April 2024 (687) March 2024 (758) February 2024 (840) January 2024 (759) December 2023 (809) November 2023 (367) October 2023 (556) September 2023 (291) August 2023 (325) July 2023 (276) June 2023 (346) May 2023 (212) April 2023 (139) March 2023 (143) February 2023 (174) January 2023 (255) December 2022 (121) November 2022 (228) October 2022 (809) September 2022 (164) August 2022 (289) July 2022 (93) Menu Halaman Statis Beranda © 2022 - Html5 Tutorial