Eloquent orWhere question

$oneDayAgo = now()->subDay();
$twoDaysAgo = now()->subDays(2);
$threeDaysAgo = now()->subDays(3);

$oneDayAgo = now()->subDay();
$twoDaysAgo = now()->subDays(2);
$threeDaysAgo = now()->subDays(3);

is this part of an eloquent query

->where(function ($q) use ($oneDayAgo, $twoDaysAgo, $threeDaysAgo) {
    $q->orWhereDate('created_at', $oneDayAgo);
    $q->orWhereDate('created_at', $twoDaysAgo);
    $q->orWhereDate('created_at', $threeDaysAgo);
})

->where(function ($q) use ($oneDayAgo, $twoDaysAgo, $threeDaysAgo) {
    $q->orWhereDate('created_at', $oneDayAgo);
    $q->orWhereDate('created_at', $twoDaysAgo);
    $q->orWhereDate('created_at', $threeDaysAgo);
})

the same as this?

->where(function ($q) use ($oneDayAgo, $twoDaysAgo, $threeDaysAgo) {
    $q->whereDate('created_at', $oneDayAgo);
    $q->orWhereDate('created_at', $twoDaysAgo);
    $q->orWhereDate('created_at', $threeDaysAgo);
})

->where(function ($q) use ($oneDayAgo, $twoDaysAgo, $threeDaysAgo) {
    $q->whereDate('created_at', $oneDayAgo);
    $q->orWhereDate('created_at', $twoDaysAgo);
    $q->orWhereDate('created_at', $threeDaysAgo);
})

the difference is on the first

orWhereDate

orWhereDate

orWhere

orWhere

the objective is to retrieve the records that their creation date is 1 day ago or 2 or 3 days ago
so all of them are OR but one of them must be true

i've searched it and i understand they are the same, but im not confident it is. what u'd say?

Filament•2y ago•

14 replies

Eric

Eloquent orWhere question

$oneDayAgo = now()->subDay();
$twoDaysAgo = now()->subDays(2);
$threeDaysAgo = now()->subDays(3);

$oneDayAgo = now()->subDay();
$twoDaysAgo = now()->subDays(2);
$threeDaysAgo = now()->subDays(3);

is this part of an eloquent query

->where(function ($q) use ($oneDayAgo, $twoDaysAgo, $threeDaysAgo) {
    $q->orWhereDate('created_at', $oneDayAgo);
    $q->orWhereDate('created_at', $twoDaysAgo);
    $q->orWhereDate('created_at', $threeDaysAgo);
})

->where(function ($q) use ($oneDayAgo, $twoDaysAgo, $threeDaysAgo) {
    $q->orWhereDate('created_at', $oneDayAgo);
    $q->orWhereDate('created_at', $twoDaysAgo);
    $q->orWhereDate('created_at', $threeDaysAgo);
})

the same as this?

->where(function ($q) use ($oneDayAgo, $twoDaysAgo, $threeDaysAgo) {
    $q->whereDate('created_at', $oneDayAgo);
    $q->orWhereDate('created_at', $twoDaysAgo);
    $q->orWhereDate('created_at', $threeDaysAgo);
})

->where(function ($q) use ($oneDayAgo, $twoDaysAgo, $threeDaysAgo) {
    $q->whereDate('created_at', $oneDayAgo);
    $q->orWhereDate('created_at', $twoDaysAgo);
    $q->orWhereDate('created_at', $threeDaysAgo);
})

the difference is on the first

orWhereDate

orWhereDate

orWhere

orWhere

Eloquent orWhere question

Similar Threads

Eloquent orWhere question

Similar Threads

Similar Threads

Similar Threads