<?php
if (!session_start()) {
session_start();
}
include 'Controller/DB.php';
global $db, $dbcon;
$db = new DB();
$dbcon = $db->connect_db();
$browser_t = "View";
include 'Controller/Login_controller.php';
include 'Controller/Product_controller.php';
$current_page_uri = $_SERVER['REQUEST_URI'];
$part_url = explode("/", $current_page_uri);
$page_name = end($part_url);
$email_id = "*****@*****.**";
$file_url = 'http://' . $_SERVER['HTTP_HOST'] . '/' . $part_url[1];
$login = new Login_controller();
<?php
require "DB_config.php";
require "DB_class.php";
$day = $_GET['day'];
// connect database--MySQL
//---> host, account, pw, dbname setting in the DB_config.php <---//
// new a DB instance first
$db = new DB();
// then connect to your DB through DB_class.php you may check how to use by openning the DB_class.php
$db->connect_db($_DB['host'], $_DB['username'], $_DB['password'], $_DB['dbname']);
// write you query here:
$query = "SELECT epoch,value FROM sensor_data WHERE day='{$day}' AND entry='Pressure mbar'";
// execute query
$db->query($query);
// new an array for push your result into
$resultArray = [];
// fetch your result, result will be an Array return from MySQL
while ($result = $db->fetch_array()) {
$temArray = [];
$temArray['epoch'] = $result['epoch'];
$temArray['value'] = $result['value'];
array_push($resultArray, $temArray);
}
// make to json format:
$resultArray = json_encode($resultArray);
header('Content-type: application/json');
echo $resultArray;
//Write to file
//$fp = fopen("C:\\Users\\Spartan-117\\Documents\\Visual Studio 2015\\WebSites\\WebSite1\\gps.json", 'w');
//fwrite($fp, $resultArray);
header("Pragma: no-cache");
$module_ver = "V3.1.2";
//模組版本
date_default_timezone_set('Asia/Taipei');
//如果沒這個的話company 的 time_difference 要設28800，php 5.1以下版本請註解掉此功能
$db = new DB();
//============================開啟資料庫=================================
$dbname = "wonderd1_wd_sport";
// db name
$dbuser = "******";
// db username
$dbpw = "px8BvD^QBA8y";
// db password
$dbhost = "localhost";
// db server
$db->connect_db($dbhost, $dbuser, $dbpw, $dbname);
//$link = mysql_connect($dbhost, $dbuser, $dbpw) or die(mysql_error()); //需linux安裝指令 yum install php-mysql
//mysql_select_db($dbname, $link) or die(mysql_error());
//mysql_query("SET NAMES 'UTF8'");
//mb_internal_encoding("UTF-8"); //需linux安裝指令 yum install php-mbstring
//=======================================================================
//網域
define("App_host", $_SERVER['HTTP_HOST']);
//未對DNS的路徑
define("App_dir", "phpfbtest");
//=======================================================================
//資料表名稱
//類別
$race_class = "race_class";
//會員
$member = "member";
