PHPackages                             amadiify/querydb - 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. amadiify/querydb

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

amadiify/querydb
================

This package provides more flexibility working with mysql, sqlite and pgsql database systems in PHP out of the box.

0.1(6y ago)06MITPHPPHP ^7.1

Since Dec 1Pushed 6y ago1 watchersCompare

[ Source](https://github.com/amadiify/phporm)[ Packagist](https://packagist.org/packages/amadiify/querydb)[ RSS](/packages/amadiify-querydb/feed)WikiDiscussions master Synced 4d ago

READMEChangelog (1)DependenciesVersions (2)Used By (0)

Database ORM Handler for PHP
----------------------------

[](#database-orm-handler-for-php)

- This package provides more flexibility working with mysql, sqlite and pgsql database systems in PHP out of the box. It's an extension of Moorexa Query Builder. You should check out **Moorexa** for your next amazing web app.

### How to use

[](#how-to-use)

- Configure your database connection settings in **Amadiify/Connection.php**You can create multiple connection setting and switch connection during run time. But first, a default connection must be avaliable for fallbacks.

Here is how the connection file looks like.

```
    'default' => [
        'dsn' 		=> '{driver}:host={host};dbname={dbname};charset={charset}',
		'driver'    => 'mysql', // mysql, pgsql, sqlite
		'host' 	    => '',
		'user'      => '',
		'password'  => '',
		'dbname'    => '',
		'charset'   => 'UTF8',
		'port'      => '',
		'handler'   => 'pdo', // pdo or mysqli
		'attributes'=> true,
		'production'=> [
			'driver'  =>   'mysql',
			'host'    =>   '',
			'user'    =>   '',
			'password'  =>   '',
			'dbname'    =>   '',
		],
		'options'   => [ PDO::ATTR_PERSISTENT => true ]
     ]
     // you can add more
```

### Security

[](#security)

- Oh yeah, it's safe. All queries are prepared and filtered even down to raw sql statements.

Once this is done, you can **Use** this connection. see example:

```
use Amadiify\Client;
```

Get Request
-----------

[](#get-request)

- perform a basic get request (select query)

```
    // generic option
    Client::table('user')->get();
    // or
    Client::user()->get();
    // or
    \user::get(); // some other configuration must be made for this to work.
```

More Advance Get request
------------------------

[](#more-advance-get-request)

- This goes beyond the basics.

```
    // using generic
    Client::table('user')->get('userid=?', 1);
    // or
    Client::table('user')->get('userid=?')->bind(1);
    // or
    Client::table('user')->get('username,password')->where('userid=?')->bind(1);
    // we can even perform two actions at the same time
    Client::table('user')->get('userid=?')->bind(1)->update(['username' => 'frank']);
    // get random
    Client::table('user')->get()->rand();
    // using limit
    Client::table('user')->get()->limit(0,20);
    // using order
    Client::table('user')->get()->orderby('username', 'asc')->limit(0,20);
    // and much more.
    // see the cheat sheet for more possibilities.
```

Insert Request
--------------

[](#insert-request)

- You can insert in multiples. System protects you from double records. Keeps everything unqiuely stored.
- You can apply loops and chain other actions in one line.

```
    // lets insert something simple
    $table = Client::table('user');
    // simple first
    $table->insert(['username' => 'chris']);
    // multiple
    $table->insert(['username' => 'mack'], ['username' => 'frank']); // and much more
    // if you drop the line you need to instruct execution
    $table->insert(
        ['username' => 'mack'],
        ['username' => 'sam']
    )->go();
    // or
    $table->insert('username,password')->bind('mack', '1234');
    // or
    $table->insert('username,password', 'mack', '1234');
    // or run a get after
    $table->insert('username,password')->bind('mack', '1234')->get(); // returns records.
    $data = [

        [
            'username' => 'Moorexa',
            'password' => 'hash-password'
        ],

        [
            'username' => 'Wekiwork',
            'password' => 'hash-password'
        ]

    ];
    array_map(function($data){
        Client::table('user')->insert($data);
    }, $data);
    // insert json data
    $table->insert('{"username":"mike2", "password":"hash-password2"}');
    // or insert an object
    $object = (object) $data;
    $table->insert($object);
    // and much more..
```

Update Request
--------------

[](#update-request)

- You can run update easily, and chain other actions along side that request

```
    // get table
    $table = Client::table('user');
    // update with json
    $table->update('{"username":"chris", "id":3}', 'userid=?', 3);
    // or
    $table->update('{"username":"chris", "id":3}')->where('userid=?', 3);
    // or
    $table->update('{"username":"chris", "id":3}')->where('userid=?', 3);
    // or
    $table->update(['username' => 'chris'], 'userid = ?', 3);
    // or
    $table->update(['username' => 'moorexa'])->where('userid = ?')->bind(3);
    // or
    $get = $table->get('username = ?')->bind('chris');
    // then update that row
    $get->update(['telephone' => '080000000000']);
    // and much more
```

Delete Request
--------------

[](#delete-request)

- You can run delete queries easily and also chain other actions along side that request

```
    // get table
    $table = Client::table('user');
    // update with json
    $table->delete('userid = ?')->bind(30);
    // or
    $table->delete(['userid' => 3]);
    // or
    $get = $table->get('userid = ?', 2);
    // then delete that row
    $get->pop();
    // and much more
```

Raw sql
-------

[](#raw-sql)

- Raw sql statements are prepared also, lets see an example

```
    Client::sql('select * from users where username = ?', 'chris');
    // or
    Client::sql('select * from users where username = :name')->bind('chris');
    // or
    Client::sql('select * from users where username = "chris"');
    // interpreted as
    // select * from users where username = :username
    // or
    $table = new Client();
    $table->sql('Your query here.');
```

Switch database connection
--------------------------

[](#switch-database-connection)

- You can switch to a different connection during run time. It's easy

```
    $default = Client::serve();
    $switch1 = Client::apply('database1');
    // and other queries can be chained here
```

This is just an evaluation copy, You can do much more with this in Moorexa. You can share and contribute, thank you.

###  Health Score

20

—

LowBetter than 14% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity4

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity42

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

Unknown

Total

1

Last Release

2358d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/6d53d5272e5c80c51a44a4faf21266b2c9b75b65169e5e60ea99340b647cef06?d=identicon)[wekiwork](/maintainers/wekiwork)

---

Top Contributors

[![amadiify](https://avatars.githubusercontent.com/u/49183066?v=4)](https://github.com/amadiify "amadiify (17 commits)")

### Embed Badge

![Health badge](/badges/amadiify-querydb/health.svg)

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

###  Alternatives

[doctrine/orm

Object-Relational-Mapper for PHP

10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database

The Illuminate Database package.

2.8k52.4M9.4k](/packages/illuminate-database)[mongodb/mongodb

MongoDB driver library

1.6k64.0M546](/packages/mongodb-mongodb)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

90340.3M211](/packages/ramsey-uuid-doctrine)[reliese/laravel

Reliese Components for Laravel Framework code generation.

1.7k3.4M16](/packages/reliese-laravel)

PHPackages © 2026

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