PHPackages                             simsoft/adodb-orm - 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. simsoft/adodb-orm

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

simsoft/adodb-orm
=================

ORM wrapper for ADOdb PHP

1.1.14(4mo ago)1349MITPHPPHP ^8

Since Nov 21Pushed 1mo ago2 watchersCompare

[ Source](https://github.com/sim-soft/adodb-orm)[ Packagist](https://packagist.org/packages/simsoft/adodb-orm)[ RSS](/packages/simsoft-adodb-orm/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (8)Dependencies (2)Versions (56)Used By (0)

ADOdb ORM
=========

[](#adodb-orm)

This is an ORM wrapper for ADOdb ()

Requirements
------------

[](#requirements)

- PHP >= 8

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

[](#installation)

1. Install package using composer

```
$ composer require simsoft/adodb-orm
```

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

[](#getting-started)

```
require_once "vendor/autoload.php";
require_once "vendor/adodb/adodb-php/adodb-active-recordx.inc.php";

use Simsoft\ADOdb\DB;
use Simsoft\ADOdb\Query;

$config = [
    'mysql' => [
        'driver' => 'mysqli',
        'host' => '127.0.0.1',
        'user' => 'username',
        'pass' => 'password',
        'schema' => 'db_example',
    ],
    /* Sample config
    'connection_name' => [
        'driver' => 'mysqli',
        'host' => '127.0.0.1',
        'user' => 'username',
        'pass' => 'password',
        'schema' => 'database_name',
        'debug' => true,
        'execute' => [ // run once when the connection is successful.
            "SET @@session.time_zone='+00:00'",
        ],
    ],*/
];

// Initiate DB config
DB::init($config);

$result = DB::use('mysql')->execute('SELECT * FROM table1 WHERE attr1 = ? AND attr2 = ?', ['value1', 'value2']);

while ($row = $result->fetchRow()) {
    print_r($row);
}

// Insert new record
$success = DB::use('mysql')->insert('table', ['attr1' => 'value1', 'attr2' => 'value2']);

// Update an record.
$success = DB::use('mysql')->update('table', ['attr1' => 'value1', 'attr2' => 'value2'], 'id=2');
$success = DB::use('mysql')->update('table', ['attr1' => 'value1', 'attr2' => 'value2'], Query::where('id', 2));

// Return result in array
$result = DB::use('mysql')->getArray('SELECT * FROM user WHERE name LIKE ?', ['%john%']);

// Enable debug mode
$result = DB::use('mysql')->debug()->getArray('SELECT * FROM user WHERE name LIKE ?', ['%john%']);
```

Basic Usage
-----------

[](#basic-usage)

### Query Builder

[](#query-builder)

```
require_once "vendor/autoload.php";
require_once "vendor/adodb/adodb-php/adodb-active-recordx.inc.php";

use Simsoft\ADOdb\DB;
use Simsoft\ADOdb\Query;

$config = [
    'mysql' => [
        'driver' => 'mysqli',
        'host' => '127.0.0.1',
        'user' => 'username',
        'pass' => 'password',
        'schema' => 'db_example',
    ],
];

DB::init($config);

$result = Query::db('mysql')->from('table')->where('attr1', 'value1')->where('attr2', 'value2')->execute();

while ($row = $result->fetchRow()) {
    print_r($row);
}
```

### Active Record

[](#active-record)

```
namespace Model;

use Simsoft\ADOdb\ActiveRecord;

/**
 * Class User
 */
class User extends ActiveRecord
{
    /** @var string Connection name */
    public $_dbat = 'mysql';

    /** @var string table name */
    public $_table = 'user';
}
```

```
require_once "vendor/autoload.php";
require_once "vendor/adodb/adodb-php/adodb-active-recordx.inc.php";

use Simsoft\ADOdb\DB;
use Model\User;

$config = [
    'mysql' => [
        'driver' => 'mysqli',
        'host' => '127.0.0.1',
        'user' => 'username',
        'pass' => 'password',
        'schema' => 'db_example',
    ],
];

DB::init($config);

$users = User::query()->where('age', '>', 20)->where('gender', 'male')->findAll();

foreach ($users as $user) {
    echo $user->first_name;
    echo $user->last_name;
}
```

Documentations
--------------

[](#documentations)

1. [DB class](docs/db.md)
2. [Query Builder](docs/query-builder.md)
3. [Active Record](docs/active-record.md)

License
-------

[](#license)

The WeCanTrack PHP API is licensed under the MIT License. See the [LICENSE](LICENSE) file for details

###  Health Score

45

—

FairBetter than 92% of packages

Maintenance85

Actively maintained with recent releases

Popularity13

Limited adoption so far

Community10

Small or concentrated contributor base

Maturity60

Established project with proven stability

 Bus Factor1

Top contributor holds 81.6% 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 ~22 days

Recently: every ~9 days

Total

52

Last Release

128d ago

PHP version history (2 changes)1.0.0PHP ^7.4|^8

1.0.4PHP ^8

### Community

Maintainers

![](https://www.gravatar.com/avatar/7c3e6315469b56ed1797318e31e05bcddb12dba268488a2fb0cd2b43971c9ac3?d=identicon)[vzangloo](/maintainers/vzangloo)

---

Top Contributors

[![vzangloo](https://avatars.githubusercontent.com/u/1908200?v=4)](https://github.com/vzangloo "vzangloo (71 commits)")[![sim-soft](https://avatars.githubusercontent.com/u/118705222?v=4)](https://github.com/sim-soft "sim-soft (16 commits)")

---

Tags

phpormactive-recordadodbsencillez

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/simsoft-adodb-orm/health.svg)

```
[![Health](https://phpackages.com/badges/simsoft-adodb-orm/health.svg)](https://phpackages.com/packages/simsoft-adodb-orm)
```

###  Alternatives

[swoft/db

swoft database component

24167.4k11](/packages/swoft-db)[modul-is/orm

Lightweight hybrid ORM/Explorer

1118.1k](/packages/modul-is-orm)[flightphp/active-record

Micro Active Record library in PHP, support chain calls, events, and relations.

163.0k](/packages/flightphp-active-record)

PHPackages © 2026

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