Advertisement
Guest User

Untitled

a guest
Feb 25th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.79 KB | None | 0 0
  1. <script type="text/javascript">
  2. var track_page = 1;
  3. load_contents(track_page);
  4.  
  5. $("#load_more_button").click(function (e) {
  6. track_page++;
  7. load_contents(track_page);
  8. });
  9.  
  10. function load_contents(track_page){
  11. $('.animation_image').show();
  12.  
  13. $.post( 'fetch_pages.php', {'page': track_page}, function(data){
  14.  
  15. if(data.trim().length == 0){
  16. $("#load_more_button").text("You have reached end of the record!").prop("disabled", true);
  17. }
  18.  
  19. $("#results").append(data);
  20.  
  21. $('.animation_image').hide();
  22. });
  23. }
  24. </script>
  25.  
  26. $_SESSION['name']=$_GET['name'];
  27. $_SESSION['area']=$_GET['area'];
  28.  
  29. <div class="wrapper">
  30. <div id="results"></div>
  31.  
  32. <button id="load_more_button"><img src="ajax-loader.gif" class="animation_image" style="float:left;"> Load More</button>
  33. </div>
  34.  
  35. include("db.php");
  36. $item_per_page = 10;
  37. $page_number = filter_var($_POST["page"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH);
  38.  
  39. $position = (($page_number-1) * $item_per_page);
  40. $sort="id";
  41. if(isset($_GET['sort'])&&($_GET['sort'])=='ASC'){
  42. $sort="price ASC";
  43. }
  44. elseif(isset($_GET['sort'])&&($_GET['sort'])=='DESC'){
  45. $sort="price DESC";
  46. }
  47. if($_SESSION['area']=='All'){
  48. $stmt = $mysqli->prepare("SELECT * from table where name= ? ORDER BY $sort LIMIT ?,?");
  49. $stmt->bind_param("sdd", $_SESSION['name'], $position, $item_per_page);
  50. }
  51. else{
  52. $stmt = $mysqli->prepare("SELECT * from table where name= ? AND area= ? ORDER BY $sort LIMIT ?,?");
  53. $stmt->bind_param("ssdd", $_SESSION['name'], $_SESSION['area'], $position, $item_per_page);
  54. }
  55. $stmt->execute();
  56. $i=1;
  57. $res = $stmt->get_result();
  58. while($row4=mysqli_fetch_array($res)){
  59. ---------------
  60. ---------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement