1

I am thinking of implementing a real time event listener for a personal project. Is there are way that say, if an INSERT, UPDATE, and DELETE SQL queries have been issued, then mySQL will trigger a PHP file which will in turn process this, like refreshing a page automatically if a new record is found, or say a record has been edited or deleted?

I have been reading through mySQL triggers but I do not know how to implement. Thanks!

JudeJitsu
  • 730
  • 1
  • 10
  • 17
  • What's the JavaScript/AJAX connection? – Mitya Jul 16 '12 at 11:35
  • Hi @Utkanos, I am also open to JS/AJAX processing / implementation, as I intend to minimize the refreshing of a whole pages, rather, just a small part of the page. – JudeJitsu Jul 16 '12 at 11:36
  • see this answer http://stackoverflow.com/questions/1467369/invoking-a-php-script-from-a-mysql-trigger – Waygood Jul 16 '12 at 11:49

1 Answers1

1

If what you want to do is refreshing the page in an appropriately lazy manner, I suggest you look less to triggering out of MySQL and trigger it with AJAX. Waygood has a good link for the latter, but consider the former for simply updating data.

You can update the information on your site by way of long polling. That way you keep a persistant connection open back to your server and can update data whenever the server pushes an update through. When done, simply start the connection again and wait for another update. The most commonly used LP technique is probably one with AJAX. Alternatively, for things like cross-domain support, you could go a bit more exotic with script tag long polling.

Naltharial
  • 2,132
  • 14
  • 21