# PHP Laravel Multiple Where Condition using Eloquent

Today, We want to share with you PHP Laravel Multiple Where Condition using Eloquent.In this post we will show you where condition in laravel controller, hear for Laravel collection multiple where conditions we will give you demo and example for implement.In this post, we will learn about How to use multiple OR,AND condition in Laravel queries with an example.

## PHP Laravel Multiple Where Condition using Eloquent

There are the Following The simple About Laravel eloquent multiple WHERE with OR AND OR and LIKE Full Information With Example and source code.

Laravel reusable functions with Example

As I will cover this Post with live Working example to develop How to use multiple OR,AND condition in Laravel queries, so the How to Create Multiple Where Clause Query Using Laravel Eloquent? is used for this example is following below.

### laravel two where conditions

Simple Laravel Syntax

```->where('YOUR_COLUMN_NAME', 'OPERATOR', 'VALUE')
->where('YOUR_COLUMN_NAME', 'OPERATOR', 'VALUE')
```

using an Array Multiple Value

```->where([
['YOUR_COLUMN_NAME', 'OPERATOR', 'VALUE'],
['YOUR_COLUMN_NAME', 'OPERATOR', 'VALUE']
]);
```

using MySQL Query

```SELECT * FROM `products` WHERE is_bundle = 1 AND is_sell = 0
```

### Example 1:

laravel eloquent multiple where conditions

```public function index()
{
\$products = Product::select('*')
->where('is_bundle', '=', 1)
->where('is_sell', '=', 0)
->get();

dd(\$products);
}
```

### Example 2:

laravel query builder multiple where conditions

```public function index()
{
\$products = Product::select('*')
->where([
['is_bundle', '=', 1],
['is_sell', '=', 0]
])
->get();
dd(\$products);
}
```

### Laravel 6 – inner join with multiple conditions example using Query Builder

```\$product = Product::select("products.*","menus.id as itemId","categories.id as catId")
->join("categories",function(\$join){
\$join->on("categories.product_id","=","products.id")
})
->get();
print_r(\$product);
```

##### Web Programming Tutorials Example with Demo

Laravel Eloquent Multiple WHERE clauses

### Summary
{"ft_lang_label":"__label__en","ft_lang_prob":0.7104036,"math_prob":0.87196654,"size":2324,"snap":"2019-51-2020-05","text_gpt3_token_len":533,"char_repetition_ratio":0.14956896,"word_repetition_ratio":0.077922076,"special_character_ratio":0.260327,"punctuation_ratio":0.18676123,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.96025896,"pos_list":[0,1,2],"im_url_duplicate_count":[null,null,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2020-01-24T11:59:56Z\",\"WARC-Record-ID\":\"<urn:uuid:cf17e067-3446-4aae-b2f1-4351423dc9e6>\",\"Content-Length\":\"130567\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:146a5b7e-c1d1-4c36-9517-d233ab5403d0>\",\"WARC-Concurrent-To\":\"<urn:uuid:0db9f00b-dbbc-4f40-898f-7aeb84c4b435>\",\"WARC-IP-Address\":\"104.28.17.33\",\"WARC-Target-URI\":\"https://www.pakainfo.com/php-laravel-multiple-where-condition-using-eloquent/\",\"WARC-Payload-Digest\":\"sha1:UTF3AQAT3XFOH52RSZMK3UI6MPCAENY6\",\"WARC-Block-Digest\":\"sha1:V25NWH7ZNBWYOH7BEYGYDFSASZYVFQUI\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2020/CC-MAIN-2020-05/CC-MAIN-2020-05_segments_1579250619323.41_warc_CC-MAIN-20200124100832-20200124125832-00331.warc.gz\"}"}