Use variables in Eloquent query / Laravel 5.2

Question

In my Laravel 5.2 controller, I'm executing a request with Eloquent ORM :

$products = Product::where('first_condition', 'first_condition_value')
                            ->where('second_condition', 'second_condition_value')
                            ->get();

This request works fine and gives me a list of the products that match the two conditions.

Ideally, I would like to generate a $request variable and use it in my request:

$request = "where('first_condition', 'first_condition_value')->where('second_condition', 'second_condition_value')"

I didn't manage to make this code run.

To give you more perspective, the request can have multiple conditions from 2 to n so I would like to generate it with a for loop.

Whiteulver · Accepted Answer · 2016-08-11 15:37:08Z

1

Wrap your extra conditions in an array and loop them as the following snippet:

<?php
$query = Product::where('first_condition', 'first_condition_value');

$conditions = array(
    'second_condition' => 'second_condition_value',
    'third_condition' => 'third_condition_value',
);

foreach ($conditions as $key => $value) {
    $query->where($key, $value);
}

$products = $query->get();

answered Aug 11, 2016 at 15:37

Whiteulver

8387 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Use variables in Eloquent query / Laravel 5.2

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