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