MySql数据库条目更改时发送通知

Question

I've written a php file that changes a MySql table entry when it receives an http post. I would also like the php file to send out a notification to the table entry's owner. This idea is similar to a chat room or instant messengering program. I've looked at php chat scripts but I really need something that has a very simple interface that is customizable. Can anyone point me in the right direction?

Answer 1

So you want to synchronize a set of clients, do you?

If so, look at the Long Polling technique. It's quite simple: The client opens a connection but the server does not respond until data is updated.

On the downside this won't work well with PHP. You will need to sleep() several connections, therefore blocking PHP processes.

If you have the possibility I would recommend using node.js to do stuff like that. Long Polling Chats are quire simple to implement using node ;)