0 votes

Push notifications in android with mysql, php and firebase

I have two tables A and B in MySQL. When a new record is inserted in a trigger inserted another in B. What would be the correct way to do that when you create that record in B can run a query that will allow me to send the notice through firebase with php?What through another trigger?.

The code to send the message by firebase is not what is important.

0voto

Jorge Ortiz Points 1

As to your table B add a column called FLAGENVIO(0=not shipped , 1=shipped) , create a scheduled task or a daemon that periodically check to see that table and each time you find that the FLAGENVIO is equal to zero , send a notification with the data of that record and update the FLAGENVIO to 1

HolaDevs.com

HolaDevs is an online community of programmers and software lovers.
You can check other people responses or create a new question if you don't find a solution

Powered by:

X