getdata.php

<?php
// Get data from Fitbit Website through its API

include_once("config.php");


// Get session vars from cookies if possible
if (isset($_COOKIE['fb_client_id']) && $_COOKIE['fb_client_id'] != '') {
	$fb_client_id = $_COOKIE['fb_client_id'];
	$_SESSION['fb_client_id'] = $fb_client_id;
}

if (isset($_COOKIE['fb_access_token']) && $_COOKIE['fb_access_token'] != '') {
	$fb_access_token = base64_decode($_COOKIE['fb_access_token']);
	$_SESSION['fb_access_token'] = $fb_access_token;
}

// VALIDATE THE VARIABLES
// Step 1 - Validation of Date Availability
if (isset($_GET['date'])) {
	$date = $_GET['date'];
} else {
	exit("No date information is provided. Please provide date in YYYY-MM-DD format.");
}

// Step 2 - Validation of Date Format
if (!validateDate($date . ' 00:00:00')) {
	exit("Date is not in a valid format. Please use YYYY-MM-DD Format. Sorry.");
}

// Step 2a - Validation of Next Date Availability
if (isset($_GET['next'])) {
	$tempnext = $_GET['next'];
	if (validateDate($tempnext . ' 00:00:00')) {
		$next = $_GET['next'];
	} else {
		$next = $date;
	}
} else {
	$next = $date;
}

// Step 3 - Validation of Access Token
if (!isset($_SESSION['fb_access_token']) || trim($_SESSION['fb_access_token']) == "") {
	exit("No access token available. Please <a href='./index.php'>try again</a>.");
} else {
	$access_token = trim($_SESSION['fb_access_token']);
}

// Step 4 - Validation of Client ID
if (!isset($_SESSION['fb_client_id']) || trim($_SESSION['fb_client_id']) == "") {
	exit("No access token available. Please <a href='./index.php'>try again</a>.");
} else {
	$fb_client_id = trim($_SESSION['fb_client_id']);
}

// GET DATA FROM FITBIT
// Step 1 - Prepare URL
//$url = "$config_api_url/$date/1d/1sec/time/00:00/23:50.json";
$url = "$config_api_url/$date/1d/1sec.json";
$headers = array("Authorization: Bearer $access_token");

// Step 2 - Get from Fitbit
$data = curl($url, $headers);

// Step 3 - Sanitize
$date = safe($date);
$user = safe($fb_client_id);
$data = safe($data);

// Step 4 - Delete existing data
$q = "delete from `data_raw` where `data_raw`.`fbuser` = '$user' and `data_raw`.`fbdate`='$date'";
if (mysqli_query($config_conn, $q)) {
	// Step 5 - Insert into database
	$q = "insert into `data_raw` set fbuser = '$user', fbdate='$date', fbjsondata='$data'";
	if (mysqli_query($config_conn, $q)) {
		header("Location: data.php?date=$next&rand=" . rand());
		mysqli_close($config_conn);
	} else {
		exit("There was an error synchronising with Fitbit: " . mysqli_error($config_conn));
	}
} else {
	exit("There was an error synchronising with Fitbit: " . mysqli_error($config_conn));
}