si hago una consulta especifica me muestra los registros bien pero las paginas de todos los registros aunque no esten ay me explico?
trate de encontra la solucion pero pues nada de nada, espero me puede ayudar, gracias...
Código PHP:
Ver original<?php
require_once ('pagination.php');
//connect to the mysql
$db = mysql_connect('localhost', 'user', 'password') or
die("Could not connect database");
$page = (int
) (!isset($_GET["page"]) ?
1 : $_GET["page"]); $page = ($page == 0 ? 1 : $page);
$perpage = 5;//limit in each page
$startpoint = ($page * $perpage) - $perpage;
$sql = mysql_query("select * FROM archivos WHERE COLORES='VERDE' order by id desc LIMIT $startpoint,$perpage");
?>
pagination.php
Código PHP:
Ver original<?php
/**
* @author Jooria Refresh Your Website <www.jooria.com>
* @copyright 2010
*/
function Pages($tbl_name,$limit,$path)
{
$query = "SELECT COUNT(*) as num FROM $tbl_name";
$total_pages = $row['num'];
$adjacents = "2";
$page = (int
) (!isset($_GET["page"]) ?
1 : $_GET["page"]); $page = ($page == 0 ? 1 : $page);
if($page)
$start = ($page - 1) * $limit;
else
$start = 0;
$sql = "SELECT id FROM $tbl_name LIMIT $start, $limit";
$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($total_pages/$limit); $lpm1 = $lastpage - 1;
$pagination = "";
if($lastpage > 1)
{
$pagination .= "<div class='pagination'>";
if ($page > 1)
$pagination.= "<a href='".$path."page=$prev'>‹ Previous</a>";
else
$pagination.= "<span class='disabled'>‹ Previous</span>";
if ($lastpage < 7 + ($adjacents * 2))
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class='current'>$counter</span>";
else
$pagination.= "<a href='".$path."page=$counter'>$counter</a>";
}
}
elseif($lastpage > 5 + ($adjacents * 2))
{
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination.= "<span class='current'>$counter</span>";
else
$pagination.= "<a href='".$path."page=$counter'>$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href='".$path."page=$lpm1'>$lpm1</a>";
$pagination.= "<a href='".$path."page=$lastpage'>$lastpage</a>";
}
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination.= "<a href='".$path."page=1'>1</a>";
$pagination.= "<a href='".$path."page=2'>2</a>";
$pagination.= "...";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<span class='current'>$counter</span>";
else
$pagination.= "<a href='".$path."page=$counter'>$counter</a>";
}
$pagination.= "..";
$pagination.= "<a href='".$path."page=$lpm1'>$lpm1</a>";
$pagination.= "<a href='".$path."page=$lastpage'>$lastpage</a>";
}
else
{
$pagination.= "<a href='".$path."page=1'>1</a>";
$pagination.= "<a href='".$path."page=2'>2</a>";
$pagination.= "..";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class='current'>$counter</span>";
else
$pagination.= "<a href='".$path."page=$counter'>$counter</a>";
}
}
}
if ($page < $counter - 1)
$pagination.= "<a href='".$path."page=$next'>Next ›</a>";
else
$pagination.= "<span class='disabled'>Next ›</span>";
$pagination.= "</div>\n";
}
return $pagination;
}
?>