Pdo V20 Extended Features

Using PDO::FETCH_INT and PDO::FETCH_FLOAT ensures type-safety:

Using PDO::ATTR_EMULATE_PREPARES wisely is old news. The real v20 feature is via proxies: pdo v20 extended features

// Direct server-side prepare (bypass emulation) $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); $pending = $handle-&gt

$pending = $handle->queryAsync('SELECT COUNT(*) FROM orders'); $result = $pending->wait(); // blocks until ready $count = $result->fetchColumn(); queryAsync('SELECT COUNT(*) FROM orders')

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); set_error_handler(function($errno, $errstr, $errfile, $errline, $errcontext) if (strpos($errstr, 'PDO') !== false) // Send to logging service

Simple, right? But in v20, execute() now demanded instead of bare arrays.