How to query this year's data in php-PHP Problem-php.cn

How to query this year's data in php

藏色散人

Release： 2023-03-14 14:26:01

Original

2463 people have browsed it

How to query this year's data in php: 1. Get the time of this year through date; 2. Run the query statement "$result = $db->where($where)->select(); "That's it.

How to query this year's data in php

#The operating environment of this article: Windows 7 system, thinkphp v5.1 version, Dell G3 computer.

How to query this year's data in php?

thinkphp queries the data of the day, this week, this month, and this year

The code is such as:

//当天时间
$where[&#39;time&#39;] = array(
    array(&#39;egt&#39;,strtotime(date(&#39;Y-m-d&#39;,time())),
    array(&#39;lt&#39;,strtotime(date(&#39;Y-m-d&#39;,time())).&#39;+1 day&#39;)
);
// 本周时间
$where[&#39;time&#39;] = array(
    array(&#39;egt&#39;,strtotime(date(&#39;Y-m-d&#39;,time())).&#39;-&#39;.date(&#39;w&#39;,time()).&#39; day&#39;),
    array(&#39;lt&#39;,strtotime(date(&#39;Y-m-d&#39;,time())).&#39;+1 week -&#39;.date(&#39;w&#39;,time()).&#39; day&#39;);
);
// 本月时间
$where[&#39;time&#39;] = array(
    array(&#39;egt&#39;,strtotime(date(&#39;Y-m&#39;,time()))),
    array(&#39;lt&#39;,strtotime(date(&#39;Y-m&#39;,time()).&#39;+1 month&#39;))
);
// 本年时间
$where[&#39;time&#39;] = array(
    array(&#39;egt&#39;,strtotime(date(&#39;Y&#39;,time()))),
    array(&#39;lt&#39;,strtotime(date(&#39;Y&#39;,time()).&#39;+1 year&#39;))
);

Copy after login

The above is the query condition, which is directly applied to the query The statement is enough

$result = $db->where($where)->select();

Copy after login

Correction of the query time of this year above

$where[&#39;time&#39;] = array(
    array(&#39;egt&#39;,strtotime(date(&#39;Y-01-01&#39;,time())),
    array(&#39;lt&#39;,strtotime(date(&#39;Y-01-01&#39;,time()).&#39;+1 year&#39;))
);

Copy after login

Repaired version

//昨天时间
    $yesterday[&#39;addtime&#39;] = array(
array(&#39;egt&#39;,strtotime(date(&#39;Y-m-d&#39;,time()).&#39; -1 day&#39;)),
array(&#39;lt&#39;,strtotime(date(&#39;Y-m-d&#39;,time())))
);
//当天时间
$day[&#39;addtime&#39;] = array(
array(&#39;egt&#39;,strtotime(date(&#39;Y-m-d&#39;,time()))),
array(&#39;lt&#39;,strtotime(date(&#39;Y-m-d&#39;,time()).&#39; +1 day&#39;))
);
// 本月时间
$month[&#39;addtime&#39;] = array(
array(&#39;egt&#39;,strtotime(date(&#39;Y-m&#39;,time()))),
array(&#39;lt&#39;,strtotime(date(&#39;Y-m&#39;,time()).&#39; +1 month&#39;))
);
// 本周时间
$week[&#39;addtime&#39;] = array(
array(&#39;egt&#39;,strtotime(date(&#39;Y-m-d&#39;,time()).&#39;-&#39;.date(&#39;w&#39;,time()).&#39; day&#39;)),
array(&#39;lt&#39;,strtotime(date(&#39;Y-m-d&#39;,time()).&#39;+1 week -&#39;.date(&#39;w&#39;,time()).&#39; day&#39;))
);

Copy after login

Recommended learning: "PHP Video tutorial》《The latest 10 thinkphp video tutorials》

The above is the detailed content of How to query this year's data in php. For more information, please follow other related articles on the PHP Chinese website!