CODEWITHSUNDEEP
phpsqlpdo
Dan Goodspeed
Dan Goodspeed

Reputation: 3590

Import two column sql table with PHP PDO to an array

I'm using PHP PDO to access a sql database. There's a table with just two columns (ID and VALUE). I want to read that table into an array such that 

$array[ID]=VALUE

I know how I can do it manually with a for loop or while loop going through one by one… but I was wondering if there's any better way of doing it.

Upvotes: 0

Views: 88

Answers (1)

Your Common Sense
Your Common Sense

Reputation: 157914

You can use PDO::FETCH_KEY_PAIR constant

$sql  = "select id, username from users limit 10";
$data = $pdo->query($sql)->fetchAll(PDO::FETCH_KEY_PAIR);

Upvotes: 1

Related Questions