Si quieres puedes usar tambien este
Código PHP:
<?php
class paginationClass{
var $page_num = 1;
var $page_pagination;
var $r_comment;
var $row_num;
var $numofpages;
var $range_min;
var $range_max;
var $page_min;
var $page_max;
var $range;
var $rowsPerPage;
var $s_comment;
var $s_comment_n;
function paginationClass($r, $rPP, $sc, $scn){
$this->range = $r;
$this->rowsPerPage = $rPP;
$this->s_comment = $sc;
$this->s_comment_n = $scn;
}
private function setComment(){
$this->page_num = (empty($this->page) ? $this->page_num : $this->page);
$offset = ($this->page_num - 1) * $this->rowsPerPage;
$this->s_comment = $this->s_comment . " LIMIT $offset, " . $this->rowsPerPage;
$this->r_comment = mysql_query($this->s_comment) or die(mysql_error());
$r_comment_n = mysql_query($this->s_comment_n) or die(mysql_error());
$this->row_num = mysql_num_rows($r_comment_n);
}
private function setValues(){
$this->numofpages = ceil($this->row_num/$this->rowsPerPage);
if($this->numofpages > 1){
$this->range_min = ($this->range % 2 == 0) ? ($this->range / 2) -1 : ($this->range - 1) / 2;
$this->range_max = ($this->range % 2 == 0) ? $this->range_min + 1 : $this->range_min;
$this->page_min = $this->page_num - $this->range_min;
$this->page_max = $this->page_num + $this->range_max;
$this->page_min = ($this->page_min < 1) ? 1 : $this->page_min;
$this->page_max = ($this->page_max < ($this->page_min + $rthis->ange - 1)) ? $this->page_min + $this->range - 1 : $this->page_max;
if ($this->page_max > $this->numofpages){
$this->page_min = ($this->page_min > 1) ? $this->numofpages - $this->range + 1 : 1;
$this->page_max = $this->numofpages;
}
$this->page_min = ($this->page_min < 1) ? 1 : $this->page_min;
}
}
private function setPagePagination(){
$self = $_SERVER["PHP_SELF"];
if($this->numofpages > 1){
$setPP = "<div>";
//[ « ]
if (($this->page_num > ($this->range - $this->range_min)) && ($this->numofpages > $this->range)){
$setPP .= "[ <a title='First' href='".$self."?page=1' class='title'><b>«</b></a> ]\n";
}
// [ Previous # ]
if ($this->page_num != 1) {
$setPP .= "[ <a title='First' href='".$self."?page=".($this->page_num-1)."' class='title'><b>Anteriores " . $this->rowsPerPage . "</b></a> ]\n";
}
// ...
if (($this->page_num > ($this->range - $this->range_min)) && ($this->numofpages > $this->range)){
$setPP .= " <b>...</b> ";
}
// [ # ]
for ($i = $this->page_min; $i <= $this->page_max; $i++) {
if ($i == $this->page_num)
$setPP .= "[ <b><font color=red>" . $i . "</font></b> ]\n";
else
$setPP .= "[ <a href='" .$self. "?page=" .$i. "' class='title'>".$i."</a> ]\n";
}
// ...
if (($this->page_num< ($this->numofpages - $this->range_max)) && ($this->numofpages > $this->range)) {
$setPP .= " <b>...</b> ";
}
//[ Next # ]
if ($this->page_num < $this->numofpages) {
$setPP .= "[ <a href='".$self."?page=".($this->page_num + 1) . "' class='title'><b>Siguientes " . $this->rowsPerPage . "</b></a> ]\n";
}
//[ » ]
if (($this->page_num< ($this->numofpages - $this->range_max)) && ($this->numofpages > $this->range)) {
$setPP .= "[ <a title='Last Info' href='".$self."?page=".$this->numofpages. "' class='title'><b>»</b></a> ]\n";
}
$setPP .= "</div>";
$this->page_pagination = $setPP;
}
}
function getPagePagination(){
$this->setComment();
$this->setValues();
$this->setPagePagination();
return array('r_comment' => $this->r_comment,
'row_num' => $this->row_num,
'page_pagination' => $this->page_pagination);
}
}
function pagination($r, $rPP, $sc, $scn){
$p = new paginationClass($r, $rPP, $sc, $scn);
foreach($p->getPagePagination() as $k => $v){
if(trim($v)){
global $$k;
$$k = $v;
}
}
}
?>
Código PHP:
sql_que_quiero_verificar = "SELECT * FROM TABLA";
$sql_que_verificara_numero_de_lineas = "SELECT * FROM TABLA";
/*
El primero es para que me muestre el rango que quiero mostrar
El segundo es para que me muestre cuantos "Rows" quiero que muestre
El tercero es mi sql principal
El cuarto es para ver cuantos "Rows" tiene la tabla seleccionada
*/
pagination(10, 10, $sql_que_quiero_verificar, $sql_que_verificara_numero_de_lineas);
while($row = mysql_fetch_assoc($r_comment)){
//codigo que quieras usar
echo $page_pagination;
}
Usa el mas que te guste