PDO associative arrays - return associative

arrays pdo associative
bestprogrammerintheworld picture bestprogrammerintheworld · Mar 20, 2013 · Viewed 33.9k times · Source

I have this code:

$dbInstance = DB_Instance::getDBO();
$statement = $dbInstance->prepare("SELECT id, name FROM language ORDER BY id");
$statement->execute();      
$rows = $statement->fetchAll(); 

//Create associative array wuth id set as an index in array
$languages = array();
foreach($rows as $r) {
    $languages[$r['id']] = $r['name'];
}
return $languages;

I can't figure out how to use PDO-statement to achieve the same result that array $languages produces. I've tried some different fetch_styles.

I've tried some different styles and I could get like:

[0] svenska
[1] engelska

but I want like:

[1] svenska
[2] engelska

(where 1 and 2 are the values of id in database)

I guess I could create a function and call that with FETCH_FUNC but I'm not sure that would be so great either.

Is the above the best/cleanest way to do it?

Answer

Miron Yanovskiy picture Miron Yanovskiy · Feb 13, 2014

Everybody forgot about the

$sth->fetchAll(PDO::FETCH_KEY_PAIR);

Related questions

Can I bind an array to an IN() condition?

I'm curious to know if it's possible to bind an array of values to a placeholder using PDO. The use case here is attempting to pass an array of values for use with an IN() condition. I'd like to be …

Read More
PDO fetchAll array to one dimensional

this may be a simple question but am struggling to understand how to solve it. I have a form which allows the user to select either "custom" or "all" staff" to assign to a job. If custom is selected the …

Read More
Is there a way to fetch associative array grouped by the values of a specified column with PDO?

For example, let's use some simple data set +---------+------+------+------------+ | name | age | sex | position | +---------+------+------+------------+ | Antony | 34 | M | programmer | | Sally | 30 | F | manager | | Matthew | 28 | M | designer | +---------+------+------+------------+ What we are trying to get is …

Read More