search

bjverde / sysgen

:elephant: SysGen is crud scaffolding. Generates PHP code using FormDin FrameWork
GNU General Public License v3.0
21 stars 9 forks source link

Sqlite Pagination #112

Closed bjverde closed 4 years ago

bjverde commented 4 years ago

https://www.sqlitetutorial.net/sqlite-limit/

        $sql = self::$sqlBasicSelect
        .( ($where)? ' where '.$where:'')
        .( ($orderBy) ? ' order by '.$orderBy:'')
        .( ' LIMIT '.$rowStart.','.$rowsPerPage);