PHP Ajax: Perform action when database is updated

Question

What I want to do is, when something new comes into the database, it gets the latest value entered and plays a specific song depending on what it says.

For example, on my computer, I run this website. Say somebody else around the world picked up their phone and clicked to play a song, that song would automatically play on all devices running the page. When somebody chooses a new song, the song should change.

I have made several tries at this, mainly trying to use setInterval in JavaScript however it just updates and updates all the time as you would expect.

I guess what I really am looking for is a way to track when the database has been updated, any solutions or code examples I can use?

Keep track of which user's you've "notified" so you don't "notify" them multiple times of the same thing. — apokryfos
– apokryfos, Commented Mar 28, 2017 at 16:25

Sergei Kutanov · Accepted Answer · 2017-03-28 17:00:09Z

2

If I understand you right, you can use push notifications. https://firebase.google.com/docs/notifications/

Here's a tutorial how to set up a js client https://firebase.google.com/docs/cloud-messaging/js/client

In this case you won't have to do unnecessary requests to the server to fetch updated. Just send a push notification to the client and do necessary actions on the client side.

answered Mar 28, 2017 at 17:00

Sergei Kutanov

8256 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

PHP Ajax: Perform action when database is updated

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related