public function __construct($table = NULL, array $columns = NULL, $db = NULL, $order = NULL, $limit = NULL)
{
parent::__construct(NULL, $db);
//Set Table
if (isset($table)) {
$this->setTable($table);
}
//Set Columns
if (isset($columns)) {
$this->setColumns($columns);
}
//Set Order
if (isset($order)) {
$this->orderBy($order);
}
//Set Limit
if (isset($limit)) {
$this->limit($limit);
}
}
public function getUpdateString()
{
$stmt = '';
$colcount = 0;
foreach ($this->data as $name => $col) {
if ($colcount > 0) {
$stmt .= ',';
}
$stmt .= ' ' . $name . '=';
if ($this->literal[$name] === true) {
$stmt .= $col;
} else {
$stmt .= Staple_Query::convertTypes($col);
}
$colcount++;
}
return $stmt;
}
public static function Between($column, $start, $end)
{
$obj = new static();
$obj->setColumn($column)->setOperator(self::BETWEEN)->setValue(Staple_Query::convertTypes($start) . " AND " . Staple_Query::convertTypes($end))->setColumnJoin(true);
return $obj;
}
