SQL Abstract for PHP

Examples

namespace Model;

require_once('Sql/Sql.php');

class Foo extends \Sql\Sql
{
    protected $table = 'table_names';
    protected $alias = 'alias';
}

$sql = new \Model\Foo();

FROM

$sql->from('tables');

AS

$sql->alias('t');

SELECT

$sql->select();
// SELECT * FROM tables AS t

$sql->column('col0')->select();
// SELECT t.col0 FROM tables AS t

$sql->column(array('col0', 'z'))->select();
// SELECT t.col0 AS z FROM tables AS t

$sql->column('COUNT', 'col0')->select();
// SELECT COUNT(t.col0) FROM tables AS t

$sql->column('COUNT', array('col0', 'z'))->select();
// SELECT COUNT(t.col0) AS z FROM tables AS t

WHERE

$sql->where('col0', 1)->select();
// SELECT * FROM tables AS t WHERE col0 = 1

$sql->where('col0', 'a')->select();
$sql->values();
// SELECT * FROM tables AS t WHERE col0 = ?
// Array
// (
//   [0] => a
// )

$sql->where('col0', 'a')->where('col1', '<>', 1)->select();
$sql->values();
// SELECT * FROM tables AS t WHERE col0 = ? AND col1 <> 1
// Array
// (
//   [0] => a
// )

$sql->wheres(array(array('col0', 'a'), array('col1', '<>', 1)))->select();
$sql->values();
// SELECT * FROM tables AS t WHERE col0 = ? AND col1 <> 1
// Array
// (
//   [0] => a
// )

ORDER

$sql->order('col0')->select();
// SELECT * FROM tables AS t ORDER BY col0 ASC

$sql->order('col0', 'desc')->select();
// SELECT * FROM tables AS t ORDER BY col0 DESC

LIMIT

$sql->limit(8)->select();
// SELECT * FROM tables AS t LIMIT 8

OFFSET

$sql->offset(8)->select();
// SELECT * FROM tables AS t OFFSET 8

UPDATE

$sql->update()
// UPDATE tables

SET

$sql->set('col0', 1)->update();
// UPDATE tables SET col0 = 1

$sql->set('col0', 'a')->update();
$sql->values();
// UPDATE tables SET col0 = ?
// Array
// (
//   [0] => a
// )

$sql->set(array(array('col0', 'a'), array('col1', 1)))->update();
$sql->values();
// UPDATE tables SET col0 = ?, col1 = 1
// Array
// (
//   [0] => a
// )

DELETE

$sql->delete();
// DELETE FROM tables;

INSERT

$sql->set('col0', 1)->insert();
// INSERT INTO tables (col0) VALUES (1)

$sql->set('col0', 'a')->insert();
$sql->values();
// INSERT INTO tables (col0) VALUES (?)
// Array
// (
//   [0] => a
// )