What is the purpose of using a foreach loop in PHP to populate a select box with values from a database?

When populating a select box with values from a database in PHP, using a foreach loop is a convenient way to iterate through the result set and dynamically generate the options for the select box. This approach allows for easy maintenance and scalability, as the select box will automatically update with any changes to the database values. 

<select name="my_select">
<?php
// Assume $db is the database connection and $query is the SQL query to fetch values
$result = $db->query($query);

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "<option value='" . $row['id'] . "'>" . $row['name'] . "</option>";
    }
}
?>
</select>

Keywords

foreach loop PHP select box database values

Related Questions