PHP multidimensional array, each number as an array in an array

Question

I have a database with the following information:

    | ID | Name | Number |
    +----+------+--------+ 
    | 1  |  aaa |   1    |
    | 2  |  bbb |   1    |
    | 3  |  ccc |   2    |
    | 4  |  ddd |   2    |

and so on.....

What I want is to make an array like this:

    $array[1] = array ('aaa','bbb');
    $array[2] = array ('ccc','ddd');

And so on......

How do I achieve that, with a loop?

This is what I got so far:

while ($array = $query_res->fetch_assoc()) {
     $final_array[$array['Number']] = array ($array['Name']);
}
print_r($final_array);

This isn't working. I think I should use array_merge but can't figure out how to

marc_s · Accepted Answer · 2018-12-09 09:21:11Z

3

What about:

while ($array = $query_res->fetch_assoc()) {
     $final_array[$array['Number']][] = $array['Name'];
}

edited Dec 9, 2018 at 9:21

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Sep 22, 2014 at 13:40

Lorenzo Marcon

8,2395 gold badges40 silver badges64 bronze badges

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

Comments

marc_s · Accepted Answer · 2018-12-09 09:21:17Z

1

If $array is really an array an contains the keys ID,Number and Name

   $final_array = array();
   while ($array = $query_res->fetch_assoc()) {
       $final_array[$array['Number']][] = array ($array['Name']);
   }

and then print_r ....

edited Dec 9, 2018 at 9:21

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Sep 22, 2014 at 13:41

donald123

5,7883 gold badges28 silver badges24 bronze badges

Comments

marc_s · Accepted Answer · 2018-12-09 09:21:33Z

0

Change your query to

SELECT `Number`, GROUP_CONCAT(DISTINCT(`Name`)) as `Name` FROM `table`

You will get a response like:

Number=1, Name=aaa,bbb Number=2, Name=ccc,ddd

Then do something like

while ($array = $query_res->fetch_assoc()) {
     $final_array[$array['Number']] = explode(',' $array['Name']);
}
print_r($final_array);

edited Dec 9, 2018 at 9:21

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Sep 22, 2014 at 13:41

cornelb

6,0663 gold badges22 silver badges30 bronze badges

Comments

marc_s · Accepted Answer · 2018-12-09 09:21:42Z

0

You need to check if an element with the key exists, if yes, push the new value into the array, if not create a new array:

while ($array = $query_res->fetch_assoc()) {
     if(isset($final_array[$array['Number']]){
         $final_array[$array['Number']][] = $array['Name'];
     }else{
         $final_array[$array['Number']] = array ($array['Name']);
     }
}
print_r($final_array);

edited Dec 9, 2018 at 9:21

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Sep 22, 2014 at 13:40

Steve

20.5k5 gold badges47 silver badges71 bronze badges

Collectives™ on Stack Overflow

PHP multidimensional array, each number as an array in an array

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related