//php后台查询数据库代码
$Recordss = DB::select("select topten,sum(checked) as count from tbl_records where checked = 1 group by topten");
dd($Recordss );
查询结果显示:
结果集转换数组,传到前台页面接收:
//php代码
$topten = [];
$count = []; //创建两个一维数组,分开存放柱状图的x,y轴的数据
foreach ($Recordss as $item) {
$topten[] = $item->topten;
$count[] = $item->count;
}
return view('chart', ['topten' => $topten, 'count' => $count]);
//前台JS接收php传过来的数据(echarts)
x-data: [
@foreach($topten as $key=>$value)
'{{$value}}',
@endforeach
]
y-data: [
@foreach($count as $key=>$value)
'{{$value}}',
@endforeach
]
一维数组转二维数组
public function getchart_bing()
{
$obj = new RecordsBll();
$list = $obj->getchart();
$topten = [];
$count = [];
foreach ($list as $item) {
$topten[] = $item->topten;
$count[] = $item->count;
}
$data = [];
for ($i = 0; $i < count($topten); $i++) {
$data[] = ['topten' => $topten[$i], 'count' => $count[$i]];
}
return view('chart-bing', ['count' => $data]);
}
前台JS饼状图数据接收:
data: [
@foreach($count as $key=>$value)
{ value: '{{$value["count"]}}', name: '{{$value["topten"]}}' },
@endforeach
]