i trying create drill down, using fusionchart , php mysql database. have worked on every error , there no errors still don't see chart.
please can tell problem code. below code project starting link parent page.
$strxml .= "<set name = '".$row['day']."' value = '".$row['totoutput']."' link='" . urlencode("detailed.php?day=" . $row['day']) . "'/>"; <?php //we have included ../includes/fusioncharts.php , ../includes/dbconn.php, contains //functions embed charts , connect database. include("includes/fusioncharts.php"); include("includes/dbconn.php"); ?> <html> <head> <title> fusioncharts xt - database , drill-down example </title> <script language="javascript" src="../../fusioncharts/fusioncharts.js"></script> </head> <body> <?php //this page invoked default.php. when user clicks on pie //slice in default.php, factory id passed page. need //to factory id, information database , show //a detailed chart. //first, factory id //request factory id querystring $day = $_get['day']; //connect database $link = connecttodb(); //$strxml used store entire xml document generated //generate chart element string $strxml = "<graph caption='peak electricity generated ---- month april 2015' xaxisname='day' yaxisname='megawatts' decimalprecision='0' formatnumberscale='0' yaxismaxvalue='1000' shownames='1' rotatenames='1'>"; //now, data plant $strquery = "select plant_id, peak_generation daily_report pdate=" . $day; $result = mysql_query($strquery) or die(mysql_error()); //iterate through each factory if ($result) { while($ors = mysql_fetch_array($result)) { $strquery = "plant_name power_plant plant_id=" . $ors['plant_id']; $result2 = mysql_query($strquery) or die(mysql_error()); $ors2 = mysql_fetch_array($result2); //here, convert date more readable form set label. $strxml .= "<set name = '".$ors2['plant_name']."' value = '".$ors['peak_generation']."'/>"; } } mysql_close($link); //close <chart> element $strxml .="</graph>"; //create chart - column 2d chart data $strxml echo renderchart("charts/fcf_line.swf", "", $strxml, "daily output", 1300, 500); ?> </center> </body> </html>
