Relación de consulta laravel
Ejemplos de código
laravel donde tiene
use Illuminate\Database\Eloquent\Builder;
// Retrieve posts with at least one comment containing words like foo%...
$posts = App\Post::whereHas('comments', function (Builder $query) {
$query->where('content', 'like', 'foo%');
})->get();
// Retrieve posts with at least ten comments containing words like foo%...
$posts = App\Post::whereHas('comments', function (Builder $query) {
$query->where('content', 'like', 'foo%');
}, '>=', 10)->get();laravel eloquent associate
$account = App\Account::find(10);
$user->account()->associate($account);
$user->save();donde consulta de la tabla de relaciones en laravel
UserModel::whereHas('attachments', function ($attachmentQuery) {
$attachmentQuery->where('level', 'profile_level');
})->get();
If you want from already queried model get specific attachments then write
$userModel->attachments()->where('level', 'profile_level')->get();
it is impossible to query both UserModel and AttachementModel in single query,
it must be at least two queries. Even fancy
UserModel::with('attachments')->get();,
which returns user with all attachments, do internally two queries.
OR:
I noticed that you can define relation constraints within with method
UserModel::with(['attachments' => function ($attachmentQuery) {
$attachmentQuery->where('level', 'profile_level');
}])->get();Páginas relacionadas
Páginas de ejemplo relacionadas
En otros idiomas
Esta página está en otros idiomas
empty row
Русский
..................................................................................................................
English
..................................................................................................................
Italiano
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
中文
..................................................................................................................
Slovenský
..................................................................................................................
Балгарскі
..................................................................................................................
Íslensk
..................................................................................................................
Popular en esta categoría
Páginas populares con ejemplos en la categoría
empty row