Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $server = "localhost";
- $userName = "root";
- $password = "";
- $databaseName = "CPUmonitor";
- $currentTime = time();
- $tableName = $_POST['tableName'];
- $min = $_POST['min'];
- $max = $_POST['max'];
- $live = $_POST['live'];
- if($live == 1) {
- $live = True;
- }
- else {
- $live = False;
- }
- $liveRange = $_POST['liveRange'];
- $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 ".$tableName;
- $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 myVM");
- if($live) {
- $query = mysqli_query($conn, "SELECT * FROM ".$tableName." ORDER BY time DESC LIMIT ".$liveRange);
- }
- else {
- $query = mysqli_query($conn, "SELECT * FROM ".$tableName." WHERE time BETWEEN ".$min." AND ".$max);
- }
- $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;
- exit();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement