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

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

dynamonet/orm
=============

Fluent Query Builder and ActiveRecord-based ORM for PHP 7

v0.1.2(6y ago)05[1 PRs](https://github.com/dynamonet/orm/pulls)MITPHPCI passing

Since Nov 8Pushed 4w ago1 watchersCompare

[ Source](https://github.com/dynamonet/orm)[ Packagist](https://packagist.org/packages/dynamonet/orm)[ RSS](/packages/dynamonet-orm/feed)WikiDiscussions master Synced 6d ago

READMEChangelogDependenciesVersions (6)Used By (0)

Active-ORM
==========

[](#active-orm)

ActiveRecord-based ORM for PHP 7, inspired in Eloquent and Yii2 ORM.

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

[](#getting-started)

Create a new PDO instance, and pass the instance to Query:

```
use Dynamo\ORM\Query;
....
$pdo = new \PDO('mysql:dbname=goldoni;host=localhost;charset=utf8', 'root', 'root');
$query = (new Query($pdo))
```

or better yet, set the PDO globally:

```
Query::setPdo($pdo);
....
$query = (new Query()) // this will use the static PDO instance.
```

Query Builder
-------------

[](#query-builder)

Fluent and intuitive Query Builder:

```
$users = (new Query)
  ->select('*') // This is the default select
  ->from('users')
  ->where([
    'role' => 'ADMIN', // translates to "role = ?", where "?" will be securely replaced by the PDO layer
    'age > $minAge', // insecure! $minAge is not verified! However, we allow this form for convenience
    [ 'age', '