php-pdoGet key-value pairs from table using PHP PDO

$st = $pdo->prepare('SELECT id, name FROM test');
$st->execute();
$key_vals = $st->fetchAll(PDO::FETCH_KEY_PAIR);ctrl + cgithub

`$pdo->prepare` prepare given query to execute	`id, name` 2 columns that will be used as `key` (1st column) and `value` (2nd column)
`$st->execute(` run query on the server	`fetchAll` returns all rows from result set
`FETCH_KEY_PAIR` will return key-value pairs based on selected columns in the resulting set

Usage example

<?php

$pdo = new PDO('mysql:host=localhost;dbname=test', 'usr', 'pwd');

$st = $pdo->prepare('SELECT id, name FROM test LIMIT 3');
$st->execute();
$key_vals = $st->fetchAll(PDO::FETCH_KEY_PAIR);
print_r($key_vals);

output

Array
(
    [1] => A
    [2] => B
    [3] => C
)

Fetch single column value with PHP PDO
Fetch single row with PHP PDO
Fetch all resulting rows with PHP PDO
Fetch array of column values with PHP PDO

More of Php Pdo

Set execution timeout with PHP PDO
Set charset in PHP PDO
Fetch single column value with PHP PDO
Bind current datetime with PHP PDO
Escape string with PHP PDO
How to get results after PHP PDO statement execute()
Get last query error with PHP PDO
Commit transaction in PHP PDO
Get current database name with PHP PDO
Transaction example with PHP PDO

See more codes...

php-pdoGet key-value pairs from table using PHP PDO

Usage example

output

Related

More of Php Pdo