Download the PHP package frootbox/db without Composer

Frootbox Db

Frootbox Db is a small PHP database abstraction and Active Record layer for MySQL. It wraps PDO, provides a lightweight query builder, maps result rows to row objects, and offers a migration path from dynamic Active Record accessors to explicit getter and setter methods.

The package is intentionally compact. It is useful when you want simple models and rows without adopting a full ORM.

Installation

Install the package with Composer:

Requirements:

• PHP 8.0 or newer
• ext-pdo
• MySQL or MariaDB when using the bundled MySQL adapter

Creating A Connection

Create a DBMS adapter and wrap it in Frootbox\Db\Db:

Db exposes low-level methods such as query(), prepare(), fetch(), update(), delete(), and transaction helpers.

Rows

A row represents one database record. Extend Frootbox\Db\Row for your entities:

Rows store their raw database values internally and track changed attributes. Call save() to persist changed values and delete() to remove the record.

Legacy Dynamic Accessors

Older projects can still call accessors that are not explicitly defined:

These calls are handled by Row::__call() for backward compatibility. New code should add explicit methods that delegate to getAttribute() and setAttribute(). Deprecated dynamic calls are logged once per call site by default.

Disable that logging when needed:

Models

A model acts as a repository for one table:

Fetch rows:

Fetch one row:

Insert a row:

insert() is still available as a deprecated alias for persist().

Conditions

Condition objects can be used in where arrays for comparisons beyond equality:

Available conditions include:

• Equal
• NotEqual
• Greater
• GreaterOrEqual
• Less
• LessOrEqual
• Like
• IsNull
• IsNotNull
• InArray
• NotInArray
• MatchColumn

Results

Frootbox\Db\Result is an iterator, Countable, and JsonSerializable. It lazily converts raw database records into row objects while iterating.

Useful helpers:

Nested Sets

The package includes optional nested-set base classes:

• Frootbox\Db\Rows\NestedSet
• Frootbox\Db\Models\NestedSet

They provide helpers such as appendChild(), getChildren(), getParent(), getTrace(), getSiblings(), and rewriteIds().

Generating Explicit Accessors

The package ships a Composer binary:

Generate missing getter and setter methods for existing row classes:

When the command is run from a project root containing localconfig.php, it automatically reads the database connection from:

Use a custom config path when needed:

Alternatively, a bootstrap file can return a Frootbox\Db\Db instance, or an array with a db key:

You can also pass connection details directly:

Preview changes without writing files:

The generator scans concrete classes extending Frootbox\Db\Row, reads their protected $table value, loads columns from INFORMATION_SCHEMA.COLUMNS, and adds missing methods. Existing methods are not overwritten.

Transactions

Use transactionStart() and transactionCommit() around multi-step changes:

Call rollback() if a transaction should be reverted.

Error Handling

Model::persist() maps common MySQL integrity errors to package exceptions:

• UniqueConstraintViolationException
• ForeignKeyViolationException
• ConstraintViolationException

All extend Frootbox\Db\Exception\DatabaseException.

License

This package is licensed under the GPL-3.0-or-later license.