Display “Complete” div when reaches a line or a variable in PHP/HTML code
I have a large MYSQL / PHP in a while loop report being run and in many cases the report times out due to the large amount of data being calculated.
Is there a way to make have a div displaying "Processing" when the while loops is calculating and if the report is completed , a div "complete" is displayed.
For example: The calculation are not complete because the variable $totals are not displayed. It is only when $Total is a rational value then "Completed" is displayed.
Many Thanks in advance!
PHP Code:
<?php
session_start();
?>
<html>
<body id="dt_example">
<div "Processing">
<?php
while($noticia = mysql_fetch_array($query)) { // Very long mysql query , query usually times out in this loop. Div "Processing" shown
$Total +=$subtotal;
}
echo "Totals: ".$Total; //when this is executed , the report is succesful and div "Completed " is displayed
echo "<div Completed>";
?></tbody></table></div>
</body>
</html>
Re: Display “Complete” div when reaches a line or a variable in PHP/HTML code
If your query times out either (1) your query string is bloated causing overwork, (2) you have a very bad database structure, or (3) you are working with databases way too large for your server architecture.
If you don't fix either of those first three issues, then the rest really isn't going to help.
As for PHP processing, remember that it is server-side. The only way to communicate back to the client is to finish the script. Hence the reason why AJAX was created.