PHPackages                             onebytesolutions/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. onebytesolutions/database

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

onebytesolutions/database
=========================

Database Library - A dependency injection based Database Class

v1.6(2y ago)233GPL-3.0-or-laterPHPPHP >=7.2

Since Jun 20Pushed 2y agoCompare

[ Source](https://github.com/onebytesolutions/database)[ Packagist](https://packagist.org/packages/onebytesolutions/database)[ Patreon](https://www.patreon.com/onebytesolutions)[ RSS](/packages/onebytesolutions-database/feed)WikiDiscussions master Synced 4d ago

READMEChangelog (5)DependenciesVersions (7)Used By (0)

Database Library - A dependency injection based Database Class

---

\### Table of Contents **[Installation](#installation)**
**[Initialization](#initialization)**
**[Insert Query](#insert-query)**
**[Insert Batch Query](#insert-batch-query)**
**[Update Query](#update-query)**
**[Select Query](#select-query)**
**[Delete Query](#delete-query)**
**[Raw Query](#raw-query)**

About
-----

[](#about)

This software was developed during my free time and is free to use.

### Installation

[](#installation)

Composer

```
composer require onebytesolutions/database
```

### Initialization

[](#initialization)

Simple initialization:

```
use OneByteSolutions\Database\Database,
    OneByteSolutions\Database\Adapters\PdoAdapter;

// set db config
$db = [
    'host' => 'localhost',
    'user' => 'db-username',
    'pass' => 'db-password',
    'database' => 'database-name'
	// OPTIONAL: ,'port' => 3308
];

// try to connect to the database
try {
    $database = new Database(new PdoAdapter($db));
    $database->connect();
}catch (\Exception $e){
    echo "Unable to connect: ".$e->getMessage();
}
```

### Insert Query

[](#insert-query)

Simple example

```
// example of inserting a new user, with transactions
$database->beginTransaction();
try {
    $row = [
        'name' => 'John Doe',
        'email' => 'john.doe@example.org'
    ];
    $id = $database->insertRow("users", $row);
    $database->commit();

    echo 'inserted id: '.$id;
} catch(\Exception $e){
    echo 'insert failure';
    $database->rollBack();
}
```

### Insert Batch Query

[](#insert-batch-query)

Simple example

```
// example of inserting a bunch of rows
$rows = [];
$rows[] = [
        'name' => 'John Doe ',
        'email' => 'john.doe@example.org'
];
$rows[] = [
        'name' => 'Jane Doe ',
        'email' => 'jane.doe@example.org'
];
$rows[] = [
        'name' => 'Sarah Doe ',
        'email' => 'sarah.doe@example.org'
];
$database->insertRowBatch("users", $rows);
```

### Update Query

[](#update-query)

```
// example of updating a row
$database->updateRowWhere("user", ["lastLogin" => time()], "id", 1);
```

### Select Query

[](#select-query)

```
// example of fetching a query as an array
$sql = "SELECT * FROM users LIMIT 30";
$params = [];
$results = $database->queryToArray($sql, $params);

echo ''.print_r($results,true).'';
```

### Delete Query

[](#delete-query)

```
// example of deleting a row
$database->deleteWhere("users", "id", 1);
```

### Raw Query

[](#raw-query)

```
// example of running raw sql
$database->run("UPDATE users SET name = :name", ['name' => 'Alex Doe']);
```

###  Health Score

26

—

LowBetter than 43% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity10

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity58

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

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

Recently: every ~383 days

Total

6

Last Release

987d ago

PHP version history (2 changes)v1.1PHP ^5.5 || ^7.0

v1.6PHP >=7.2

### Community

Maintainers

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

---

Top Contributors

[![onebytesolutions](https://avatars.githubusercontent.com/u/22356463?v=4)](https://github.com/onebytesolutions "onebytesolutions (12 commits)")

---

Tags

databasemysqlpdo

### Embed Badge

![Health badge](/badges/onebytesolutions-database/health.svg)

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

###  Alternatives

[lincanbin/php-pdo-mysql-class

A PHP MySQL PDO class similar to the Python MySQLdb, which supports iterator and parameter binding when using 'WHERE IN' statement.

2386.4k](/packages/lincanbin-php-pdo-mysql-class)[sorskod/db

PDO wrapper. Extends PDO and PDOStatement with useful methods.

788.1k2](/packages/sorskod-db)

PHPackages © 2026

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