PHP 8.4の改善されたデータベース接続 – セキュリティとパフォーマンスを強化

$dsn = 'mysql:host=localhost;dbname=testdb';
$username = 'user';
$password = 'password';
$options = [
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8mb4",
];
try {
    $dbh = new PDO($dsn, $username, $password, $options);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

$dsn = 'mysql:host=localhost;dbname=testdb';
$options = [
    PDO::MYSQL_ATTR_SSL_CA     => '/path/to/ca-cert.pem',
    PDO::MYSQL_ATTR_SSL_CERT   => '/path/to/client-cert.pem',
    PDO::MYSQL_ATTR_SSL_KEY    => '/path/to/client-key.pem',
];
try {
    $dbh = new PDO($dsn, 'user', 'password', $options);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

$stmt = $dbh->prepare('SELECT * FROM users WHERE email = :email');
$stmt->bindParam(':email', $email);
$email = 'user@example.com';
$stmt->execute();

$db1 = new PDO('mysql:host=localhost;dbname=db1', 'user', 'password');
$db2 = new PDO('pgsql:host=localhost;dbname=db2', 'user', 'password');

$options = [
    PDO::ATTR_TIMEOUT => 5, // 5秒でタイムアウト
];
$dbh = new PDO($dsn, $username, $password, $options);

$dbh->beginTransaction();
$dbh->exec("INSERT INTO users (email, name) VALUES ('user@example.com', 'User')");
$dbh->commit();

try {
    $dbh->exec("SELECT * FROM non_existent_table");
} catch (PDOException $e) {
    echo 'Error: ' . $e->getMessage();
}