OOP with MySQL

OOP with MySQL — a practical guide to OOP MySQL PDO with clear examples you can reuse in real projects.

OOP Tutorial Series (58/65). Prefer one article? Read the complete OOP tutorial.

Short description

PDO is object-oriented and supports safe parameterized queries for MySQL.

PDO connection

$pdo = new PDO(
    'mysql:host=127.0.0.1;dbname=app;charset=utf8mb4',
    'root',
    '',
    [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]
);
$stmt = $pdo->prepare('SELECT * FROM users WHERE id = ?');
$stmt->execute([1]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);