Load Infinite Data while Scrolling Page Down in jQuery, AJAX ,PHP AND MYSQL

This excercise about my top choice put Dzone like information stacking while page scrolling down with jquery and Php. We have heaps of information however can’t show all. This script encourages you to showcase small information and make quicker your site. Investigate live demo and span down.

Database Table
CREATE TABLE messages(
mes_id INT PRIMARY KEY AUTO_INCREMENT,
msg TEXT);
Browser Capability : Safari, Firefox, IE, Chrome
load_data.php

When we are scrolling down a webpage, the script($(window).scroll) finds that you are at the bottom and calls the last_msg_funtion(). Take a look at $.post(“”) eg:$.post(“load_data.php?action=get&last_msg_id=35”)

<?php
include(‘config.php’);
$last_msg_id=$_GET[‘last_msg_id’];
$action=$_GET[‘action’];

if($action <> “get”)
{
?>

<script type=”text/javascript” src=”jquery.js”></script>
<script type=”text/javascript”>
$(document).ready(function()
{
function last_msg_funtion()
{
var ID=$(“.message_box:last”).attr(“id”);
$(‘div#last_msg_loader’).html(‘<img src=”bigLoader.gif”>’);
$.post(“load_data.php?action=get&last_msg_id=”+ID,

function(data){
if (data != “”) {
$(“.message_box:last”).after(data);
}
$(‘div#last_msg_loader’).empty();
});
};

$(window).scroll(function(){
if ($(window).scrollTop() == $(document).height() – $(window).height()){
last_msg_funtion();
}
});
});
</script>
</head>
<body>
<?php
include(‘load_first.php’); //Include load_first.php
?>
<div id=”last_msg_loader”></div>
</body>
</html>
<?php
}

else
{
include(‘load_second.php’); //include load_second.php
}
?>

load_first.php
Contains PHP code to load 20 rows form the message table.
<?php
$sql=mysql_query(“SELECT * FROM messages ORDER BY mes_id DESC LIMIT 20″);
while($row=mysql_fetch_array($sql))
{
$msgID= $row[‘mes_id’];
$msg= $row[‘msg’];
?>
<div id=”<?php echo $msgID; ?>” class=”message_box” >
<?php echo $msg; ?>
</div>
<?php
}
?>
load_second.php
Contains PHP code to load 5 rows less than last_msg_id form the message table.

<?php
$last_msg_id=$_GET[‘last_msg_id’];
$sql=mysql_query(“SELECT * FROM messages WHERE mes_id < ‘$last_msg_id’ ORDER BY mes_id DESC LIMIT 5″);
$last_msg_id=””;
while($row=mysql_fetch_array($sql))
{
$msgID= $row[‘mes_id’];
$msg= $row[‘msg’];
?>
<div id=”<?php echo $msgID; ?>” class=”message_box” >
<?php echo $msg;
?>
</div>
<?php
}
?>

Download Full Code

Advertisements

7 thoughts on “Load Infinite Data while Scrolling Page Down in jQuery, AJAX ,PHP AND MYSQL

  1. Hello, I am not able to download the script as it leads to a broken link. Can you provide me with this script. Thanx.

    Like

  2. Is this complete and working? The code is bad! LOL…

    Like

  3. Thank you! i need infinite scroll for my homepage but i don’t think sql.
    luckily i saw your post. and i complete it!

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s