pauls page

PHP PDO Cheat Sheet

August 17, 2019

A quick and dirty example for PHP with MySQL PDO.

// db details
$db_HOST = 'localhost';
$db_USER = 'myusername';
$db_PASS = 'mypassword';
$db_NAME = 'databasename';
$db_CHR = 'utf8mb4';
$db_DSN = "mysql:host=$db_HOST;dbname=$db_NAME;charset=$db_CHR";
$pdoOPT = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false ];

// connect
try { $pdo = new PDO($db_DSN, $db_USER, $db_PASS, $pdoOPT); }
catch (\PDOException $e) { throw new \PDOException($e->getMessage(),(int)$e->getCode()); }

// query
$stmt = $pdo->query('SELECT * FROM table');

// push query result into array 
$result = array();
while ($row = $stmt->fetch()) { array_push($result, $row); }

// step through results 
foreach ($result as $col) { 
  print("Name: ".$col['name']);
  print("Score: ".$col['score']);
}