<?php
$servername = "localhost";
$dbname     = "cha63191_ESP8266_Temp";
$username   = "cha63191_pablo";
$password   = "MlD_RtZ5hN-L";

$tipo   = $_POST['val_formulario'];
                                                                    
$conn = new mysqli($servername, $username, $password, $dbname);     // Create connection
                                                                    
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);              // Check connection
} 

//$sql = "SELECT value1, value2, value3, reading_time FROM Sensor_BME280 order by reading_time desc limit 1";
$sql = "SELECT value1, value2, value3, reading_time FROM Sensor_BME280 WHERE ubicacion LIKE '%".$tipo."%' order by reading_time desc limit 1";
//$sql = "SELECT value1, value2, value3, reading_time FROM Sensor_BME280 WHERE ubicacion LIKE '%casa%' order by reading_time desc limit 1";


$result = $conn->query($sql);

if ($result->num_rows > 0) {

    while($row = $result->fetch_assoc()) {
      
        $value1 = $row['value1'];
        $value2 = $row['value2'];
        $value3 = $row['value3'];
        
        $reading_time = $row['reading_time'];


        $datos = array( 'value1' => $value1,  'value2' => $value2, 'value3' => $value3, 'reading_time' => $reading_time );
        
        echo json_encode($datos, JSON_FORCE_OBJECT);
        
    }
} 

    else {
      echo "0 results";
    }

$conn->close();
?>