dongxie7683 2017-01-09 21:48
浏览 115
已采纳

如何将变量传递给Laravel 5.3中的内部函数?

I am trying to pass the locale data to the eloquent query but it cannot get it. $locale value is taken from the URI.

class MyController extends Controller
{

    public function index($locale = 'en')
    {
        $news = News::join('categories', 'categories.id', '=', 'news.catid')
            ->select('news.*', 'categories.category')
            ->where([['news.published', '1'], ['news.deleted', '0']])
            ->where(function ($query) {
                $query->where('news.language', $locale) //$locale is not recognized naturally
                      ->orWhere('news.language', 'all');
            })
            ->orderBy('news.published_at', 'desc')
            ->take(4)
            ->get();

             .
             .
             .
    }
}

How can I pass $locale value into the subquery?

  • 写回答

1条回答 默认 最新

  • duanpin2034 2017-01-09 21:50
    关注

    There is the use construct that you can use to create a closure around the variable:

    ->where(function ($query) use($locale) {
        $query->where('news.language', $locale) 
              ->orWhere('news.language', 'all');
    })
    

    See Example #3 in the manual, "Inheriting variables from the parent scope".

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 关于c++外部库文件宏的问题,求解
  • ¥15 office打开卡退(新电脑重装office系统后)
  • ¥300 FLUENT 火箭发动机燃烧EDC仿真
  • ¥15 【Hadoop 问题】Hadoop编译所遇问题hadoop-common: make failed with error code 2
  • ¥15 vb6.0+webbrowser无法加载某个网页求解
  • ¥15 RPA财务机器人采购付款流程
  • ¥15 计算机图形多边形及三次样条曲线绘制
  • ¥15 根据protues画的图用keil写程序
  • ¥200 如何使用postGis实现最短领规划?
  • ¥15 pyinstaller打包错误