Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa PHP load more with jquery
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


sridhar Bodakunti
load more with jquery
0 Answer(s)      2 years and 11 months ago
Posted in : PHP


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>";
    }
}
?>

Advertisement
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. Our jQuery Load Content example
JQuery
JQuery  how to use jquery
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: Here... Tutorial Collection of more than 100 tutorials on jQuery.   Server... browser.   jQuery Load Content In this section you will learn
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
Load Icon Image Exception
Load Icon Image Exception  Load Icon Image Exception
how to load pdf on html
how to load pdf on html  how to load pdf on html
Load UIImage from URL
Load UIImage from URL  Load UIImage from URL
JQuery-Disabling element in JQuery.
JQuery-Disabling element in JQuery.   How can we enable/disable an element in JQuery
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
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
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 Demos
and installing jQuery Server time Example jQuery Load... jQuery Demos and quick examples       jQuery Demos The best way to learn a new technology
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
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?     
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
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
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
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
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
Form Should not load
box after submitting or the form should not load again. Thanks in adbance
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
 

 

 

DMCA.com