Laravel 4:多个 where with 或 in eloquent

Laravel 4: multiple where with or in eloquent(Laravel 4:多个 where with 或 in eloquent)

本文介绍了Laravel 4:多个 where with 或 in eloquent的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

如何用laravel eloquent写这个条件

how to write this condition using laravel eloquent

SQL

select count(id) from fight where status = 'finished' and (user1 = 1 or user2 = 1)

Laravel(未完成):

Laravel (not finished):

Fight::where('user1','=',$uid)->orWhere('user2', '=', $uid)->count('id');

谢谢,

推荐答案

这应该可以解决问题:

Fight::whereStatus('finished')->where(function($q) use ($uid) {
    $q->where('user1',$uid)->orWhere('user2', $uid);
})->count('id');

编辑

回答评论:

Fight::whereIn('status', ['finished', 'cancelled'])->where(function($q) use ($uid) {
    $q->where('user1',$uid)->orWhere('user2', $uid);
})->count('id');

这篇关于Laravel 4:多个 where with 或 in eloquent的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本文标题为:Laravel 4:多个 where with 或 in eloquent

基础教程推荐