agent31537
یک شنبه 19 آبان 1392, 13:01 عصر
با سلام من با کد زیر در سیستم خود اطلاعات را جدول بندی میکنم اما مشکل اینجاست که هر سلکت را به تعداد 10 ردیف نمایش میده میخوام کل سلکت را که انجام میده به صورت 10 تا 10 تا صفحه بندی کنه به این روش من مثلا اگر 10 sales داشته باشم و 10 body مجموع ردیف صفحه اول من میشه 20 میشه کد را اصلاح کنید که چطوری وقتی بیشتر از 10 تا ردیف شد صفحه دوم ایجاد شود ممنون میشم من بیشتر مشکل در جمع کل query خوانده شده و start و limit دارم
<?php
//مشخصات اختصاصی صفحه جاری
$_SESSION['pages'] ="src.php";
$tbl_name_s = "sales";
$tbl_name_b = "Body";
$tbl_name_h = "havades_Enferadi";
$tbl_name_k = "havades_kanevade";
$tbl_name_f = "fire";
$tbl_name_m = "masoliyat";
$tbl_name_o = "omr";
$tbl_name_G = "havades_Group";
$US = "agent31537";
//کد مربوط به ایجاد ردیف و جدول بندی اطلاعات
$adjacents = 10;
if(($type) == admin){
$sql_s = "SELECT * FROM $tbl_name_s WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_b = "SELECT * FROM $tbl_name_b WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_h = "SELECT * FROM $tbl_name_h WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_k = "SELECT * FROM $tbl_name_k WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_f = "SELECT * FROM $tbl_name_f WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_m = "SELECT * FROM $tbl_name_m WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_o = "SELECT * FROM $tbl_name_o WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_G = "SELECT * FROM $tbl_name_G WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC ";}
else{
$sql_s = "SELECT * FROM $tbl_name_s WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_b = "SELECT * FROM $tbl_name_b WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_h = "SELECT * FROM $tbl_name_h WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_k = "SELECT * FROM $tbl_name_h WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_f = "SELECT * FROM $tbl_name_f WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_m = "SELECT * FROM $tbl_name_m WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_o = "SELECT * FROM $tbl_name_o WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_G = "SELECT * FROM $tbl_name_G WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC ";}
$res_s = mysql_query($sql_s);
$res_b = mysql_query($sql_b);
$res_h = mysql_query($sql_h);
$res_k = mysql_query($sql_k);
$res_f = mysql_query($sql_f);
$res_m = mysql_query($sql_m);
$res_o = mysql_query($sql_o);
$res_G = mysql_query($sql_G);
$query_s = mysql_num_rows($res_s);
$query_b = mysql_num_rows($res_b);
$query_h = mysql_num_rows($res_h);
$query_k = mysql_num_rows($res_k);
$query_f = mysql_num_rows($res_f);
$query_m = mysql_num_rows($res_m);
$query_o = mysql_num_rows($res_o);
$query_G = mysql_num_rows($res_G);
$query = $query_s+$query_b+$query_h+$query_f+$query_m+$quer y_o+$query_G;
$targetpage = "view.php";
$limit = 10;
$page = $_GET['page'];
if($page)
$start = ($page - 1) * $limit;
else
$start = 0;
if(($type) == admin){
$sql_s = "SELECT * FROM $tbl_name_s WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_b = "SELECT * FROM $tbl_name_b WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_h = "SELECT * FROM $tbl_name_h WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_k = "SELECT * FROM $tbl_name_k WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_f = "SELECT * FROM $tbl_name_f WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_m = "SELECT * FROM $tbl_name_m WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_o = "SELECT * FROM $tbl_name_o WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_G = "SELECT * FROM $tbl_name_G WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";}
else{
$sql_s = "SELECT * FROM $tbl_name_s WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_b = "SELECT * FROM $tbl_name_b WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_h = "SELECT * FROM $tbl_name_h WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_k = "SELECT * FROM $tbl_name_k WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_f = "SELECT * FROM $tbl_name_f WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_m = "SELECT * FROM $tbl_name_m WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_o = "SELECT * FROM $tbl_name_o WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_G = "SELECT * FROM $tbl_name_G WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit";}
if ($page == 0) $page = 1;
$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($query/$limit);
$lpm1 = $lastpage - 1;
$pagination = '';
if($lastpage > 1){
$pagination.= "<div class=pagination>";
//کلید قبلی
if ($page > 1)
$pagination.= "<a href='$targetpage?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='$targetpage?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='$targetpage?page=$counter'>$counter</a>";}
$pagination.= "...";
$pagination.= "<a href='$targetpage?page=$lpm1'>$lpm1</a>";
$pagination.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";}}
elseif(($lastpage - ($adjacents * 2) > $page) and ($page > ($adjacents * 2))){
$pagination.= "<a href='$targetpage?page=1'>1</a>";
$pagination.= "<a href='$targetpage?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='$targetpage?page=$counter'>$counter</a>";}
$pagination.= "...";
$pagination.= "<a href='$targetpage?page=$lpm1'>$lpm1</a>";
$pagination.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";}
else{
$pagination.= "<a href='$targetpage?page=1'>1</a>";
$pagination.= "<a href='$targetpage?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='$targetpage?page=$counter'>$counter</a>";}}
//کلید بعدی
if ($page < $counter - 1)
$pagination.= "<a href='$targetpage?page=$next'>next »</a>";
else
$pagination.= "<span class='disabled'>next »</span>";
$pagination.= "</div>";
}
?>
<br>
<div align="center"><?php echo $pagination; ?></div>
<br>
<?php
//مشخصات اختصاصی صفحه جاری
$_SESSION['pages'] ="src.php";
$tbl_name_s = "sales";
$tbl_name_b = "Body";
$tbl_name_h = "havades_Enferadi";
$tbl_name_k = "havades_kanevade";
$tbl_name_f = "fire";
$tbl_name_m = "masoliyat";
$tbl_name_o = "omr";
$tbl_name_G = "havades_Group";
$US = "agent31537";
//کد مربوط به ایجاد ردیف و جدول بندی اطلاعات
$adjacents = 10;
if(($type) == admin){
$sql_s = "SELECT * FROM $tbl_name_s WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_b = "SELECT * FROM $tbl_name_b WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_h = "SELECT * FROM $tbl_name_h WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_k = "SELECT * FROM $tbl_name_k WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_f = "SELECT * FROM $tbl_name_f WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_m = "SELECT * FROM $tbl_name_m WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_o = "SELECT * FROM $tbl_name_o WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_G = "SELECT * FROM $tbl_name_G WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC ";}
else{
$sql_s = "SELECT * FROM $tbl_name_s WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_b = "SELECT * FROM $tbl_name_b WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_h = "SELECT * FROM $tbl_name_h WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_k = "SELECT * FROM $tbl_name_h WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_f = "SELECT * FROM $tbl_name_f WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_m = "SELECT * FROM $tbl_name_m WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_o = "SELECT * FROM $tbl_name_o WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC ";
$sql_G = "SELECT * FROM $tbl_name_G WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC ";}
$res_s = mysql_query($sql_s);
$res_b = mysql_query($sql_b);
$res_h = mysql_query($sql_h);
$res_k = mysql_query($sql_k);
$res_f = mysql_query($sql_f);
$res_m = mysql_query($sql_m);
$res_o = mysql_query($sql_o);
$res_G = mysql_query($sql_G);
$query_s = mysql_num_rows($res_s);
$query_b = mysql_num_rows($res_b);
$query_h = mysql_num_rows($res_h);
$query_k = mysql_num_rows($res_k);
$query_f = mysql_num_rows($res_f);
$query_m = mysql_num_rows($res_m);
$query_o = mysql_num_rows($res_o);
$query_G = mysql_num_rows($res_G);
$query = $query_s+$query_b+$query_h+$query_f+$query_m+$quer y_o+$query_G;
$targetpage = "view.php";
$limit = 10;
$page = $_GET['page'];
if($page)
$start = ($page - 1) * $limit;
else
$start = 0;
if(($type) == admin){
$sql_s = "SELECT * FROM $tbl_name_s WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_b = "SELECT * FROM $tbl_name_b WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_h = "SELECT * FROM $tbl_name_h WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_k = "SELECT * FROM $tbl_name_k WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_f = "SELECT * FROM $tbl_name_f WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_m = "SELECT * FROM $tbl_name_m WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_o = "SELECT * FROM $tbl_name_o WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_G = "SELECT * FROM $tbl_name_G WHERE `user`!='{$US}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";}
else{
$sql_s = "SELECT * FROM $tbl_name_s WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_b = "SELECT * FROM $tbl_name_b WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_h = "SELECT * FROM $tbl_name_h WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_k = "SELECT * FROM $tbl_name_k WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_f = "SELECT * FROM $tbl_name_f WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_m = "SELECT * FROM $tbl_name_m WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_o = "SELECT * FROM $tbl_name_o WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit ";
$sql_G = "SELECT * FROM $tbl_name_G WHERE `user`='{$user}' AND `newbim`='' ORDER BY `sdate` DESC LIMIT $start,$limit";}
if ($page == 0) $page = 1;
$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($query/$limit);
$lpm1 = $lastpage - 1;
$pagination = '';
if($lastpage > 1){
$pagination.= "<div class=pagination>";
//کلید قبلی
if ($page > 1)
$pagination.= "<a href='$targetpage?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='$targetpage?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='$targetpage?page=$counter'>$counter</a>";}
$pagination.= "...";
$pagination.= "<a href='$targetpage?page=$lpm1'>$lpm1</a>";
$pagination.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";}}
elseif(($lastpage - ($adjacents * 2) > $page) and ($page > ($adjacents * 2))){
$pagination.= "<a href='$targetpage?page=1'>1</a>";
$pagination.= "<a href='$targetpage?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='$targetpage?page=$counter'>$counter</a>";}
$pagination.= "...";
$pagination.= "<a href='$targetpage?page=$lpm1'>$lpm1</a>";
$pagination.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";}
else{
$pagination.= "<a href='$targetpage?page=1'>1</a>";
$pagination.= "<a href='$targetpage?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='$targetpage?page=$counter'>$counter</a>";}}
//کلید بعدی
if ($page < $counter - 1)
$pagination.= "<a href='$targetpage?page=$next'>next »</a>";
else
$pagination.= "<span class='disabled'>next »</span>";
$pagination.= "</div>";
}
?>
<br>
<div align="center"><?php echo $pagination; ?></div>
<br>