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

#define myPeriodic 15 //in sec | Thingspeak pub is 15sec
#define ONE_WIRE_BUS 2  // DS18B20 on arduino pin2 corresponds to D4 on physical board

OneWire oneWire(ONE_WIRE_BUS);
DallasTemperature DS18B20(&oneWire);
float prevTemp = 0;
const char* server = "172.168.2.143";

const char* MY_SSID = "AkhuogTkhbbEjhbuvouvr7i2";
const char* MY_PWD = "2pkpmbipsrbeirbp3niag%";
int sent = 0;

void setup() {
  Serial.begin(115200);
  connectWifi();
}

void loop() {
  float temp;
  //char buffer[10];
  DS18B20.requestTemperatures();
  temp = DS18B20.getTempCByIndex(0);
  //String tempC = dtostrf(temp, 4, 1, buffer);//handled in sendTemp()
  Serial.print(String(sent)+" Temperature: ");
  Serial.println(temp);

  //if (temp != prevTemp)
  //{
  //sendTemperatureTS(temp);
  //prevTemp = temp;
  //}

  sendTemperatureTS(temp);
  int count = myPeriodic;
  while(count--)
  delay(1000);
}

void connectWifi()
{
  Serial.print("Connecting to "+*MY_SSID);
  WiFi.begin(MY_SSID, MY_PWD);
  while (WiFi.status() != WL_CONNECTED) {
  delay(1000);
  Serial.print(".");
  }

  Serial.println("");
  Serial.println("Connected");
  Serial.println("");
}//end connect

void sendTemperatureTS(float temp)
{
   WiFiClient client;

   if (client.connect(server, 80)) {
   Serial.println("WiFi Client connected ");

   String postStr = "/php/";
   postStr += "?temp=";
   postStr += String(temp);
   postStr += "rnrn";

   client.print("POST 172.168.2.143/php/collectdata.php HTTP/1.1n");
   client.print("Host: 122.168.2.143n");
   client.print("Connection: closen");

   client.print("Content-Type: application/x-www-form-urlencodedn");
   client.print("Content-Length: ");
   client.print(postStr.length());
   client.print("nn");
   client.print(postStr);
   delay(1000);

   }//end if
   sent++;
 client.stop();
}

<?php

$servername = “172.168.2.143”;
$username = “esp8266”;
$password = “Tutorial”;
$dbname = “esp8266”;

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