Малко помощ

W

winers

Registered
Използвам кода за странициране

Код: 
<?php
$page = $_GET['page'];
if ($page == 0 || $page == NULL || $page < 0)
{
    $page = 1;
}
$pp = 10; // броя на записите, който ще са на страница
$start = ($page*$pp) - $pp;
$query = mysql_query("SELECT * FROM songs  where id") or die (mysql_error());
$broi = mysql_num_rows($query);
$total = ceil($broi/$pp);
$sql = mysql_query("SELECT * FROM songs where id" .
" ORDER BY id DESC LIMIT $start,$pp") or die (mysql_error());

while($row = mysql_fetch_assoc($sql)){
}
echo "<br />";
echo"<table align=\"center\"><tr>";
if ($page > 1) { 
$prev = ($page - 1); 
echo "<td class='mbord'><a href=\"songs.php?$prev\"></a></td> "; 
} 
else echo ""; 

if (!$page or ($page > $total)) { 
$page="1"; 
} 

if ($total < 10) { 
for($i=1 ; $i<=$total ; $i++) { 
if ( ($page)==$i ) { 
echo "<td class='mbord'>$i</td>"; 
} 
else { 
echo "<td class='mbord'><a href=\"songs.php?".$i."\">".$i."</a></td> "; 
} 
} 
} 
else { 
for($i=1 ; $i<=3 ; $i++) { 
if ( ($page)==$i ) { 
echo "<td class='mbord'>$i</td> "; 
} 
else { 
echo "<td class='mbord'><a href=\"songs.php?".$i."\" >".$i."</a></td> "; 
} 
} 

if ($page <= 3) { 
if ($page == 3) echo " <td class='mbord'> <a href=\"songs.php?4\">4</a></td> "; 
echo " <td class='mbord'>...</td> "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<td class='mbord'><a href=\"songs.php?".$i."\">".$i."</a></td>"; 
} 
if ($page == 5) $parva.= " <td class='mbord'><a href=\"songs.php?4\">4</a></td>"; 

if ( ($page == 4) or ($page == 5) ) { 
for ($i=$page; $i<=$page+1; $i++) { 
if ($page == $i) echo "<td class='mbord'>$i</td> "; 
else echo "<td class='mbord'> <a href=\"songs.php?".$i."\">".$i."</a></td>"; 
} 
echo "<td class='mbord'> ...</td> "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<td class='mbord'><a href=\"songs.php?".$i."\">".$i."</a></td>"; 
} 

if ( ($page > 5) and ($page < ($total - 4)) ) { 
echo " <td class='mbord'>...</td> "; 
for ($i=$page-1; $i<=$page+1; $i++) { 
if ($page == $i) echo "<td class='mbord'>$i</td> "; 
else echo "<td class='mbord'><a href=\"songs.php?".$i."\">".$i."</a></td>"; 
} 
echo " <td class='mbord'> ...</td> "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<td class='mbord'> <a href=\"songs.php?".$i."\">".$i."</a></td> "; 
} 

if ( $page > ($total - 5) ) { 
echo " <td class='mbord'> ... </td>"; 
for ($i=$total-5; $i<=$total; $i++) { 
if ($page == $i) echo "<td class='mbord'> $i</td> "; 
else echo "<td class='mbord'> <a href=\"songs.php?".$i."\">".$i."</a></td> "; 
} 
} 
} 

if ($page < $total) { 
$next = ($page + 1); 
echo "<td class='mbord'>  <a href=\"songs.php?&$next\"></a></td>"; 
} 
print "<tr></table><table align=\"center\"><tr><td class='mbord'>  </td><tr></table>";
?>

Но вижте как ми излиза
http://store.picbg.net/pubpic/FE/A0/0b9371278406fea0.png
Как да махна тези от горе 1 2 а тези от долу в табличките да си останат?
 
Най-добре, използвай това странициране, само си го нагласи. Винаги ползвам него, и ми е доволно! Сложил съм ти и малко обяснения.

[css]<style>
.paginate {
font-family:Arial, Helvetica, sans-serif;
padding: 3px;
margin: 3px;
}

