This is an update to a note I wrote earlier concerning how to set multiple attributes when you create you PDO connection string.
You can put all the attributes you want in an associative array and pass that array as the fourth parameter in your connection string. So it goes like this:
<?php
$options = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_CASE => PDO::CASE_NATURAL,
PDO::ATTR_ORACLE_NULLS => PDO::NULL_EMPTY_STRING
];
try {
$connection = new PDO("mysql:host=$host; dbname=$dbname", $user, $password, $options);
} catch(PDOException $e) {
die("Database connection failed: " . $e->getMessage());
}
?>