WebLogsController.php $get_all=WebLogs::orderBy('log_time','desc')->take($day)->get(); // var_dump($get_all); $get_all=$get_all->toarray();//转化成数组 // var_dump($get_all); $get_all=array_reverse($get_all); // var_dump($get_all); // $get_time = WebLogs::orderBy('log_time','desc')->take(10)->get(['log_time'])-->toArray(); // get(['log_time']) 获取某一列-> return view('logs',compact('get_all'));//传入数组 logs.blade.php //传入数组的调用 @foreach($get_all as $value) {{$value["baidu"]}}, @endforeach //如果传入是的<span class="wp_keywordlink_affiliate"><a href="https://www.168seo.cn/tag/laravel" title="View all posts in laravel" target="_blank">laravel</a></span> eloquent&amp;nbsp; @foreach($get_all as $value) {{$value-&gt;baidul}}, @endforeach //DB查询 use Illuminate\Support\Facades\DB;</pre> <pre>$citys = DB::table('ips_info') ->where('city','<>','none') ->where('city','<>','') ->select('city','xx','yy') ->groupBy('city') ->get(); $city_repeats = DB::table("ips_info") ->where('city','<>','none') ->where('city','<>','') ->select('city',DB::raw("SUM(repeat_times) as count")) ->groupBy('city') ->get();</pre> <pre>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
WebLogsController
.
php
$get_all
=
WebLogs::
orderBy
(
'log_time'
,
'desc'
)
->
take
(
$day
)
->
get
(
)
;
// var_dump($get_all);
$get_all
=
$get_all
->
toarray
(
)
;
//转化成数组
// var_dump($get_all);
$get_all
=
array_reverse
(
$get_all
)
;
// var_dump($get_all);
// $get_time = WebLogs::orderBy('log_time','desc')->take(10)->get(['log_time'])-->toArray();
//
get
(
[
'log_time'
]
)
获取某一列
->
return
view
(
'logs'
,
compact
(
'get_all'
)
)
;
//传入数组
logs
.
blade
.
php
//传入数组的调用
@
foreach
(
$get_all
as
$value
)
{
{
$value
[
"baidu"
]
}
}
,
@
endforeach
//如果传入是的laravel eloquent&amp;nbsp;
@
foreach
(
$get_all
as
$value
)
{
{
$value
-
&
amp
;
gt
;
baidul
}
}
,
@
endforeach
//DB查询
use
Illuminate
\
Support
\
Facades
\
DB
;
<
/
pre
>
<
pre
>
$citys
=
DB::
table
(
'ips_info'
)
->
where
(
'city'
,
'<>'
,
'none'
)
->
where
(
'city'
,
'<>'
,
''
)
->
select
(
'city'
,
'xx'
,
'yy'
)
->
groupBy
(
'city'
)
->
get
(
)
;
$city_repeats
=
DB::
table
(
"ips_info"
)
->
where
(
'city'
,
'<>'
,
'none'
)
->
where
(
'city'
,
'<>'
,
''
)
->
select
(
'city'
,
DB::
raw
(
"SUM(repeat_times) as count"
)
)
->
groupBy
(
'city'
)
->
get
(
)
;
<
/
pre
>
<
pre
>
|