get a two dimensional array out of a query sql

Question

i have a query like that:

$pd= DB::table("projects")
            ->orderBy("project_number", "asc")
            ->select('name' , "type")
            ->get()->keyBy('date_scheduled');;

and i get a array keyed By the date_scheduled which is fine, but the problem is date_scheduled is not unique so it overwrites the entries. So i need to get a two dimensional array with keyby date_scheduled like:

[
 'date_1_of_date_scheduled' => [0 => '1', 1 => '4', 2 => '17']
 'date_2_of_date_scheduled' => [0 => '15', 1 => '64', 2 => '1142']
 'date_3_of_date_scheduled' => [0 => '25', 1 => '125', 2 => '66']
]

Vadim Sirbu · Accepted Answer · 2022-03-04 08:01:32Z

1

You can use groupBy() instead of keyBy(): https://laravel.com/docs/8.x/collections#method-groupby

$pd = DB::table("projects")
    ->orderBy("project_number", "asc")
    ->select('name' , "type")
    ->get()
    ->groupBy('date_scheduled');

edited Mar 4, 2022 at 8:01

answered Mar 4, 2022 at 7:47

Vadim Sirbu

6914 silver badges10 bronze badges

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

Comments

Mátyás Grőger · Accepted Answer · 2022-03-04 07:48:21Z

0

You can use the laravel map function for the purpose

Try that:

$pd= DB::table("projects")
            ->orderBy("project_number", "asc")
            ->select('name' , "type")
            ->get()
            ->map(function ($item) {
               return ['date_'.$item->date_scheduled.'_of_date_scheduled' => $item->YOUR_DESIRED_DATA] ;
             }

answered Mar 4, 2022 at 7:48

Mátyás Grőger

1,7323 gold badges20 silver badges30 bronze badges

Collectives™ on Stack Overflow

get a two dimensional array out of a query sql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related