douzhi3667 2018-04-29 08:08
浏览 290
已采纳

PHP Laravel:理解这个闭包

I have this snippet from the Laravel documentation:

DB::table('users')
            ->whereExists(function ($query) {
                $query->select(DB::raw(1))
                      ->from('orders')
                      ->whereRaw('orders.user_id = users.id');
            })
            ->get();

I need to understand two things.

  1. Where does the $query parameter to the closure come from? I suspect that there is something happening under the hood that I don't understand. The function takes 1 parameter, the $query, but where does it come from, how does this function know what is in this parameter, what is passed into the function?
  2. It appears that this closure doesn't return a value, there is no return statement. So how does the whereExists method know the return value of the closure?
  • 写回答

1条回答 默认 最新

  • doushi3715 2018-04-29 08:22
    关注

    Refer to the source: https://github.com/laravel/framework/blob/987a21f39f203c76665f6014cbef10451689fbdd/src/Illuminate/Database/Query/Builder.php#L1333

    As you can see the closure is treated like a callback.

    So whereExists passes $query to it. $query is an instance of self (Builder) class, so the code in the closure is just updating the object.

    /**
     * Add an exists clause to the query.
     *
     * @param  \Closure $callback
     * @param  string   $boolean
     * @param  bool     $not
     * @return $this
     */
    public function whereExists(Closure $callback, $boolean = 'and', $not = false)
    {
        $query = $this->forSubQuery();
        // Similar to the sub-select clause, we will create a new query instance so
        // the developer may cleanly specify the entire exists query and we will
        // compile the whole thing in the grammar and insert it into the SQL.
        call_user_func($callback, $query);
        return $this->addWhereExistsQuery($query, $boolean, $not);
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 metadata提取的PDF元数据,如何转换为一个Excel
  • ¥15 关于arduino编程toCharArray()函数的使用
  • ¥100 vc++混合CEF采用CLR方式编译报错
  • ¥15 coze 的插件输入飞书多维表格 app_token 后一直显示错误,如何解决?
  • ¥15 vite+vue3+plyr播放本地public文件夹下视频无法加载
  • ¥15 c#逐行读取txt文本,但是每一行里面数据之间空格数量不同
  • ¥50 如何openEuler 22.03上安装配置drbd
  • ¥20 ING91680C BLE5.3 芯片怎么实现串口收发数据
  • ¥15 无线连接树莓派,无法执行update,如何解决?(相关搜索:软件下载)
  • ¥15 Windows11, backspace, enter, space键失灵