PHP FetchAll to array

Question

I'm trying to take a result from fetchAll and to take some of the data and put it into an array.

Relevant PHP:

  $catcodessql = "select distinct cat_code from mytable";
  $result2 = $dbh->query($catcodessql)->fetchAll(PDO::FETCH_ASSOC);

This returns something like below:

array(4) {
 [0]=>
array(1) {
["cat_code"]=>
string(3) "edu"
 }
 [1]=>
 array(1) {
["cat_code"]=>
string(3) "inc"
}
[2]=>
array(1) {
["cat_code"]=>
string(3) "net"
 }
[3]=>
 array(1) {
["cat_code"]=>
string(3) "occ"
}

What I want is all those strings so I can dynamically put together this line later in my PHP:

$allcategories = array ('edu', 'inc', 'net', 'occ' );

So, I need to create a variable that will replace this part: 'edu', 'inc', 'net', 'occ'

I've tried a couple of while functions, but clearly they aren't right.

If you use PHP +5.5 then you may want to look into: php.net/manual/en/function.array-column.php — Rizier123
– Rizier123, Commented Jan 27, 2015 at 18:42
do you want only this array $allcategories = array ('edu', 'inc', 'net', 'occ' )? — acontell
– acontell, Commented Jan 27, 2015 at 18:55

AbraCadaver · Accepted Answer · 2015-01-27 19:11:02Z

2

PHP >= 5.5.0 needed for array_column() or use the PHP Implementation of array_column()

$allcategories = array_column($result2, 'cat_code');

Or foreach over the query:

foreach($dbh->query($catcodessql) as $row) {
    $allcategories = $row['cat_code'];
}

edited Jan 27, 2015 at 19:11

answered Jan 27, 2015 at 18:43

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

3 Comments

Rizier123 Over a year ago

If he only have this column in the array he also could use this one: print_r(array_keys(call_user_func_array('array_merge', array_map("array_flip", $arr)))); :D But i know that you love array_column(), so +1

jonmrich Over a year ago

I think I'm not implementing what you suggested correctly. I'm trying this:

$catcodessql = "select distinct cat_code from mytable";  $dbh->query($catcodessql);  while($row = $dbh->fetch(PDO::FETCH_ASSOC)) {     $allcategories = $row['cat_code']; }

Is that right or am I missing something? This is returning a 500 error.

AbraCadaver Over a year ago

I don't know about the 500 and rarely use query but check the edit with the foreach.

acontell · Accepted Answer · 2015-01-27 19:12:15Z

1

If you only want to retrieve unique categories, You can do it directly with a query:

$stmt = $dbh->prepare("select GROUP_CONCAT( cat_code SEPARATOR ',') as cat_code from ( select distinct cat_code from mytable) as m"); 
$stmt->execute(); 
$row = $stmt->fetch();
$categories = explode(",",$row["cat_code"]);
var_dump($categories);

answered Jan 27, 2015 at 19:12

acontell

6,9321 gold badge22 silver badges33 bronze badges

5 Comments

jonmrich Over a year ago

This results in roughly the same thing I had before:

array(36) {   [0]=>   string(3) "edu"   [1]=>   string(3) "inc"   [2]=>   string(3) "net"   [3]=>   string(3) "occ"   [4]=>

acontell Over a year ago

isn't it what you wanted?

jonmrich Over a year ago

Ideally, I wanted it precisely in this format: ('edu', 'inc', 'net', 'occ' ). I can't seem to get from the array returned to the array I need to feed another function, which just wants this comma separated list.

acontell Over a year ago

I mean, you need a string?

jonmrich Over a year ago

Wait a minute...my mistake. I actually don't need any further processing. I was able to take exactly what you had and put it into my function. So, this worked perfectly after all. Thanks!

Collectives™ on Stack Overflow

PHP FetchAll to array

2 Answers 2

3 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related