load more with jquery

Ads
 

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

Ads









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
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 Tutorials and examples
Using the QUnit to test jQuery application More jQuery Tutorials: Here... Tutorial Collection of more than 100 tutorials on jQuery.   Server... browser.   jQuery Load Content In this section you will learn
jquery
jquery  What are the Jquery similarities or difference with other java script libraries
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  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
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
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
How jQuery works?
. The jQuery is designed to do more work in less coding. It's very easy... more about jQuery with the help of many examples Learn from experts! Attend... How jQuery Works?     
jQuery Demos
and installing jQuery Server time Example jQuery Load... jQuery Demos and quick examples       jQuery Demos The best way to learn a new technology
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 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
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 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
jQuery Training Course
using jQuery Read more at jQuery Training page... jQuery Training Course     Online jQuery Training course for beginners and experienced web developers
jQuery questions - Ask jQuery questions
at http://www.roseindia.net/answers/questions/ jQuery Tutorials Read more...jQuery questions - Ask jQuery questions       jQuery questions The jQuery framework
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
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
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
PHP and JQuery
PHP and JQuery  How to make validation using PHP and JQuery

Ads