mocodo/sql

0.4.2 2016-10-06 13:24 UTC

Requires

• php: >=5.4
• ext-mbstring: *
• ext-pdo: *

Requires (Dev)

• phpunit/phpunit: ^5.5

MIT

• Charly Goblet

README

Provides a small extension to the native PDO behavior, allowing simple query build.

Installation

$ composer require mocodo/sql

Tests

$ composer tests

Usage

As it is simply extending PDO, you can instanciate it like so :

<?php

use Mocodo\Driver\MySQLConnection

$pdo = new MySQLConnection('mysql:127.0.0.1;dbname=test', 'root', 'root', [...]);

It also comes with a neat feature for building queries.

$query = 'SELECT foo, bar FROM my_table WHERE 1';

$stmt = $pdo->find($query, [
    'conditions' => [
        'foo' => 'foobar',
        'bar LIKE' => '%.com',
    ]
]);

// SELECT foo, bar FROM my_table WHERE 1 AND foo = 'foobar' AND bar LIKE '%.com'

License

MIT