query database using variable in eloquent

Question

I am trying to query for records using eloquent.

this works fine:

    $xs = X::all()->where('y_id', 1);
    return view('x', compact('xs'));

but when i try to pass a variable:

    $xs = X::all()->where('y_id', $id);
    return view('x', compact('xs'));

it returns empty array!

how can I do this query?

Shyam Achuthan · Accepted Answer · 2016-03-02 06:02:44Z

1

The query should be

 $xs = X::where('y_id', $id)->get();

all() returns all the records without any condition if you use a condition do a get() after all conditions queries

answered Mar 2, 2016 at 6:02

Shyam Achuthan

9506 silver badges8 bronze badges

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

1 Answer 1