PHPackages                             joyltonmaciel/mpdo - 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. joyltonmaciel/mpdo

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

joyltonmaciel/mpdo
==================

My Personal PDO Library for PostgreSQL

0174PHP

Since Apr 20Pushed 2y agoCompare

[ Source](https://github.com/joyltonmaciel/mpdo)[ Packagist](https://packagist.org/packages/joyltonmaciel/mpdo)[ RSS](/packages/joyltonmaciel-mpdo/feed)WikiDiscussions master Synced today

READMEChangelogDependenciesVersions (1)Used By (0)

MPDO - My Personal PDO
======================

[](#mpdo---my-personal-pdo)

Small Database Manipulation which looks like Laravel Eloquent syntax. Based on PHP-PDO library.

Install
-------

[](#install)

```
composer require joyltonmaciel/mpdo:dev-master

```

The dotEnv Settings
-------------------

[](#the-dotenv-settings)

At the root of the project, create a file called *.env* with the following content:

```
DB_DRIVER=[pgsql]
DB_HOST=[localhost]
DB_USER=[data_base_user_name]
DB_PASS=[data_base_user_name_password]

```

Usage
-----

[](#usage)

**Connect to Database**

```
require_once __DIR__ . '/../vendor/autoload.php';
use Mpdo\MDB;
$db = new MDB($dbname);

```

**insert**

```
$dados = new stdClass();
$dados->{'tabela'} = new stdClass();
$dados->{'tabela'}->nome = 'Joao';
$dados->{'tabela'}->date = '2020-01-01';
$dados->{'tabela'}->valid = true;
$db->insert($dados);

```

**update**

```
$db->table('tabela')->where('id', $id)->update(['field_name' => $value]);

```

**delete**

```
$db->table('table')->where('id', $id)->delete();

```

**Join**

```
$db->table('tableA')
    ->join('tableB', 'tableB.id', '=', 'tableA.compid')

```

```
$db->table('tableA as A')
    ->join('tableB as B', 'B.compid', '=', 'A.compid')

```

**Where**

```
$db->table('folhas')
    ->where('tpfolha', 0)
    ->where('folhaid', '