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

webman-查詢構造器-whereIn、whereNotIn、orWhereIn 、orWhereNotIn的用法

发布时间：2022-02-04 23:06:29编辑：雪饮阅读（）

 webman中whereIn / whereNotIn / orWhereIn / orWhereNotIn 方法验证字段的值必须存在指定的数组里

控制器實例如：
    public function index(Request $request)
    {

        ini_set('memory_limit','4096M');
       // whereIn / whereNotIn / orWhereIn / orWhereNotIn 方法验证字段的值必须存在指定的数组里：
        $where_In = Db::table('ecms_news')
            ->whereIn('id', [1, 2, 3])
            ->get();

        $whereNot_In = Db::table('ecms_news')
            ->whereNotIn('id', [1, 2, 3])
            ->get();
        $whereNot_In0=$whereNot_In[0];
        //這裏有點不太認同，其生成的sql是：select * from `phome_ecms_news` where `id` in (1, 2, 3)
        //而我覺得應該是select * from `phome_ecms_news` where 1=1 or (`id` in (1, 2, 3))類似這樣才對
        $orWhereIn = Db::table('ecms_news')
            ->orWhereIn('id', [1, 2, 3])
            ->get();
        $orWhereIn0=isset($orWhereIn[0]) ? $orWhereIn[0] : [];

        $orWhereNotIn = Db::table('ecms_news')
            ->orWhereNotIn('id', [1, 2, 3])
            ->get();
        $orWhereNotIn0=$orWhereNotIn[0];

        $all=compact("where_In","whereNot_In0","orWhereIn0","orWhereNotIn0");
        var_dump($all);

        return response("ok");
    }
實例被訪問時：
[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) {
  ["where_In"]=>
  object(Illuminate\Support\Collection)#54 (2) {
    ["items":protected]=>
    array(0) {
    }
    ["escapeWhenCastingToString":protected]=>
    bool(false)
  }
  ["whereNot_In0"]=>
  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)
  }
  ["orWhereIn0"]=>
  array(0) {
  }
  ["orWhereNotIn0"]=>
  object(stdClass)#2643 (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)
  }
}