Programming Languages

PHP MySQL Connection (PDO)

Connect to MySQL using PDO with error handling

Basic PDO Connection

$dsn = "mysql:host=localhost;dbname=testdb"; # data source name
$username = "root"; # database user
$password = "password"; # database password
try { # error handling
    $pdo = new PDO($dsn, $username, $password); # create connection
} catch(PDOException $e) { # catch errors
    die("Connection failed: " . $e->getMessage()); # show error
}

PDO with Options

$options = [ # configuration array
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, # throw exceptions
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, # fetch as array
    PDO::ATTR_EMULATE_PREPARES => false # use real prepared statements
];
$pdo = new PDO($dsn, $user, $pass, $options); # connect with options

Close Connection

$pdo = null; # close PDO connection