"Forcing" PHP to echo information as it executes

[mrherman]

Good evening --

 

My script takes a while to execute as it processes records from the db.  I'd like to have it print out to the screen the record id # as it processess each record, just to let me know where it is.  Currently, the program waits till the end and then prints out the record numbers, which is no help.  How can I enable PHP to print out each record number as it goes along?

 

Thanks!

[WatsonN]

Use while to run while its doing the database work.

 

More info: http://php.net/manual/en/control-structures.while.php

[mrherman]

Thanks for your reply...I have tried to place an ECHO statement inside the WHILE loop, but it still waits until the end of processing and then prints out all the record numbers at one time, rather than doing it as it processes each record...

[WatsonN]

Could you post the code so we can rake a look at it?

[Zane]

This is called flushing the output buffer.

 

Take a read on it here.. http://www.tuxradar.com/practicalphp/13/9/0

[chintansshah]

Hello,

 

Your query saved as a resource id. To check and debug of your query output.

 

use,

var_dump($query);

or you can use,

print_r($query);

 

You get the all rows details with data as an array.

[mrherman]

Ahaa!  That is it!

 

Thank you all for responding.  Yes, that is it.  One learns something new every day!!

 

 

 

[chintansshah]

Your welcome mrherman...