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
}
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
}