PHP PDO: fetchAll(PDO::FETCH_COLUMN | PDO::FETCH_GROUP) doesn't work

Question

I have a question about PDO in PHP:

I'm trying to fetch a column from my mysql database, indexed by the id of each row... Now php.net has an example on how to do it: http://www.php.net/manual/en/pdostatement.fetchall.php (example #3)

    <?php
$insert = $dbh->prepare("INSERT INTO fruit(name, colour) VALUES (?, ?)");
$insert->execute(array('apple', 'green'));
$insert->execute(array('pear', 'yellow'));

$sth = $dbh->prepare("SELECT name, colour FROM fruit");
$sth->execute();

/* Group values by the first column */
var_dump($sth->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP));
?>

But this doesn't seem to work for me... All i get is:

array {

   [id1] => null;
   [id2] => null;
   [id3] => null;
   ...

}

Even when i copy the exact same code, and only edit the table name etc. Does anyone know what can cause this problem?

Well it's part of the example on php.net but doesn't really matter actually, I just copied the whole example. — user3108837
– user3108837, Commented Dec 20, 2013 at 14:12
Ah if you mean there could be something wrong in my database, this is not the case (: — user3108837
– user3108837, Commented Dec 20, 2013 at 14:13
No, not really, but i'll just leave it at that and select the answer below as a good answer — user3108837
– user3108837, Commented Dec 20, 2013 at 23:10

Your Common Sense · Accepted Answer · 2013-12-20 14:11:22Z

0

As you can see from the output in the example you linked to, it doesn't work the way you expect.

So, just loop over result using while fetch, storing resul in array manually and set whatever index you like.

answered Dec 20, 2013 at 14:11

Your Common Sense

158k42 gold badges226 silver badges372 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3108837 Over a year ago

Well actually I wanted something like that... I would only have one item in the array where colors are stored in the example, but that's easier to fix than the loop... But yeah I'll probably just loop...

Collectives™ on Stack Overflow

PHP PDO: fetchAll(PDO::FETCH_COLUMN | PDO::FETCH_GROUP) doesn't work

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related