phphtmllaravellaravel-8react-google-charts

Foreach lopp only returns a result of SQL query - Laravel 8


I am using Google Charts to make a graph to show all my citizens ordered by class, everything works correctly except the recovery of the SQL query

My function in my GraphicController is this

public function piechart(){

$result = DB::select(DB::raw("select count(class_id) as citizen_count,citizen_classes.name from assign_citizens LEFT JOIN citizen_classes ON assign_citizens.class_id = citizen_classes.id GROUP BY citizen_classes.id"));
    //dd($result);  // This dd recovery all the data

 $data="";
 foreach ($result as $val){
   $data ="['".$val->name."',     ".$val->citizen_count."],";
 }
 $chartData = $data;
    //dd($chartData ); // This dd only recovery the last register


 return view('backend.graphs.pie_chart',compact('chartData'));
    }

The thing is that if I use dd with my result variable before the foreach loop, I retrieve all my classes and the number of citizens in them correctly

array:3 [▼
  0 => {#1723 ▼
    +"citizen_count": 3
    +"name": "Participativo"
  }
  1 => {#1724 ▼
    +"citizen_count": 1
    +"name": "Inactivo"
  }
  2 => {#1725 ▼
    +"citizen_count": 1
    +"name": "Clase cuatro"
  }
]

When using the foreach loop to retrieve all the data in an understandable format for Google Chart, it only retrieves the last data, if I use dd with the data variable after the foreach loop I get this

"['Clase cuatro',     1],"

Therefore, my graph only shows that one piece of information.

I hope you can help me, sorry for the inconvenience


Solution

  • You're using $data = instead of $data .=