json - Removing title from select query in PHP -
is there way select table in sqlite without printing column headers?
the following code using:
select realpow, timestamp powerdata; //to loop through table , fetch data real power while($res = $results->fetcharray(sqlite3_assoc)){ $equal[] = $res; } echo json_encode($mearray,json_numeric_check);
result:
[{"realpow":50,"timestamp":1391990400},{"realpow":200,"timestamp":1392422400}, {"realpow":100,"timestamp":1394409600},{"realpow":150,"timestamp":1395273600}, {"realpow":140,"timestamp":1397952000},{"realpow":130,"timestamp":1398384000}, {"realpow":120,"timestamp":1400544000},{"realpow":90,"timestamp":1402358400}, {"realpow":100,"timestamp":1402790400}]
i want remove "realpow:" & "timestamp:".
here code modified:
select realpow, timestamp powerdata; //to loop through table , fetch data real power while($res = $results->fetcharray(sqlite3_assoc)){ $equal[] = array($res['realpow'], $res['timestamp']); } echo json_encode($mearray,json_numeric_check);
Comments
Post a Comment