如何使用拆分数组拆分表列

Question

I am currently looking for a way to split a database to send messages after 60 minutes or so. I have a table with over 1000 rows being returned from the database and would like to split them into groups of 50. I would appreciate an example of how this can be attained. Thank you.

Answer 1

You could create a script that is navigated to like the following:

runner.php?start=0&limit=50

This page would start at row 0 and do 50 repeats. Then after 50 repeats it would echo out:

<script>setTimeout(function() {
    window.location='runner.php?start=50&limit=50';
}, 3600000)</script>

Where start=50 would be the $_GET['start'] + $_GET['limit']

You would need to keep your browser window opened though.