Home / Questions / 469747
Accepted
jmrufo
Asked: 2022-07-20 03:59:50 +0800 CST 2022-07-20 03:59:50 +0800 CST

Create multidimensional array with query result, grouping by one of its properties

  • 772

I am going to reformulate the question because I think I have not oriented it as I should.

Currently I have two tables in database TypeFactors , Factors with relation 1:N.

To obtain the data of these tables, I perform the following query:

$factors = DB::table('type_factors')
        ->join('factors', 'type_factors.id', '=', 'factors.typefactor_id')
        ->select('type_factors.typename', 'factors.typefactor_id', 'factors.factorname')
        ->get();

And I get a result of the type:

dd() result

What I would like now is to be able to group the obtained data in a multidimensional array before passing it to the view; of the type :

Example:

[
  "Conocimiento y Aptitudes" => [
     // Aquí todos los resultados, con el mismo typename "Conocimiento y Aptitudes"
   ],
  "Responsabilidad" => [
     // Aquí todos los resultados, con el mismo typename "Responsabilidad"
  ],
  // ...
]

Thanks in advance.

All the best.

laravel-blade

1 Answers

  1. Best Answer

    Well, a few hours ago I answered a question from another community colleague who needed relatively the same thing, but in javascript instead of PHP . I have adapted that solution to PHP and it is as follows:

    With a foreachwe go through and check, if the current group exists, if not we create it and add the item like this:

    // Obtenemos los resultados de la consulta
$factors = DB::table('type_factors')
  ->join('factors', 'type_factors.id', '=', 'factors.typefactor_id')
  ->select('type_factors.typename', 'factors.typefactor_id', 'factors.factorname')
  ->get();

// Creamos un Array de salida vacio
$output = [];

/** 
 * Recorremos el Array 
 */
foreach($factors as $item)
{
  // Si no existe el grupo según el tipo, lo creamos como Array vacio 
  if(! array_key_exists($item->typename, $output) )
  {
    $output[$item->typename] = [];
  }
  
  // Adicionamos el item actual al grupo
  array_push($output[$item->typename], $item);
}

// Acá debería pasar a tu vista el nuevo Array multidimensional $output
// ...

    This should work just fine for you, grouping as you like bytypename

    However, I will give you a piece of advice, I think you should consider and see the use of the groupBy closure in Laravel and in SQL in general.

    Also remember that you have in your hands, along with Laravel , Eloquent and its relationships.

    Using Laravel and not taking advantage of its features is like grinding wheat while having flour in your pantry haha. But it's just advice , you use of course, what you think is best and what you need

    Cheers :)

    • 0