comparison: www/getispindellog.php
www/getispindellog.php
- changeset 837
- b5e2ff72cc73
- parent 627
- f1a7c14d5601
- child 848
- 542bdc7f6522
equal
deleted
inserted
replaced
| 836:409f8c497429 | 837:b5e2ff72cc73 |
|---|---|
| 1 <?php | 1 <?php |
| 2 | 2 |
| 3 require_once('config.php'); | 3 require_once('config.php'); |
| 4 | 4 |
| 5 if (isset($_GET["code"])) | 5 if (isset($_GET["code"])) |
| 6 $code = $_GET["code"] . ' ' . $_GET["name"]; | 6 $code = $_GET["code"]; |
| 7 else | 7 else |
| 8 $code = "CB0081 Keuls"; | 8 $code = "CB0111"; |
| 9 | 9 |
| 10 $filename = 'log/ispindel/' . $code . '.log'; | 10 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
| 11 if (! file_exists($filename)) { | 11 if (! $connect) { |
| 12 header("Content-type: application/json"); | 12 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
| 13 echo '{}'; | |
| 14 exit; | |
| 15 } | 13 } |
| 14 mysqli_set_charset($connect, "utf8" ); | |
| 16 | 15 |
| 16 $query = "SELECT * FROM log_ispindel WHERE code='".$code."' ORDER BY datetime;"; | |
| 17 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | |
| 18 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | |
| 17 | 19 |
| 18 /* | 20 $logs[] = array( |
| 19 * 2014-11-15 18:39:12,TEMPERATURE,PLATO,SG,BATTERY,ANGLE,INVERVAL,UUID | 21 'date' => substr($row['datetime'],0,16), |
| 20 * | | | | | | 22 'temperature' => $row['temperature'], |
| 21 * datetime + | | | | | 23 'plato' => $row['plato'], |
| 22 * temperature ------------+ | | | | 24 'sg' => $row['sg'], |
| 23 * density plato --------------------+ | | | 25 'battery' => $row['battery'] |
| 24 * density sg ----------------------------+ | | 26 ); |
| 25 * battery ------------------------------------+ | |
| 26 */ | |
| 27 $handle = @fopen($filename, "r"); | |
| 28 if ($handle) { | |
| 29 $lines = 0; | |
| 30 while (($buffer = fgets($handle, 4096)) !== false) { | |
| 31 | |
| 32 $buffer = preg_replace( "/\r|\n/", "", $buffer); | |
| 33 $row = explode(",", $buffer); | |
| 34 $lines++; | |
| 35 | |
| 36 $logs[] = array( | |
| 37 'date' => $row[0], | |
| 38 'temperature' => $row[1], | |
| 39 'plato' => $row[2], | |
| 40 'sg' => $row[3], | |
| 41 'battery' => $row[4] | |
| 42 ); | |
| 43 } | |
| 44 if (!feof($handle)) { | |
| 45 echo "Error: unexpected fgets() fail\n"; | |
| 46 } | |
| 47 fclose($handle); | |
| 48 } | 27 } |
| 49 header("Content-type: application/json"); | 28 header("Content-type: application/json"); |
| 50 echo json_encode($logs); | 29 echo json_encode($logs); |
