The database query builder in Laravel provides a simple, intuitive interface for generating and performing database queries. It works with every one of Laravel's supported database systems and may be used to conduct most operations on the database in your application.

We'll look at the whereKey method in Laravel Eloquent in this post. whereKey is an extremely easy-to-use tool with a lot of potential. Where condition with add key(column) name and then value is provided by Laravel. However, in this manner, you must write Key = column name.

So, in order for you to understand how whereKey() works, I'll give you an example. So, first, we'll create a table called "posts" with some dummy data.

whereKey() Example

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

You will find output similar to what is seen below.

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 you will like the content and it will help you to learn Laravel Eloquent Query - Laravel whereKey method
If you like this content, do share.


Recommended Posts

View All

Laravel whereBetween Query Example


In this post, we will see Laravel whereBetween query model. SQL gives numerous different sorts of techniques or queries to get separated information f...

Google Map with Multiple Marker and Info Box in Laravel


This tutorial will teach you how to use Laravel to integrate a Google Map with numerous markers and an info box.

Laravel where and orWhere Condition Example


how to use where and orwhere condition in laravel 8, laravel 8 where and orwhere condition, where and orwhere laravel 8 example, orwhere and where in...

Laravel 8 Create Custom Helper Functions


Laravel 8 Create Custom Helper Functions In this tutorial we will see how to Create Custom Helper Functions in Laravel 8.

Laravel 9 Form Validation Example


In this Laravel 9 validation tutorial, I'll demonstrate how to validate form input and provide an error message before saving it to the database.