data.php

gistfile1.txt

<?php
// Include database connection
include 'connect.php';

// Declare result array
$result = array(
    'nameA'     => ' Temperatur',
	  'nameB'     => ' Setpoint',
    'category'  => array(),
    'data1'     => array(),
	  'data2'     => array(),
);
// Get MySQL connection resource
$mysql = GetMyConnection();

// Get data SQL parameter from request query or default date

$dateParam = array_key_exists('dateParam', $_GET) ? mysql_real_escape_string($_GET['dateParam']) : '2015-12-24';
//$dateParam = '2015-12-20';

// Execute select query
if(!$query = mysql_query("SELECT `Time`,`SP1`, `Tilgang` FROM `ebpool` WHERE `Time` LIKE '" . $dateParam . "%'", $mysql))

{
    die("Query error: " . mysql_errno($mysql) . ": " . mysql_error($mysql));
}
// Get each table row
while($row = mysql_fetch_array($query)) 
{    
    $result['category'][] = $row['Time'];
   	$result['data1'][] = $r['Tilgang'];
    $result['data2'][] = $r['SP1'];
}
// Clean up database result
CleanUpDB();
// Output result as JSON
echo json_encode($result, JSON_NUMERIC_CHECK);
?>