PHPackages                             sethadam1/pdofish2 - 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. sethadam1/pdofish2

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

sethadam1/pdofish2
==================

A flexible, lightweight PDO wrapper for PHP inspired by Active Record

00

Since May 20Compare

[ Source](https://github.com/sethadam1/PdoFish2)[ Packagist](https://packagist.org/packages/sethadam1/pdofish2)[ RSS](/packages/sethadam1-pdofish2/feed)WikiDiscussions Synced 3w ago

READMEChangelogDependenciesVersions (1)Used By (0)

PdoFish2
========

[](#pdofish2)

A wrapper for PHP and PDO.

Purpose
-------

[](#purpose)

PdoFish2 is an Active Record-inspired query interface built on top of PDO. This is *not* a PHP implementation of Active Record, but rather, a class that mimics its best parts while keeping the amount of code needed to use PDO to a minimum.

This project is not for everyone; however, if you're already familiar with Active Record or wish to use an Active Record style DB interface in PHP, this may suit. The aim of this project was simple: readable code that is as thin a layer on top of PDO as possible.

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

[](#installation)

**Via Composer:**

```
composer require sethadam1/PdoFish2
```

**Manually:**

- Upload the files to your web server.
- Include `PdoFish2.php` in your code.
- Instantiate the class as seen below.

```
require_once '/path/to/PdoFish2/src/PdoFish2.php';

// Pass credentials directly, or set DB_HOST, DB_NAME, DB_USER, DB_PASSWORD
// environment variables and call with no arguments (see Instantiating below).
$pf2 = new PdoFish2(['host' => 'localhost', 'database' => 'mydb', 'username' => 'dbuser', 'password' => 'secret']);
```

#### Using environment variables

[](#using-environment-variables)

These two calls are functionally equivalent:

```
$pf2 = new PdoFish2();

$pf2 = new PdoFish2([
    'host'     => $_ENV['DB_HOST'],
    'database' => $_ENV['DB_NAME'],
    'username' => $_ENV['DB_USER'],
    'password' => $_ENV['DB_PASSWORD'],
]);
```

Currently Supported Methods
---------------------------

[](#currently-supported-methods)

`$object->set_table(tbl_name)` - a chainable function to specify a table
`$object->t(tbl_name)` - a shortcut for `set_table`
`$object->raw($sql)` - execute raw SQL
`$object->find($id)` - find by a column called "id"
`$object->all($args)` - return all rows matching a query
`$object->first($args)` - returns the first row matching a query
`$object->conditions($conditions)` - shorthand for `all()` with a conditions array
`$object->find_by_sql($sql)` - returns a single row matching a query
`$object->find_all_by_sql($sql)` - returns all rows matching a query
`$object->find_by_column($col, $val)` - find a single row by a specific column value
`$object->find_by_slug($val)` - shorthand for `find_by_column('slug', $val)`
`$object->find_by_ref($val)` - shorthand for `find_by_column('ref', $val)`
`$object->count($args)` - return matching row count
`$object->insert($data)` - insert a record; returns the last insert ID
`$object->update($data, $where)` - update field(s)
`$object->delete($where)` - delete rows matching criteria
`$object->delete_by_id($id)` - delete by a column called "id"
`$object->delete_by_column($col, $val)` - delete by any column
`$object->delete_many($column, $vals)` - delete multiple rows matching a list of values (uses the IN keyword)

#### Dynamic function names

[](#dynamic-function-names)

`$object->find_by_[field]($val)` - find a single row by a specific column value
`$object->find_all_by_[field]($val)` - find multiple rows where one column matches the given value

Basic CRUD
----------

[](#basic-crud)

##### For the purposes of these examples, we'll assume you'll assign PdoFish2 to the variable $pf2.

[](#for-the-purposes-of-these-examples-well-assume-youll-assign-pdofish2-to-the-variable-pf2)

#### Instantiating

[](#instantiating)

PdoFish2 accepts credentials either as a constructor argument or from environment variables. If no argument is passed, it automatically reads `DB_HOST`, `DB_NAME`, `DB_USER`, and `DB_PASSWORD` from your environment (e.g. via `.env` + a loader, server config, or shell exports).

```
// Option 1: pass credentials directly
$pf2 = new PdoFish2([
    'host'     => 'localhost',
    'database' => 'mydb',
    'username' => 'dbuser',
    'password' => 'secret',
]);

// Option 2: rely on environment variables — no argument needed
// Requires DB_HOST, DB_NAME, DB_USER, and DB_PASSWORD to be set in $_ENV
$pf2 = new PdoFish2();
```

#### Create

[](#create)

```
$data = [
    'col1' => '2020-08-27 09:58:01',
    'col2' => 'a string',
    'col3' => 12345
];
$id = $pf2->t('products')->insert($data);

echo $id;
// example response "3"
```

#### Read

[](#read)

```
// print an object
$x = $pf2->t('users')->first([ 'conditions' => ['some_field=?', 'some_value'] ]);
print_r($x);
```

```
// print an associative array
$x = $pf2->first(['from' => 'table_name', 'conditions' => ['some_field=?', 'some_value']], PDO::FETCH_ASSOC);
print_r($x);
```

```
// print a single row matching a SQL query
$x = $pf2->find_by_sql('select * from random_table where random_field=12');
print_r($x);
```

```
// print a row where id = 5
$x = $pf2->t('table')->find(5);
print_r($x);
```

```
// print 5 rows from a complex query
$x = $pf2->all([
    'select'     => 'field1, field2, field3',
    'from'       => 'table t',
    'joins'      => 'LEFT JOIN table2 t2 ON t.field1=t2.other_field',
    'conditions' => ['some_field=?', $some_value],
    'order'      => 'field3 ASC',
    'limit'      => 5
]);
print_r($x);
```

#### Update

[](#update)

```
// updates column "firstname" to "Boris" where id = 5
$pf2->t('table_name')->update(['firstname' => 'Boris'], ['id' => 5]);

// updates multiple columns where id = 5
$pf2->t('table_name')->update(['firstname' => 'June', 'lastname' => 'Basoon'], ['id' => 5]);
```

#### Delete

[](#delete)

```
// delete rows where column "firstname" is equal to "Boris"
$pf2->t('table_name')->delete(['firstname' => 'Boris']);

// delete row where column "id" is equal to 5
$pf2->t('table_name')->delete_by_id(5);

// delete rows where column "user_id" is equal to 1, 2, or 3
$pf2->t('table_name')->delete_many('user_id', [1, 2, 3]);
```

Arguments supported
-------------------

[](#arguments-supported)

The following arguments are supported in the PdoFish queries:
`select` - columns to select
`from` - table, or table and an alias *e.g. "prices p"*
`joins` - a string of joins in SQL syntax, *e.g. LEFT JOIN table2 on prices.field=table2.field*
`conditions` - an array of SQL with ? placeholders and bound arguments *e.g. \['year=? AND mood=?', 2021, 'happy'\]*
`group` - group by field name
`having` - having clause *e.g. 'count(x)>3'*
`order` - order by *e.g. 'id DESC'*
`offset` - row offset (integer)
`limit` - a positive integer greater than 0

Credits
-------

[](#credits)

This project draws inspiration from [David Carr](https://twitter.com/dcblogdev)'s [PDOWrapper](https://dcblog.dev/docs/pdo-wrapper).

###  Health Score

9

—

LowBetter than 0% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity0

Limited adoption so far

Community2

Small or concentrated contributor base

Maturity11

Early-stage or recently created project

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.

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/66285?v=4)[Adam Sch](/maintainers/sethadam1)[@sethadam1](https://github.com/sethadam1)

### Embed Badge

![Health badge](/badges/sethadam1-pdofish2/health.svg)

```
[![Health](https://phpackages.com/badges/sethadam1-pdofish2/health.svg)](https://phpackages.com/packages/sethadam1-pdofish2)
```

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k117.2M118](/packages/jdorn-sql-formatter)[propel/propel1

Propel is an open-source Object-Relational Mapping (ORM) for PHP5.

8351.6M87](/packages/propel-propel1)[jfelder/oracledb

Oracle DB driver for Laravel

11518.4k](/packages/jfelder-oracledb)

PHPackages © 2026

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