/**
* Construct a new SQLUpdate object
*
* @param string $table Table name to update (ANSI quoted)
* @param array $assignment List of column assignments
* @param array $where List of where clauses
*/
function __construct($table = null, $assignment = array(), $where = array())
{
parent::__construct(null, $where);
$this->assignment = new SQLAssignmentRow();
$this->setTable($table);
$this->setAssignments($assignment);
}
/**
* Construct a new SQLSelect.
*
* @param array $select An array of SELECT fields.
* @param array|string $from An array of FROM clauses. The first one should be just the table name.
* Each should be ANSI quoted.
* @param array $where An array of WHERE clauses.
* @param array $orderby An array ORDER BY clause.
* @param array $groupby An array of GROUP BY clauses.
* @param array $having An array of HAVING clauses.
* @param array|string $limit A LIMIT clause or array with limit and offset keys
*/
public function __construct($select = "*", $from = array(), $where = array(), $orderby = array(), $groupby = array(), $having = array(), $limit = array())
{
parent::__construct($from, $where);
$this->setSelect($select);
$this->setOrderBy($orderby);
$this->setGroupBy($groupby);
$this->setHaving($having);
$this->setLimit($limit);
}
/**
* Construct a new SQLDelete.
*
* @param array|string $from An array of Tables (FROM clauses). The first one should be just the table name.
* Each should be ANSI quoted.
* @param array $where An array of WHERE clauses.
* @param array|string $delete The table(s) to delete, if multiple tables are queried from
*/
function __construct($from = array(), $where = array(), $delete = array())
{
parent::__construct($from, $where);
$this->setDelete($delete);
}