connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } $r=mysqli_query($mysqli, "select UNIX_TIMESTAMP(time) as time,$id as amps from device_log where time>FROM_UNIXTIME($oldtime)", MYSQLI_USE_RESULT); #$r=mysqli_query($mysqli, "select UNIX_TIMESTAMP(time) as time,$id as amps from device_log where time>FROM_UNIXTIME($oldtime)"); #$result=mysqli_query($mysqli, $sqlquery, MYSQLI_USE_RESULT); $myArray = array(); #if ($result = $mysqli->store_result()) { # echo "hi"; while($row = mysqli_fetch_assoc($r)) { #while($row = mysqli_fetch_row($r)) { #echo "

";
    #print_r($row);
    list($counter,$iforget,$amps)=explode(",",$row['amps']);
    #list($counter,$iforget,$amps)=explode(",",$row[1]);
    $row['amps']=$amps;
    $myArray[] = $row;
    unset($counter);
    unset($iforget);
    unset($amps);
  }
#  $result->free();
#}
#print_r($myArray);
#echo "

"; echo json_encode($myArray); ?>