dongsuoying9059 2017-08-13 19:54
浏览 34
已采纳

如何在Laravel中定义雄辩关系

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();
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥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键失灵
  • ¥15 cfx离心泵非稳态计算