CODEWITHSUNDEEP
phpmysqlajax
Sjaak piraat
Sjaak piraat

Reputation: 53

Page refresh on record in database changing

Okay so I'm running into a small problem.

Basicly my whole website runs through the AJAX system, content is loaded in the middle page, and theres a left and right menu which dont refresh.

Currently I'm trying to look for a PHP->Ajax feature that refreshes the whole website incase a certain record changes in the MYSQL table

Okay so every user has a record called "State" which indicates the state of their account, this can be changed by anyone, for example the account gets shot and killed by someone. How do I make it so it checks what state you have and if it changes from the "standart" state that it performs a full page refresh.

I tried to find an answer for this everywhere but haven't been able to figure something out.

-----Edit-----

Okay so I'll also notify, I kind of know how to perform a full page refresh, and I know how to retrieve data from the mysql database, this isn't the problem.

I have a table with all the users accounts in it, one of the records for every user is called "State" everybodies state will be 1 which means alive. when its 0 it means its a dead account.

On a part of my website theres an auto refresh with always fetches data from the database every 5 seconds, to check if your online if you have money etc. it also checks what state you have.

the only thing I want to do, is that when it sees your state is 0, it performs a full page refresh, considering state 0 means death, you should be seeing a deathscreen, I want it to perform a full page refresh cause the menu's have to dissapear. and it has to redirect you to the deathpage.

Upvotes: 1

Views: 1393

Answers (1)

Maxim Krizhanovsky
Maxim Krizhanovsky

Reputation: 26719

You need long pooling / comet - basically you keep open connection between the client and the server, and when the state is changed, the server sends the response to the client.

Basically, you'll open a long pooling connection, sending the userid. The server script receives the userid, and starts monitoring for changes for that user. If such change is detected, send the response.

If performance is concern, you can use Tornado web server. What's nice about it, is that you can post from another application to the web server, and it can detect which client is affected by the change and send response to that client.

Upvotes: 2

Related Questions