What are best practices for organizing database connection code in PHP to avoid conflicts between multiple connections?

When working with multiple database connections in PHP, it's important to organize your connection code properly to avoid conflicts. One way to do this is by encapsulating each connection within a separate class or function, ensuring that each connection is isolated and doesn't interfere with others. By structuring your code in this way, you can easily manage and maintain multiple database connections without running into conflicts. 

class DatabaseConnection {
    private $connection;

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

        if ($this->connection->connect_error) {
            die("Connection failed: " . $this->connection->connect_error);
        }
    }

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

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

// Example usage
$connection1 = new DatabaseConnection('localhost', 'user1', 'password1', 'database1');
$connection2 = new DatabaseConnection('localhost', 'user2', 'password2', 'database2');

$result1 = $connection1->query('SELECT * FROM table1');
$result2 = $connection2->query('SELECT * FROM table2');

$connection1->close();
$connection2->close();

Keywords

PHP database connection organization conflicts multiple connections

Related Questions