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); }