decmuc/pdodb

Modern, secure and fully compatible PDO-based replacement for ThingEngineer’s PHP-MySQLi-Database-Class

v1.3.9 2025-11-21 03:35 UTC

Requires

• php: >=8.1

MIT

• decmuc

• database
• orm
• pdo
• wrapper
• mysqli
• thingengineer

README

PDOdb is a modern database wrapper and SQL builder for PHP 8+, built on top of PDO.
It offers full support for secure query building, prepared statements, dynamic joins, subqueries, transactions, and strict validation.

🔒 Safe by default.
⚙️ Fast, clean, extendable.
📘 Documentation:
👉 https://DocsPDOdb.decmuc.dev/

Features

• Intuitive query builder (get(), insert(), update(), delete())
• Smart where*() methods with type validation
• Nested queries, joins, subqueries, aliases
• Safe ORDER/GROUP clause parsing with heuristics
• Locking, transactions, pagination, bulk insert
• Inspired by ThingEngineer/MySQLiDB, but built for PDO with a similar API and strict SQL injection protection.

Installation

composer require decmuc/pdodb

Quick Example

Two lines for 90% of queries. MySQL-first, prepared by default—no manual prepare() or binding.

$db->whereInt('id', 42);
$user = $db->getOne('users');

// Booleans made easy
$db->whereBool('status', true);
$users = $db->get('users');
// In short:
$users = $db->whereBool('status', true)->get('users');
// whereBool('status', 1) + get('users') is equivalent to
// SELECT * FROM users WHERE status = 1.
// false → 0 (or FALSE)
$users = $db->whereBool('status', false)->get('users');
// SELECT * FROM `users` WHERE `status` = 0

// Chaining with other conditions
$users = $db->whereBool('is_active', true)
   ->where('role', 'admin')
   ->orderBy('created_at', 'DESC')
   ->get('users');

For comprehensive documentation and more examples, visit the PDOdb docs: https://DocsPDOdb.decmuc.dev

📝 License / Lizenz

This project is licensed under the MIT License. See LICENSE for details