예제 #1
0
 $monthly_step_goal = $daily_step_goal * date('t');
 //Get Percentages for progressbar
 $daily_step_percent = floor($dailysteps / $daily_step_goal * 100);
 $weekly_step_percent = floor($weeklysteps / $weekly_step_goal * 100);
 $monthly_step_percent = floor($monthlysteps / $monthly_step_goal * 100);
 //Daily HB Sensor Data
 $dailyHBdata = getSensorData($_SESSION['SE_User_ID'], "HB", "Daily");
 $dailyHB = $dailyHBdata[0];
 $lastdailyupdateHB = $dailyHBdata[1];
 //Weekly HB Sensor Data
 $weeklyHBdata = getSensorData($_SESSION['SE_User_ID'], "HB", "Weekly");
 $weeklyHB = $weeklyHBdata[0];
 $lastweeklyupdateHB = $weeklyHBdata[1];
 $weeklyHBsize = $weeklyHBdata[2];
 //Weekly HB Sensor Data
 $monthlyHBdata = getSensorData($_SESSION['SE_User_ID'], "HB", "Monthly");
 $monthlyHB = $monthlyHBdata[0];
 $lastmonthlyupdateHB = $monthlyHBdata[1];
 $monthlyHBsize = $monthlyHBdata[2];
 //Get weekly and monthly average heartbeat
 if ($weeklyHBsize == 0) {
     $weekly_avg_HB = 0;
 } else {
     $weekly_avg_HB = floor($weeklyHB / $weeklyHBsize);
 }
 if ($monthlyHBsize == 0) {
     $monthly_avg_HB = 0;
 } else {
     $monthly_avg_HB = floor($monthlyHB / $monthlyHBsize);
 }
 echo '
예제 #2
0
<?php

require "dbconnection.php";
if (isset($_GET["sensor"])) {
    getSensorData($_GET["sensor"], $conn);
} else {
    makeError(1);
    die;
}
function getSensorData($sensor, $conn)
{
    $sql = "SELECT * FROM `sensors` WHERE {$sensor} = 1";
    $result = $conn->query($sql);
    $json = array();
    if ($result->num_rows > 0) {
        // output data of each row
        while ($row = $result->fetch_assoc()) {
            $json = ["error" => 0, "id" => $row["id"], "lon" => $row["lon"], "lat" => $row["lat"], "waterlevel" => $row["waterlevel"], "lastDataTime" => $row["last data time"]];
            $encoded_json = json_encode($json);
            print_r($encoded_json);
        }
    } else {
        makeError(2);
        die;
    }
    $conn->close();
}
function makeError($errorNumber)
{
    $json = array();
    $json = ["error" => 1, "errornumber" => $errorNumber];