Laravel Sql multiple Where Condition

Question

      $items = property::orderBy('id', 'desc')
    ->whereProperty_categoryAndProperty_for_sale_or_rent('condo', 'rent')
    ->whereProperty_categoryAndProperty_for_sale_or_rent('apartment', 'rent')
    ->paginate('9');

Hello please help me about this multiple select category there and two category Condo and Apartment and type rent in laravel. Thank you in advance.

TsaiKoga · Accepted Answer · 2019-12-26 04:03:49Z

1

Your query code's condition is

WHERE
property_category = 'condo' 
AND property_for_sale_or_rent.rent = 'rent' 
AND property_category = 'apartment' 
AND property_for_sale_or_rent.rent = 'rent'

so it will return no records.

You need to use where closure to get that:

$items = property::orderBy('id', 'desc')
    ->whereProperty_for_sale_or_rent('rent')
    ->where(function($q) {
        $q->whereProperty_category('condo')
          ->orWhere('property_category', 'apartment');
    })
    ->paginate('9');

answered Dec 26, 2019 at 4:03

TsaiKoga

13.4k2 gold badges23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel Sql multiple Where Condition

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related