Laravel 在关系对象上的位置

Laravel where on relationship object(Laravel 在关系对象上的位置)
本文介绍了Laravel 在关系对象上的位置的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

问题描述

我正在使用 Laravel 5.0 开发 Web API,但我不确定我正在尝试构建的特定查询.

I'm developing a web API with Laravel 5.0 but I'm not sure about a specific query I'm trying to build.

我的课程如下:

class Event extends Model {

    protected $table = 'events';
    public $timestamps = false;

    public function participants()
    {
        return $this->hasMany('AppParticipant', 'IDEvent', 'ID');
    }

    public function owner()
    {
        return $this->hasOne('AppUser', 'ID', 'IDOwner');
    }
}

class Participant extends Model {

    protected $table = 'participants';
    public $timestamps = false;

    public function user()
    {
        return $this->belongTo('AppUser', 'IDUser', 'ID');
    }

    public function event()
    {
        return $this->belongTo('AppEvent', 'IDEvent', 'ID');
    }
}

现在,我想获取特定参与者的所有事件.我试过:

Now, I want to get all the events with a specific participant. I tried with:

Event::with('participants')->where('IDUser', 1)->get();

但是 where 条件应用于 Event 而不是它的 Participants.以下给了我一个例外:

but the where condition is applied on the Event and not on its Participants. The following gives me an exception:

Participant::where('IDUser', 1)->event()->get();

我知道我可以写这个:

$list = Participant::where('IDUser', 1)->get();
for($item in $list) {
   $event = $item->event;
   // ... other code ...
}

但是向服务器发送这么多查询似乎效率不高.

but it doesn't seem very efficient to send so many queries to the server.

使用 Laravel 5 和 Eloquent 通过模型关系执行 where 的最佳方法是什么?

What is the best way to perform a where through a model relationship using Laravel 5 and Eloquent?

推荐答案

对您的关系执行此操作的正确语法是:

The correct syntax to do this on your relations is:

Event::whereHas('participants', function ($query) {
    return $query->where('IDUser', '=', 1);
})->get();

这将返回参与者的用户 ID 为 1 的事件.如果参与者的用户 ID 不为 1,则不会返回该事件.

This will return Events where Participants have a user ID of 1. If the Participant doesn't have a user ID of 1, the Event will NOT be returned.

在 https://laravel.com/docs/5.8/eloquent 阅读更多-relationships#eager-loading

这篇关于Laravel 在关系对象上的位置的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

相关文档推荐

Warning: mysqli_query() expects at least 2 parameters, 1 given. What?(警告:mysqli_query() 需要至少 2 个参数,1 个给定.什么?)
INSERT query produces quot;Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean givenquot;(INSERT 查询产生“警告:mysqli_num_rows() 期望参数 1 为 mysqli_result,给出布尔值;)
prepared statements - are they necessary(准备好的陈述 - 它们是否必要)
Do I need to escape my variables if I use MySQLi prepared statements?(如果我使用 MySQLi 准备好的语句,是否需要转义我的变量?)
Properly Escaping with MySQLI | query over prepared statements(使用 MySQLI 正确转义 |查询准备好的语句)
Is it possible to use mysqli_fetch_object with a prepared statement(是否可以将 mysqli_fetch_object 与准备好的语句一起使用)