Laravel - Query building in controller or model? For large web apps

Question

Quick question, i am studying Laravel 4 as i am coming from Codeigniter, i noticed that some laravel tutorials have their queries in the controller and some have their queries in the model.

My question is, where should we write all of our queries for best practice? In the controller or the model? This is regarding to large web applications.

Many thanks

Eelke van den Bos · Accepted Answer · 2014-02-25 02:13:39Z

2

Best practice is to write your queries in a separate layer. So separate from your controller, and separate from your model. Controller best practice also depends on the scale of your project and your specific demand for maintainability.

As soon as you scale up the project, try to extract more so maintainability is less of an issue. A layer in between for queries scoped around the User model can look something like:

class UserRepository {

    public function __construct(Illuminate\Database\DatabaseManager $db)
    {
        $this->db = $db;
    }

    public function getLatestUsers($limit = 5) {
        //$this->db->table('users')->
    }

}

For more best practices, you should take a look at all the resources that are being created around laravel. Like

answered Feb 25, 2014 at 2:13

Eelke van den Bos

1,4631 gold badge13 silver badges19 bronze badges

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

1 Comment

jonprasetyo Over a year ago

Hmm, I have never seen that method before. Say if I do create the UserRepository class, where would I store it?

Collectives™ on Stack Overflow

Laravel - Query building in controller or model? For large web apps

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related