load more with jquery

load more with jquery

i am using jquery to loadmore "posts" from my site as pagination like twitter... it's working for all posts in my table but it's not working for filtering table.. means if i am entering "php" in my search box its is going to display php posts and after that when i click on load more button it is displaying the entire posts but it can display only php posts... whats the problem can any one will say please? here is my code::::::

index.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Ajax Auto Suggest</title>
    <link rel="icon" href="../favicon.ico" type="image/x-icon" />
    <script type="text/javascript" src="jquery-1.4.4.js"></script>
    <script type="text/javascript">
        $(document).ready(function(){
            $("#loadmorebutton").click(function (){
                $('#loadmorebutton').html('<img src="ajax-loader.gif" />');
                $.ajax({
                    url: "loadmore.php?lastid=" + $(".postitem:last").attr("id"),
                    success: function(html){
                        if(html){
                            $("#postswrapper").append(html);
                            $('#loadmorebutton').html('Load More');
                        }else{
                            $('#loadmorebutton').replaceWith('<center>No more posts to show.</center>');
                        }
                    }
                });
            });
        });
    </script>

<script type="text/javascript" src="jquery-1.2.1.pack.js"></script>
<script type="text/javascript">
    function lookup(inputString) {
        if(inputString.length == 0) {
            // Hide the suggestion box.
            $('#suggestions').hide();
        } else {
            $.post("rpc.php", {queryString: ""+inputString+""}, function(data){
                if(data.length >0) {
                    $('#suggestions').show();
                    $('#autoSuggestionsList').html(data);
                }
            });
        }
    } // lookup

    function fill(thisValue) {
        $('#inputString').val(thisValue);
        setTimeout("$('#suggestions').hide();", 200);
    }


function fun1()
{
    document.form1.style.visibility="hidden"
}

</script>

<style type="text/css">
    body {
        font-family: Helvetica;
        font-size: 11px;
        color: #000;
    }

    h3 {
        margin: 0px;
        padding: 0px;   
    }

    .suggestionsBox {
        position: relative;
        left: 30px;
        margin: 10px 0px 0px 0px;
        width: 200px;
        background-color: grey;
        -moz-border-radius: 7px;
        -webkit-border-radius: 7px;
        border: 2px solid #000; 
        color: #fff;
    }

    .suggestionList {
        margin: 0px;
        padding: 0px;
    }

    .suggestionList li {

        margin: 0px 0px 3px 0px;
        padding: 3px;
        cursor: pointer;
    }

    .suggestionList li:hover {
        background-color:green;
    }
    </style>

    <style>
        body{ margin:0px; }
        #hycusdemosheader{ font-family:Georgia; font-size:30px;border-bottom:1px solid #676767;padding:5px 5px 8px;margin-bottom:10px; }
        #idh, #idh:visited { color:#000; text-decoration:none; }
        #hycusdemosheader span{ color:#999; }
        #downloadbutton{ color:#ffffff;background:#03AEEB;float:right;font-size:20px;padding:5px;-moz-border-radius: 5px;-webkit-border-radius: 5px;border-radius: 5px;text-decoration:none; }
        #downloadbutton:hover{ background:#888888; }
        #hycucdemosbody{ padding:10px 0; min-height:500px; }
        #hycusdemosfooter{ border-top:1px solid #676767; padding:10px; font-size:20px; }
        #hycusdemosfooter a{ text-decoration:none; }
        #wrapper{
            width:600px;
            margin:auto;
        }
        .spacer{
            clear:both;
            height:5px;
        }
        .txtarea{
            font-size:18px;
            height:50px;
            width:100%;
        }
        #postswrapper{

        }
        .postitem{


            font-size:24px;
        }
        .postitem:hover{
            background:#EFEFEF;
        }
        #newpostlink{
            display:block;text-align:center;border:2px solid #414141;background:#7D7D7D;color:#fff; margin: 0 0 10px;padding:5px; -moz-border-radius: 5px; -webkit-border-radius: 5px; border-radius: 5px;font-size:20px;text-decoration:none;
        }
        #loadmorebutton{ width:100%;height:30px; }
    </style>

