php - In Laravel project, where do I put code which reads data from database tables, which would be common to multiple controllers?

Solution:

I am using class and call it asrepository to handle all my request through database

First i create an fileUserRepository

<?php

namespace App\Repositories;

use App\Model\User;

class UserRepository
{
    function getUsers(){
       Return User::get();    
    }
}
Copy code

Then in Controller, you just need to call therepository in the parent ofcontruct

<?php

namespace App\Http\Controllers;
use App\Repositories\UserRepository;

class UserController extends Controller
{
    protected $user;
    function __construct(){
        $this->user = new UserRepository();
    }

    function index(){
        $users = $this->user->getUser(); // getUser() is the function inside the repository class
        return view('user',compact('users'));
    }

}
Copy code

That's how I do code in laravel, because i dont want to callLaravel Model and do all the store, reads inside Controller and cause messy code

Solution:

Laravel has Eloquent ORM what presents Object Relation Mapping interface.

In Introduction:

The Eloquent ORM included with Laravel provides a beautiful, simple ActiveRecord implementation for working with your database. Each database table has a corresponding "Model" which is used to interact with that table. Models allow you to query for data in your tables, as well as insert new records into the table.

Basically, same as yourreadFromDb.php file but it handles with OOP so codebase is very understandable and expandable and strictly related with your code.

When querying with Eloquent you use Models. If your query result has single row you get single Model, if your result has multiple rows you get Eloquent\Collection result set contain your models.

Finally, you mustn't write ORM in Laravel because you already have.

If you think high level abstract accessors; you should explore design patterns. After that you can think to Repository Pattern, Decorator Pattern etc.