PHP PDO Prepared Statement Generator

Type a table name and its columns, and get copy-paste PHP PDO code with placeholders, so user input never touches your SQL string. Everything runs in your browser; nothing is sent anywhere.

Table name

Primary key column

Columns (comma separated, excluding the primary key)

Placeholder style

Database

Notes

Table and column names cannot be placeholders. The generator only accepts letters, digits and underscores, and wraps names in backticks (MySQL) or double quotes (PostgreSQL/SQLite).
Set PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION on your connection (the default since PHP 8.0).
Guides: prepared statements, insert and lastInsertId(), transactions, full PDO tutorial.