#include <WiFi.h>
#include <HTTPClient.h>
#include <MySQL_Connection.h>
#include <MySQL_Cursor.h>
#include <NewPing.h>

#define TRIGGER_PIN  25  
#define ECHO_PIN     26 
#define MAX_DISTANCE 200 
#define WIFI_SSID "Wokwi-GUEST"
#define WIFI_PASSWORD ""
#define MYSQL_HOST "localhost"
#define MYSQL_PORT 3306
#define MYSQL_USER "root"
#define MYSQL_PASSWORD ""
#define MYSQL_DATABASE "sensor"

char INSERT_SQL[200];

NewPing sonar(TRIGGER_PIN, ECHO_PIN, MAX_DISTANCE);

void setup() {
  Serial.begin(115200);
  WiFi.begin(WIFI_SSID, WIFI_PASSWORD);
  while (WiFi.status() != WL_CONNECTED) {
    delay(1000);
    Serial.println("Connecting to WiFi...");
  }
  Serial.println("WiFi connected");
}

void loop() {
  
  int distance = sonar.ping_cm();
  Serial.println(distance);
  if (distance != 0) {
    Serial.print("Distance: ");
    Serial.print(distance);
    Serial.println(" cm");
    if (sendData(distance)) {
      Serial.println("Data sent successfully");
    }
    else {
      Serial.println("Data could not be sent");
    }
  }
  delay(2000);
}

bool sendData(int distance) {
  WiFiClient client;
  HTTPClient http;
  http://xammp/htdocs/esp32/insert_data.php);
  http.addHeader("Content-Type", "application/x-www-form-urlencoded");
  String post_data = "distance=" + String(distance);
  int http_code = http.POST(post_data);
  http.end();
  return http_code == 200;
}