$date = gc_head::select('DATE','point_no')->orderBy('DOCDATE','desc')->limit(7)->get();返回类似于数组格式的内容。
[{"DATE":"2021-06-11 00:00:00","point_no":"SRT-358"},{"DATE":"2021-06-11 00:00:00","point_no":"SRT-359"},{"DATE":"2021-06-11 00:00:00","point_no":"SRT-360"},{"DATE":"2021-06-10 00:00:00","point_no":"SRT-357"},{"DATE":"2021-06-10 00:00:00","point_no":"SRT-356"},{"DATE":"2021-06-10 00:00:00","point_no":"SRT-355"},{"DATE":"2021-06-09 00:00:00","point_no":"SRT-348"}]我想分离出DATE和point_no。例如
$year=['2015','2016','2017','2018','2019','2020'];我试过$date['DOCDATE']来隔离日期--它不起作用。有什么更好的方法来解决这个问题吗?
发布于 2021-06-17 13:58:27
$date = gc_head::select('DATE','point_no')->orderBy('DOCDATE','desc')->limit(7)->get();
$date_array = array();
foreach($date as $dat){
array_push($date_array, \Carbon\Carbon::parse($dat["DATE"])->format('Y');
}
return $date_array;发布于 2021-06-17 13:46:53
试试这个查询-
$years= gc_head::select('DATE','point_no')->orderBy('DOCDATE','desc')->limit(7)->get()->map(function ($q) {
return [Carbon::parse($q->DATE)->format('Y')];
});发布于 2021-06-17 13:49:45
您可以使用array_map函数。
$extractYear = function($date) {
return substr($date["DATE"], 0, 4);
};
$years = array_map($extractYear, $date);https://stackoverflow.com/questions/68020574
复制相似问题