hi .write code to send my nodemcu sensor data to my computer .i want get data from nodemcu and store in mysql database with xampp but when nodemcu want to connect to xampp get timeout error(400);
here my code:can you help me?
#include <ESP8266WiFi.h>
#include <Wire.h>
#include "SSD1306.h"
#include "DHT.h"
char* ssid = "shuttle";
char* pass= "131376760000";
char* host ="192.168.1.3";
#define DHTPIN D3
#define DHTTYPE DHT22
DHT dht(DHTPIN, DHTTYPE); //define Instance for DHT.h Library
SSD1306 display(0x3c, 4, 5); //define Instance for OLED1306 Library
int localHum = 0;
int localTemp = 0;
int thingtemp = 0 ;
int thinghum = 0 ;
int GASvalue = 0;
void setup() {
// put your setup code here, to run once:
Serial.begin(115200);
Serial.print("connecting.");
WiFi.begin(ssid,pass);
while(WiFi.status()!= WL_CONNECTED){
Serial.print(".");
delay(500);
}
Serial.println("");
Serial.println("wifi connected");
Serial.println("ip adress is:");
Serial.println(WiFi.localIP());
int value=0;
dht.begin();
display.init();
display.flipScreenVertically();
display.setFont(ArialMT_Plain_16);
display.setTextAlignment(TEXT_ALIGN_LEFT);
display.drawString(0 , 0, "Please wait \n for the device\n to be ready");
display.display();
delay(3000);
display.clear();
display.drawString(0 , 0, "hello \n amir hosein");
}
void loop() {
Serial.println("connecting to host");
Serial.println(host);
WiFiClient client;
const int httpPort=80;
if(!client.connect(host,httpPort)){
Serial.println("conncetion failed");
return;
}
// put your main code here, to run repeatedly:
//getDHT(); //read DHT 22 Sensor data
// drawDHT(); //show DHT sensor data on OLED
// drawGAS_sensor(); //Read and show mq9 sensor On OLED
String url ="/tosave.php?";
url+="temp=";
url+=localTemp;
url+="&hum=";
url+=localHum;
url+="&gaslevel=";
url+=GASvalue;
Serial.print("Requesting URL: ");
Serial.println(url);
client.print(String("GET") + url + " HTTP/1.1\r\n" +
"Host: "+host + "\r\n"
"Connection: close\r\n\r\n");
unsigned long timeout = millis();
while(client.available() ==0){
if (millis() - timeout > 5000) {
Serial.println(">>>client Timeout !");
client.stop();
return;
}}
while(client.available()){
String line = client.readStringUntil('\r');
Serial.print(line);
}
Serial.println();
Serial.println("closing connection");
delay(3000);
}
void getDHT(){
localTemp = dht.readTemperature(); //READ DHT22 Tepmerature
localHum = dht.readHumidity(); //READ DHT22 Humidity
if (isnan(localHum) || isnan(localTemp) ) {
localTemp=thingtemp;
localHum=thinghum;
return;
}
if (localHum >99 || localTemp>99){
localTemp=thingtemp;
localHum=thinghum;
return;
}
}
/***************************************************
* Draw DHT22 Page
****************************************************/
void drawDHT(){
int x=0;
int y=0;
display.setFont(ArialMT_Plain_10);
display.setTextAlignment(TEXT_ALIGN_LEFT);
display.drawString(43 + x, y, "DHT22");
display.setFont(ArialMT_Plain_10);
display.setTextAlignment(TEXT_ALIGN_LEFT);
display.drawString(0 + x, 5 + y, "Hum");
display.setFont(ArialMT_Plain_24);
String humdht22 = String(localHum);
display.drawString(0 + x, 15 + y, humdht22 + "%");
display.setFont(ArialMT_Plain_10);
display.setTextAlignment(TEXT_ALIGN_LEFT);
display.drawString(95 + x, 5 + y, "Temp");
display.setFont(ArialMT_Plain_24);
String tempdht22 = String(localTemp) ;
display.drawString(70 + x, 15 + y, tempdht22+ "°C");
}
void drawGAS_sensor() {
int x=0;
int y=0;
for(int i = 0; i < 10; i++) {
GASvalue += analogRead(A0); //summation for A0 reads
delay(50);
}
GASvalue = GASvalue/10;
String GAS(GASvalue); // convert to string
display.setFont(ArialMT_Plain_10);
display.setTextAlignment(TEXT_ALIGN_LEFT);
display.drawString(34 + x, 37+y, "GAS Level");
display.setFont(ArialMT_Plain_16);
display.drawString(45,48,GAS );
}
and the php code:
connecting.php
<?php
$servername = "localhost";
$username ="root";
$password = "";
$dbname = "bdbnodemcu";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>
tosave.php
<?php
include('connecting.php');
$temp = $_GET['temp'];
$hum = $_GET['hum'];
$gaslevel = $_GET['gaslevel'];
$stmt = $conn->prepare("INSERT INTO weather (temp, hum, gaslevel) VALUES (?, ?, ?)");
$stmt->bind_param("sss", $temp, $hum, $gaslevel);
if($stmt->execute()){
echo("register successfully");
}
else{
echo("register faild");
}
?>