Masalah di Dynamic Realtime dengan Fusioncharts

Beranda
Komunitas
Tech
Programmer Forum
Masalah di Dynamic Realtime dengan Fusioncharts

mirfspot

28-05-2013 03: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:

Kira2 mastah2 ada yang tau nggak masalahnya dimana ?

Diubah oleh mirfspot 28-05-2013 03:45

922

Kutip

Balasan

Guest

Tulis komentar menarik atau mention replykgpt untuk ngobrol seru

Urutan

Terbaru

Terlama

Guest

Tulis komentar menarik atau mention replykgpt untuk ngobrol seru

Komunitas Pilihan