PHPackages                             mateodioev/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. [Database &amp; ORM](/categories/database)
4. /
5. mateodioev/db

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

mateodioev/db
=============

Easy sql-db connection

v1.1.2(3y ago)31661MITPHP

Since Apr 21Pushed 3y agoCompare

[ Source](https://github.com/Mateodioev/db)[ Packagist](https://packagist.org/packages/mateodioev/db)[ RSS](/packages/mateodioev-db/feed)WikiDiscussions master Synced 5d ago

READMEChangelog (4)Dependencies (1)Versions (6)Used By (0)

Easy sql-connection
===================

[](#easy-sql-connection)

[![CodeFactor](https://camo.githubusercontent.com/c988293522767c51f3f201dfb8d1929d4894c3197cd5e69b3148d94a73271fba/68747470733a2f2f7777772e636f6465666163746f722e696f2f7265706f7369746f72792f6769746875622f6d6174656f64696f65762f64622f6261646765)](https://www.codefactor.io/repository/github/mateodioev/db)

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

[](#installation)

Github:

```
git clone https://github.com/Mateodioev/db
cd db
composer install
```

Composer:

```
composer require mateodioev/db
```

Usage
-----

[](#usage)

Set database data

```
use Mateodioev\Db\Connection;

Connection::Prepare('DB_HOST', 'DB_PORT', 'DB_NAME', 'DB_USER', 'DB_PASS');
# or
$dir = 'path/to/.env/file';
Connection::PrepareFromEnv($dir);
```

Execute querys

```
use Mateodioev\Db\Query;
$db = new Query();

// Return one afect row
$db->Exec('SELECT * FROM users'); // Simple sql query
$db->Exec('SELECT * FROM users WHERE id = :id', [':id' => 'random_id']); // With params

// Return all afect rows
$db->GetAll('SELECT * FROM users'); // Simple sql query
$db->GetAll('SELECT * FROM users WHERE id = :id', [':id' => 'random_id']); // With params
```

Exceptions
----------

[](#exceptions)

- `Connection::PrepareFromEnv($dir);` If dir not fund or not readable throw exception
- `$db->Exec($sql_query)` or `$db->GetAll($sql_query)` If sql query not valid or invalid credentials throw exception

###  Health Score

26

—

LowBetter than 43% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity15

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity52

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

Total

5

Last Release

1119d ago

Major Versions

v1.1 → v2.0-beta2022-10-01

### Community

Maintainers

![](https://www.gravatar.com/avatar/77e3f2a5c4e98caf6e911141af3d18235c658500e8b9e0a95ec251a803a39676?d=identicon)[Mateodioev](/maintainers/Mateodioev)

---

Top Contributors

[![Mateodioev](https://avatars.githubusercontent.com/u/68271130?v=4)](https://github.com/Mateodioev "Mateodioev (21 commits)")

---

Tags

mysqlpdophpsqlmysqlsqldb

### Embed Badge

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

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

###  Alternatives

[aura/sqlquery

Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.

4572.9M34](/packages/aura-sqlquery)[danielme85/laravel-log-to-db

Custom Laravel Log channel handler that can store log events to SQL or MongoDB databases. Uses Laravel native logging functionality.

135934.5k1](/packages/danielme85-laravel-log-to-db)[illuminated/db-profiler

Database Profiler for Laravel Web and Console Applications.

168237.4k](/packages/illuminated-db-profiler)[rah/danpu

Zero-dependency MySQL dump library for easily exporting and importing databases

64401.8k10](/packages/rah-danpu)[atlas/query

Object-oriented query builders and performers for MySQL, Postgres, SQLite, and SQLServer.

41249.0k7](/packages/atlas-query)[aura/sqlschema

Provides facilities to read table names and table columns from a database using PDO.

41234.1k4](/packages/aura-sqlschema)

PHPackages © 2026

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