How can I receive a notification whenever there are record in a database table?

Question

How do I get a notification whenever there is a record in a particular table in the database?

If I use a Trigger in MySQL will not work when I change database.
If I make an Ajax request every certain interval, I will make unnecessary requests and I've been punished for it in Hostmonster (escape them).
Another idea?

This guy went through the problem as me: http://www.schiffner.com/11-excruciating-months-with-hostmonster-have-come-to-an-end/

Thank you.

Use AJAX, make interval high enough (1 minute or 30 seconds) also create button for manual refreshing and you are done. — Kyslik, Jan 04 '14 at 19:17

score 1 · Accepted Answer · edited May 23 '17 at 11:56

1

Sending Ajax requests at regular intervals (long polling) may not be the best solution but I have seen this implementation in many applications and probably it is easy to implement.

One of the solutions that has not been mentioned here is a PHP script running in a scheduler. This question will help you and make things clearer. Schedule alarm notification system php

Do let me know if you need more info.

edited May 23 '17 at 11:56

Community

1
1

answered Jan 04 '14 at 17:46

Talha Masood

993
1
7
22

added information: http://stackoverflow.com/questions/10028770/html5-websocket-vs-long-polling-vs-ajax – tomexsans Jan 05 '14 at 02:33

How can I receive a notification whenever there are record in a database table?

1 Answers1