Hirdetés
Új hozzászólás Aktív témák
-
wmati
addikt
válasz Sk8erPeter #17310 üzenetére
Van egy data.php azzal be csatlakozol sql szerverre ahonnan ki kérem adatok és átadom a Highstock- nak ahol pedig idő pontok helyén 00:00:00:001 ilyenek jelennek meg de Highcharts-al viszont minden rendben van, idő adatokat pedig linuxos gép teszi meg datatime sql oszlopba.
<?php
require_once('config.inc.php');
$sql = "select date_format(datum,'%Y-%m-%d %H:%i.%s') as utime, down_ch1, down_ch2, down_ch3, down_ch4, down_ch5, down_ch6, down_ch7, down_ch8, up_ch1, up_ch2, up_ch3, up_ch4
from power_levels
where id between '1' and '40'
order by id
limit 0,5000";
//where datum between '".date("Y-m-d H:i.s")."' and '".date("Y-m-d H:i.s",time()+24*60*60)."'
$result = $mysqli->query($sql) or die($mysqli->error);
$dates=array();
$down_ch1=array();
$down_ch2=array();
$down_ch3=array();
$down_ch4=array();
$down_ch5=array();
$down_ch6=array();
$down_ch7=array();
$down_ch8=array();
$up_ch1=array();
$up_ch2=array();
$up_ch3=array();
$up_ch4=array();
$dates['name']='Dátum';
$down_ch1['name']='Downstream channel 1';
$down_ch2['name']='Downstream channel 2';
$down_ch3['name']='Downstream channel 3';
$down_ch4['name']='Downstream channel 4';
$down_ch5['name']='Downstream channel 5';
$down_ch6['name']='Downstream channel 6';
$down_ch7['name']='Downstream channel 7';
$down_ch8['name']='Downstream channel 8';
$up_ch1['name']='Upstream channel 1';
$up_ch2['name']='Upstream channel 2';
$up_ch3['name']='Upstream channel 3';
$up_ch4['name']='Upstream channel 4';
$recordcount = 0;
while ($row = $result->fetch_assoc()) {
$dates['data'][]=$row['utime'];
$down_ch1['data'][]=$row['down_ch1'];
$down_ch2['data'][]=$row['down_ch2'];
$down_ch3['data'][]=$row['down_ch3'];
$down_ch4['data'][]=$row['down_ch4'];
$down_ch5['data'][]=$row['down_ch5'];
$down_ch6['data'][]=$row['down_ch6'];
$down_ch7['data'][]=$row['down_ch7'];
$down_ch8['data'][]=$row['down_ch8'];
$up_ch1['data'][]=$row['up_ch1'];
$up_ch2['data'][]=$row['up_ch2'];
$up_ch3['data'][]=$row['up_ch3'];
$up_ch4['data'][]=$row['up_ch4'];
$recordcount++;
}
$mysqli->close();
$datas=array();
$datas[]=$dates;
$datas[]=$down_ch1;
$datas[]=$down_ch2;
$datas[]=$down_ch3;
$datas[]=$down_ch4;
$datas[]=$down_ch5;
$datas[]=$down_ch6;
$datas[]=$down_ch7;
$datas[]=$down_ch8;
$datas[]=$up_ch1;
$datas[]=$up_ch2;
$datas[]=$up_ch3;
$datas[]=$up_ch4;
header('Content-Type: text/javascript');
echo json_encode($datas, JSON_NUMERIC_CHECK | JSON_PRETTY_PRINT );
?>[ Szerkesztve ]
Új hozzászólás Aktív témák
- Acer Extensa 5635G, T6570, 4GB DDR3, 120GB 2.5" SSD, 15.6", Wi-Fi, Webcam, Win10
- GYÁRI ÚJ / Corsair HS70 Pro Wireless fejhallgató (cream)
- Audient Sono hangkáryta
- Eladó config:980Ti x3,i5 6400 Skylake, 1+1Tb HDD /250Ssd, 2x8Gig G.skill...
- HP EliteBook 2570p, i5-3320M, 8GB DDR3 RAM, 120GB 2.5" SSD, 12.5", Wi-Fi & BT, Webcam, Win10
Állásajánlatok
Cég: Ozeki Kft
Város: Debrecen
Cég: Ozeki Kft
Város: Debrecen