dongsuoying9059 2017-08-13 19:54
浏览 34


I have two models - the User model and the Movie model for the following tables

The user table has the following columns

  • id
  • age

The movie table has the following columns

  • id
  • min_age

How do I define a relationship on the User model such that for each user, I am able to get all the movies which follow the constraint:

Movie.min_age <= User.age

I know that I can just query the Movie model and get all movies having min_age less than or equal to the age of the User. My question is that how can this be achieved by defining an Eloquent relationship inside the User model using the functions like hasMany() or belongsToMany()?

  • 写回答

1条回答 默认 最新

  • dsvbtgo639708 2017-08-13 20:25

    So a user can watch many movies. At the same time a movie can be watched from many users at the same time.

    On User.php

    public function movies(){
       return $this->hasMany(Movie::class);

    On Movie.php

    public function users(){
      return $this->belongsToMany(User::class);

    To get what you are looking for through relationship you do something like this;

    Let us say that you have a auth system set as well.

    $user = Auth::user();
    $getMovies = $user->movies()->where('min_age','<=',$user->age)->get();
    本回答被题主选为最佳回答 , 对您是否有帮助呢?



  • ¥30 关于#c++#的问题,请各位专家解答!
  • ¥15 App的会员连续扣费
  • ¥15 不同数据类型的特征融合应该怎么做
  • ¥15 用proteus软件设计一个基于8086微处理器的简易温度计
  • ¥15 用联想小新14Pro
  • ¥15 multisim中关于74ls192n和DSWPK开关仿真图分析(减法计数器)
  • ¥15 w3wp,exe 中发生未处理的 Microsoft ,NETFramework 异常。
  • ¥20 C51单片机程序及仿真(加减器)
  • ¥15 AQWA | 水动力分析 二阶波浪力
  • ¥15 c语言题目:成绩管理系统