PHPackages                             llwebsol/easy-db - 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. llwebsol/easy-db

ActiveLibrary

llwebsol/easy-db
================

A Wrapper for PDO

v1.0.6(7y ago)02031MITPHP

Since Feb 28Pushed 7y ago3 watchersCompare

[ Source](https://github.com/llwebsol/EasyDB)[ Packagist](https://packagist.org/packages/llwebsol/easy-db)[ RSS](/packages/llwebsol-easy-db/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (7)DependenciesVersions (8)Used By (1)

EasyDB
======

[](#easydb)

A Simple Wrapper for PDO

To get the most out of this library, every table in your database should have a primary key called `id`.

Getting Started
---------------

[](#getting-started)

using composer

```
composer require llwebsol/easy-db

```

1. Create a Config
------------------

[](#1-create-a-config)

```
$config = new EasyDb\Core\Config([
    'db_type' => 'mysql',
    'host' => 'localhost',
    'db_name' => 'my_test_db',
    'user' => 'root',
    'password' => ''
]);

```

#### Accepted `db_type` options:

[](#accepted-db_type-options)

- mysql
- pgsql
- sqlite\*
- sqlsrv\*

\*currently untested

#### Complete List of Options:

[](#complete-list-of-options)

```
db_type
host
db_name
port
user
password

// mysql specific:
unix_socket
charset

// sqlsrv specific:
app
connection_pooling
encrypt
failover_partner
login_timeout
multiple_active_result_sets
quoted_id
server
trace_file
trace_on
transaction_isolation
trust_server_certificate
wsid

// sqlite specific:
path

```

2. Get a DB Instance
--------------------

[](#2-get-a-db-instance)

Use the ConnectionPool to retrieve a database instance for a given configuration.

```
$db = ConnectionPool::getDbInstance($config);

```

3. Querying the Database
------------------------

[](#3-querying-the-database)

Once you have an instance of the DB class, there are several helper methods available to you

#### - Query

[](#--query)

accepts any database query you desire, with an optional array of bound parameters

returns a Generator for iterating through your result set

```
$query = 'SELECT * FROM users WHERE name = :user_name';
$params = [':user_name' => 'Ted'];

$users = $db->query($query,$params);

```

#### - QueryOne

[](#--queryone)

helper for getting a single record from the database

Returns the record as an array, (not wrapped in a generator)

```
$query = 'SELECT * FROM users WHERE id = :user_id';
$params = [':user_id' => 7]

$user = $db->queryOne($query,$params);

```

#### - Insert

[](#--insert)

Insert a record into a given table Returns the last inserted id

```
$data = [
    'name' => 'Chris',
    'email' => 'chris@landlordwebsolutions.com'
];

$inserted_id = $db->insert('users', $data);

```

#### - Update

[](#--update)

Update a record in a given table returns the number of rows affected

```
$data = [
    'email' => 'new.email@email.com'
];

$rows_affected = $db->update('users', 76, $data);

```

#### - Save

[](#--save)

this is just an alias for insert/update if the $data has an 'id' field it will update, otherwise it will insert

#### - Delete

[](#--delete)

Delete a record from a given table returns the number of rows affected or `false` if invalid

```
// Delete the record with id=76 from 'users'
$rows_deleted = $db->delete('users', 76);

```

#### - Delete Where

[](#--delete-where)

Delete records from a given table that meet the conditions of the where clause Returns the number of rows deleted

```
// Delete all clients from Toronto or New York with a name starting with 'T'

$where = 'name LIKE :name_compare AND city_id IN (:toronto_id,:new_york_id)';
$params = [
    ':name_compare' =>  't%',
    ':toronto_id' => 5142,
    ':new_york_id' => 1432
];

$records_deleted = $db->deleteWhere('clients', $where, $params);

```

#### - Update Where

[](#--update-where)

Update records from a given table that meet the conditions of the where clause Returns the number of rows updated

```
Set Status to 'disabled' for all users with hotmail accounts

$update = [ 'status' => 'disabled' ];
$where  = 'email LIKE :email_compare';
$params = [ ':email_compare' => '%@hotmail.com' ]

$rows_updated = $db->updateWhere('users', $update, $where, $params);

```

#### - Find In

[](#--find-in)

Returns a Generator with all records in table where `$column_name IN ( $in_array )`

```
$records = $db->findIn('clients', 'city_id', [5142,1432,76,222]);

```

SQL Equivalent:

```
SELECT *
FROM clients
WHERE city_id IN (5142,1432,76,222);

```

4. Events
---------

[](#4-events)

You can add event listeners for any stage of a database interaction

Supported Events:

- ON\_ERROR
- BEFORE\_QUERY
- AFTER\_QUERY
- BEFORE\_UPDATE
- AFTER\_UPDATE
- BEFORE\_INSERT
- AFTER\_INSERT
- BEFORE\_DELETE
- AFTER\_DELETE

Helpers:

- BEFORE\_SAVE ( BEFORE\_INSERT and BEFORE\_UPDATE)
- AFTER\_SAVE (AFTER\_INSERT and AFTER\_UPDATE)

### Examples

[](#examples)

Echo the sql of every query that is performed

```
use EasyDb\Events\Listener;

class QueryListener implements Listener
{
    /**
     * @param EventData $data
     * @param array     &$ref_parameters [optional]
     */
    public static function handleEvent(EventData $data, array &$ref_parameters = []){
        echo $data->getSql();
    }
}

// Register the listener
Listeners::register(Event::BEFORE_QUERY, QueryListener::class);

```

Add a user id to all inserted records

\*Assumes all of your tables have a `created_user` column

```
use EasyDb\Events\Listener;

class InsertListener implements Listener
{
    /**
     * @param EventData $data
     * @param array     &$ref_parameters [optional]
     */
    public static function handleEvent(EventData $data, array &$ref_parameters = []){
        $ref_parameters['created_user'] = $_SESSION['user'];
    }
}

// Register the listener
Listeners::register(Event::BEFORE_QUERY, InsertListener::class);

```

\*Referenced Parameters are available for `BEFORE_INSERT` and `BEFORE_UPDATE` events only

5. Transactions
---------------

[](#5-transactions)

You can perform multiple actions with a single transaction with the following 3 methods

- beginTransaction
- commitTransaction
- rollbackTransaction

Example:

```
/**
* @param array $save_records
* @param DB    $db
*
* @return int $records_saved
*/
function save_a_bunch_of_records(array $save_records, DB $db){
    $db->beginTransaction();

    $records_saved = 0;
    foreach($save_records as $table_name => $record){
        try{
            $records_saved += $db->save($table_name, $record);
        }
        catch(QueryException $ex){

            // All or nothing. Undo all previous saves
            $db->rollbackTransaction();

            return false;
        }
    }

    $db->commitTransaction();
    return $records_saved;
}

```

###  Health Score

30

—

LowBetter than 64% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity11

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity68

Established project with proven stability

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 ~27 days

Recently: every ~20 days

Total

7

Last Release

2823d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/b5a9a283da02972cd289fac42dbab51db6f305b2173665eb8c025dad8c974767?d=identicon)[chris-jaques](/maintainers/chris-jaques)

### Embed Badge

![Health badge](/badges/llwebsol-easy-db/health.svg)

```
[![Health](https://phpackages.com/badges/llwebsol-easy-db/health.svg)](https://phpackages.com/packages/llwebsol-easy-db)
```

PHPackages © 2026

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