您当前的位置： 首页 > 慢生活 > 程序人生 网站首页程序人生

webman-查詢構造器-whereDate,whereMonth,whereDay,whereYear, whereTime的用法

发布时间：2022-02-05 11:28:10编辑：雪饮阅读（）

 實例：

    public function index(Request $request)
    {

        ini_set('memory_limit','4096M');
       // whereDate / whereMonth / whereDay / whereYear / whereTime 方法用于比较字段值与给定的日期
        $data = Db::table('ecms_news')
            ->whereDate('truetime','2016-12-31')
            ->get();
        $whereDate=isset($data[0]) ? $data[0]:[];

        $data = Db::table('ecms_news')
            ->whereMonth('truetime','12')
            ->get();
        $whereMonth=isset($data[0]) ? $data[0]:[];

        $data = Db::table('ecms_news')
            ->whereDay('truetime','05')
            ->get();
        $whereDay=isset($data[0]) ? $data[0]:[];


        $data = Db::table('ecms_news')
            ->whereYear('truetime','05')
            ->get();

        $whereYear=isset($data[0]) ? $data[0]:[];

        $data = Db::table('ecms_news')
            ->whereTime('truetime','11:09')
            ->get();

        $whereTime=isset($data[0]) ? $data[0]:[];

        $all=compact("whereDate","whereMonth","whereDay","whereYear","whereTime");
        var_dump($all);

        return response("ok");
    }
 構造的sql：
    select * from `phome_ecms_news` where date(`truetime`) = '2016-12-31'
    select * from `phome_ecms_news` where month(`truetime`) = '12'
    select * from `phome_ecms_news` where day(`truetime`) = '05'
    select * from `phome_ecms_news` where year(`truetime`) = '05'
    select * from `phome_ecms_news` where time(`truetime`) = '11:09'
 實例被請求時：
[root@localhost webman]# /usr/local/php734/bin/php -c /usr/local/php734/lib/php.ini start.php start
Workerman[start.php] start in DEBUG mode
----------------------------------------- WORKERMAN -----------------------------------------
Workerman version:4.0.26          PHP version:7.3.4
------------------------------------------ WORKERS ------------------------------------------
proto   user            worker          listen                 processes    status
tcp     root            webman          http://0.0.0.0:8787    4             [OK]
tcp     root            monitor         none                   1             [OK]
---------------------------------------------------------------------------------------------
Press Ctrl+C to stop. Start success.
訪問了全局中間件！
array(5) {
  ["whereDate"]=>
  array(0) {
  }
  ["whereMonth"]=>
  array(0) {
  }
  ["whereDay"]=>
  array(0) {
  }
  ["whereYear"]=>
  array(0) {
  }
  ["whereTime"]=>
  array(0) {
  }
}
從構造的sql來看，以及結合我研究了第一個sql，初步理解應該是被查詢字段必須是date類型吧，否則雖然查詢沒有報錯，但是查詢是沒有結果的
不過對於非date類型也即是時間戳的秒數來説，也可以先這樣使用：
select FROM_UNIXTIME(truetime) from `phome_ecms_news` where 1=1 and date(FROM_UNIXTIME(truetime)) = '2015-02-14'