[ dizaster @ 15.05.2005. 21:54 ] @
Code: <?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 = Code: if(5 < $puno){ $next = ($page + 1); echo "<br><a href=\"".$_SERVER['PHP_SELF']."?page=$next\">Sljedecih $max_results>></a>"; } |