How does MySQL PHP read data cyclically from the database in batches?

Question

If five items are read from the database each time, how should the program continue to loop until all loops are completed? Is the logic of adding {code...} correct?

过去多啦不再A梦 · Answer

You use limit. Then record the id until the id is greater than maxid, right?

高洛峰 · Answer

You can use the principle of paging query. .

$count = '100';//总条数
$strip = 0;
$num = $count/5;//循环多少次
for($i=1;$i<=$num;$i++)
{
 $sql = "select * from `table` order by id limit ".$strip.",5";
 $strip += 5;
}