get a two dimensional array out of a query sql

user_13629479 0
Viewed 44

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']
]
laravel php
2 Answers
user_15381090

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] ;
             }
user_124508290
Related