2 ini_set('memory_limit', '-1');
3 error_reporting(E_ALL);
4 ini_set('display_errors', 1);
10 $mysqli = new mysqli("localhost", "USERNAME", "PASSWORD", "power");
11 mysqli_set_charset($mysqli,'utf8');
13 if ($mysqli->connect_errno) {
14 echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
17 $r=mysqli_query($mysqli, "select UNIX_TIMESTAMP(time) as time,$id as amps from device_log where time>FROM_UNIXTIME($oldtime)", MYSQLI_USE_RESULT);
18 #$r=mysqli_query($mysqli, "select UNIX_TIMESTAMP(time) as time,$id as amps from device_log where time>FROM_UNIXTIME($oldtime)");
19 #$result=mysqli_query($mysqli, $sqlquery, MYSQLI_USE_RESULT);
23 #if ($result = $mysqli->store_result()) {
25 while($row = mysqli_fetch_assoc($r)) {
26 #while($row = mysqli_fetch_row($r)) {
29 list($counter,$iforget,$amps)=explode(",",$row['amps']);
30 #list($counter,$iforget,$amps)=explode(",",$row[1]);
41 echo json_encode($myArray);