How to call Moldel in My Controller?

1

My Project:
App
|-----Controllers
|-----Controllers/Controler.php
|-----Controllers/Admin\HomeControler.php
|-----Models
|-----Models\User.php

App.php

   $container['db'] = function ($container) {
    return new App\Helpers\Database($container['settings']['db']);
};

Controller.php

namespace App\Controllers;

use Interop\Container\ContainerInterface;

class Controller
{
    protected $container;

    public function __construct(ContainerInterface $container)
    {
        $this->container = $container;

    }

    public function __get($property)
    {
        if ($this->container->{$property}) {
            return $this->container->{$property};
        }
    }
}

HomeController.php

namespace App\Controllers\Admin;    
use App\Models\User    
    Class HomeController extends Controller

       public function index($request, $response, $agr)
        {
        // How to call Model here ? How do I have must to code Model ?
        //Exp:  $user = User::getUsername($agr['id']);
      }

router.php

$this->get('', '\App\Controllers\Admin\HomeCtroller:index')->setName('home');

Final, my question at comment in HomeCtroller: How to call User Model or other Model enywhere ?

2

With the exception of things like a spelling error in your route (HomeController), missing a semicolon after you import your User model, missing class braces, etc, your example line looks plausible for the rest of your code.

Are you getting an error, and if so what does the error say?

3

Do you use Eloquent?
You can have a look at : https://github.com/akrabat/slim-bookshelf/blob/master/app/src/Bookshelf/AuthorController.php#L33

4

i’m Just use PDO.

Model.php

namespace App\Models;
Abstract  class Model{

    protected $db;
    public function __construct($db)
    {
        $this->db = $db;
    }

}

Models/User.php

namespace App\Models;
class User extends Model
{
    public  function attempt($file='')
    {
        $this->db->query('SELECT email FROM '. $this->db->table('users'). ' WHERE email = :email');
        $this->db->bind(':email', $file);
        $email = $this->db->getOne();
        return $email;
    }
}

at HomeCtroller.php

use App\Models\User;

$user =  new User($this->db);
$email = $user->attempt('myemail@domain.com');

But i want:

$email = User::attempt('myemail@domain.com');

So, i’ll to code Model Class, How ?

5

Why are you injection your DB connection into the model?
I suggest you to use the User Cconstructor for create new Users.
Use a UserRepository intead!

PdoUserRepository implments UserRepositoryInterface
{
       private $pdo;

       public function __construnct(\PDO $pdo)
        {
             $this->pdo = $pdo;
        }


        public function getUserByUsername(string $username) : User // Return a User Object and do not couple it to the database :)
}