میشه یه توضیحی بدید نمونه اونو بنویسد بدونم چجوری میگید
از روش pageing و صفحه بندی اسفاده کنم خوبه
$lvl = "public";
@$page = mysql_real_escape_string($_GET['page']);
if(empty($page)){
$page = 1;
}
$start = ($page - 1) * $setting['paged_item'];
if ((isset($_GET['id'])))
{
$catid =mysql_real_escape_string(htmlspecialchars($_GET['id']))+0;
$querypage = mysql_query("SELECT * FROM nafis_product WHERE nafis_product.cat ='$catid' and nafis_product.lvl='$lvl' ORDER BY id ASC LIMIT $start, ".$setting['paged_item']."")
or die(mysql_error());
$total = mysql_query("SELECT * FROM nafis_product WHERE nafis_product.cat ='$catid' and nafis_product.lvl='$lvl' ")
or die(mysql_error());
}else{
$querypage = mysql_query("SELECT * FROM nafis_product WHERE lvl='$lvl' ORDER BY id ASC LIMIT $start, ".$setting['paged_item']."")
or die(mysql_error());
$total = mysql_query("SELECT * FROM nafis_product WHERE lvl='$lvl' ")
or die(mysql_error());
}
while($row = mysql_fetch_array($querypage)){
و بعد از تگ html
$count = mysql_num_rows($total);
if($count - $setting['paged_item'] > 0){
$paged_total = ceil($count / $setting['paged_item']);
$paged_last = $paged_total;
$paged_middle = $page + 4;
$paged_start = $paged_middle - 4;
if($page > 1){
$paged_result = '<div class="paged-link"><a href="vg.php?page=1" title="صفحه نخست">نخست</a></div>'."\n";
}
else{
$paged_result = '<div class="paged-link-off">نخست</div>'."\n";
}
if($page > 1){
$paged_perv = $page - 1;
$paged_result .= '<div class="paged-link"><a href="vg.php?page='.$paged_perv.'" title="صفحه قبلي">قبلي</a></div>'."\n";
}
else{
$paged_result .= '<div class="paged-link-off">قبلي</div>'."\n";
}
for ($i=$paged_start-2; $i<=$paged_middle; $i++){
if ($i > 0 && $i <= $paged_last){
if($i == $page){
$paged_result .= '<div class="paged-link-selected"><a href="vg.php?page='.$i.'" title="صفحه '.$i.'">'.$i.'</a></div>'."\n";
}
else{
$paged_result .= '<div class="paged-link"><a href="vg.php?page='.$i.'" title="صفحه '.$i.'">'.$i.'</a></div>'."\n";
}
}
}
if($page <= $paged_last - 1){
$paged_next = $page + 1;
$paged_result .= '<div class="paged-link"><a href="vg.php?page='.$paged_next.'" title="صفحه بعدي">بعدي</a></div>'."\n";
}
else{
$paged_result .= '<div class="paged-link-off">بعدي</div>'."\n";
}
if($page <= $paged_last - 1){
$paged_result .= '<div class="paged-link"><a href="vg.php?page='.$paged_last.'" title="صفحه آخر">آخر</a></div>'."\n";
}
else{
$paged_result .= '<div class="paged-link-off">آخر</div>'."\n";
}
$paged_result .= '<div class="paged-link-info">» صفحه: '.$page.' از '.$paged_total.'</div>'."\n";
echo $paged_result;
}
else{
echo 'صفحه اي وجود ندارد!'."\n";
}
?>