I have (after plenty of help from the likes of ScruffR and others) managed to update a mysql database with a string from my photon and was wondering if it is possible to reverse the procedure and save the data from the database to the photons eeprom at given intervals. Would I somehow have to create a php page which would request the data from the database which passed it on to the subscribing photon or would I create a function on the photon which request the information from the database. I’m just not sure of the best way to go about it.
You would send the data via a
Particle.function() POST request.
@benjiiiiuk did this solve your question?
not really I was still looking in to it. so would the photon send the request from the sql database then store it in the eeprom ?
That doesn’t make sense. The Photon doesn’t host the DB so it can’t send a request from it.
Both is possibe, but what do you want?
For option 1 you’d need a
Particle.function() that you call from your PHP to transmit the data from your DB to the device.
For option 2 you’d use a webhook where the device sends an event to request the data from the DB to which the DB responds and the device subscribes to the respective
That helps a lot thanks I can now look at each method and see which best suits. Thanks for your help