Stdlib: ext/pdo — PDO connect/query/fetch subset (ext/pdo parity)

[PurHur]

Category

stdlib

Problem

Database access via PDO, PDOStatement, and driver DSNs (pdo_mysql, pdo_sqlite, …) is absent. Framework bootstrap code and many examples assume new PDO($dsn, $user, $pass) with prepared statements.

php-src reference

• ext/pdo/pdo.c — php_pdo_register_driver, connection lifecycle
• ext/pdo/pdo_dbh.c — PDO methods (query, prepare, exec, …)
• ext/pdo/pdo_stmt.c — PDOStatement::fetch, fetchAll, bindValue
• ext/pdo_mysql/, ext/pdo_sqlite/ — drivers (phase 1: sqlite in-memory OK)

Repro (today)

<?php
$pdo = new PDO('sqlite::memory:');
$pdo->exec('CREATE TABLE t (id INTEGER PRIMARY KEY, v TEXT)');
$st = $pdo->prepare('INSERT INTO t (v) VALUES (?)');
$st->execute(['hello']);
foreach ($pdo->query('SELECT v FROM t') as $row) {
    echo $row['v'], "\n";
}

./script/docker-exec.sh -- bash -lc 'source script/php-env.sh && php bin/vm.php repro.php'
/usr/bin/php repro.php   # Zend: hello

This compiler: compile/runtime error — PDO class / extension missing.

Scope (this repo)

Module	Path
Extension	ext/pdo/ (new), optional ext/pdo_sqlite/
OOP classes	PDO, PDOStatement, PDOException in lib/VM/BuiltinClasses.php or ext
VM	Prepared statements + bound parameters (subset)
Tests	test/compliance/cases/stdlib/pdo_sqlite_memory.phpt

Done when

• Repro runs on VM with sqlite::memory: and prints hello
• PDO::ATTR_ERRMODE + exceptions on error (Zend default subset)
• Capability matrix lists PDO; mysql driver optional follow-up issue

Related

• Stdlib: ext/curl — curl_init/exec/getinfo and HTTP client API (ext/curl parity) #3325 — ext/curl (HTTP, not SQL)

[PurHur]

claim: worker-lane-b — starting this run

Pre-flight (master):

• bootstrap-inventory --check: OK 5253/5253 (later 5258+)
• release-readiness --json: user_release_ready: yes (north-star5-fast + vm-driver-probe OK)
• Continued Regression: settype($obj,'array') strips private property null-byte key mangling — re-#9963 (ext/standard/type.c) #10009 / PR Fix: settype() by-ref after new — clear leftover __construct label (#10009) #19798 — already merged on master; pivoting to Stdlib: ext/pdo — PDO connect/query/fetch subset (ext/pdo parity) #3367 (PDO sqlite::memory: subset)

Implementing ext/pdo VM surface: PDO / PDOStatement / PDOException for sqlite::memory: per done-when.

[PurHur]

Follow-up: ATTR_ERRMODE was throwing RuntimeException (not PDOException) after #19813 because the VM collapsed PDOException extends RuntimeException. Fixed in #19830 / #19831.