Laravel: Eloquent 'more than' and 'lesser than'

user_7441341 0
Viewed 7363

I want a Database Query like this in query builder:

SELECT * FROM posts WHERE active = 1 AND published <= '{$now}' LIMIT 5

What I made:

$now = new Carbon;
$feed = Post::where([
        ['active' => 1],
        ['published' => $now]
    ])
    -> take(5)
    -> get()
    -> toArray();

But it's like:

SELECT * FROM posts WHERE active = 1 AND published = '{$now}' LIMIT 5

How to make <, <=, >, >=, <> and LIKE statements with ::where method?

laravel-5.5 eloquent laravel mysql php
3 Answers

Use like this ['published','>=',$now]

$now = new Carbon;
$feed = Post::where([
    ['active', '=', '1'],
    ['published','>=',$now]
])
->take(5)
->get()
->toArray();

OR use separate where function 

$now = new Carbon;
$feed = Post::where('active', 1)->where('published','>=', $now)
->take(5)
->get()
->toArray();
user_28156350

Eloquent

  $feed = Post::where('active','=',1)->where('published','<=',$now)->get();
user_32246300
user_15784020
Related