- Edited
I can call the code but for some reason it keeps calling the same rows over and over, is there a way keep track of rows called?
example
https://gotsocial.co.uk/business-view.php?id=4
Calling code
<script type="text/javascript">
$(window).scroll(function()
{
if($(window).scrollTop() + $(window).height() == $(document).height())
{
console.log("got here");
// $('.load-results').load('get_records.php');
var getid = '<?php echo $_GET['id']; ?>';
console.log(getid);
var flag = 0;
$.ajax({
url:'get_records.php',
data: {id: getid,
'offset': flag,
'limit': 3
},
type:'get',
success: function(data){
$(".reviews-section").after(data);
flag += 3;
}
});
}
});
</script>
php section
<?php
require("classes/Database.php");
$db = new Database;
$get = filter_input_array(INPUT_GET, FILTER_SANITIZE_STRING);
$business = $get['id'];
$limit = 2;
$query = "SELECT * FROM reviews ORDER BY adressId DESC LIMIT 8";
$s = $db->prepare($query);
$s->execute();
$total_results = $s->rowCount();
$total_pages = ceil($total_results / $limit);
if (!isset($_GET['page'])) {
$page = 1;
} else {
$page = $_GET['page'];
}
$starting_limit = ($page - 1) * $limit;
$query = "
SELECT s.town, s.street, s.streetNumber, s.region, s.postcode, s.businessName, s.business, s.adressId, s.town, r.userId, r.review, s.phone, s.lat, s.lon, u.username
FROM shopAddress as s
INNER JOIN reviews AS r ON s.adressId=s.adressId
INNER JOIN users AS u ON r.userId=u.userId
WHERE s.adressId = :business LIMIT $starting_limit, $limit";
$s = $db->prepare($query);
$s->bindValue(':business', $business);
$s->execute();
// $total_results = $s->rowCount();
foreach ($s as $review) {
?>
<section class="user-review">
<div class="review-username"><a href="#"><?php
print $review['username'];
?></a></div>
<div class="user-rating"><div class="rating"></div></div>
<p class="review-output">
<?php
print $review['review'];
?>
</p>
</section>
<?php
}
