<?php
header("Content-Type: text/javascript; charset=utf-8");
session_start();
$server = "localhost";
$userName = "root";
$password = "1844";
$databaseName = "CPU";
$currentTime = time();
$tableName = $_POST['tableName'];

$conn = mysqli_connect($server, $userName, $password) or die('Error connecting to server');

mysqli_select_db($conn, $databaseName);

$columns = array();
$table = array();
$table['cols'] = array();
$sql = "SHOW COLUMNS FROM XPS13";
$result = mysqli_query($conn,$sql);
while($thing = mysqli_fetch_array($result)){
    array_push($table['cols'],array("label"=>$thing['Field'],"type"=>"number"));
    array_push($columns,$thing['Field']);
}
$query = mysqli_query($conn,"SELECT * FROM XPS13");
$rows = array();
while($r = mysqli_fetch_assoc($query)) {
    $temp = array();
    for($i = 0; $i < count($columns); $i++) {
        array_push($temp, array("v" => (float)$r[$columns[$i]]));
    }
    array_push($rows, array("c" => $temp));
}

$table['rows'] = $rows;

$jsonTable = json_encode($table, true);
echo $jsonTable;

/*$jsonfile = fopen('data.json','w');
fwrite($jsonfile, $jsonTable);
fclose($jsonfile);
*/
exit();
?>