Automatic "GET" (like facebook) on new MySQL entry

Hi,

We would like to have a code to implement a instant/automatic "GET" for every new entry on MySQL database. For example: a user post a new data in a form and this data is displayed instantly to every user connected into the website.

At the moment we have a code that reads the MySQL database every 3 seconds, but this solution consumes a lot of network bandwidth.

We heard about COMET, xmlhttprequest and longpolling (all with Javascript or ajax), but we don't know how to implement it.

The code must work in a Linux (32bits) virtual machine in EC2 (Amazon) with PHP, Apache and MySQL.

AJAX HTML JavaScript MySQL PHP

ID Проекту: #1442619

Про проект