Problem getting ESP01 to MySQL with AT commands

Projects Programming
1

My setup consists of an arduino MEGA, an ESP8266-01 wifi module and an mq4 sensor whose values I want to store in a database, I have set up MySQL and can send values via apache like http://192.168.1.6/insertMQ4.php?MQ4_CO_ppm=1&MQ4_alcohol_ppm=2&MQ4_smoke_ppm=3&MQ4_H2_ppm=4&MQ4_LPG_ppm=5&MQ4_CH4_ppm=6

Now I have a problem that I don't really know how to do this via AT commands, when I try the following no new values appear in the database:

AT+CIPSTART="TCP","192.168.1.6",80

CONNECT

OK
AT+CIPSEND=159


OK
> GET /insertMQ4.php?MQ4_CO_ppm=1&MQ4_alcohol_ppm=2&MQ4_rook_ppm=3&MQ4_H2_ppm=4&MQ4_LPG_ppm=5&MQ4_CH4_ppm=6 HTTP/1.1
*enter*
Host: 192.168.1.6
*enter*
Connection: keep alive
*enter*

SEND OK
AT+CIPCLOSE

CLOSED

Does anyone know how I can do this correctly and which AT commands I should use?

Thank you in advance

2

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.