Forcing remote reload of PHP page after database change...

[Jakobud]

I have a bit of an odd question. I'm developing a mysql database and have users access the data via homemade PHP pages that query data. When the user(s) open the PHP page or query on it, it fetches the data from the database and then refreshes the page showing the new data. If something in the database changes, like if a user adjusts some value, is it possible for mySql to send out some sort of "autorefresh" signal/trigger to all open connections to the database, which could be used to automatically refresh the user(s) PHP page, thus giving them the most up to date information without them having to manually click refresh?

Does that make sense? Does mySql have any sort of feature like that?

 

[KarveR]

The short answers are :
no mySQL isn't that clever.

PHP is server side, and therefore cannot do what you ask.

Java may be used here but you'd need to ask in the right forum, even so, mysql still isnt that clever.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[Bastien]

Can't be done that way...the only thing you can do is to put a meta refresh in the page to force refresh after a certain time...

The other thing to check is to see if the value has changed between the time user a requests a page and makes a change and user b requests the page and makes a change...

Two optins here:
1. Lock record to not allow changes
2. Find a way to handle concurrent updates to the same record.


Bastien

Cat, the other other white meat