hello i'm from
itenas. how do I connect esp8266 to the database. I have followed many tutorials but still can't. please tell me the code
What I have tried:
#include <ESP8266WiFi.h>
#include <DHT.h>
#define DHTPIN 4
#define DHTTYPE DHT11
DHT dht(DHTPIN, DHTTYPE);
const char* server = "fiksid.xyz";
const char* ssid = "f";
const char* password = "87654321";
const char* SensorID = "ESP001";
WiFiClient client;
void setup() {
Serial.begin(115200);
delay(10);
dht.begin();
pinMode(BUILTIN_LED, OUTPUT);
digitalWrite(BUILTIN_LED, HIGH);
WiFi.begin(ssid, password);
Serial.println();
Serial.println();
Serial.print("Connecting to ");
Serial.print(ssid);
WiFi.begin(ssid, password);
while (WiFi.status() != WL_CONNECTED) {
delay(500);
Serial.print(".");
}
Serial.println("");
Serial.println("WiFi Connected");
}
void loop() {
float h = dht.readHumidity();
float t = dht.readTemperature();
if (isnan(h) || isnan(t)) {
Serial.println("Gagal membaca sensor DHT");
return;
}
Serial.print("Temperature: ");
Serial.print(t);
Serial.print(" *C. Humidity: ");
Serial.println(h);
if (client.connect(server,8090)) {
Serial.print("Posting data...");
digitalWrite(BUILTIN_LED, LOW);
Serial.println("Temperature: " + String(t) + ", Humidity: " + String(h));
client.println("GET fiksid.xyz/connect.php? t=" + String(t) + "&&h=" + String(h) + "&&i=" +SensorID+ " HTTP/1.1");
client.println("HOST: fiksid.xyz");
client.println("Connection: close");
client.println();
client.stop();
Serial.println();
digitalWrite(BUILTIN_LED, HIGH);
}
delay(5000);
}
<pre lang="PHP">
<?php
$db_amb = mysqli_connect("localhost", "user", "password", "namadb");
if (!$db_amb) die("Gagal terkoneksi ke DB Utama. Error : " . mysqli_connect_error());
$t = $_REQUEST['t'];
$h = $_REQUEST['h'];
$IP = $_SERVER['REMOTE_ADDR'];
$i = $_REQUEST['i'];
if (!empty($t) && !empty($h) && !empty($i) && !empty($IP)) {
$s = "insert into log_sensor set IP='$IP', SensorID='$i', Temp='$t', Humid='$h', Waktu=now()";
$r = mysqli_query($db_amb, $s);
echo "OK";
}
else echo "ERR";
?>