[ b0sAnChE @ 29.06.2009. 15:33 ] @
Pozdrav! Imam sljedecu funkciju za Pagination na sajtu: Code: <?php global $upit; $t = mysql_query("SELECT * FROM naslov WHERE naziv = '$upit' ORDER BY id DESC"); if(!$t) die(mysql_error()); $a = mysql_fetch_object($t); $total_items = mysql_num_rows($t); $limit = $_GET['limit']; $type = $_GET['type']; $page = $_GET['page']; //set default if: $limit is empty, non numerical, less than 10, greater than 50 if((!$limit) || (is_numeric($limit) == false) || ($limit < 10) || ($limit > 50)) { $limit = 5; //default } //set default if: $page is empty, non numerical, less than zero, greater than total available if((!$page) || (is_numeric($page) == false) || ($page < 0) || ($page > $total_items)) { $page = 1; //default } //calcuate total pages $total_pages = ceil($total_items / $limit); $set_limit = $page * $limit - ($limit); //query: **EDIT TO YOUR TABLE NAME, ECT. $q = mysql_query("SELECT * FROM naslov WHERE naziv = '$upit' ORDER BY id DESC LIMIT $set_limit, $limit"); if(!$q) die(mysql_error()); $err = mysql_num_rows($q); if($err == 0) die("Nema rezultata."); //Results per page: **EDIT LINK PATH** echo("<p><h5>Prikazi <b><a href='ispis.php?podkategorija=$podkategorija&limit=10&page=1'>10</a> | <a href='ispis.php?podkategorija=$podkategorija&limit=25&page=1'>25</a> | <a href='ispis.php?podkategorija=$podkategorija&limit=50&page=1'>50</a></b> po stranici</h5></p>"); while($code = mysql_fetch_array($q)) { $naziv = $code['naziv']; $opis = $code['opis']; $id = $code['id']; echo"<h2><a href='/$naziv-artikal-$id.php' target ='_blank'>$naziv</a></h2><p>$opisprograma</p>"; } ?> <p> <div class="pagination"> <?php $prev_page = $page - 1; if($prev_page >= 1) { echo("<a href='ispis.php?podkategorija=$podkategorija&limit=$limit&page=$prev_page' class='prev'>« Prethodna</a>"); } //Display middle pages: **EDIT LINK PATH** for($a = 1; $a <= $total_pages; $a++) { if($a == $page) { echo("<span class='current'>$a</span>"); //no link } else { echo("<a href='ispis.php?podkategorija=$podkategorija&limit=$limit&page=$a'>$a</a>"); } } //next page: **EDIT THIS LINK PATH** $next_page = $page + 1; if($next_page <= $total_pages) { echo("<a href='ispis.php?podkategorija=$podkategorija&limit=$limit&page=$next_page' class='next'>Slijedeca »</a>"); } ///////////////// ?></div> Ono sto dobijem putem ove funkcije je sljedece: Prethodna 1 2 3 4 5 6 7 8 9 10 Sljedeca (Ovakakav ispis , pagination) Zanima me da li se ovo moze preurediti tako da dobijem nesto poput ovoga: Prethodna 1 2 3 ... 8 9 10 Hvala svima unaprijed !!! |