PHP Classes

File: examples/Pool/pool_example.php

Recommend this page to a friend!
  Classes of Carlos Artur Curvelo da Matos   Desired Patterns   examples/Pool/pool_example.php   Download  
File: examples/Pool/pool_example.php
Role: Example script
Content type: text/plain
Description: Example script
Class: Desired Patterns
Implements of several modern design patterns
Author: By
Last change:
Date: 10 days ago
Size: 942 bytes
 

Contents

Class file image Download
<?php

require_once __DIR__ . '/../../vendor/autoload.php';

use DesiredPatterns\Examples\Pool\DatabaseService;

// Create a database service with connection pooling
$dbService = new DatabaseService(
    dsn: 'mysql:host=localhost;dbname=test',
    username: 'root',
    password: 'password',
    minConnections: 2,
    maxConnections: 5
);

// Execute some queries
try {
    // First query
    $results1 = $dbService->executeQuery('SELECT * FROM users WHERE id = ?', [1]);
    echo "Query 1 results: " . json_encode($results1) . "\n";
   
    // Second query
    $results2 = $dbService->executeQuery('SELECT * FROM users WHERE active = ?', [true]);
    echo "Query 2 results: " . json_encode($results2) . "\n";
   
    // Get pool statistics
    $stats = $dbService->getPoolStats();
    echo "Pool statistics: " . json_encode($stats, JSON_PRETTY_PRINT) . "\n";
   
} catch (Exception $e) {
    echo "Error: " . $e->getMessage() . "\n";
}