KumbiaPHP / ActiveRecord

 *

 * @return string

 */

function mysql_limit($sql, $limit = null, $offset = null)

{

    if ($limit !== null) {

        $limit = (int) $limit;

        $sql .= " LIMIT $limit";

    }

    if ($offset !== null) {

        $offset = (int) $offset;

        $sql .= " OFFSET $offset";

    }

    return $sql;

}

 *

 * @return string

 */

function pgsql_limit($sql, $limit = null, $offset = null)

{

    if ($limit !== null) {

        $limit = (int) $limit;

        $sql .= " LIMIT $limit";

    }

    if ($offset !== null) {

        $offset = (int) $offset;

        $sql .= " OFFSET $offset";

    }

    return $sql;

}

 * @param string $offset valor offset

 * @return string

 */

function sqlsrv_limit($sql, $limit = null, $offset = null)

{

    if ($limit !== null) {

        $limit = (int) $limit;

        $sql = preg_replace('/(DELETE|INSERT|SELECT|UPDATE)/i', '${1} TOP ' . $limit, $sql);

    }

    if ($offset !== null) {

        $offset = (int) $offset;

        $sql .= " OFFSET $offset";

    }

    return $sql;

}