Laravel orm database query inside model function

Question

I am new in Laravel. I want to make some custom functions in models which is related to database query.

Class A Extends Controller{
  public function view(){
    B::get_user();
  }
}

Class B Extends Model{
  protected $table = "user";

  public function get_user(){
    //Here is my database query
  }
}

How can I use database query in get_user() function? I know this method:

B::table('user')->get();

Amit Gupta · Accepted Answer · 2016-12-25 06:39:40Z

5

You can define query scopes for adding the query on the model as:

public function scopeUser($query)
{
    return $query->where('some_field', 'some_value');
}

Then you can use it in you controller as:

B::user()->get();

Docs

answered Dec 25, 2016 at 6:39

Amit Gupta

17.7k5 gold badges46 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

Laravel orm database query inside model function

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