[ pijavica. @ 08.02.2014. 19:41 ] @
Da li mozete da mi pomognete oko ovog problema zapoceo sam ali nikako da zavrsim sa problemom. 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'; ?> |