Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //LIBRARY PAGINATION CODE IGNITER
- //DEFAULT FOR BOOTSTRAP
- <?php
- class Pagination_library
- {
- function paginate_anchor($url, $queryPaging, $total, $per_page) {
- $prevlabel = "‹ Prev";
- $nextlabel = "Next ›";
- $out = '<div class="pagination">';
- $page=$queryPaging;
- $tpages=ceil($total/$per_page);
- $adjacents=$per_page;
- if($page==1) {
- $out.= "<span>$prevlabel</span>";
- } else if($page==2) {
- $out.= "<a href='".$url."page=".($page-1)."'>$prevlabel</a>";
- }else {
- $out.= "<a href='".$url."page=".($page-1)."'>$prevlabel</a>";
- }
- if($page>($adjacents+1)) {
- $out.= "<a href='".$url."page=1'>1</a>";
- }
- if($page>($adjacents+2)) {
- $out.= "...\n";
- }
- $pmin = ($page>$adjacents) ? ($page-$adjacents) : 1;
- $pmax = ($page<($tpages-$adjacents)) ? ($page+$adjacents) : $tpages;
- for($i=$pmin; $i<=$pmax; $i++) {
- if($i==$page) {
- $out.= "<span>$i</span>";
- }else if($i==1) {
- $out.= "<a href='".$url."page=$i'>$i</a>";
- }else {
- $out.= "<a href='".$url."page=$i'>$i</a>";
- }
- }
- if($page<($tpages-$adjacents-1)) {
- $out.= "...\n";
- }
- if($page<($tpages-$adjacents)) {
- $out.= "<a href='".$url."page=$tpages'>$tpages</a>";
- }
- if($page<$tpages) {
- $out.= "<a href='".$url."page=".($page+1)."'>$nextlabel</a>";
- }else {
- $out.= "<span>$nextlabel</span>";
- }
- $out.= "</div>";
- if($total<$per_page)
- {
- return null;
- }else{
- return $out;
- }
- }
- }
- //HOW TO USE ?
- //ON CONTROLLERS OR MODELS
- $url=site_url('viewdata/').'?';
- $page = isset($_GET['page']) ? mysql_real_escape_string($_GET['page']) : '1';
- $limit=10;
- $offset = ($page - 1) * $limit;
- $sql=$this->db->query("SELECT * FROM TABLE limit $offset,$limit");
- $sql2=$this->db->query("SELECT * FROM TABLE");
- $datadb=$sql->result();
- $totalrow=$sql2->num_rows();
- $this->load->library('pagination_library');
- $data['links']=$this->pagination_library->paginate_anchor($url,$page,$totalrow,$limit);
- $data['results']=$datadb;
- //CREATE VIEWS FOR DATA
- foreach($isdata['results'] as $row)
- {
- $row->field1.'<br>';
- $row->field2;
- }
- echo $isdata['links'];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement