des3rtfoxie
-
Posts
3 -
Joined
-
Last visited
Never
des3rtfoxie's Achievements
Newbie (1/5)
0
Reputation
-
User feedback after MySQL query has been executed
des3rtfoxie replied to des3rtfoxie's topic in PHP Coding Help
Tanks for the replies guys. Using AJAX would indeed solve what I was looking for .. BUT .. I started building the application in Java and completely revamped it recently to run on PHP / MySQL only, due to performance issues, so I'll have to see .. I think I'll look more into the Ajax thing none the less when I'm done with the rest of my app. Thanks again ! -
User feedback after MySQL query has been executed
des3rtfoxie replied to des3rtfoxie's topic in PHP Coding Help
The term "Real time" might be misleading. All I would like my php code to do, is do one thing after another. 1) Execute a query 2) Give feedback to user that it the query has finished ( I don't want to display results here ! ) 3) Go on with the next query 4) Provide feedback 5) And so on What I don't grasp is, that - even when I put the user feedback as "echo blah blah" into the php code and not in the html code - that php always seems to execute all MySQL queries first before it echoes any output. I would expect the server to parse my code line by line if you know what I mean : ) -
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: <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.