Initializing a class within a static class php

Question

I have a class responsible for connecting to the database and it returns the connection itself in the construction method

How can I use it inside a static class?

Database.php

<?php


class Database {

    private $host = "localhost";
    private $usuario = "root";
    private $senha = "";

    protected $connection;

    public function __construct()
    {
        if(!isset($this->connection))
        {
            $this->connection = new mysqli($this->host, $this->usuario, $this->senha, "netflix_cards", 3308);
            mysqli_set_charset($this->connection, "utf8");
            if(!$this->connection) {
                echo 'Não foi possível conectar ao banco de dados';
                exit;
            }

            return $this->connection;
        }
    }

    public function query($query)
    {
        return $this->connection->query($this->connection->real_escape_string($query));
    }
?>

User.php

<?php


class User {

    static function register() {
        
    }
}

Your `query` method is completely wrong. You need to check how to execute queries with mysqli. See https://stackoverflow.com/questions/7537377/how-to-include-a-php-variable-inside-a-mysql-statement — Dharman, Jul 09 '20 at 22:38
You should read this too: https://phpdelusions.net/mysqli/mysqli_connect — Dharman, Jul 09 '20 at 22:55

score 0 · Answer 1 · answered Jul 09 '20 at 22:48

Best practice is to avoid purely static class and the singleton pattern (see answer here : PHP singleton database connection pattern

You should instantiate User with new, and dependancy-inject an instantiated database connection that you pass around as a parameter where needed.

As someone noted, you should first make your Database work properly.

Initializing a class within a static class php

1 Answers1