/** * Applies LIMIT/OFFSET to SQL command. * @param string $sql SQL command * @return string */ protected function applyLimit($sql) { list($limit, $offset) = $this->stmt->getLimit(); if ((int) $limit > 0) { $sql .= "\nLIMIT " . (int) $limit; if ((int) $offset > 0) { $sql .= ' OFFSET ' . (int) $offset; } } return $sql; }