What role does Dependency Injection play in resolving issues related to too many MySQLi connections in PHP?

When too many MySQLi connections are created in PHP, it can lead to performance issues and potential resource exhaustion. One way to resolve this is by implementing Dependency Injection, which allows for better management of database connections by injecting the connection object into classes that need it, rather than creating new connections each time. 

// Database connection class
class Database {
    private $connection;

    public function __construct($host, $username, $password, $database) {
        $this->connection = new mysqli($host, $username, $password, $database);
    }

    public function getConnection() {
        return $this->connection;
    }
}

// Example class using Dependency Injection
class UserRepository {
    private $db;

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

    public function getUsers() {
        $connection = $this->db->getConnection();
        // Perform database operations using $connection
    }
}

// Create a single instance of Database and inject it into classes
$database = new Database('localhost', 'username', 'password', 'database');
$userRepository = new UserRepository($database);

// Use UserRepository to perform database operations
$userRepository->getUsers();

Keywords

Dependency Injection MySQLi connections PHP resolving issues performance.

Related Questions