What is the best approach to creating a select box with standard values and values from a database in PHP?

When creating a select box in PHP with standard values and values from a database, the best approach is to first fetch the values from the database and then dynamically generate the options for the select box. This ensures that the select box is always up-to-date with the latest values from the database. 

<?php
// Connect to the database
$connection = new mysqli("localhost", "username", "password", "database");

// Check connection
if ($connection->connect_error) {
    die("Connection failed: " . $connection->connect_error);
}

// Fetch values from the database
$query = "SELECT id, name FROM table";
$result = $connection->query($query);

// Generate select box options
echo "<select name='selectbox'>";
echo "<option value=''>Select an option</option>";
while ($row = $result->fetch_assoc()) {
    echo "<option value='" . $row['id'] . "'>" . $row['name'] . "</option>";
}
echo "</select>";

// Close database connection
$connection->close();
?>

Keywords

PHP select box database values approach

Related Questions