NodeMCU отправляет данные на сервер Raspberry Pi — phpMyAdmin

В настоящее время у меня возникают проблемы с отправкой данных, собранных с датчика температуры, на мой Raspberry Pi. Пи говорит, что не получил никаких данных. Я также не уверен, как работают GET и POST. Я довольно новичок в этом деле, поэтому любая помощь будет высоко ценится.

Код NodeMCU:

#include <ESP8266WiFi.h>
#include <OneWire.h>
#include <DallasTemperature.h>
//#include <WiFiEspClient.h>

/********************************************************************/
// Data wire is plugged into pin 2 on the Arduino
#define ONE_WIRE_BUS D4

/********************************************************************/
// Setup a oneWire instance to communicate with any OneWire devices
// (not just Maxim/Dallas temperature ICs)
OneWire oneWire(ONE_WIRE_BUS);

/********************************************************************/
// Pass our oneWire reference to Dallas Temperature.
DallasTemperature sensors(&oneWire);

// Init library
WiFiClient client;
//dht DHT;
// Wifi config, ssid = wifi name & password = wifi password
const char* ssid = "ATkudnisdb0TAbEdfhrsdhg7i2";
const char* password = "2pkpmp3niagfdhgsdfhg%";
// Get data host
const char* host = "172.168.2.143";
// Your domain remember don't add slash at the end or http it will not work
const char* streamId   = "collectdata.php";
// Sensor values
//int humidityValue = 0;
int tempValue = 0;

void sendRequest(){
Serial.print("connecting to ");
Serial.println(host);
// Use WiFiClient class to create TCP connections
WiFiClient client;
const int httpPort = 80;
if (!client.connect(host, httpPort)) {
Serial.println("connection failed");
}
// We now create a URI for the request
String url = "/php/";
url += streamId;
url += "?temp=";
url += tempValue;
Serial.print("Requesting URL: ");
Serial.println(url);
// This will send the request to the server
client.print("POST " + url + " HTTP/1.1\r\n" +
"Host: " + host + "\r\n" +
"Connection: close\r\n\r\n");
delay(1000);
Serial.println();
Serial.println("closing connection");
delay(2500);
}

void setup() {
sensors.begin();
Serial.begin(9600);
Serial.println();
Serial.print("Connecting to ");
Serial.println(ssid);
WiFi.begin(ssid, password);
while (WiFi.status() != WL_CONNECTED) {
delay(500);
Serial.print(".");
}
Serial.println("");
Serial.println("WiFi connected");
Serial.println("IP address: ");
Serial.println(WiFi.localIP());
//digitalWrite(blue, HIGH);
}

void loop() {
Serial.print(" Requesting temperatures...");
sensors.requestTemperatures();
tempValue = sensors.getTempCByIndex(0);
Serial.print(tempValue);
// Send the command to get temperature readings
sendRequest();
}

Код PHP:

<?php
$servername = “localhost”;
$username = “esp8266”;
$password = “Tutorial”;
$dbname = “esp8266”;

$mood = $_GET[‘mood’];
$conn = mysql_connect(“localhost”,”esp8266”,”Tutorial”);
if(!$conn) {
die(‘Could not connect: ’ . mysql_error());
}
$datenow = date(‘Y-m-d’);
$sql = “INSERT INTO `JSDataTable`(`logdate`,`mood`) VALUES (\”$datenow\”,\”$mood\”)”;
$result = mysql_query($sql);
if(!result) {
die(‘Invalid query: ‘ . mysql_error());
}
echo “<h1>The data has been sent!</h1>”;
mysql_close($conn);
?>