PDO

PHP Data Objects — a database abstraction layer providing a consistent interface for multiple database types with prepared statement support.

Syntax

php

new PDO(string $dsn, string $username, string $password)

Example

php

$pdo = new PDO("mysql:host=localhost;dbname=mydb", "user", "pass");
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$stmt = $pdo->prepare("SELECT * FROM users WHERE id = ?");
$stmt->execute([$userId]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);