Sending DATA from ESP8266 to WebServer + via ArduinoIDE
Posted: Tue Oct 06, 2015 3:53 amHello Everyone!
I'll begin by saying that this community is awesome
providing wonderful and insightful information to noobs such as myself. Please bare with me as this is a long post.
GOAL: Send Data from an attached sensor to the ESP8266-01 to a WebServer and store that information in a mySQL DB running on the WebServer. I wanted to do everything from scratch, So I went ahead and half-assed my way through setting up a simple WebServer on my Laptop using WAMP (actually still in the process of finishing, I'll come back to this later).
PROGRESS: I have downloaded Arduino IDE support for ESP8266 and uploaded the following code on the ESP8266-01:
***********************************************************************************************
#include <ESP8266WiFi.h>
const char* ssid = "ssid";
const char* password = "password";
void setup(){
Serial.begin(115200);
delay(10);
WiFi.begin(ssid,password);
while(WiFi.status() != WL_CONNECTED){
delay(500);
Serial.println(".");
Serial.println("Connected to ");
Serial.println(ssid);
}
}
void loop(){
Serial.println("Hello, Internet");
delay(1000);
Serial.println("IP Address");
Serial.println(WiFi.localIP());
delay(2000);
}
***********************************************************************************************
With the above code running on the ESP8266-01 I am able to have the Chip connect to my SSID on bootup (I was also able to attach a Sensor to GPIO2 for collecting Analog Data, but kept the code out for simplification)
NEED HELP: Now we come to the reason why I've been pulling my hair for the past few weeks, Not knowing any HTML,PHP or Web programming I was able to understand the basics and created a simple Webpage, However I wasn't able to setup a mySQL DB where the incoming Data from ESP8266 will be stored, and nor have I any clue as to how to get he ESP8266 to SEND Data to the WebServer.
TO SUMMARIZE: PLEASE HELP WITH THE FOLLWOING
1) Sample code that allows the ESP8266 to SEND Data to a Webserver
2) Documentaiton/Guide for setting up a WebServer using WAMP and accepting the incoming Data from the ESP8266 and store that Data in a mySQL DB.
Would appreciate Help of any Sort. Be it Documentation/Videos/Tutorials/Guides etc.
Thanks Again for taking the time to Help.
Best
I'll begin by saying that this community is awesome
providing wonderful and insightful information to noobs such as myself. Please bare with me as this is a long post.GOAL: Send Data from an attached sensor to the ESP8266-01 to a WebServer and store that information in a mySQL DB running on the WebServer. I wanted to do everything from scratch, So I went ahead and half-assed my way through setting up a simple WebServer on my Laptop using WAMP (actually still in the process of finishing, I'll come back to this later).
PROGRESS: I have downloaded Arduino IDE support for ESP8266 and uploaded the following code on the ESP8266-01:
***********************************************************************************************
#include <ESP8266WiFi.h>
const char* ssid = "ssid";
const char* password = "password";
void setup(){
Serial.begin(115200);
delay(10);
WiFi.begin(ssid,password);
while(WiFi.status() != WL_CONNECTED){
delay(500);
Serial.println(".");
Serial.println("Connected to ");
Serial.println(ssid);
}
}
void loop(){
Serial.println("Hello, Internet");
delay(1000);
Serial.println("IP Address");
Serial.println(WiFi.localIP());
delay(2000);
}
***********************************************************************************************
With the above code running on the ESP8266-01 I am able to have the Chip connect to my SSID on bootup (I was also able to attach a Sensor to GPIO2 for collecting Analog Data, but kept the code out for simplification)
NEED HELP: Now we come to the reason why I've been pulling my hair for the past few weeks, Not knowing any HTML,PHP or Web programming I was able to understand the basics and created a simple Webpage, However I wasn't able to setup a mySQL DB where the incoming Data from ESP8266 will be stored, and nor have I any clue as to how to get he ESP8266 to SEND Data to the WebServer.
TO SUMMARIZE: PLEASE HELP WITH THE FOLLWOING
1) Sample code that allows the ESP8266 to SEND Data to a Webserver
2) Documentaiton/Guide for setting up a WebServer using WAMP and accepting the incoming Data from the ESP8266 and store that Data in a mySQL DB.
Would appreciate Help of any Sort. Be it Documentation/Videos/Tutorials/Guides etc.
Thanks Again for taking the time to Help.
Best