2018-11-23 02:40
浏览 101

在Laravel中使用Query Builder进行外键查询?

I am wondering if it is possible or not to reference a foreign key to a table using the Query Builder instead of using Eloquent relationships.

I am looking at Laravel Documentation where we can create foreign key

Schema::table('posts', function (Blueprint $table) {


But I don't see in query builder if it is possible to just use the foreign key or references to get all the posts from a user

Do I have to use Eloquent relationships?

Thanks in advance for any help.

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dpxf81245 2018-11-23 03:24

    Use join to query for relations:

    $users = DB::table('users')
            ->join('posts', 'users.id', '=', 'posts.user_id')
            ->select('users.*', 'posts.*')
    解决 无用
    打赏 举报