Masalah di Dynamic Realtime dengan Fusioncharts

Beranda
Komunitas
Tech
Programmer Forum
Masalah di Dynamic Realtime dengan Fusioncharts

mirfspot

28-05-2013 10:42

Masalah di Dynamic Realtime dengan Fusioncharts

Mastah2, bisa tolong kasih petunjuk yah.

link Fusioncharts free
link Prototype

Ane mau buat realtime chart dengan fusioncharts, tp kok nggak update2 (tanpa harus refresh page per 5 detik). kalo dari database sudah update.

index.php

Spoiler for index.php:

Code:



<html>

<head>

 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>

 [removed][removed]

 [removed][removed]



</head>



<body>

<div id="chartdiv" align="center"></div>

[removed]

 var myChart = new FusionCharts("FCF_Line.swf", "myChartId", "600", "400", "0", "1");

 myChart.setDataURL('get_latest_data.php');

 myChart.render("chartdiv");

[removed]

</body>

</html>

[removed]

 new PeriodicalExecuter(function getLatestData() {

 new Ajax.Request('get_latest_data.php', {

 method:'get',

 onSuccess:function (transport) {

 updateChartXML('myChartId', transport.responseText);

 }

 });

 }, 5);

[removed]

get_last_data.php

Spoiler for get_last_data.php:

Code:



<?php

include("config.php");



$resultSet = mysql_query("select *, date_format(update_datetime, 'H%:%i') as time_only from price_fluctuation order by update_datetime desc limit 5");

$rowCount = mysql_num_rows($resultSet);

$xmlData = "<graph caption='Price Fluctuation (in USD)' yAxisMinValue='1000' yAxisMaxValue='5000' animation='0' canvasBorderColot='FFFFFF' yAxisName='Time' yAxisName='Price' showNames='1' decimalPrecision='0' formatNumberScale='0'>";

$index = $rowCount - 1;

for ($i = 0; i < $rowCount; $i++) {

 $updateDatetime = mysql_result($resultSet, $index, "time_only");

 $price = mysql_result($resultSet, $index, "price");

 $xmlData .= "<set name='" . $updateDatetime . "' value='" . $price . "' color='000000' />";

 $index--;

}

$xmlData .= "</graph>";

// insert new data, to make fluctuation effect on the chart 

mysql_query("insert into price_fluctuation (update_datetime, price) values (now(), ". rand(1000, 5000) . ")");



echo $xmlData;

?>

Hasilnya

Spoiler for Chart Result:

Masalah di Dynamic Realtime dengan Fusioncharts

Kira2 mastah2 ada yang tau nggak masalahnya dimana ?

Diubah oleh mirfspot 28-05-2013 10:45

925

Kutip

Balasan

Komentar yang asik ya

Urutan

Terbaru

Terlama

Komentar yang asik ya

Komunitas Pilihan