duansha6410 2015-07-02 17:30
浏览 38

Laravel 5:如何使用Eloquent查询数据透视表

Is there a way to use Eloquent to query a pivot table without having a model for that pivot table?

Situation: a user can own multiple businesses, and a business can be owned by multiple users. I have the following tables to deal with the many-to-many relationship.

| users     | businesses  | business_user |
| id        | id          | business_id   |
| name      | name        | user_id       |
| created_at| created_at  | created_at    |
| updated_at| updated_at  | updated_at    |

My User.php model

public function businesses()
    return $this->belongsToMany('App\Business')->withTimestamps();

My Business.php model

public function users()
    return $this->belongsToMany('App\User')->withTimestamps();

1- In my controller, i'm trying to query the business_user (pivot) table to count the number of businesses the Auth user Id has.

select count(*) from business_user where user_id = Auth::user()->id() ;

2- I'm trying to query the business_user (pivot) table to get the business name for each row found in table business_user for that user id.

select business_user.business_id, businesses.name 
  from business_user 
  join businesses 
    on business_user.business_id = businesses.id
 where business_user.user_id     = Auth::user()->id() ;

I would like to query the pivot table with Eloquent, but I can't get the syntax right. Do I need a model for that business_user table?

Do some of you prefer not using Eloquent at all?

Thanks cv

  • 写回答

1条回答 默认 最新

  • dqhbuwrwq692118284 2015-07-02 17:36

    You don't need Model for a Pivot table. Things you are asking for are pretty straight forward.

    Number of businesses the current logged in User has

    echo \Auth::user()->businesses->count();

    name of each business for current User

    foreach(\Auth::user()->businesses as $business){
      echo $business->name;
    本回答被题主选为最佳回答 , 对您是否有帮助呢?



    • ¥15 I350 Gigabit Network
    • ¥15 关于#abap#的问题,请各位专家解答!
    • ¥20 内网通过公网访问外网问题
    • ¥20 谁有这个东西 继续教育的
    • ¥15 怎么使请求通过cors
    • ¥15 WDM 驱动ACPI 相关疑问
    • ¥15 prism 跨窗体共享数据绑定 wpf
    • ¥15 hdl designer突然用不了系统的moduleware组件,请问有人遇到或者怎么解决吗?
    • ¥15 0基础计算机毕设,应该从哪开始?
    • ¥60 使用DKT40脑图划分ROI区域