Pagination - Kako skratiti duzinu ispisaImam 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>
<?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 !!!
:::===>>> www.DOWNLOAD.ba <<<===::::::===>>> www.DOWNLOAD.co.ba <<<===:::
