function getLimit($num) { $sql = new SelectStatement(); $sql->limit(($this->current - 1) * $num, $num); return $sql; }
public function count(SelectStatement $select) { $sql = $select->sql(); $sql = "SELECT count(*) as count FROM ({$sql}) as tmp"; $statement = $this->prepareAndExecuteStatement($sql); $result = $statement->fetchAll(PDOPhp::FETCH_ASSOC); return $result[0]['count']; }
/** * @return SQLStatement */ public function getSQLStatement() : SQLStatement { return $this->select->getSQLStatement(); }