How to Add Multiple Where Clauses Using Laravel Eloquent?

How to Add Multiple Where Clauses Using Laravel Eloquent?

Written by Bobby Iliev on Dec 13th, 2020 ・ Views ・ Report Post

Bobby Iliev Visit User Profile

Introduction

The Eloquent ORM included with Laravel provides you with an easy way of interacting with your database. This simplifies all CRUD (Create, read, update, and delete) operations and any other database queries.

In this tutorial, you will learn how to add multiple where clauses using Laravel Eloquent!

Prerequisites

Before you start, you would need to have a Laravel application up and running.

I will be using a DigitalOcean Ubuntu Droplet for this demo. If you wish, you can use my affiliate code to get free $100 DigitalOcean credit to spin up your own servers!

If you do not have that yet, you can follow the steps from this tutorial on how to do that:

Or you could use this awesome script to do the installation:

Chaining multiple where clauses together

Generally speaking, you could chain multiple where methods together like this:

        $posts = Post::where('status', 'published')
                        ->where('featured', '')
                        ->where('author_id', 1)
                        ->toSql();
        dd($posts);

The output of the above to pure SQL with the toSql method would look like this:

"select * from `posts` where `status` = ? and `featured` = ? and `author_id` = ?"

So the first where method is translated to an actual where in SQL, and then each where clause is translated to an AND in SQL.

🤩 Our Amazing Sponsors 👇
DigitalOcean View Website
DigitalOcean offers a simple and reliable cloud hosting solution that enables developers to get their website or application up and running quickly.
Laravel News View Website
Laravel News keeps you up to date with everything Laravel. Everything from framework news to new community packages, Laravel tutorials, and more.
Genesis View Website
A Laravel Starter Kit that includes Authentication, User Dashboard, Edit Profile, and a set of UI Components.

Passning an array to the where method

An alternative to the above would be to pass an array with your specific rules. This would look like this:

        $posts = Post::where(['status' => 'published',
                            'featured' => '',
                            'author_id' => 1,
                            ])
                        ->toSql();
        dd($posts);

Output:

"select * from `posts` where (`status` = ? and `featured` = ? and `author_id` = ?)"

In case that you needed to give different rules rather than the default equals to, you could use the following syntax:

$posts = Post::where([
                    ['status', '=', 'published'],
                    ['featured', '!=', 'no'],
                    ['author_id', '>', 0],
                    ])
                ->toSql();
dd($posts);

The raw SQL for the above would look like this:

"select * from `posts` where (`status` = ? and `featured` != ? and `author_id` > ?)"

Using orWhere Clauses

In case you want your clauses to be joined with OR rather than AND, you could use the orWhere method:

$posts = Post::where('status', 'published')
                ->orWhere('featured', '')
                ->orWhere('author_id', 1)
                ->toSql();
dd($posts);

Output:

"select * from `posts` where `status` = ? or `featured` = ? or `author_id` = ?"

Conclusion

For more information and useful tips on Laravel Eloquent, make sure to check this tutorial here:

I strongly suggest checking out the official Laravel Documentation:

Comments (0)