Reading from SQL database (GET)

Getting Started
1

Hello,

I would like to read data from a SQL database (strings) however I could not find a good example on the internet.

The project is a led matrix ticker where people can go to a website where they can update the displayed text. The website contains of a php script that puts data in a sql database.

Now I would like to let my photon (or wemos D1) to GET this data.

On the internet I only found these two “tutorials” but they do not work for me. It seems that both are for local use (?). There exists a lot of tutorials for writing so i’m doubting if it is even possible.
ttp://ice786pk.com/?p=662
http://afterhoursengineering.net/blog/blog/2015/04/11/esp8266-read-and-write-data-to-a-database/

I’m not that experienced with coding hardware. So If you could point me to a step by step guide that would be awesome! :slight_smile:

Thank you in advance,
Mark

ticker1
ticker1889×682 49.9 KB
ticker2
ticker21043×487 58.5 KB

2

You'd need a server/service running on your SQL host which listens on a port to which you send the GET request which then collects the data from your DB an returns the data via the HTTP response.
If you want to do that in a secure fashion you'd want to do that via a webhook.

This thread may be a bit old and uses some outdated syntax, but it might provide some pointers