Return to Question

added 1404 characters in body

Source Link

edited Jul 23, 2013 at 9:46

EDIT:

I couldn't figure out a good approach so I came up with this horrible code:

if ($page != 1) {

  
  if ($page > 5) {
  
    $sdot = '....';
  
  } else {
  
    $sdot = '';
    
  }
    
  echo '<a href="?page=1" class="page" >First</a>'.$sdot ;

}
  

  if ($page < 5) {
    
    for ($i=1; $i<=5; $i++) {
     
      echo '<a href="?page='.$i.'">'.$i.'</a>';
    
    }
    
  } elseif (($page > 5) && ($page < ($count-5))) {
  
    for ($i=($page-2); $i<=($page+2); $i++) {
    
      echo '<a href="?page='.$i.'">'.$i.'</a>';
        
    }

  } elseif (($page > ($count-7)) && ($page < ($count-2))) {
  
    for ($i=($page-2); $i<=($page+2); $i++) {
    
      echo '<a href="?page='.$i.'">'.$i.'</a>';
        
    }
  
  } else {
  
    for ($i=($page-2); $i<=$count; $i++) {
    
      echo '<a href="?page='.$i.'">'.$i.'</a>';
        
    }
  
  }


if ($page != $count) {

  if ($page < ($count-2)) {
  
    $edot = '....';
  
  } else {
  
    $edot = '';
    
  }

  echo $edot.'<a href="?page='.$count.'" class="page">Last</a>';

}

EDIT:

I couldn't figure out a good approach so I came up with this horrible code:

if ($page != 1) {

  
  if ($page > 5) {
  
    $sdot = '....';
  
  } else {
  
    $sdot = '';
    
  }
    
  echo '<a href="?page=1" class="page" >First</a>'.$sdot ;

}
  

  if ($page < 5) {
    
    for ($i=1; $i<=5; $i++) {
     
      echo '<a href="?page='.$i.'">'.$i.'</a>';
    
    }
    
  } elseif (($page > 5) && ($page < ($count-5))) {
  
    for ($i=($page-2); $i<=($page+2); $i++) {
    
      echo '<a href="?page='.$i.'">'.$i.'</a>';
        
    }

  } elseif (($page > ($count-7)) && ($page < ($count-2))) {
  
    for ($i=($page-2); $i<=($page+2); $i++) {
    
      echo '<a href="?page='.$i.'">'.$i.'</a>';
        
    }
  
  } else {
  
    for ($i=($page-2); $i<=$count; $i++) {
    
      echo '<a href="?page='.$i.'">'.$i.'</a>';
        
    }
  
  }


if ($page != $count) {

  if ($page < ($count-2)) {
  
    $edot = '....';
  
  } else {
  
    $edot = '';
    
  }

  echo $edot.'<a href="?page='.$count.'" class="page">Last</a>';

}

Source Link

asked Jul 22, 2013 at 19:19

Niket Malik

Pagination Review

I went through lots of tutorial, and almost all of them were quite long, so I came up with my own code:

  $page = $_GET['page'];
  $pg_count = $page-1;
  
  if ($page == 1) {
   
    $start = 0;
  
  } else {
  
    $start = $pg_count*15;
  
  }
  
  $limit = $page*15;
  
  $query = 'SELECT * FROM table LIMIT '.$start.', '.$limit.'';

  foreach($db->query($query) as $row) {
  
    //outputs
    
  }
  
  $stmt = $db->query('SELECT * FROM table'); 
  $row_count = $stmt->rowCount(); 

  $count = ceil($row_count/15);

  for ($i=1; $i<=$count; $i++) {
  
  echo '<a href="?page='.$i.'">'.$i.'</a>';

  }

Here i'm displaying 15 results per page.

This small piece of code seems to do the job (new to pdo, sorry if the method of including parameter is wrong).

So basically my question is, is their a much better way to do this?

php pagination