PHPackages                             timefrontiers/php-sql-database - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. timefrontiers/php-sql-database

ActiveLibrary[Database & ORM](/categories/database)

timefrontiers/php-sql-database
==============================

PHP SQL Database manager supporting MySQLi and PDO with backward compatibility

v1.0.3(2mo ago)0274MITPHP >=8.1

Since Apr 14Compare

[ Source](https://github.com/timefrontiers/php-sql-database)[ Packagist](https://packagist.org/packages/timefrontiers/php-sql-database)[ Docs](https://github.com/timefrontiers/php-sql-database)[ RSS](/packages/timefrontiers-php-sql-database/feed)WikiDiscussions Synced 3w ago

READMEChangelog (4)Dependencies (1)Versions (5)Used By (4)

TimeFrontiers PHP SQL Database
==============================

[](#timefrontiers-php-sql-database)

A flexible SQL database manager supporting MySQLi (default) and PDO with a unified interface.

[![PHP Version](https://camo.githubusercontent.com/04744bae0a61d2ffe29c26f07a9612eae20445fc6feaeb77b3af1f0e9be6447c/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f7068702d253345253344382e312d3838393242462e737667)](https://php.net/)[![License](https://camo.githubusercontent.com/7013272bd27ece47364536a221edb554cd69683b68a46fc0ee96881174c4214c/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4d49542d626c75652e737667)](LICENSE)

Features
--------

[](#features)

- **Backward compatible** – drop-in replacement for the legacy `MySQLDatabase` class.
- **Dual backend support** – MySQLi (default) or PDO via factory pattern.
- **Prepared statements** – both `MySQLiDatabase` and `PDODatabase` support secure parameterized queries.
- **Unified API** – same method names across both drivers.
- **Error collection** – consistent with other TimeFrontiers packages.

Installation
------------

[](#installation)

```
composer require timefrontiers/php-sql-database
```

Requirements
------------

[](#requirements)

- PHP 8.1 or higher
- `ext-mysqli` (always required)
- `ext-pdo` + driver (optional, for PDO support)

Basic Usage
-----------

[](#basic-usage)

### Default: MySQLiDatabase

[](#default-mysqlidatabase)

```
use TimeFrontiers\SQLDatabase;

// This uses MySQLiDatabase internally (backward compatible)
$db = new SQLDatabase('localhost', 'root', 'secret', 'my_database');
```

### Using PDO Instead

[](#using-pdo-instead)

```
use TimeFrontiers\SQLDatabase;
use TimeFrontiers\PDODatabase;

// Pass the PDO class name as the fourth parameter
$db = new SQLDatabase('localhost', 'root', 'secret', PDODatabase::class, driver: 'mysql');
```

### Executing Queries (Legacy Style)

[](#executing-queries-legacy-style)

```
$result = $db->query("SELECT * FROM users WHERE id = 1");
while ($row = $db->fetchAssocArray($result)) {
  // ...
}
```

### Using Prepared Statements (Recommended)

[](#using-prepared-statements-recommended)

```
// Fetch all rows
$users = $db->fetchAll("SELECT * FROM users WHERE status = ?", ['active']);

// Fetch single row
$user = $db->fetchOne("SELECT * FROM users WHERE id = ?", [5]);

// Execute INSERT/UPDATE
$db->execute("UPDATE users SET name = ? WHERE id = ?", ['John', 5]);
$newId = $db->insertId();
```

License
-------

[](#license)

MIT License. See [LICENSE](LICENSE) for details.

```

```

###  Health Score

38

—

LowBetter than 83% of packages

Maintenance83

Actively maintained with recent releases

Popularity7

Limited adoption so far

Community8

Small or concentrated contributor base

Maturity46

Maturing project, gaining track record

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~4 days

Total

4

Last Release

87d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/dfcd9a5645cb2deb0771b9102be193d63b495564b1e06c0b85cb31bf028d0887?d=identicon)[ikechukwuokalia](/maintainers/ikechukwuokalia)

---

Tags

phpdatabasemysqlsqlpdomysqli

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/timefrontiers-php-sql-database/health.svg)

```
[![Health](https://phpackages.com/badges/timefrontiers-php-sql-database/health.svg)](https://phpackages.com/packages/timefrontiers-php-sql-database)
```

###  Alternatives

[ifsnop/mysqldump-php

PHP version of mysqldump cli that comes with MySQL

1.3k6.0M79](/packages/ifsnop-mysqldump-php)[clouddueling/mysqldump-php

PHP version of mysqldump cli that comes with MySQL

1.3k23.2k](/packages/clouddueling-mysqldump-php)[ezsql/ezsql

Advance database access library. Make interacting with a database ridiculously easy. An universal interchangeable CRUD system.

86749.2k](/packages/ezsql-ezsql)[jv2222/ezsql

Advance database access library. Make interacting with a database ridiculously easy. An universal interchangeable CRUD system.

86711.6k2](/packages/jv2222-ezsql)[druidfi/mysqldump-php

PHP version of mysqldump cli that comes with MySQL

35612.8k8](/packages/druidfi-mysqldump-php)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)