[ Cuchulainn @ 15.08.2007. 18:35 ] @
Treba mi stranicenje ispisa iz baze kao kod Googla.... Sledeca skripta izbacuje sve strane ali ne kao kod google-a...Sta josh treba da dodam... Code: function guestbook_prikaz(){ //Stranichenje $guestbook_limit = 10; if(!isset($_GET['str']) || empty($_GET['str']) || $_GET['str'] == 1){ $str = 1; $prvilimit = 0; $limit = $prvilimit.",".$guestbook_limit; $limitd = $_GET['str']-5; $limitg = $_GET['str']+5; $limitu = $limitd.", ".$limitg; echo 'LIMIT='.$limitu; } else { $str = $_GET['str']; $poslednjilimit = $_GET['str'] * $guestbook_limit; $prvilimit = $poslednjilimit-$guestbook_limit; $limit = $prvilimit.",".$guestbook_limit; $gp = $ipage + 5; $dp = $ipage - 5; $limitd = $_GET['str']-5; $limitg = $_GET['str']+5; $limitu = $limitd.",".$limitg; echo 'LIMIT='.$limitu; } //kraj stranicenja //prikaz guestbook-a $db = konekcija(); $upit = "SELECT autor, mesto, email, DATE_FORMAT(datum, '%d/%m/%Y, %H:%i:%s') as formatiran_datum, komentar, dozvola FROM guestbook WHERE dozvola=1 ORDER BY id DESC LIMIT $limit"; $rezultat = mysql_query($upit, $db); while($red = mysql_fetch_array($rezultat)){ echo '<table class="tbl_guestbook">'; echo '<tr>'; if($red["formatiran_datum"]!="00/00/0000, 00:00:00"){ echo '<td><b>'.$red["formatiran_datum"].'</b></td>'; }else{ echo '<td><b>Nepoznat datum i vreme upisa</b></td>'; } echo '</tr>'; echo '<tr>'; echo '<td><em>'.$red["komentar"].'</em></td>'; echo '</tr>'; echo '<tr>'; echo '<td align="right"><a href="mailto:'.$red["email"].'">'.$red["autor"].'</a>, '.$red["mesto"].'</td>'; echo '</tr>'; echo '</table>'; } //kraj prikaza guestbook-a //stranicenje echo '<center>'; $upit1 = "SELECT * FROM guestbook WHERE dozvola=1"; echo $upit1.'<br>'; $broj_redova = mysql_num_rows(mysql_query($upit1)); $pom = ($_GET["str"] - 0); $back = $pom - 1; $next = $pom + 1; if($back >0) { echo "<span class='strane'><a href='".$_SERVER['PHP_SELF']."?str=".$back."'> Prethodna </a></span>"; } $s=0; for($i=0;$i<=$broj_redova;$i=$i+$guestbook_limit) { $lasti = $i+$guestbook_limit; $ipage = $lasti/$guestbook_limit; if($ipage<>$pom){ echo "<span class='strane'><a href='".$_SERVER['PHP_SELF']."?str=".$ipage."'> ".$ipage." </a></span>"; $s++; } else { echo "<span class='strane_active'>".$ipage."</span>"; $s++; } if($i+$guestbook_limit <= $broj_redova) { echo " "; } } if($next <= $s) { echo "<span class='strane'><a href='".$_SERVER['PHP_SELF']."?str=".$next."'> Sledeća </a></span>"; } echo '</center>'; //Kraj stranichenja } |