ESP8266 Community Forum

- Sat Jan 07, 2017 1:19 pm #60597 Hi
Is there someone who can help me and show me how i can receive data for database to esp, because i need this date in arduino sketch. I can send data to database, and this is my code in php:

Code: Select all<?php

$wartosc1 = $_GET['temperatura'];
$wartosc = $_GET['wilgotnosc'];

$connect = mysqli_connect("localhost","root","szynszyle","food") or die("blad polaczenia z baza danych");
 
if($wartosc!='')
{

$dodaj=mysqli_query($connect,"INSERT INTO device_values (device_id,temp_level,humidity_level) VALUES ('100','$wartosc1','$wartosc')");
echo "<h1>THE DATA HAS BEEN SEND!!</h1>";

mysqli_close($connect);
}
 
?>

and from arduino ide:

Code: Select all  String url = "http://localhost/food/conec.php?temperatura="+String(t)+"&wilgotnosc="+String(h);


  Serial.print("Wysylam dane na serwer: ");
  Serial.println(url);

  client.print(String("GET ") + url + " HTTP/1.1\r\n" +
               "Host: " + String(adresSerwera) + "\r\n" +
               "Connection: close\r\n" +
               "Content-Length: 0\r\n" +
               "\r\n");


And this works fine, but how to receive date?I will be very grateful for help.

- Sat Jan 07, 2017 1:56 pm #60601 If you wish to track the insert date/time in your database, no need to add that in the ESP <-> PHP server transaction, simply use MySQL "NOW()" to insert current DATETIME into a table field.

- Sat Jan 07, 2017 2:07 pm #60604 Actually i need values like maxiumum and minimum temperature, humidity and food form database. This data are in database and i need to receive them on esp, and use in arduino ide skech.

- Sat Jan 07, 2017 2:15 pm #60606 i know i should use http request and make script in php like in sending to database, but i've tried and it doesn't work. I'am doing something wrong.