laravel using query builder without chaining

Question

I have a query builder that works:

        $article = Page::where('slug', '=', $slug)
                     ->where('hide', '=', $hidden)
                     ->first();

But I want to only add the second where statement if hidden is equal to 1. I've tried the code below which shows the logic of what I'm trying to do, but it doesn't work.

$article = Page::where('slug', '=', $slug);
if ($hidden == 1) {
    $article->where('hide', '=', 1);
}
$article->first();

I'm using Laravel 4, but I think the question still stands with Laravel 3.

Oddman · Accepted Answer · 2013-02-05 22:09:41Z

8

Yeah there's a little "gotcha" with Eloquent and the query builder. Try the code below ;)

$query = Page::where('slug', '=', $slug);

if ($hidden == 1) {
    $query = $query->where('hide', '=', 1);
}

$article = $query->first();

Note the assigning of $query within the conditional. This is becuase the first where (statically called) returns a different object to the query object within the conditional. One way to get around this, I believe due to a recent commit, is like so:

$query = Page::where('slug', '=', $slug)->query();

This will return the query object and you can do what you want as per normal (Instead of re-assigning $query).

Hope that helps.

answered Feb 5, 2013 at 22:09

Oddman

4,0001 gold badge18 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

laravel using query builder without chaining

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related