How can you retrieve data from database in drop down box?

Answer 1

You will need a server-side language (and, obviously, a database) to accomplish that. Here's a very simple example, using PHP and MySQL. ---- <?php // Connect to MySQL and select a database (if either one fails, stop the script) $connect = mysql_connect('username', 'password') or exit('Connection failed.'); $select = mysql_select_db('database') or exit('Database Selection failed.'); // Retrieve data from the database. $sql = "SELECT `name` FROM `fruits`"; $query = mysql_query($sql); if (!$query) { exit('The query failed.'); } // Create a drop-down box. echo "<input type='select'>"; // For each row returned, create an option element for it. while ($fruit = mysql_fetch_assoc($query)) { echo "<option>"; echo $fruit['name']; echo "</option>"; } // End the drop-down box. echo "</select>"; ?>

Answer 2

You can retrieve data from a database and populate a drop-down box by querying the database for the desired data, looping through the results, and creating options for the drop-down box based on the data retrieved. Once you have the data, you can populate the drop-down box with the options using HTML or a front-end framework like React.