#include <ESP8266WiFi.h>    // ESP8266
#include <ESP8266HTTPClient.h>
//#include <WiFi.h>           // ESP32
//#include <HTTPClient.h>


#include <ArduinoJson.h>
#include <jsonlib.h>
const char* ssid = "Saksri_truexxxx";
const char* password = "0804063131xxxx";

//const char* serverName = "http://saksri.net/test_db_mysql_1.php"; // เปลี่ยน URL ให้ถูกต้อง
const char* serverName = "http://192.168.1.34/test_db_mysql_1.php"; // เปลี่ยน URL ให้ถูกต้อง

float vmin,vnn;

  float temperature = 25.3; // ตัวอย่างค่าจากเซนเซอร์
  float humidity = 60.7;

void setup() {
  Serial.begin(115200);
  WiFi.begin(ssid, password);

  while (WiFi.status() != WL_CONNECTED) {
    delay(1000);
    Serial.println("Connecting to WiFi...");
  }
  Serial.println("Connected!");

  

  delay(10000); // รอ 10 วินาทีก่อนส่งอีกครั้ง
}

void loop() {
  if (millis()-vmin>10000)
  {
    vmin=millis();
    
  String   vd1="test001";
  String   vd2=String(temperature);
  String   vd3=String(humidity);
  String   vd4=String(vnn);
  String   vd5=String(123);    
   // sent_data(vd1,vd2,vd3,vd4,vd5);
    sent_to_database(vd1,vd2,vd3,vd4,vd5);
  vnn=vnn+1;  
    }
    
}
void sent_data(String v_d1,String v_d2, String v_d3, String v_d4, String v_d5)
{
if (WiFi.status() == WL_CONNECTED) {
    HTTPClient http;
    http.begin(serverName);
    http.addHeader("Content-Type", "application/x-www-form-urlencoded");

    String postData = "D1=" + v_d1 + "&D2=" + v_d2+ "&D3=" + v_d3+ "&D4=" + v_d4+ "&D5=" + v_d5  ;

    int httpResponseCode = http.POST(postData);
    String response = http.getString();
   String strg1 = jsonExtract(response, "vch1");
    Serial.print("HTTP Response code: ");
    Serial.println(httpResponseCode);
    Serial.println("Response: " + response);
         Serial.println("Response: " + strg1);
        
    http.end();
  }
}



void sent_to_database(String v_d1,String v_d2, String v_d3, String v_d4, String v_d5)
{
  Serial.println("get data");
  HTTPClient http;
  //http.begin("http://saksri.net/s4/home_smart_db_mysql.php?code="+vcode+"&vtopic="+vtopic+"&vbrs="+vbrs+"&vobj="+vobj+"&vch="+vch+"&vact="+vact);
  http.begin("http://192.168.1.34/test_db_mysql_1.php?D1="+ v_d1 + "&D2=" + v_d2+ "&D3=" + v_d3+ "&D4=" + v_d4+ "&D5=" + v_d5);
  int httpCode = http.GET();
  if (httpCode > 0)
  {
    String Payload = http.getString();
    
    String x = jsonExtract(Payload, "name");
    Serial.println(x);
  }
}