Laravel 5. Query from a existing model instance?

Question

Now I get some model with all properties filled except one.

So I want to make a search in a database and see if there is some registry that matches all the properties values, in which case, get the last property value and keep it.

Now im doing a query wit query builder, giving it all where like this:

$query->Model::select()->where(field, $instance->field);
$query->where(field2, $instance->field2);
...
$query->get();

But I want to know if there some way to make a shortcut like...

$instance->get();

Please have a look at the Eloquent documentation. Everything you need is there, including examples and common use cases. laravel.com/docs/5.2/eloquent — Dan H
– Dan H, Commented Apr 19, 2016 at 8:45

user6067756 · Accepted Answer · 2016-04-19 12:28:29Z

1

Yes you can do this by defining method in your model like this

class YourModel extends Model
{
  public function getFiltered()
  {
    return Model::where('field1',$this->field1)->where('field2',$this->field2)->get();
  }
}

And you can access it like this:

$instance->getFiltered();

You cannot keep function name 'get' because It's already being used in Model which is being extended. But you can change from getFiltered to anything which is not used. Like If the Model was User and the function getFiltered gives user's comments then It can be comments.

answered Apr 19, 2016 at 12:28

user6067756

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

3 Comments

Sampudon Over a year ago

Nice, sorry for taking to long to answer. Very clean, thats what i was looking for. Thank you :)

Sampudon Over a year ago

Done. Thank you again :)

user6067756 Over a year ago

@Sampudon No problem.

Collectives™ on Stack Overflow

Laravel 5. Query from a existing model instance?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related