I want to try socket.io for the first time. I did the tutorial chat message with socket.io. But now I want to select some data in my database to count the number of rows in the table 'product' with query Phalcon :
$count_products = Product::count();
For example in my HTML page I have 5 products and when I'll add one product or more into my table Product I want an auto refresh to see 6 products in my HTML page.
I need to do an query to my database with phalcon and push to socket.io the data to do a realtime update.
could you help me to do that and tell me if socket.io is the best tools to conncect web socket with phalcon ?