วิธีการส่งข้อมูลจาก NodeMCU-V.3(esp8266) ไปเก็บไว้ใน mySQL บน 000webhost.com

<?php
class xxxx{
 public $link='';
 function __construct($A, $B, $C){
  $this->connect();
  $this->storeInDB($A, $B, $C);
 }
 
 function connect(){
  $this->link = mysqli_connect('localhost','aaaa','') or die('Cannot connect to the DB');
  mysqli_select_db($this->link,'bbbb') or die('Cannot select the DB');
 }
 
 function storeInDB($A, $B, $C){
  $query = "insert into xxxx set C='" .$C."', B='".$B."', A='".$A."';
  $result = mysqli_query($this->link,$query) or die('Errant query:  '.$query);
 }
 
}
if($_GET['A'] != '' and  $_GET['B'] != '' and  $_GET['C'] != ''){
 $dht11=new realproject($_GET['A'],$_GET['Bs'],$_GET['C']);
}
?>

#include <ESP8266WiFi.h>
#include <WiFiClient.h>
#include <ESP8266WebServer.h>
#include <ESP8266mDNS.h>
#include <SPI.h>

String data; 
String dat1, dat2, dat3;

float A,B,C;

const char* ssid = "abc";// 
const char* password = "acb";
//WiFiClient client;
const char* host = "xxxx.000webhostapp.com";

WiFiClient client;    

void setup()
{
 Serial.begin(9600);
  delay(10);
  // Connect to WiFi network
  Serial.println();
  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");
 
  // Start the server
//  server.begin();
  Serial.println("Server started");
  Serial.println("IP address: ");
  Serial.print(WiFi.localIP());
  delay(1000);
  Serial.println("connecting...");
}

void loop() 
{
 if(Serial.available() > 0) 
 {
    data = Serial.readStringUntil('\n'); 
    dat1  = getValue(data, ',', 0);
    dat2  = getValue(data, ',', 1);
    dat3  = getValue(data, ',', 2);
    
    A = dat1.toFloat();
    B = dat2.toFloat();
    C = dat3.toFloat();
    Sending_To_phpmyadmindatabase();
 }
}

void Sending_To_phpmyadmindatabase()   //CONNECTING WITH MYSQL
{
   Serial.print("connecting to ");
   Serial.println(host);

   WiFiClient client;
   const int httpPort = 80;
   
   if (client.connect(host, httpPort)) 
   {
    String url = "/public_html/testweb/newconnect.php?C=" + String(C) +"&B=" +String(B)+"&A=" +String(A);
    Serial.print("Requesting URL: ");
    Serial.println(url);

    client.print(String("GET ") + url + " HTTP/1.1\r\n" +
                  "Host: " + host "\r\n" +
                  "Connection: cloase\r\n\r\n");
    } else 
    {
    // if you didn't get a connection to the server:
    Serial.println("connection failed");
    return;
    }
} 

/////////////////////// ฟังก์ชันการแยกข้อมูล String ///////////////////////                      
String getValue(String data, char separator, int index)       
{
  int found = 0;                                         
  int strIndex[] = {0, -1  };                                
  int maxIndex = data.length()-1;                              
  for(int i=0; i<=maxIndex && found<=index; i++){             
  if(data.charAt(i)==separator || i==maxIndex){               
  found++;                                                    
  strIndex[0] = strIndex[1]+1;                               
  strIndex[1] = (i == maxIndex) ? i+1 : i;                    
  }
 }
  return found>index ? data.substring(strIndex[0], strIndex[1]) : "";   
}