tagadvance / trapdoor

1.0.0 2026-09-05 21:12 UTC

Requires

• php: ^8.4
• ext-pdo: *

Requires (Dev)

• ext-pdo_sqlite: *
• friendsofphp/php-cs-fixer: ^3.95
• phpstan/phpstan: ^2.2
• phpunit/phpunit: ^13.3

MIT

• Tag

• logging
• database
• sql
• debug
• pdo
• prepared-statement

Published on Packagist.org on 2026-09-05 21:30 UTC

README

traPDOor

This library acts as an extension for PHP Data Objects (PDO). Basically, it makes prepared SQL queries accessible. This is useful for debug-level logging.

Download / Install

The easiest way to install traPDOor is via Composer:

composer require "tagadvance/trapdoor:^1.0"

{
    "require": {
        "tagadvance/trapdoor": "^1.0"
    }
}

Example

$pdo = new TraPDO($dsn);
$sql = 'SELECT * FROM foo WHERE a = ? AND b = ? AND c = ?';
$statement = $pdo->prepare($sql);
$statement->bindValue(1, 'one');
$statement->bindValue(2, 2);
$statement->bindValue(3, 'three');
$preparedQueryString = $statement->getPreparedQueryString();
$log->debug($preparedQueryString);

What's with the name?

wget -q -O - https://raw.githubusercontent.com/dwyl/english-words/master/words.txt | grep ".*p.*d.*o.*" | awk 'length($0) <= 8' | less

Sponsor

If you find this library useful, please consider sponsoring.