nestgraph/insert.php at master · mycon/nestgraph · GitHub

History

47 lines (40 loc) · 1.87 KB

Raw

<?php

require 'inc/config.php';

require 'inc/class.db.php';

require 'collect.php';

require 'yahoo-api-master/YahooWeather.class.php';

try {

$db = new DB($config);

$temperature_units = strtolower($config['temperature_units']);

//Yahoo now needs Oauth1 to get weather... fix later.

$yahoo = new YahooWeather($config['yh_consumerKey'], $config['yh_consumerKeySecret'], $config['yh_applicationId'], (int)$config["local_woeid"], $temperature_units);

$temperature = sprintf("%.02f", $yahoo->getTemperature(false));

$humid = sprintf("%.02f", $yahoo->getHumidity(false));

$pressure = sprintf("%.02f", $yahoo->getPressure(false));

//echo "Temperature:" . $temperature . "\n";

if ($result = $db->res->query("SELECT id, serial FROM devices")) {

while ($row = mysqli_fetch_row($result)) {

$data = get_nest_data($row[1]);

//print_r($data);

if (!empty($data['timestamp']))

{

if ($stmt = $db->res->prepare("REPLACE INTO data (device_id, timestamp, heating, cooling, fan, autoAway, manualAway, leaf, target, target2, current, humidity, outsideTemperature,outsideHumidity,outsidePressure, updated) " .

"VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,NOW())"))

{

$stmt->bind_param("isiiiiiidddiiii", $row[0], $data['timestamp'], $data['heating'], $data['cooling'], $data['fan'], $data['autoAway'], $data['manualAway'], $data['leaf'],

$data['target_temp'], $data['target_temp2'], $data['current_temp'], $data['humidity'],$temperature, $humid, $pressure);

if (!$stmt->execute())

{

echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error;

}

$stmt->close();

}

mysqli_free_result($result);

}

$db->close();

} catch (Exception $e) {

$errors[] = ("DB connection error! <code>" . $e->getMessage() . "</code>.");

}

nestgraph/insert.php at master · mycon/nestgraph · GitHub

Expand file tree

Breadcrumbs

insert.php

Latest commit

History

Breadcrumbs

insert.php

File metadata and controls