FusionCharts Forum / FusionCharts Free / FusionCharts Free and PHP / Dynamic Chart based on ODBC from Access backend / Latest Posts

RE: Dynamic Chart based on ODBC from Access backend

ardan — Mon, 07 Apr 2008 09:21:22 GMT

I finally got it, if anybody needs an obdc simple example

$conn=odbc_connect('yourODBCconnection','','');

$firststring= your SQL query string
$rs=odbc_exec($conn,$firststring);

$strXML = "";

while (odbc_fetch_row($rs))
{
$g1=odbc_result($rs,"field1");
$g2=odbc_result($rs,"field2");
$strXML .= "";
}
$strXML .= "";

//Create the chart - Column 3D Chart with data from strXML variable using dataXML method
echo renderChartHTML("./Charts/FCF_Column3D.swf", "", $strXML, "myNext", 800, 600, false);
?>

Dynamic Chart based on ODBC from Access backend

ardan — Sun, 06 Apr 2008 19:05:21 GMT

Hi,

I just cannot seem to figure this out, the converting to XML is giving me real problems. Does anyone have a short example of pulling data from a recordset using ODBC connection from a access backend......

I have lots of web pages on our intranet that use PHP to display table, runs queries etc..... I would like to take some of these table and create a chart based on them...

I would appreciate any help...

Ardan