</head>

<body>


        <form method="get" action="">
            <div>
                <br />
                <input type="text" size="30" value="" id="inputString" name="inputstring" autocomplete="off" onkeyup="lookup(this.value);" onblur="fill();" />
                <input type="submit" name="sub" value="search" onsubmit="return fun1(this)" onclick="fun1()">
            </div>

            <div class="suggestionsBox" id="suggestions" style="display: none;">
                <img src="upArrow.png" style="position: relative; top: -12px; left: 30px;" alt="upArrow" />
                <div class="suggestionList" id="autoSuggestionsList">
                    Â 
                </div>
            </div>
        </form>


<div id="form1" >
<?php /*?><?php
include("dbconnect.php");
error_reporting(0);
$stt=mysql_query("select * from post order by post_date desc");
echo "<table border='1' bgcolor='lightblue' width='100%' height='auto'>
<tr>
<th>Title</th>
<th>Description</th>
<th>Date</th>
</tr>";
while($rec=mysql_fetch_array($stt))
{
    echo "<tr><td>"."<a href='readme.txt'>".$rec['post_title']." </a></td>";
    echo "<td><a href='readme.txt'><font size='5'>".$rec['post_title']."</font></a><br>".substr($rec['Description'],0,100)."........<a href='readme.txt'>more</a></td>";
    echo "<td>".$rec['post_date']."</td></tr>";
}
echo "</table>";
?></div>

    <div id="new" style="width:auto">  <?php */?>
    <div id="hycucdemosbody">
    <div id="wrapper">
        <div id="postswrapper">
    <?php
    session_start();
    include("dbconnect.php");
    if(isset($_GET['sub']))
{
$qs=$_GET['inputstring'];
$stt=mysql_query("select * from post where post_title like '%$qs%' order by post_date desc limit 0,3");
while($rec=mysql_fetch_object($stt))
{
    echo '<div class="postitem" id="'.$rec->post_date.'">';
    echo '<table border=1><tr><td><a href="readme.txt">'.$rec->post_id.' </a></td>';
    echo "<td><a href='readme.txt'><font size='5'>".$rec->post_title."</font></a><br>".substr($rec->Description,0,175)."........<a href='readme.txt'>more</a></td>";
    echo "<td>".$rec->post_date."</td></tr></table></div>";
}
echo "</table>";
}
?>
</div>
        <div id="loadmoreajaxloader" style="display:none;"><center><img src="ajax-loader.gif" /></center></div>
        <br/>
        <button id="loadmorebutton">Load More</button>

    </div>
</div>
</div>
</body>
</html>

loadmore.php

<?php
session_start();
error_reporting(0);
$dblink = mysql_connect('localhost', 'root', '');
mysql_select_db('avaara');

if($_GET['lastid'])
{
    $qs2=$_GET['qs2'];
    $as=$_GET['lastid'];
    echo $_GET['qs2'];
    $query = 'SELECT * FROM post WHERE post_date < "'.$as.'" ORDER BY post_date DESC LIMIT 0, 3';
    $result = mysql_query($query);
echo $qs1;
    while($rec = mysql_fetch_object($result))
    {
        echo '<div class="postitem" id="'.$rec->post_date.'">';
    echo '<table border=1><tr><td><a href="readme.txt">'.$rec->post_id.' </a></td>';
    echo "<td><a href='readme.txt'><font size='5'>".$rec->post_title."</font></a><br>".substr($rec->Description,0,175)."........<a href='readme.txt'>more</a></td>";
    echo "<td>".$rec->post_date."</td></tr></table></div>";
    }
}
?>
View Answers









