PHP MySQL : How to make an auto refresh data only when data changed on database

Question

Usually I make content refresh automatically with the javascript function using setInterval. But it seems ineffective because every second the content must be reloaded will take up a lot of resources.

Therefore if there is another alternative to creating an automatic refresh function only when the data has changed in the database.

Integrate websocket in php and listen for changes in javascript and refresh on changes Ref: Websockets in PHP — Sameer
– Sameer, Commented Jun 19, 2020 at 2:57
Thank you for your alternative solution. Maybe i am newbie :( need an example simple project which is integrated with the mysql database. — Nay
– Nay, Commented Jun 19, 2020 at 3:10
If the resources are at the database layer, include SHOW CREATE TABLE {tablename} and the SQL to retrieve it. What would the SQL be to retrieve the changes? How are database changes occuring and could you use a websocket to pipe raw new results from whatever changes it. — danblack
– danblack, Commented Jun 19, 2020 at 4:08

Rohan Mukherjee · Accepted Answer · 2020-06-19 02:56:59Z

1

One way to update your data would be to use Ajax in the frontend to request the data every few seconds and update it instead of reloading the page. Otherwise, you should check out socket.io (websockets)

answered Jun 19, 2020 at 2:56

Rohan Mukherjee

2902 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP MySQL : How to make an auto refresh data only when data changed on database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related