使用PHP在块中处理数组

Question

I'm getting about 500 rows back from a DB that my PHP script connects to and executes a query on. For each row returned, I display it in table format. Script works fine in Firefox, and ultimately works in IE, but users get a 'Stop Running This Script' prompt 1 or 2 times (and telling IE to continue..) before everything displays properly.

To get around this, I need to send some data back to the browser -- and I think the best way to do that is processing the array in chunks/batches. PHP has an array_chunk function, but i'm having trouble figuring out how to use it here.

To get the DB rows, I use:

$result = mssql_query($query);

... then to display them in a table:

while($row = mssql_fetch_array($result))
{
  [DISPLAY TABLE ROW IN TABLE]
}

What is the best way to use array_chunk to process my array, say in chunks of 50?

Answer 1

array_chunk is only going to help you after you've already gotten the entire array of information from the database. From your question, it sounds like the script is hanging on the actual query from the database as it's being set to an array and then you're wanting to process that entire array.

You could output each row of the table while still in the loop you're using to get each row of results from the database, instead of creating a master array first. However, your users might see the page load in chunks as your script chugs through the query.

Off the topic of your question now: If the page loading in chunks is less than ideal for you, you could look into asynchronously running the query in the background (using JavaScript) while showing some sort of "Loading" message until the script is done running. Then, output the results to the page.

Alternatively, if you have the option of not showing all 500+ results at once, you could use pagination and use the LIMIT and OFFSET SQL keywords to only grab portions of your overall query. Then, create links to next or previous pages of results which would change the OFFSET.