Код:
function showTopic($advertid, $showfull=TRUE) {
global $conn;
global $userid;
global $limit;
if (isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = 1;
}
if ($limit == "") $limit = 25;
$start = ($page - 1) * $limit;
$sql = "SELECT SQL_CALC_FOUND_ROWS " .
"advert_id, advert_user, advert_message, advert_type, advert_date, advert_agree " .
"FROM advert_post WHERE advert_id = '$advertid' ";
$result = mysql_query($sql, $conn)
or die(mysql_error() . "<br>" . $sql);
$pagelinks = paginate($limit);
if (mysql_num_rows($result) == 0) {
echo "There are none";
} else {
echo "<table class=\"forumtable\" cellspacing=\"0\" ";
echo "cellpadding=\"2\"><tr>";
echo "<th class=\"author\">Author</th>";
echo "<th class=\"post\">Post</th>";
echo "</tr>";
$rowclass = "";
while ($row = mysql_fetch_array($result)) {
if ($showfull) {
$advert_message = $row['advert_message'];
} else {
$advert_message = trimBody($advert_message);
}
$rowclass = ($rowclass == "row1"?"row2":"row1");
echo "<tr class=\"$rowclass\">";
echo "<td class=\"author\">" . $row['advert_user'];
echo "</td><td class=\"post\"><p>";
if (isset($_GET['page'])) {
$pagelink = "&page=" . $_GET['page'];
} else {
$pagelink = "";
}
echo "<a name=\"post" . $row['id'] .
"\" href=\"viewtopic.php?t=" . $advertid .$pagelink ."#post".
$row['id'] . "\">".POSTLINK."</a>";
if (isset($row['advert_message'])) {
echo " <strong>" . $row['advert_message'] . "</strong>";
}
echo "</p><p>" . (nl2br(htmlspecialchars($advert_message))) . "</p>";
echo $advert_user;
echo "</td></tr>";
echo "<tr class=\"$rowclass\"><td class=\"authorfooter\">";
echo $advert_date . "</td><td class=\"threadfooter\">";
echo "</td></tr>\n";
}
echo "</table>";
echo $pagelinks;
}
}
function paginate($limit=10) {
global $admin;
$sql = "SELECT FOUND_ROWS();";
$result = mysql_query($sql)
or die(mysql_error());
$row = mysql_fetch_array($result);
$numrows = $row[0];
$pagelinks = "<div class=\"pagelinks\">";
if ($numrows > $limit) {
if(isset($_GET['page'])){
$page = $_GET['page'];
} else {
$page = 1;
}
$currpage = $_SERVER['PHP_SELF'] . "?" . $_SERVER['QUERY_STRING'];
$currpage = str_replace("&page=".$page,"",$currpage);
if($page == 1){
$pagelinks .= "<span class=\"pageprevdead\">< PREV</span>";
}else{
$pageprev = $page - 1;
$pagelinks .= "<a class=\"pageprevlink\" href=\"" . $currpage .
"&page=" . $pageprev . "\">< PREV</a>";
}
$numofpages = ceil($numrows / $limit);
$range = $admin['pageRange']['value'];
if ($range == "" or $range == 0) $range = 7;
$lrange = max(1,$page-(($range-1)/2));
$rrange = min($numofpages,$page+(($range-1)/2));
if (($rrange - $lrange) < ($range - 1)) {
if ($lrange == 1) {
$rrange = min($lrange + ($range-1), $numofpages);
} else {
$lrange = max($rrange - ($range-1), 0);
}
}
if ($lrange > 1) {
$pagelinks .= "..";
} else {
$pagelinks .= " ";
}
for($i = 1; $i <= $numofpages; $i++){
if ($i == $page) {
$pagelinks .= "<span class=\"pagenumdead\">$i</span>";
} else {
if ($lrange <= $i and $i <= $rrange) {
$pagelinks .= "<a class=\"pagenumlink\" " .
"href=\"" . $currpage . "&page=" . $i .
"\">" . $i . "</a>";
}
}
}
if ($rrange < $numofpages) {
$pagelinks .= "..";
} else {
$pagelinks .= " ";
}
if(($numrows - ($limit * $page)) > 0){
$pagenext = $page + 1;
$pagelinks .= "<a class=\"pagenextlink\" href=\"" . $currpage .
"&page=" . $pagenext . "\">NEXT ></a>";
} else {
$pagelinks .= "<span class=\"pagenextdead\">NEXT ></span>";
}
} else {
$pagelinks .= "<span class=\"pageprevdead\">< " .
"PREV</span> ";
$pagelinks .= "<span class=\"pagenextdead\"> " .
"NEXT ></span> ";
}
$pagelinks .= "</div>";
return $pagelinks;
}
Код:
<?php
require_once 'conn.php';
require_once 'functions.php';
require_once 'http.php';
if (!isset($_GET['t']));
require_once 'header.php';
$advert_id = $_GET['t'];
showTopic($advertid, TRUE);
require_once 'footer1.php';
?>Ако някой може да помогне или направо да ми каже по лесен начин за следното нещо.
Например: имаме страница и вътре има 50 статии и искаме като щракнем на някоя да излезе само тя на някаква страница(примерно viewadvert.php) , но за да може сами да излизат там да и слага id-то след сайта(примерно viewadvert.php?id=37) и така да излиза на всички