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

webman-查詢構造器-join語句-左右連接(leftJoin、rightJoin)

发布时间：2022-02-01 23:10:39编辑：雪饮阅读（）

 控制器實現：

    public function index(Request $request)
    {

        ini_set('memory_limit','1024M');
        // leftJoin
        $users_l = Db::table('ecms_news')
            ->leftJoin('ecms_news_data_1', 'ecms_news.id', '=', 'ecms_news_data_1.id')
            ->select("ecms_news.id","ecms_news_data_1.dokey")
            ->get();

        // rightJoin
        $users_r = Db::table('ecms_news')
            ->rightJoin('ecms_news_data_1', 'ecms_news.id', '=', 'ecms_news_data_1.id')
            ->select("ecms_news.id","ecms_news_data_1.dokey")
            ->get();

        var_dump($users_l[0]);

        var_dump(($users_r[0]));
        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.
訪問了全局中間件！
object(stdClass)#60 (2) {
  ["id"]=>
  int(82)
  ["dokey"]=>
  int(1)
}
object(stdClass)#44 (2) {
  ["id"]=>
  int(114)
  ["dokey"]=>
  int(1)
}