PDA

View Full Version : مبتدی: صفحه بندی در php



iranarze
دوشنبه 02 دی 1392, 22:48 عصر
با سلام
دوستان عزیز من یه مشکلی دارم که ممنون میشم راهنمایی کنید.
مشکل در ایجاد صفحه بندی سایت در قسمت دسته ها است البته 10 پست رو نشون میده ولی صفحه بندی زیر پست ها رو نشون نمیده وقتی دستی صفحه رو تغییر میدم درست کار میکنه
یه نکته هم اضافه کنم صفحه بندی در صفحه اول به درستی کار میکنه.
کد قسمت های مرتبط رو میذارم . ممنون
کد جهت فراخوانی


<?php if(isset($_GET['page']))
echo userSide_show_all_category_product($_GET['cid'],$_GET['page'] - 1);
else
echo userSide_show_all_category_product($_GET['cid'],0);
?>


................................



function userSide_show_all_best_product($page){

$page = my_values($page);

$startPage = $page * 10;
$endPage = $startPage + 10;

$query = "SELECT * FROM `product` WHERE `is_best` = 1 AND `delete` = '0' ORDER BY `add_date` DESC LIMIT $startPage,$endPage";


$table = " <div id='body-left'>
<div class='body-top'></div>
<div class='body-tl'></div>
<div class='body-tr'></div>
<div class='body-left'></div>
<div class='body-right'></div>
<div class='body-bl'></div>
<div class='body-br'></div>
<div class='body-bottom'></div>
<div class='body-arrow'></div>
<div class='body-center'>
<h2>".__ALLBESTBOOKLIST."</h2>
<div id='body-content'>";


connect_db();

$result = mysql_query($query) or die("Query failed:".mysql_error());

$count = 0;

while($line = mysql_fetch_array($result))
{
$count++;
$table .= "<div class='content-item'>";
$table .= "<img src='images/product/".$line['picture']."' />";
$table .= "<h3>".$line['title']."</h3>";
$table .= "<p>".$line['small_description']."</p>";
$table .= "<div class='product_buttons'>";
$table .= "<a href='buy_product_step2.php?pid=".$line['product_id']."' class='readMore'>".__BUYPRODUCT."</a>";
$table .= "<a href='product_detaile.php?pid=".$line['product_id']."' class='readMore'>".__READMOREPRODUCT."</a>";
$table .= "</div>";
$table .= "</div>";
}


$table .= "</div></div></div>";
$allItem = count_all_is_best_product();
if($allItem > 10){
$pageCount = $allItem / 10;
$pageCount = ceil($pageCount);
$table .= "<div id='pagation'>
<ul>";
for($i = 1; $i <= $pageCount; $i++)
$table .= "<li><a href='?page=$i'>$i</a></li>";
$table .= " </ul>
</div>";
}

mysql_free_result($result);

connect_close();

if($count > 0){
return $table;
} else {
return " <div id='body-left'>
<div class='body-top'></div>
<div class='body-tl'></div>
<div class='body-tr'></div>
<div class='body-left'></div>
<div class='body-right'></div>
<div class='body-bl'></div>
<div class='body-br'></div>
<div class='body-bottom'></div>
<div class='body-arrow'></div>
<div class='body-center'>
<h2>".__ALLBESTBOOKLIST."</h2>
<div id='body-content'>
<div class='warningbox' align='center'>". __NOPRODUCT ."</div>
</div></div></div>";
}

}

function userSide_show_all_category_product($category_id,$p age){

$page = my_values($page);
$category_id = my_values($category_id);

$startPage = $page * 10;
$endPage = $startPage + 10;

$query = "SELECT * FROM `product` WHERE `product_category_id` = '$category_id' AND `delete` = '0' ORDER BY `add_date` DESC LIMIT $startPage,$endPage";


$table = " <div id='body-left'>
<div class='body-top'></div>
<div class='body-tl'></div>
<div class='body-tr'></div>
<div class='body-left'></div>
<div class='body-right'></div>
<div class='body-bl'></div>
<div class='body-br'></div>
<div class='body-bottom'></div>
<div class='body-arrow'></div>
<div class='body-center'>
<h2>لیست کتاب ها</h2>
<div id='body-content'>";


connect_db();

$result = mysql_query($query) or die("Query failed:".mysql_error());

$count = 0;

while($line = mysql_fetch_array($result))
{
$count++;
$table .= "<div class='content-item'>";
$table .= "<img src='images/product/".$line['picture']."' />";
$table .= "<h3>".$line['title']."</h3>";
$table .= "<p>".$line['small_description']."</p>";
$table .= "<div class='product_buttons'>";
$table .= "<a href='buy_product_step2.php?pid=".$line['product_id']."' class='readMore'>".__BUYPRODUCT."</a>";
$table .= "<a href='product_detaile.php?pid=".$line['product_id']."' class='readMore'>".__READMOREPRODUCT."</a>";
$table .= "</div>";
$table .= "</div>";
}


$table .= "</div></div></div>";
$allItem = count_all_category_product();
if($allItem > 10){
$pageCount = $allItem / 10;
$pageCount = ceil($pageCount);
$table .= "<div id='pagation'>
<ul>";
for($i = 1; $i <= $pageCount; $i++)
$table .= "<li><a href='?page=$i'>$i</a></li>";
$table .= " </ul>
</div>";
}

mysql_free_result($result);

connect_close();

if($count > 0){
return $table;
} else {
return " <div id='body-left'>
<div class='body-top'></div>
<div class='body-tl'></div>
<div class='body-tr'></div>
<div class='body-left'></div>
<div class='body-right'></div>
<div class='body-bl'></div>
<div class='body-br'></div>
<div class='body-bottom'></div>
<div class='body-arrow'></div>
<div class='body-center'>
<h2>".__ALLBESTBOOKLIST."</h2>
<div id='body-content'>
<div class='warningbox' align='center'>". __NOPRODUCT ."</div>
</div></div></div>";
}

}

function count_all_is_best_product(){

$query = "SELECT COUNT(*) FROM `product` WHERE `is_best` = '1' AND `delete` = '0'";
$result = mysql_query($query) or die("Query failed:".mysql_error());
$line = mysql_fetch_row($result);

if($line[0])
$line = $line[0];
else
$line = 0;
return $line;

}

function count_all_category_product($category_id){

$query = "SELECT COUNT(*) FROM `product` WHERE `product_category_id` = '$category_id' AND `delete` = '0'";
$result = mysql_query($query) or die("Query failed:".mysql_error());
$line = mysql_fetch_row($result);

if($line[0])
$line = $line[0];
else
$line = 0;
return $line;

}