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
Confusing Functions
So, I've been reading up on Functions and I like them! However, I need some help using variables in
Attempt to assign property of non-object in...
I'm having issues with the following function in PHP 5...
function getTreeWithChildre
need to add "sizes" to shopping cart
Hey guys, I am trying to figure out a way to add a "size" selector on to this bit of code.
Remove values in array2 from array1
I have two arrays.
Array 1 is where the array key holds various different numbers. For exampl
How to store checkbox array in a session, and then be able to add to it?
I'm trying to store an array of checkbox values into a session array, sort of like a shopping cart,
PHP - MySQL Fail
My PHP code will only execute the first part of my code...
Code: <?php
sessio
Need Successful Return
Hello I am currently working a form here, and I have everything figured out except when I click the
Curly Bracket Delimeters.
I'd always believed that the starting and ending delimeters in preg_ functions had to be the same ch
Ajax Issues - Update Panel / Timer. Intellisense doesn't know about them
Type 'System.Web.UI.ScriptManager' does not have a public property named 'UpdatePanel'.
That is wha
How to separate records and ORDER BY
Let say i have 100 records and displayed in one page, then i want to get the records from 50-100 and
