<?php
function pdoConnect(string $host, string $db, string $user, string $pass): PDO {
return new PDO(
"mysql:host=$host;dbname=$db;charset=utf8mb4",
$user,
$pass,
[
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, // throw on errors
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, // assoc arrays
PDO::ATTR_EMULATE_PREPARES => false, // real prepares
PDO::ATTR_STRINGIFY_FETCHES => false, // keep int/float types
]
);
}
$db = pdoConnect('localhost', 'myapp', 'user', 'secret');
$rows = $db->query('SELECT id, name FROM users')->fetchAll();
Create a free account and build your private vault. Share publicly whenever you want.