<?php

exec("/usr/bin/python /home/pi/temperatura/Adafruit_Python_DHT/examples/AdafruitDHT.py 11 4",$salida);
$escribir = implode('',$salida);
$escribir = trim($escribir);

$t1 = explode('emp=',$escribir);
$t2 = explode('*  Humidity=',$t1[1]);

$temperatura = trim($t2[0]);

$hostname = exec("hostname");

$date = date("Y:m:d H:m:s");

$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "datos";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO temperatura (name, fecha, valor)
VALUES ('$hostname', '$date', '$temperatura')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

?>

<?php
function conectar_bd(){
    $link = @mysqli_connect('localhost', '*****', '*****', '*****');
    if(!$link){
        die('Connect Error: ' . mysqli_connect_errno());
    }
    return($link);
}
?>

<?php

$temperatura = ($_POST['t'])?$_POST['t']:$_GET['t'];
$nombre = ($_POST['n'])?$_POST['n']:$_GET['n'];
$humedad = ($_POST['h'])?$_POST['h']:$_GET['h'];

include ("libnube.inc");

$link = conectar_bd();

$date = time();

$querytemp = "INSERT INTO temperatura (name, fecha, valor) VALUES ('.$nombre.', '.$date.', '.$temperatura.')";
if (mysqli_query($link, $querytemp) === false) {
  die ('Error al ejecutar la consulta de temperatura: '.$querytemp.' - Error: '.mysqli_connect_errno()."n");
}

?>