Related Tutorials/Questions & Answers:
load more with jquery
load more with jquery  i am using jquery to loadmore "posts" from my... box its is going to display php posts and after that when i click on load more...); $('#loadmorebutton').html('Load More
jQuery Ajax load request
jQuery Ajax load request  Hi, How to use jQuery to send the request on server to load data in web page? Thanks   Hi, In the jQuery Load... and then load the data in web page. Thanks
Advertisements
jQuery Load Content
jQuery Load Content       In this section you will learn how to load content of a text file using jQuery... of simple text file and then show on the text box.ADS_TO_REPLACE_1 Our jQuery Load
How can I dynamically load user-entered data as content of jquery dialog?
How can I dynamically load user-entered data as content of jquery dialog?  Hi I can't seem to work my javascript. I cannot seem to figure out whatelse I am missing. Kindly guide me how to solve my project please. I cannot make
JQuery
JQuery  how to use jquery
Jquery
Jquery  I am new to Jquery. Can anyone please tell me how to use jquery plugins in html
jquery
jquery  What are the Jquery similarities or difference with other java script libraries
jQuery - jQuery Tutorials and examples
Using the QUnit to test jQuery application More jQuery Tutorials:ADS...; jQuery Tutorial Collection of more than 100 tutorials on jQuery.  ... on the user browser.   jQuery Load Content In this section
JQuery
JQuery  How i begin JQuery and where i begin learning?   Please visit the following link: JQuery Tutorials Learn Jquery from the above link. Here you will get lot of examples with illustration
jQuery
jQuery  Hi, What is jQuery and how it is used to develop Web applications? Thanks
jquery
jquery  how to display the leaves taken or holidays of the year or half working days in a calendar in some colors to identify the days using jquery plugin
JQuery
JQuery  hi there, I am just beginner for jQuery and i want to know-what is jQuery ? How it is better than JavaScript ?   jQuery... JavaScript : Each jQuery returns itself so you can chain them together(Chaining
JQuery
JQuery  how to create jquery auto-complete textbox ? in which data come from database table?   Please visit the following link: http://www.roseindia.net/tutorial/jquery/autoSuggestTextbox.html   thank you
JQuery
, use jquery autocomplete
JQuery
using url of the doctors, use jquery autocomplete
Ajax Load
Ajaxload The ajaxload is a tool, which follow web2.0 standard. Due to slow Internet speed or delay some times data takes time to load. At this time we can incorporate an animated gif image, which indicate user for the loading
JQuery-Disabling element in JQuery.
JQuery-Disabling element in JQuery.   How can we enable/disable an element in JQuery
Load UIImage from URL
Load UIImage from URL  Load UIImage from URL
how to load pdf on html
how to load pdf on html  how to load pdf on html
Load Icon Image Exception
Load Icon Image Exception  Load Icon Image Exception
jQuery Demos
jQuery Load Content jQuery to Vertical Image Scroller... jQuery Demos and quick examples       jQuery Demos The best way to learn a new technology
Conflict with jQuery scripts
Conflict with jQuery scripts  Hi, How to avoid Conflict with jQuery scripts while using jQuery with other libraries? Thanks   Hi, Read the using jQuery with other libraries tutorial for more information. Thanks
How jQuery works?
available on internt. The jQuery is designed to do more work in less coding... sections we will be understanding more about jQuery with the help of many... How jQuery Works?     
ModuleNotFoundError: No module named 'load'
ModuleNotFoundError: No module named 'load'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'load' How to remove the ModuleNotFoundError: No module named 'load' error
What is jQuery and how it is used?
What is jQuery and how it is used?  Hi, I want to know more about the jQuery as there is lot of demand of it in Job portals. In most of the website designing and development jobs jQuery is a must. What is jQuery and how
What is jQuery and how it is used?
What is jQuery and how it is used?  Hi, I want to know more about the jQuery as there is lot of demand of it in Job portals. In most of the website designing and development jobs jQuery is a must. What is jQuery and how
nsstring load from file
nsstring load from file  Hi, How to load file data into NSString object? Example of nsstring load from file, basically the html file data into NSSTring object. Thanks
UIWebview load url
UIWebview load url  How to load website url in UIWebview? Tell me code for UIWebview load url of a website Thanks...: //Load web view data NSString *strWebsiteUlr = [NSString stringWithFormat:@"http
jQuery tutorial for beginners
message on the page load. Step 1: Downloading jQuery library The jQuery library...jQuery tutorial for beginners Learn jQuery with the help of our tutorial jQuery tutorial for absolute beginners. This is complete jQuery tutorial
XML load problem - XML
XML load problem  I have load the xml document in javascript.getting error like ActiveXObject is undefined.Can you help me?  Hi friend... function load(){ var loadXML = new ActiveXObject
jQuery Installation 
by the jQuery when the page load completes and you can write your code here... to download, install and create your first jQuery example program. Check more tutorial...jQuery Installation For using jQuery , you need to follow the given below
Use of jQuery
Use of jQuery  What is the use of jQuery?   Hi, jQuery is JavaScript Ajax library. Developer is using it to create rich internet applications.ADS_TO_REPLACE_1 Read at jQuery Tutorial. Thanks
use of jquery
use of jquery  what is a jquery? what is the evalution of jquery?   Hello Friend, Please visit the following link:ADS_TO_REPLACE_1 JQuery Tutorials Thanks
learn jquery
learn jquery   is it possible to learn myself jquery,ajax and json   Yes, you can learn these technologies by yourself. Go through the following links: Ajax Tutorials JSON Tutorials JQuery Tutorials
learn jquery
learn jquery   is it possible to learn myself jquery,ajax and json   Yes, you can learn these technologies by yourself. Go through the following links: Ajax Tutorials JSON Tutorials JQuery Tutorials
Load on Startup - JSP-Servlet
Load on Startup  Hi, Can anybody explain the exact use of load-on-startup tag. Where exactly we have to write. Thanks, Naveen  ... of a deployment descriptor is used to load a servlet file when the server starts instead
javascript window.addeventlistener load
javascript window.addeventlistener load  How to load window.addeventlistener in JavaScript?   window.addEventListener('load', function() { var b = document.getElementById('box'), xbox = b.offsetWidth / 2
J2me Map load error
J2me Map load error  Hi , i am making a POC to load google map in my mobile,now i m getting the address of location by its lattitude and longitude in web page , but thing is i wana to store in my net beans emulator , its showing
PHP and JQuery
PHP and JQuery  How to make validation using PHP and JQuery
jQuery Tutorials, jQuery Tutorial
jQuery Tutorials, jQuery Tutorial The jQuery tutorials listed here will help you in learning jQuery easily. We have given many articles and easy to understand examples to making learning path easier. These jQuery tutorials
jQuery Training Course
to create real-life application using jQuery Read more at jQuery Training... jQuery Training Course     Online jQuery Training course for beginners and experienced web developers
Hibernate Session Load
This section contain description of Hibernate session load
load and upload. - JSP-Servlet
load and upload.  dear sir, plz give me the sol for my problem.i m waiting for u r reply. why u not replying ..   Hi Friend, We haven't remember your problem. So please send it again. Thanks
session on page load
session on page load  holding session on page load and reload..   <?php session_start(); if (!isset($_SESSION['arr']['counter'])) { $SESSION['arr']['counter'] = 0; } else { $SESSION['arr']['counter']++; } var_dump
jquery search for html pages
jquery search for html pages  i want to search html pages with jquery, it is k for single page but i want search more than one page at a time. Thank you in advance
jQuery questions - Ask jQuery questions
_TO_REPLACE_3 jQuery Tutorials Read more about jQuery at http...jQuery questions - Ask jQuery questions       jQuery questions The jQuery framework
load and upload. - MobileApplications
load and upload.  Dear sir/mam, i want code for java based application, that can take .3GP video file and upload it to youtube using youtube's APIs. The video file would be located on a weblink (a direct http link to a video
Form Should not load
box after submitting or the form should not load again. Thanks in adbance
jQuery Features
jQuery Features       jQuery have lot of functionalities but some of the key features are given below : Selection of DOM elements :ADS_TO_REPLACE_1 The jQuery selector
dynamic jquery statement
dynamic jquery statement  dynamic jquery statement

Ads