tagadvance/trapdoor

...

dev-master 2023-12-10 01:40 UTC

Requires

• php: ^8.1
• ext-pdo: *

Requires (Dev)

• ext-sqlite3: *
• phpunit/phpunit: ^10.5.2

MIT

• Tag

• pdo

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:dev-master"

{
    "require": {
        "tagadvance/trapdoor": "dev-master"
    }
}

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