Okay,here I try the simple one, I'm not sure its right or wrong.
But,through all these codes, The data not run n display based what I want.
Actually, I want to display the status of car In/Out on current date (shows daily transaction) in every minute.
This data it just retrieve from table include time IN/OUT of that car.
XML Page
------------
<chart caption='Status Car In/Out' subCaption='Daily Transaction' dataStreamURL='IparkTransaction.php' refreshInterval='60' numberPrefix='' setAdaptiveYMin='1' xAxisName='Time' showRealTimeValue='1' realTimeValuePadding='50' labelDisplay='Rotate' slantLabels='1'>
<categories>
</categories>
<dataset seriesName='In' showValues='0'>
</dataset>
<dataset seriesName='Out' showValues='0'>
</dataset>
<styles>
<definition>
<style type='font' name='captionFont' size='14' />
</definition>
<application>
<apply toObject='Caption' styles='captionFont' />
<apply toObject='Realtimevalue' styles='captionFont' />
</application>
</styles>
</chart>
PHP page
--------------
<?php
include("Includes/DBConn.php");
//Get date Today - date format 2011-11-04
$dateTodayLabel = date("yy-d-m");
//Get label for the data - time in format hh:mn:ss
$dateTimeLabel = date('h:i:s');
// extract pertinent data from dataset
// we will get
$strSQLIn ="select count(EventTrans) where EventTrans = 'IN' and DateTrans=" . $_REQUEST['dateTodayLabel'] . " ";
$strSQLOut ="select count(EventTrans) where EventTrans = 'OUT' and DateTrans=" . $_REQUEST['dateTodayLabel'] . " ";
// execure SQL to create recordset
$resultIn=mysql_query($strSQLIn) or die(mysql_error());
$resultOut=mysql_query($strSQLOut) or die(mysql_error());
//Now write it to output stream
print "&label=" . $dateTimeLabel . "In=" . $resultIn . "Out" . $resultOut;
?>
HTML page
---------------
<HTML>
<HEAD>
<TITLE>FusionWidgets v3 - Multiple dataset example</TITLE>
<script type="text/javascript" src="../Charts/FusionCharts.js"></script>
</HEAD>
<BODY>
<CENTER>
<div id="chart1div">
This text is replaced by the Flash movie.
</div>
<script type="text/javascript">
var chart1 = new FusionCharts("../Charts/RealTimeLine.swf", "ChId1", "500", "350", "0", "0");
chart1.setDataURL("IparkData.xml");
chart1.render("chart1div");
</script>
</BODY>
</HTML>
And also I attached print screen on display page and my table.
Thanks
transaction.bmp
