Is it recommended to keep the database connection open throughout the entire website or just per request when using PDO in PHP?

It is recommended to open a new database connection per request when using PDO in PHP to ensure better resource management and avoid potential connection issues. Keeping the connection open throughout the entire website can lead to performance issues and potential security vulnerabilities. 

// Open a new database connection per request
$dsn = 'mysql:host=localhost;dbname=mydatabase';
$username = 'username';
$password = 'password';

try {
    $pdo = new PDO($dsn, $username, $password);
    // Perform database operations using $pdo
} catch (PDOException $e) {
    die('Connection failed: ' . $e->getMessage());
}

Keywords

database connection PDO PHP website per request

Related Questions