Populate Dropdown From Database And Set Default Value April 08, 2023 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: DA Solution 1: You can do that like given below: <?php $result = $mysqli->query("select * from listoption"); $id = ($_GET['id'])? $_GET['id'] : ''; echo "<select id='list' name='list'>"; while ($row = $result->fetch_assoc()) { $listoption_item = $row['listoption_item']; $sel = ($id == $row['id'])? 'selected="selected"':''; echo '<option value="'.$listoption_item.'" '.$sel.'>'.$listoption_item.'</option>'; // $sel will deside when to set `selected` } echo "</select>"; ?>Copy Solution 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>"; ?> Copy Solution 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 SweetAlert - Change Modal Width? I love this library. I'd like to use it to display a m… Iframe Body Remove Space My iframe a style of style='width:100%', and it alm… Issue When Rendering A Torus In WebGL I'm writing a program that is supposed to draw 3D param… Javascript - Append Text After Url Element Is there a way to append something to a URL using javascrip… HTML5 Request Response Webservice I am pretty new to html5 web development I have created a p… How To Access File From An External Folder In Flask Server? I am new to flask and am very confused regarding including … Beautifulsoup And My Code: html = ' ' from bs4 import BeautifulSoup… Why Javascript Date.setdate() Change The Value Of Other Date Variables When i'm trying to know functionality of setDate() ,set… Alternative Of 'getelementbyid' In Angularjs Check this PLNKR, i have one list with id myMenuList, this … "access Is Denied" By Executing .hta File With Jscript On Windows Xp X64 I have a simple HTML (as HTA) application that shows strang… December 2024 (1) November 2024 (38) October 2024 (60) September 2024 (15) August 2024 (362) July 2024 (329) June 2024 (679) May 2024 (1295) April 2024 (750) March 2024 (1520) February 2024 (1668) January 2024 (1353) December 2023 (1223) November 2023 (231) October 2023 (483) September 2023 (269) August 2023 (341) July 2023 (275) June 2023 (354) May 2023 (189) April 2023 (141) March 2023 (139) February 2023 (178) January 2023 (261) December 2022 (134) November 2022 (161) October 2022 (172) September 2022 (162) August 2022 (287) July 2022 (94) Menu Halaman Statis Beranda © 2022 - Free Interactive Html5 Tutorial