PHP IS SOOO GREAT

BUT_WAIT_THERE_IS_MORE.php

function getPDO(): \PDO
{
    return new \PDO("mysql:dbname=solidsnake_dev;host=db", "solidsnake_dev", "solidsnake_dev", [
        PDO::ATTR_PERSISTENT => true,
    ]);
}

$pdo = getPDO();

$pdo->exec('CREATE TEMPORARY TABLE temp_test (id INT NOT NULL PRIMARY KEY)');
$pdo->exec('INSERT INTO temp_test VALUES (1), (2)');

$pdo2 = getPDO();

try {
    // SAME CONNECTION IS REUSED WHILE STILL ACTIVE IN FIRST PDO!
    var_dump($pdo2->query('SELECT * FROM temp_test')->fetchAll(PDO::FETCH_ASSOC));
} catch (\Throwable $exception) {
    var_dump($exception->getMessage());
}

// prevent first connection from getting GC'ed
$pdo->exec('SELECT * FROM temp_test');

pdo_persistent_test.php

<?php

function getPDO(): \PDO
{
    return new \PDO("mysql:dbname=test;host=localhost", "test", "test", [
        PDO::ATTR_PERSISTENT => true,
    ]);
}

$pdo = getPDO();

$pdo->exec('CREATE TEMPORARY TABLE temp_test (id INT NOT NULL PRIMARY KEY)');
$pdo->exec('INSERT INTO temp_test VALUES (1), (2)');

$pdo = getPDO();

try {
    var_dump($pdo->query('SELECT * FROM temp_test')->fetchAll(PDO::FETCH_ASSOC));
} catch (\Throwable $exception) {
    var_dump($exception->getMessage());
}