Yes, I did put it on 50 just to test it. I have around 40 elements for now.
But I realize that I was wrong about using array. My first idea was to load the entire datas from mysql in the array and then manage to show them part by part (on load display the firs 29 elements then show the next 29 ones and so on)
But that's a problem if I load like 1000 elements. It will take hours to get all the elements into my array.
So the idea is to prepare pages on the requested php. So I make this:
$count = 9;
$page = 0;
if(isset($_GET['page'])) {
$page = $count * intval(strip_tags(mysqli_real_escape_string($con, $_GET['page'])));
}
With this code I can load the first 9 row from mysql table as page 0.
Now the idea is to use Ajax to change $page in the php so it can load the 9 next entries.
And this is where I don't know how to do it.
If I create a new request, it should looks like
Ajax: send $page=+1 to URL MY_DOMAIN & "getdatas.php?page="page"
Probably a confusion here…