{source}
<?php
$uri = "mysql://avnadmin:This email address is being protected from spambots. You need JavaScript enabled to view it. :26203/defaultdb?ssl-mode=REQUIRED";
$fields = parse_url($uri);
// build the DSN including SSL settings
$conn = "mysql:";
$conn .= "host=" . $fields["host"];
$conn .= ";port=" . $fields["port"];;
$conn .= ";dbname=defaultdb";
$conn .= ";sslmode=verify-ca;sslrootcert=ca.pem";
try {
$db = new PDO($conn, $fields["user"], $fields["pass"]);
$stmt = $db->query("SELECT VERSION()");
print($stmt->fetch()[0]);
} catch (Exception $e) {
echo "Error: " . $e->getMessage();
}
?>
{/source}
