<?php
if(!isset($_GET['page'])){
$page = 1;
} else {
$page = $_GET['page'];
}
$max_results = 5;
$from = (($page * $max_results) - $max_results);
echo "</center>";
// Make a MySQL Connection
$db = mysql_connect("localhost", "dbime", "pass") or die(mysql_error());
mysql_select_db("dbime") or die(mysql_error());
// Get all the data from the "example" table
$result2 = mysql_query("SELECT * FROM guestbook ORDER by id DESC");
$result = mysql_query("SELECT * FROM guestbook ORDER by id DESC LIMIT $from, $max_results ")
or die(mysql_error());
$puno = mysql_num_rows($result2);
$rezult = mysql_num_rows($result2);
echo "<table width=\"100%\" border=\"0\" cellspacing=\"4\" cellpadding=\"0\"><tr><td><div align=\"center\"><a href=\"forma.php\">Upisi se u knjigu gostiju</a> - <a href=\"javascript:self.close();\">Izadi</a> </div></td> </tr> <tr> <td>";
while($row = mysql_fetch_array( $result )) {
// keeps getting the next row until there are no more to get
// Print out the contents of each row into a table
$row['poruka']=str_replace(":)", '<img src="smaj/36_1_1.gif" height="25" width="22,5">', $row['poruka']);
$row['poruka']=str_replace(";)", '<img src="smaj/36_1_2.gif" height="25" width="22,5">', $row['poruka']);
$row['poruka']=str_replace(":D", '<img src="smaj/36_1_13.gif" height="25" width="22,5">', $row['poruka']);
echo "<table width=\"500\" border=\"1\" cellspacing=\"4\" bordercolor=\"#000000\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">";
echo "<tr>";
echo " <td bgcolor=\"#666666\" height=\"20\">";
echo "<span style=\"background:background-color:#666666; color:#FFFFFF;\">";
echo $row['ime'];
echo "</span>";
echo "</td>";
echo "</tr>";
echo "<tr>";
echo " <td height=\"50\">";
echo $row['poruka'];
echo "</td>";
echo "</tr>";
echo "</table>";
}
echo "<div aling=\"center\">Trenutno ima ";
echo $puno;
echo " poruka</div>";
echo "</td> </tr>
</table>";
if(!isset($_GET['page'])){
$page = 1;
} else {
$page = $_GET['page'];
}
$max_results = 5;
$from = (($page * $max_results) - $max_results);
if($page > 1){
$prev = ($page - 1);
echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\">Prijasnjih $max_results</a>";
}
if(5 < $puno){
$next = ($page + 1);
echo "<br><a href=\"".$_SERVER['PHP_SELF']."?page=$next\">Sljedecih $max_results>></a>";
}
echo "</center>";
?>
evo imam taj kod kao index.php mozete ga vidjet u akciji na http://www.razvoj.hostatus.com/prog/index.php i sad vidite da kad kliknete sljedecih 5 da na sljedecoj stranici opet ima sljedecih 5 a prazno?...kako napravit da ako nema na stranici vise od 5 postova da nema linka sljedecih 5?
sljedecih 5 kod =
if(5 < $puno){
$next = ($page + 1);
echo "<br><a href=\"".$_SERVER['PHP_SELF']."?page=$next\">Sljedecih $max_results>></a>";
}