decmuc/pdodb

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

Maintainers

Details

github.com/decMuc/PDOdb

Source

Issues

Installs: 43

Dependents: 0

Suggesters: 0

Security: 0

Stars: 5

Watchers: 1

Forks: 0

Open Issues: 0

v1.3.6 2025-08-15 00:12 UTC

Requires

  • php: >=8.1

MIT e0ca137c04622977e18a65bf683bc9a6c6ce75f1

databaseormpdowrappermysqlithingengineer

This package is auto-updated.

Last update: 2025-09-12 14:39:41 UTC

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