PHP nav::build Examples

Example #1

File: app.php Project: salomay/refreshin

 function set_navigator(&$sql, &$nav, $pagesize, $param, $attr = '', $attrPls = '')
 {
     $dbu = new db();
     if ($_GET['page_offset']) {
         $pageoffset = $_GET['page_offset'];
     } else {
         $pageoffset = 0;
     }
     if ($_GET[page_total]) {
         $pagetotal = $_GET['page_total'];
     } else {
         $dbu->query($sql, $rs, $nr);
         $pagetotal = $nr;
     }
     $cari_limit = preg_match_all('|limit (.*)|sm', $sql, $hasil);
     if ($hasil[1][0]) {
         $sql = str_replace("" . $hasil[0][0] . "", "", $sql);
     }
     if ($pageoffset + $pagesize > $pagetotal) {
         $nilai = $pagetotal - $pageoffset;
         $sql = $sql . " limit {$pageoffset}, {$nilai}";
     } else {
         $sql = $sql . " limit {$pageoffset}, {$pagesize}";
     }
     $nav = new nav();
     $nav->init($pageoffset, $pagetotal, $param, $attr, $attrPls);
     $nav->param = $param;
     $nav->build($pagesize);
 }