Im implementing friendly url in my website.
Some pages working correctly, but i cant implement the pagination.
i want the friendly url pagination like this "website/categoria/categoriaid/p/number"
can anyone help me?
Follow my codes
code for pagination, work correctly without friendly url
Code: Select all
require_once 'conexao.php';
$ref=(int)$_GET['idcat'];
$p = $_GET['p'];
if(isset($p)) { $p = $p; } else { $p = 1; }
$qnt = 12;
$inicio = ($p*$qnt) - $qnt;
$sql_select = "SELECT p.*,
c.nome_categoria
FROM produtos p, categorias c
WHERE c.id_categoria = p.id_categoria
AND p.status = 'A'
AND p.id_categoria = $ref
ORDER BY p.nota +0 DESC LIMIT $inicio, $qnt";
$sql_query = mysql_query($sql_select);
$sql_select_all = "SELECT p.*, c.* FROM produtos p, categorias c where p.id_categoria = c.id_categoria AND p.id_categoria = $ref";
$sql_query_all = mysql_query($sql_select_all);
$total_registros = mysql_num_rows($sql_query_all);
$pags = ceil($total_registros/$qnt);
$max_links = 5;
$url = "http://localhost/qmmamigavel/categoria/$ref";
echo '<div class="boxpg">';
echo '<a href="'.$url . '&p=1" target="_self">Primeira</a> ';
for($i = $p-$max_links; $i <= $p-1; $i++) {
if($i <=0) {
}
else {
echo '<a href="'.$url . '&p='.$i.'" >'.$i.'</a> ';
}
}
echo '<span class="current">' .$p." ";'</span>';
for($i = $p+1; $i <= $p+$max_links; $i++) {
if($i > $pags){
}
else { echo '<a href="'.$url . '/p/'.$i.'" >'.$i.'</a> ';
}
}
echo '<a href="'.$url . '&p='.$pags.'" >Ultima</a> ';
Code: Select all
RewriteRule ^categoria/(\d+).*$ view/exibe.php?idcat=$1
Thanks.