PHP get_last_active Exemples

Exemple #1

Fichier : functions.php Projet : Rebelattonext/wifisensors

function put_data($data)
{
    include 'database.php';
    $dbhandle = mysqli_connect($hostname, $username, $password, $database) or die("Unable to connect to MySQL");
    $selected = mysqli_select_db($dbhandle, "esp");
    if (!$selected) {
        die("62 Could not select devices table");
    }
    if (!isset($data)) {
        $data = get_last_active();
    }
    //
    $data['esp_rx_date'] = date("Y-m-d");
    $data['esp_rx_time'] = date('H:i:s', time());
    $alarm = $data['esp_rx_level'] >= $data['esp_rx_treshold'] ? 1 : 0;
    if ($data['esp_actives'] == 999) {
        $sql = "UPDATE devices\n\t\t\tSET\n\t\t\t\tesp_rx_level    = '" . $data['esp_rx_level'] . "',\n\t\t\t\tesp_rx_treshold = '" . $data['esp_rx_treshold'] . "',\n\t\t\t\tesp_batt        = '" . $data['esp_batt'] . "',\n\t\t\t\tesp_zone        = '" . $data['esp_zone'] . "',\n\t\t\t\tesp_location    = '" . $data['esp_location'] . "',\n\t\t\t\tesp_rx_time     = '" . $data['esp_rx_time'] . "',\n\t\t\t\tesp_rx_date     = '" . $data['esp_rx_date'] . "',\n\t\t\t\tesp_actives     = '" . '0' . "'\n\t\t\tWHERE esp_id        = '" . $data['esp_id'] . "'";
    } else {
        $sql = "UPDATE devices\n\t\t\tSET\n\t\t\t\tesp_rx_level    = '" . $data['esp_rx_level'] . "',\n\t\t\t\tesp_rx_treshold = '" . $data['esp_rx_treshold'] . "',\n\t\t\t\tesp_batt        = '" . $data['esp_batt'] . "',\n\t\t\t\tesp_zone        = '" . $data['esp_zone'] . "',\n\t\t\t\tesp_location    = '" . $data['esp_location'] . "',\n\t\t\t\tesp_rx_time     = '" . $data['esp_rx_time'] . "',\n\t\t\t\tesp_rx_date     = '" . $data['esp_rx_date'] . "',\n\t\t\t\tesp_actives     = esp_actives + '" . $alarm . "'\n\t\t\tWHERE esp_id        = '" . $data['esp_id'] . "'";
    }
    echo $sql;
    if (!($result = mysqli_query($dbhandle, $sql))) {
        echo 'INVALID QUERY<br />';
        echo $sql;
    }
    mysqli_close($dbhandle);
}

Exemple #2

Fichier : monitor.php Projet : Rebelattonext/wifisensors

}
onload = function ()
{
  t = window.setInterval("displayLiveData()", 2000);
};
</script>

<?php 
/**
*
* @package ESP8266 Web Server
* @version $Id$
* @author  Michael O'Toole - aka michaelo
* @begin   Saturday, Jan 22, 2015
* @copyright (c) 2015 phpbbireland
* @home    http://www.phpbbireland.com
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/
define('IN_CODE', true);
$root_path = defined('ROOT_PATH') ? ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include $root_path . 'common.' . $phpEx;
include $root_path . 'includes/functions_main.' . $phpEx;
include $root_path . 'includes/functions.' . $phpEx;
$data = get_last_active();
$json_array = get_data($data['esp_id']);
include 'header.html';
include 'left_blocks.html';
include 'section_monitor.html';
include 'footer.html';