malenki/desbaies

Some classes for create SQL query without SQL code.

desbaies

Some classes for create SQL query without SQL code. Allow execution too, but there are not ORM layer., _(*1)

Simple example:, _(*2)

``` php use \Malenki\DesBaies;, <sub>(*3)</sub>

$db = new DesBaies(); $db->select->add('foo'); $db->from->add('bar');, <sub>(*4)</sub>

give:

``` sql
SELECT `foo`
FROM `bar`;

More complex example:, <sub>(*5)</sub>

``` php use \Malenki\DesBaies;, <sub>(*6)</sub>

$db = new DesBaies(); $db->select->add('foo', 'b')->add('foo2', 'b2'); $db->from->add('bar', 'b'); $db->from->add('bar2', 'b2'); $db->order->by('foo', 'b')->desc->by('foo2', 'b2');, <sub>(*7)</sub>

give:

``` php
SELECT `b`.`foo`, `b2`.`foo2`
FROM `bar` AS `b`, `bar2` AS `b2`
ORDER BY `b`.`foo` DESC, `b2`.`foo2` ASC;