Po default moze da mi prikaze 20 artikala po stranicu.
Dole sam napravio select option sa ponudjenim brojevima.
Pokusavao sam raznim nacinima kako da kada kliknem broj 10 da mi u pagination prikaze 10 artikla, ili 30 itd.
Ali nisam uspeo.
Da li mozete da mi pomognete oko ovog problema.
Hvala vam.
Code:
<?php
$page = (int) (!isset($_GET["page"]) ? 1 : $_GET["page"]);
$sort = (string) (!isset($_GET["sort"]) ? "" : $_GET["sort"]);
$limit = 20;
//$limit = (int) (!isset($_GET["limit"]) ? 1 : $_GET["limit"]);
$startpoint = ($page * $limit) - $limit;
$article_name = @$_GET['article'];
if ($article_name == '' || $article_name == ' ') {
// generate error message
echo '<div class="alert alert-danger">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
<b>ERROR: Sorry, Please fill in all required fields!</b></br></br>
1. Try more general words.</br>2. Try different words with similar meaning</br></div>';
exit();
}
$total = mysql_query("SELECT name_article FROM article WHERE keywords LIKE '%$article_name%' AND active=1");
//to make pagination
$sqlOrder = "";
if (isset($_GET['article']) AND $_GET['article'] != '') {
if($sort == "asc") {
$sqlOrder = "ORDER BY article.price ASC";
} else if($sort == "desc") {
$sqlOrder = "ORDER BY article.price DESC";
}
$statement = "WHERE keywords LIKE '%$article_name%' AND active = 1";
$url = '?article=' . $article_name . '&sort=' . $sort . '&';
$search_query = $article_name;
echo "<div class=\"searchText\" style='width:200px;'>Search</div>
<div style='float:left;'>There are is matching result for <b>$search_query</b>.</div>
<div style='float:right;'>
<a href='search.php?article=$article_name&sort=asc'>Od jeftinije</a> /
<a href='search.php?article=$article_name&sort=desc'>Od najskuplje</a>
<select name='limit'>
<option value='10'>10</option>
<option value='20'>20</option>
<option value='30'>30</option>
<option value='ovo ne znam sta da stavim'>All</option>
</select>
</div><hr />";
} else {
$statement = "WHERE active = 1";
$url = '?';
}
//show records
$query = mysql_query("SELECT article.name_article, article.info_article, article.price, article.datum, pic_article.pic_mala FROM article
LEFT JOIN pic_article ON pic_article.pic_article_id=article.pic_article_id {$statement} {$sqlOrder} LIMIT {$startpoint} , {$limit}");
$foundnum = mysql_num_rows($total); //TOTAL NUMBER OF RESULTS
include 'includes/overall/footer.php'; ?>
<?php
$page = (int) (!isset($_GET["page"]) ? 1 : $_GET["page"]);
$sort = (string) (!isset($_GET["sort"]) ? "" : $_GET["sort"]);
$limit = 20;
//$limit = (int) (!isset($_GET["limit"]) ? 1 : $_GET["limit"]);
$startpoint = ($page * $limit) - $limit;
$article_name = @$_GET['article'];
if ($article_name == '' || $article_name == ' ') {
// generate error message
echo '<div class="alert alert-danger">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
<b>ERROR: Sorry, Please fill in all required fields!</b></br></br>
1. Try more general words.</br>2. Try different words with similar meaning</br></div>';
exit();
}
$total = mysql_query("SELECT name_article FROM article WHERE keywords LIKE '%$article_name%' AND active=1");
//to make pagination
$sqlOrder = "";
if (isset($_GET['article']) AND $_GET['article'] != '') {
if($sort == "asc") {
$sqlOrder = "ORDER BY article.price ASC";
} else if($sort == "desc") {
$sqlOrder = "ORDER BY article.price DESC";
}
$statement = "WHERE keywords LIKE '%$article_name%' AND active = 1";
$url = '?article=' . $article_name . '&sort=' . $sort . '&';
$search_query = $article_name;
echo "<div class=\"searchText\" style='width:200px;'>Search</div>
<div style='float:left;'>There are is matching result for <b>$search_query</b>.</div>
<div style='float:right;'>
<a href='search.php?article=$article_name&sort=asc'>Od jeftinije</a> /
<a href='search.php?article=$article_name&sort=desc'>Od najskuplje</a>
<select name='limit'>
<option value='10'>10</option>
<option value='20'>20</option>
<option value='30'>30</option>
<option value='ovo ne znam sta da stavim'>All</option>
</select>
</div><hr />";
} else {
$statement = "WHERE active = 1";
$url = '?';
}
//show records
$query = mysql_query("SELECT article.name_article, article.info_article, article.price, article.datum, pic_article.pic_mala FROM article
LEFT JOIN pic_article ON pic_article.pic_article_id=article.pic_article_id {$statement} {$sqlOrder} LIMIT {$startpoint} , {$limit}");
$foundnum = mysql_num_rows($total); //TOTAL NUMBER OF RESULTS
include 'includes/overall/footer.php'; ?>