/** * 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|string $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); }