I would like to inform you about the another problem of the server. When we are updating the records, it updates the records in the database but when we want to access it on the browser through the frontend application of php files it is not displaying the updated records immediately. It takes the time of 15-20 minutes or more or sometimes we closes the browser and open the another browser then the updated recor开发者_JAVA技巧ds display there. I have already deleted the browser cache but the problem is still remains. I have checked this in the different different broswers like IE 6.0,7.0, chrome, safari, mozilla but unable to find the solution.
please suggest me what is the problem with the server? please check this url : http://www.nicee.org/trial/view.php
To expand on my comment slightly, I should point out that PHP isn't really something I'm familiar with, just the problem described sounded familiar.
To pseudo code it:
-- On Update
Open Transaction with Database
Run SQL command(s)
Close/commit transaction
If you don't do this final step (i.e. commiting the transaction & closing it), then it will remain open and will lock this table (depending on how your DB is set up). You must ensure that it is always finished (rolled back if there is an error too).
From a quick google, this may be useful:
http://www.devarticles.com/c/a/MySQL/Using-Transactions-with-MySQL-4.0-and-PHP/
精彩评论