Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <script type="text/javascript">
- var track_page = 1;
- load_contents(track_page);
- $("#load_more_button").click(function (e) {
- track_page++;
- load_contents(track_page);
- });
- function load_contents(track_page){
- $('.animation_image').show();
- $.post( 'fetch_pages.php', {'page': track_page}, function(data){
- if(data.trim().length == 0){
- $("#load_more_button").text("You have reached end of the record!").prop("disabled", true);
- }
- $("#results").append(data);
- $('.animation_image').hide();
- });
- }
- </script>
- $_SESSION['name']=$_GET['name'];
- $_SESSION['area']=$_GET['area'];
- <div class="wrapper">
- <div id="results"></div>
- <button id="load_more_button"><img src="ajax-loader.gif" class="animation_image" style="float:left;"> Load More</button>
- </div>
- include("db.php");
- $item_per_page = 10;
- $page_number = filter_var($_POST["page"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH);
- $position = (($page_number-1) * $item_per_page);
- $sort="id";
- if(isset($_GET['sort'])&&($_GET['sort'])=='ASC'){
- $sort="price ASC";
- }
- elseif(isset($_GET['sort'])&&($_GET['sort'])=='DESC'){
- $sort="price DESC";
- }
- if($_SESSION['area']=='All'){
- $stmt = $mysqli->prepare("SELECT * from table where name= ? ORDER BY $sort LIMIT ?,?");
- $stmt->bind_param("sdd", $_SESSION['name'], $position, $item_per_page);
- }
- else{
- $stmt = $mysqli->prepare("SELECT * from table where name= ? AND area= ? ORDER BY $sort LIMIT ?,?");
- $stmt->bind_param("ssdd", $_SESSION['name'], $_SESSION['area'], $position, $item_per_page);
- }
- $stmt->execute();
- $i=1;
- $res = $stmt->get_result();
- while($row4=mysqli_fetch_array($res)){
- ---------------
- ---------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement