<?php
$t=time();
//echo($t . "<br>");
$y=date("Y",$t);
$m=date("m",$t);
$d=date("d",$t);
//echo $y;
//echo $m;
//echo $d;
$v3 = $_POST['temp'];
//$i3 = $_POST['i2'];
//$p3 = $_POST['p2'];
//$e3 = $_POST['e2'];
//$f3 = $_POST['f2'];
//$pf3 = $_POST['pf2'];
//$v3 = 33;
echo "V3=".$v3;
$min1 = date("i",$t);
$date=date("y-m-d H:i:s");





// Create connection
$conn = mysqli_connect("localhost", "u298086314_ESP8266", "ESP8266_IoT", "u298086314_ESP8266");
//$conn = mysqli_connect($servername, $username, $password,"id14992095_powermeter");

// Check connection
if (!$conn) {
  die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully\r\n";



//echo $min0;
//echo $min1;



$sql = "UPDATE Test_IOT SET V1=".$v3." WHERE ID=1";
//$sql = "UPDATE power_meter SET volt=".$v3.",current=".$i3.",power=".$p3.", energy=".$e3.", pf=".$pf3." , min=".$min1." WHERE id=1";
echo $sql;
if(mysqli_query($conn, $sql)){
   echo "Records were updated successfully.";
} else {
    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}



mysqli_close($conn);


 //echo "V=".$v3." I=".$i3. " P=".$p3.  " E=".$e3. "F=".$f3. "PF=".$pf3. "\r\n";
 //echo "123\r\n";
 ?>