{"id":2146,"date":"2021-07-07T09:54:51","date_gmt":"2021-07-07T09:54:51","guid":{"rendered":"https:\/\/phptutorial.net\/?page_id=2146"},"modified":"2021-07-07T10:30:08","modified_gmt":"2021-07-07T10:30:08","slug":"pdo-fetch_key_pair","status":"publish","type":"page","link":"https:\/\/www.phptutorial.net\/php-pdo\/pdo-fetch_key_pair\/","title":{"rendered":"PDO FETCH_KEY_PAIR"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you’ll learn how to use the PDO FETCH_KEY_PAIR<\/code> mode to select data from a table.<\/p>\n\n\n\n

Introduction to the PDO FETCH_KEY_PAIR mode #<\/a><\/h2>\n\n\n\n

Both fetch()<\/code> and fetchAll() methods accept a very useful fetch mode called PDO::FETCH_KEY_PAIR<\/code>.<\/p>\n\n\n\n

The PDO::FETCH_KEY_PAIR<\/code> mode allows you to retrieve a two-column result in an array where the first column is the key and the second column is the value.<\/p>\n\n\n\n

In practice, you’ll use the PDO::FETCH_KEY_PAIR<\/code> to fetch data for constructing a <select><\/code> element with data that comes from the database.<\/p>\n\n\n\n

For example, you can create a <select><\/code> element with the values are publisher id and texts are publisher names:<\/p>\n\n\n

<?php<\/span>\n\n$pdo = require<\/span> 'connect.php'<\/span>;\n\n$sql = 'SELECT publisher_id, name \n        FROM publishers'<\/span>;\n\n$statement = $pdo->query($sql);\n$publishers = $statement->fetchAll(PDO::FETCH_KEY_PAIR);\n?><\/span>\n<!DOCTYPE html>\n<html lang=\"en\"<\/span>>\n<head>\n    <meta charset=\"UTF-8\"<\/span>>\n    <meta name=\"viewport\"<\/span> content=\"width=device-width, initial-scale=1.0\"<\/span>>\n    <title>Publishers<\/title>\n<\/head>\n<body>\n    <label for<\/span>=\"publisher\"<\/span>>Select a pulisher<\/label>\n    <select name=\"publisher\"<\/span> id=\"publisher\"<\/span>>\n        <?php<\/span> foreach<\/span> ($publishers as<\/span> $publisher_id => $name): ?><\/span>\n        <option value=\"<?php echo $publisher_id ?>\"<\/span>><?php<\/span> echo<\/span> $name ?><\/span><\/option>\n        <?php<\/span> endforeach<\/span> ?><\/span>\n    <\/select>\n<\/body>\n<\/html><\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
<\/p>\n\n\n\n
\n
\n