Example #1
0
 /**
  * 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;
 }