Zdravím vás,
načítavam články z databazy cez ajax infinity scroll, a mám problém, lebo stále mi to na stránke vypisuje 1 keď načítava nové články pri rolovaní
Kód:
<div class="ajax-load text-center" style="display:none"><p>Loading More post</p></div>
<script type="text/javascript">
$(window).scroll(function() {
if($(window).scrollTop() + $(window).height() >= $(document).height()) {
var last_id = $(".post-id:last").attr("id");
var id = $(".category-id:last").attr("id");
loadMoreData(last_id, id);
}
});
function loadMoreData(last_id, id){
$.ajax(
{
url: '/loadMoreData.php?last_id=' + last_id + '&id=' + id,
type: "get",
beforeSend: function()
{
$('.ajax-load').show();
}
})
.done(function(data)
{
$('.ajax-load').hide();
$("#post-data").append(data);
})
.fail(function(jqXHR, ajaxOptions, thrownError)
{
alert('server not responding...');
});
}
</script>
Kód:
<?php
require('inc/config.php');
$sql = "SELECT a.id AS idclanok,a.image,a.title,a.category,a.post,a.autor,DATE_FORMAT(a.date, '%M') AS month, DATE_FORMAT(a.date, '%d') AS day,b.* FROM posts a LEFT JOIN category b ON(a.category = b.id) WHERE b.id='".$_GET['id']."' AND a.id < '".$_GET['last_id']."' ORDER BY a.id DESC LIMIT 10";
$query = mysqli_query($con,$sql);
$json = include('get-post.php');
echo json_encode($json);
?>