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

webman-查詢構造器-whereNull ,whereNotNull,orWhereNull,orWhereNotNull的用法

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

 實例：

    public function index(Request $request)
    {

        ini_set('memory_limit','4096M');
       // whereNull / whereNotNull / orWhereNull / orWhereNotNull 方法验证指定的字段必须是 NULL
        $data = Db::table('ecms_news')
            ->whereNull('newspath')
            ->get();
        $whereNull=isset($data[0]) ? $data[0]:[];

        $data = Db::table('ecms_news')
            ->whereNotNull('newspath')
            ->get();
        $whereNotNull=isset($data[0]) ? $data[0]:[];

        $data = Db::table('ecms_news')
            ->orWhereNull('newspath')
            ->get();
        $orWhereNull=isset($data[0]) ? $data[0]:[];
        $data = Db::table('ecms_news')
            ->orWhereNotNull('newspath')
            ->get();

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

        $all=compact("whereNull","whereNotNull","orWhereNull","orWhereNotNull");
        var_dump($all);

        return response("ok");
    }
 構造的sql：
 select * from `phome_ecms_news` where `newspath` is null
 select * from `phome_ecms_news` where `newspath` is not null
 select * from `phome_ecms_news` where `newspath` is null
 select * from `phome_ecms_news` where `newspath` is not null
 實例被請求時：
 [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(4) {
   ["whereNull"]=>
   array(0) {
   }
   ["whereNotNull"]=>
   object(stdClass)#52 (37) {
     ["id"]=>
     int(114)
     ["classid"]=>
     int(83)
     ["ttid"]=>
     int(0)
     ["onclick"]=>
     int(62)
     ["plnum"]=>
     int(0)
     ["totaldown"]=>
     int(0)
     ["newspath"]=>
     string(0) ""
     ["filename"]=>
     string(3) "114"
     ["userid"]=>
     int(1)
     ["username"]=>
     string(6) "雪饮"
     ["firsttitle"]=>
     int(0)
     ["isgood"]=>
     int(0)
     ["ispic"]=>
     int(1)
     ["istop"]=>
     int(0)
     ["isqf"]=>
     int(0)
     ["ismember"]=>
     int(0)
     ["isurl"]=>
     int(0)
     ["truetime"]=>
     int(1423920308)
     ["lastdotime"]=>
     int(1425445123)
     ["havehtml"]=>
     int(1)
     ["groupid"]=>
     int(0)
     ["userfen"]=>
     int(0)
     ["titlefont"]=>
     string(0) ""
     ["titleurl"]=>
     string(30) "/manshenghuo/xinshang/114.html"
     ["stb"]=>
     int(1)
     ["fstb"]=>
     int(1)
     ["restb"]=>
     int(1)
     ["keyboard"]=>
     string(0) ""
     ["title"]=>
     string(30) "一个程序员的爱情故事"
     ["newstime"]=>
     int(1423920134)
     ["titlepic"]=>
     string(76) "/d/file/manshenghuo/xinshang/2015-02-14/01e4753ff30b6bf0838b6e55cbe88c39.jpg"
     ["ftitle"]=>
     string(35) "程序员,爱情,雪饮个人博客"
     ["smalltext"]=>
     string(170) " //一个程序员的爱情故事    public class MyLoveStory    {        public static void Main(string[] args)        {            //The ForeStory            int result"
     ["diggtop"]=>
     int(0)
     ["push_weixin_material"]=>
     int(0)
     ["push_baidu_last_time"]=>
     int(0)
     ["push_weixin_material_last_time"]=>
     int(0)
   }
   ["orWhereNull"]=>
   array(0) {
   }
   ["orWhereNotNull"]=>
   object(stdClass)#2639 (37) {
     ["id"]=>
     int(114)
     ["classid"]=>
     int(83)
     ["ttid"]=>
     int(0)
     ["onclick"]=>
     int(62)
     ["plnum"]=>
     int(0)
     ["totaldown"]=>
     int(0)
     ["newspath"]=>
     string(0) ""
     ["filename"]=>
     string(3) "114"
     ["userid"]=>
     int(1)
     ["username"]=>
     string(6) "雪饮"
     ["firsttitle"]=>
     int(0)
     ["isgood"]=>
     int(0)
     ["ispic"]=>
     int(1)
     ["istop"]=>
     int(0)
     ["isqf"]=>
     int(0)
     ["ismember"]=>
     int(0)
     ["isurl"]=>
     int(0)
     ["truetime"]=>
     int(1423920308)
     ["lastdotime"]=>
     int(1425445123)
     ["havehtml"]=>
     int(1)
     ["groupid"]=>
     int(0)
     ["userfen"]=>
     int(0)
     ["titlefont"]=>
     string(0) ""
     ["titleurl"]=>
     string(30) "/manshenghuo/xinshang/114.html"
     ["stb"]=>
     int(1)
     ["fstb"]=>
     int(1)
     ["restb"]=>
     int(1)
     ["keyboard"]=>
     string(0) ""
     ["title"]=>
     string(30) "一个程序员的爱情故事"
     ["newstime"]=>
     int(1423920134)
     ["titlepic"]=>
     string(76) "/d/file/manshenghuo/xinshang/2015-02-14/01e4753ff30b6bf0838b6e55cbe88c39.jpg"
     ["ftitle"]=>
     string(35) "程序员,爱情,雪饮个人博客"
     ["smalltext"]=>
     string(170) " //一个程序员的爱情故事    public class MyLoveStory    {        public static void Main(string[] args)        {            //The ForeStory            int result"
     ["diggtop"]=>
     int(0)
     ["push_weixin_material"]=>
     int(0)
     ["push_baidu_last_time"]=>
     int(0)
     ["push_weixin_material_last_time"]=>
     int(0)
   }
 }