In PHP, how can the FETCH_KEY_PAIR fetch mode be used to simplify the process of populating select fields with data from a database?

When populating select fields with data from a database in PHP, the FETCH_KEY_PAIR fetch mode can simplify the process by fetching key-value pairs directly from the database query result. This eliminates the need to manually iterate over the result set and build an associative array for populating the select field options. By using FETCH_KEY_PAIR, you can directly fetch the key-value pairs and use them to populate the select field options efficiently. 

// Connect to the database
$pdo = new PDO("mysql:host=localhost;dbname=mydatabase", "username", "password");

// Prepare a query to fetch key-value pairs for populating select field
$stmt = $pdo->query("SELECT id, name FROM my_table");

// Fetch key-value pairs directly using FETCH_KEY_PAIR fetch mode
$options = $stmt->fetchAll(PDO::FETCH_KEY_PAIR);

// Populate select field options
echo "<select>";
foreach ($options as $key => $value) {
    echo "<option value='$key'>$value</option>";
}
echo "</select>";

Keywords

PHP FETCH_KEY_PAIR fetch mode select fields database

Related Questions