User feedback after MySQL query has been executed
Posted on
16th Feb 2014 07:03 pm by
admin
Hi all, I've just registered on PHPFreaks because I've got a question that I simply can't work out by myself.
Im developing a web based reporting application, based upon PHP/MySQL. At some point the user can chose some parameters from a form like dates etc and hit a button, then the form data is submitted to execute_report.php, which contains some code as follos:
Code: <html>
Some html stuff here, like text output for the user, that the query xyz has been started
<?php
Here goes the first query
?>
Then html code again to insert a line that the query has finished
Another line of text that the next query has started
<?php
And the next MySQL query
?>
Text again that the query has finished ... and so on
</html>
Basically everything works like a charm. The queries do what I want and deliver the output and results just fine. What bugs me is, that all results and the html text output are only displayed after the last query has finished.
During the whole executing time, the browser just says "Loading" until the queries have executed, then all results are displayed the way I intended them to.
I already tried experimenting with putting the queries into functions and also with sleep commands, but to no avail.
I would love to give the user a feedback before a query starts and after it has finished, sort of in "Real time". Any tips would be greatly appreciated
No comments posted yet
Your Answer:
Login to answer
216 50
Other forums
Stumped by Third Day of Month problem
I am trying to build an algorithm that will essentially do this:
Code: [Select]$this_month = Oct
Help with some dates
I have a list of dates in an array:
$mondays = array(
strtotime("October 12, 2009
parse error
Parse error: syntax error, unexpected '[', expecting ')' in /Users/admin/Sites/phptest/array.php on
How to display value in drop down list after form has been reloaded
Please bear with me as I am very new to php and html.
I have a form with several drop down me
Tournament Brackets (Double Elimination)?
Is making a double elimination tournament style bracket system capable of being done in php?
Help with file_get_html
The following code gives the expected results:
<html>
<head&g
array_map() probably obvious mistake
The code below is part of a class to escape strings, but should also accept an array, using array_ma
Oracle Text CTX_DOC.snippet slow
I have a table (FILE_TABLE) that contains a blob column (ft_file) and I have created the following O
need help with date function
i have following form for date
Code: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01
Embedding flash object in Else statement
This is my first major project in PHP and I'm having some trouble embedding a flash object in an Els