Laravel using WHERE in eloquent ORM

Question

I came across this

$user = User::whereConfirmationCode($confirmation_code)->first();

In Laravels eloquent ORM, can you append the tables row name in the where statment like above?

Before I saw this I would just written

eg: $user = User::where('confirmation_code', '=', $confirmation_code)->first();

Thanks

Answer 1

'Yes, you can build dynamic where. It's parse in simple where statement. Also you can build magic query like this:

$user = User::whereConfirmationCodeAndIdOrRole(12345, 5, 'admin')->first();

It will be transform to:

$user = User::where('confirmation_code', '=', 123456, 'and')->where('id', '=', 5, 'or')->where('role', '=', 'admin')->first();

Answer 2

I may be wrong. I was un-aware of magic query builder setup.

That is a custom query scope.

IE: A post model with a query scope to get all posts with 'status' = published.

class Post extends Eloquent {
    /**
     * Get all posts with 'status' published
     *
     * @param Illuminate\Database\Query\Builder $query
     * @return Builder $query
     */
     public function scopePublished(Builder $query)
     {
         return $query->where('status', 'published');
     }
}

Then using it:

 Post::published()->first();

Note parameters can be passed to the custom scope by passing them as parameters to the query scope after the query builder.

 public function scopeStatus(Builder $query, $status)
 {
     return $query->where('status', $status);
 }