开发者

problem of the server

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/

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