|
|
| Тема |
 Re: Пейджинг за лаици [re: CAШO] |
|
| Автор |
hobbit (dreamer) |
|
| Публикувано | 18.03.07 10:27 |
|
|
|
Пробвай по този начин. Не е най-доброто, но е вариант
<?
//NACHALO NA SKRIPTA ZA IZCHISLQVANE BROQ NA STRANICITE
$display=100;
if (isset($_GET['np'])) {
$num_pages = $_GET['np']; }
else {
$pagingquery = "SELECT COUNT(*) FROM news ORDER BY newsID DESC";
$pagingresult = mysql_query ($pagingquery);
$pagingrow = mysql_fetch_array ($pagingresult, MYSQL_NUM);
$num_records = $pagingrow[0];
if ($num_records > $display) {
$num_pages = ceil ($num_records/$display); }
else {
$num_pages = 1; }
}
if (isset($_GET['offset'])) {
$offset = $_GET['offset']; }
else { $offset = 0; }
//KRAI NA SKRIPTA ZA IZCHISLQVANE BROQ NA STRANICITE
$result = mysql_query("SELECT newsID,header,info,pic from news ORDER BY newsID DESC") or die ("Невъзможно извеждането на новини!");
while ($row = @mysql_fetch_row($result)){
$row[1] = stripslashes($row[1]);
$row[2] = stripslashes($row[2]);
$row[3] = stripslashes($row[3]);
$row[2] = nl2br($row[2]);
$row[2] = short_text($row[2],300);
if ($row[3] == NULL) $row[3] = "stuart.jpg";
echo "<div class=\"main_news\">";
echo "<b><a href=\"?p=news_details&id=$row[0]\">$row[1]</a></b>
";
echo "<a href=\"?p=img_order&id=$row[0]\"><img src=\"img/$row[3]\" width=\"100px\" border=\"0\" style=\"float:left;margin: 10px;\" alt=\"Можете да закупите снимката!\"></a>
";
echo "<p style=\"margin: 10px;\">$row[2]
";
echo "<p align=\"right\"><b><a href=\"?p=news_details&id=$row[0]\">повече</a></b></div>\n";
}
?>
<div>
<?php
//NACHALO NA IZVEJDANETO NA VRUZKITE KUM STRANICITE
if ($num_pages > 1) {
$current_page=($offset/$display)+1;
if ($current_page != 1) {
echo("<a href=\"?p=news_archive&offset=".($offset-$display)."&np=".$num_pages."\">Предишна</a> ");
}
for ($i=1; $i<=$num_pages; $i++) {
if ($i != $current_page) {
echo("<a href=\"?p=news_archive&offset=".(($display * ($i - 1)))."&np=".$num_pages."\">".$i."</a> ");
} else {
echo(" ".$i." ");
}
}
if ($current_page != $num_pages) {
echo("<a href=\"?p=news_archive&offset=".($offset + $display)."&np=".$num_pages."\">Следваща </a>");
}
}
//KRAI NA IZVEJDANETO NA VRUZKITE KUM STRANICITE
?>
</div>
| |
| |
| 
|
|