.paginate a {
background-image:url('imgs/paging_a.gif');
padding:2px 5px 2px 5px;
margin:2px;
/* border:1px solid #999;*/
border:1px solid orange;
text-decoration:none;
color: #666;
}
.paginate a:hover, .paginate a:active {
background-image:url('imgs/paging_a_hvr.gif');
border: 1px solid #999;
color: #000;
}
.paginate span.current {
background-image:url('imgs/paging_a_on.gif');
margin: 2px;
padding: 2px 5px 2px 5px;
border: 1px solid #999;

font-weight: bold;
background-color: #999;
color: #FFF;
}
.paginate span.disabled {

padding:2px 5px 2px 5px;
margin:2px;
border:1px solid black;
color:#DDD;
}

</style>[/css]

PHP: 
	 <div class="right_box_middle" style='text-align: center;'>
				<table class="kef-body" style='margin: 0 auto;' border='1' color='cdcdcd'>
				<td class="kef-body" bgcolor="cdcdcd"> Потребител </td> <td class="kef-body" bgcolor="black"> Долари за днес </td> <td class="kef-body" bgcolor="black"> Долари </td> <td class="kef-body" bgcolor="cdcdcd"> Качени </td> <tr />
          <?php
          $tableName = "tablica";
          $targetpage = "stranica.php";
          $limit = 15;
          $orderby="id";
          $stages = 1;

          $query = "SELECT COUNT(*) as num FROM `$tableName`";
          $total_pages = mysql_fetch_array(mysql_query($query));
          $total_pages = $total_pages[num];

          $page = mysql_escape_string($_GET['page']);
          if ($page) {
               $start = ($page - 1) * $limit;
          } else {
               $start = 0;
          }

          // Взима номерирането
          $query1 = "SELECT * FROM `$tableName`  order by `$orderby`  LIMIT $start, $limit";
          $result = mysql_query($query1);
		  
		  $rq = mysql_query("SELECT * FROM `$tableName` ORDER BY `$orderby` DESC limit $start, $limit");
				while($data = mysql_fetch_assoc($rq)) {
				echo "$data[neshtosi]";}
          if ($page == 0) {
               $page = 1;
          }
          $prev = $page - 1;
          $next = $page + 1;
          $lastpage = ceil($total_pages / $limit);
          $LastPagem1 = $lastpage - 1;


          $paginate = '';
          if ($lastpage > 1) {
               $paginate .= "<div class='paginate'>";
               // Предишна
               if ($page > 1) {
                    $paginate.= "<a href='$targetpage?page=$prev'><<</a>";
               } else {
                    $paginate.= "<span class='disabled'><<</span>";
               }



               // Страници
               if ($lastpage < 7 + ($stages * 2)) { // Няма достатъчно за разкъсване
                    for ($counter = 1; $counter <= $lastpage; $counter++) {
                         if ($counter == $page) {
                              $paginate.= "<span class='current'>$counter</span>";
                         } else {
                              $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";
                         }
                    }
               } elseif ($lastpage > 5 + ($stages * 2)) { // Достатъчно за разкъсване
			   
                    if ($page < 1 + ($stages * 2)) {
                         for ($counter = 1; $counter < 4 + ($stages * 2); $counter++) {
                              if ($counter == $page) {
                                   $paginate.= "<span class='current'>$counter</span>";
                              } else {
                                   $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";
                              }
                         }
                         $paginate.= "...";
                         $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
                         $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
                    }

                    elseif ($lastpage - ($stages * 2) > $page && $page > ($stages * 2)) {
                         $paginate.= "<a href='$targetpage?page=1'>1</a>";
                         $paginate.= "<a href='$targetpage?page=2'>2</a>";
                         $paginate.= "...";
                         for ($counter = $page - $stages; $counter <= $page + $stages; $counter++) {
                              if ($counter == $page) {
                                   $paginate.= "<span class='current'>$counter</span>";
                              } else {
                                   $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";
                              }
                         }
                         $paginate.= "...";
                         $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
                         $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
                    }
    
                    else {
                         $paginate.= "<a href='$targetpage?page=1'>1</a>";
                         $paginate.= "<a href='$targetpage?page=2'>2</a>";
                         $paginate.= "...";
                         for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++) {
                              if ($counter == $page) {
                                   $paginate.= "<span class='current'>$counter</span>";
                              } else {
                                   $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";
                              }
                         }
                    }
               }

               // Следваща
               if ($page < $counter - 1) {
                    $paginate.= "<a href='$targetpage?page=$next'>>></a>";
               } else {
                    $paginate.= "<span class='disabled'>>></span>";
               }

               $paginate.= "</div>";
          }
		  ?>
		  </table>
			<?php
          echo $paginate;
          ?>

		  </div>
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе