drjltlm156790
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) {
    $table->unsignedInteger('user_id');

    $table->foreign('user_id')->references('id')->on('users');
});

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.*')
            ->get();
    
    已采纳该答案
    评论
    解决 无用
    打赏 举报