<?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";