Laravel 5.4 New Feature - Add Eloquent WhereKey Method Example

Yesterday release Laravel 5.4 new version with new features and many upgrade. Laravel also provide documentation for Laravel 5.4 on their website. There are several update in Laravel 5.4 like in collections, mail, factory helper, Bootstrappers etc.

In this post we are going to see whereKey method in Laravel Eloquent. whereKey is very simple way to use and pretty interesting feature. laravel provide us where condition with add key(column) name and then value, But in this method you have write Key = name of column.

So i am going to give one example for whereKey() that way you can understand how it is working. So first we have on "posts" table with some dummy data like as bellow screen shot.

posts table

Ok, now we require to get only status = 'PUBLISHED' records. So now using whereKey() through we can make query as like bellow:

whereKey() Example

Route::get('wherekey', function () {
    $posts = \DB::table('posts')
    		->select(["id","title","status"])
    		->whereStatus("PUBLISHED")
    		->get();
    dd($posts);
});

You will be found out put as like bellow:

Output:

Illuminate\Support\Collection Object
(
    [items:protected] => Array
        (
            [0] => stdClass Object
                (
                    [id] => 21
                    [title] => My Sample Post
                    [status] => PUBLISHED
                )
            [1] => stdClass Object
                (
                    [id] => 23
                    [title] => Latest Post
                    [status] => PUBLISHED
                )
            [2] => stdClass Object
                (
                    [id] => 27
                    [title] => Yarr Post
                    [status] => PUBLISHED
                )
        )
)

I hope it can help you...