dsa1234569
2015-11-14 14:00
浏览 183
已采纳

在Laravel和Eloquent中获取2个以上连接表的数据

Here are my tables.

╔════════════╤═╤══════════╤═╤═══════╗
║ Insurances │ │ Devices  │ │ Brands║
╠════════════╪═╪══════════╪═╪═══════╣
║ id         │ │ id       │ │ id    ║
╟────────────┼─┼──────────┼─┼───────╢
║ IMEI       │ │ type     │ │ name  ║
╟────────────┼─┼──────────┼─┼───────╢
║ device_id  │ │ name     │ │       ║
╟────────────┼─┼──────────┼─┼───────╢
║ user_id    │ │ brand_id │ │       ║
╚════════════╧═╧══════════╧═╧═══════╝

now I wanna show the results data in a table like

╔══════╤════════════╤═════════════╤══════════════╤═════════╗
║ IMEI │ brand_name │ device_name │ device_price │ user_id ║
╚══════╧════════════╧═════════════╧══════════════╧═════════╝

Imagine if it is AJAX and I have to join the tables before sending the data to the view. I have defined the relationships in models. but with the with() method I only can call 2 of em the same time and yet I dunno how to call them in the view.

Are there anyways to not use plain DB::class and just use eloquent?

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

2条回答 默认 最新

  • duanlong4890 2015-11-15 02:57
    已采纳

    You should be able to do something like this in your controller to get that result in your view.

    $insurance = Insurance::with('device.brand')->find($id);
    
    return json_encode([
      'imei' => $insurance->IMEI,
      'brand_name' => $insurance->device~>brand->name,
      'device_name' => $insurance->device->name,
      'device_price' => $insurance->device->price
      'user_id' => $insurance->user_id
    

    ]);

    评论
    解决 无用
    打赏 举报
查看更多回答(1条)

相关推荐 更多相似问题