ESP8266 WiFi MySQL database

Projects Programming
1

Hello everyone,
I’m working on barcode scanning terminal with WiFi connection. I want to check scanned ID in MySQL database using wifi connection. In easy words - I have string variable and and I want to check if it is present in MySQL database. How can I achieve this?

2

Just write a simple PHP script that takes data from an HTTP request, performs the database operation, and sends a response back to the ESP.

http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers

Pieter

3

So - I guess there’s a simple method to reach php script from esp8266.

4

Yes, just use the WiFiClient class to establish a TCP connection to the server, send it an HTTP request, and read back the response.

Pieter