Atrhick
-
Content count
5 -
Joined
-
Last visited
-
Days Won
1
Posts posted by Atrhick
-
-
please see my code and generated XML i don't see the problem please help
PHP Code
$strXML1 = "<chart caption='Arbitrage Buyer Comparison' lineThickness='2' showValues='0' numVDivLines='22' formatNumberScale='1' labelDisplay='ROTATE' slantLabels='1' anchorRadius='2' anchorBgAlpha='50' showAlternateVGridColor='1' anchorAlpha='100' animation='1' limitsDecimalPrecision='0' divLineDecimalPrecision='1'>"; $strXML1 .= "<dataset seriesName='". $bname1 ."' color='0080C0' anchorBorderColor='0080C0' >"; while ($linedata1 = mysql_fetch_assoc($result1)) { $linedata1_date = substr($linedata1['date_day'],8); $linedata1_sum = $linedata1['bname1']; $strXML1 .= "<set name='$linedata1_date' value='$linedata1_sum' />"; } $strXML1 .= "</dataset>"; $strXML1 .= "<dataset seriesName='". $bname2 ."' color='008040' anchorBorderColor='008040'>"; while ($linedata2 = mysql_fetch_assoc($result2)) { $linedata2_date = substr($linedata2['date_day'],8); $linedata2_sum = $linedata2['bname2']; $strXML1 .= "<set name='$linedata2_date' value='$linedata2_sum' />"; } $strXML1 .= "</dataset>"; $strXML1 .= "</chart>"; echo renderChart("../../admin/FusionCharts_Evaluation/Charts/MSLine.swf", "", $strXML1, "Arbitrage_Buyer_Comparison", 855, 320); }XML Output
<script type="text/javascript" ><!-- // Instantiate the Chart if ( FusionCharts("Arbitrage_Buyer_Comparison") && FusionCharts("Arbitrage_Buyer_Comparison").dispose ) FusionCharts("Arbitrage_Buyer_Comparison").dispose(); var chart_Arbitrage_Buyer_Comparison = new FusionCharts( { "swfUrl" : "../../admin/FusionCharts_Evaluation/Charts/MSLine.swf", "width" : "855", "height" : "320", "renderAt" : "Arbitrage_Buyer_ComparisonDiv", "dataFormat" : "xml", "id" : "Arbitrage_Buyer_Comparison", "dataSource" : " <chart caption='Arbitrage Buyer Comparison' lineThickness='2' showValues='0' numVDivLines='22' formatNumberScale='1' labelDisplay='ROTATE' slantLabels='1' anchorRadius='2' anchorBgAlpha='50' showAlternateVGridColor='1' anchorAlpha='100' animation='1' limitsDecimalPrecision='0' divLineDecimalPrecision='1'> <dataset seriesName='AllWebLeads' color='0080C0' anchorBorderColor='0080C0' > <set name='01' value='1.7425' /> <set name='02' value='21.4' /> <set name='03' value='88.7675000000001' /> <set name='04' value='119.67' /> <set name='05' value='0.034' /> <set name='06' value='0.034' /> <set name='07' value='0.0255' /> <set name='09' value='0.034' /> <set name='10' value='0.1275' /> <set name='12' value='0.0765' /> <set name='13' value='0.3315' /> <set name='14' value='0.0255' /> <set name='16' value='0.034' /> </dataset> <dataset seriesName='CompareInsuranceQ' color='008040' anchorBorderColor='008040'> <set name='01' value='10.4865' /> <set name='02' value='110.2825' /> <set name='03' value='133.4645' /> <set name='04' value='67.5015' /> <set name='05' value='172.5332' /> <set name='06' value='370.6034' /> <set name='07' value='228.5293' /> <set name='08' value='83.115' /> <set name='09' value='503.1444' /> <set name='10' value='574.123000000001' /> <set name='11' value='864.926400000001' /> <set name='12' value='1392.9156' /> <set name='13' value='1201.649' /> <set name='14' value='1221.0325' /> <set name='15' value='605.951' /> <set name='16' value='1505.497' /> </dataset> </chart>" } ).render(); // --></script> -
Please help me out I ma using the evaluation version and i keep getting no data and i know there is data in the output because i can see it in the generated code. here is my php code.
<?php $ciqfy1 = "CIQFY"; $query_str1 = "SELECT DAY( date_day ), COUNT( afid_seller_name ) " . " FROM lead_partners_pages " . " WHERE afid_seller_name = '$ciqfy1' AND MONTH(date_day)=MONTH(NOW()) " . " GROUP BY DATE( date_day ) "; $result1 = mysql_query($query_str1) or die(mysql_error()); $row1 = mysql_fetch_array($result1); $strXML1 = "<graph yaxisname='Leads Generatd' canvasBorderColor='333333' numdivlines='4' divLineColor='333333' >"; $strXML1 .= "<dataset seriesname='Leads Generatd' color='AFD8F8' showValues='0'>"; foreach($row1 as $leads_generated1) { $chardollers1 = $leads_generated1['COUNT(afid_seller_name)']; //Iterate through each factory $the_row1 = $leads_generated1['date_day']; $strXML1 .= "<set name='" . $the_row1 . "' value='250'" . " />"; //Finally, close <graph> element } $strXML1 .= "</dataset>"; $strXML1 .= "<dataset seriesname='Leads Sold' color='F6BD0F' showValues='0'> "; $ciqfy2 = "CIQFY"; $query_str2 = "SELECT DAY( date_day ), COUNT( afid_seller_name ) " . " FROM lead_partners_pages " . " WHERE afid_seller_name = '$ciqfy2' AND MONTH(date_day)=MONTH(NOW()) " . " GROUP BY DATE( date_day ) "; $result2 = mysql_query($query_str2) or die(mysql_error()); $row2 = mysql_fetch_array($result2); foreach($row2 as $leads_generated2) { $chardollers2 = $leads_generated2['COUNT(afid_seller_name)']; //Iterate through each factory $the_row2 = $leads_generated1['date_day']; $strXML1 .= "<set name='" . $the_row2 . "' value='250'" . " />"; //Finally, close <graph> element } $strXML1 .= "</dataset>"; $strXML1 .= "</graph>"; //Create the chart - Pie 3D Chart with data from $strXML echo renderChart("../../admin/FusionCharts_Evaluation/Charts/MSStackedColumn2D.swf", "", $strXML1, "leads_gen_and_sold", 855, 320, false, true, true); ?> -
First of all let me thank you guys for being so willing to help me out on this. here is the PHP Code i am using to
<?php $ciqfy1 = "CIQFY"; $query_str1 = "SELECT DAY( date_day ), COUNT( afid_seller_name ) " . " FROM lead_partners_pages " . " WHERE afid_seller_name = '$ciqfy1' AND MONTH(date_day)=MONTH(NOW()) " . " GROUP BY DATE( date_day ) "; $result1 = mysql_query($query_str1) or die(mysql_error()); $row1 = mysql_fetch_array($result1); $strXML1 = "<graph yaxisname='Leads Generatd' canvasBorderColor='333333' numdivlines='4' divLineColor='333333' >"; $strXML1 .= "<dataset seriesname='Leads Generatd' color='AFD8F8' showValues='0'>"; foreach($row1 as $leads_generated1) { $chardollers1 = $leads_generated1['COUNT(afid_seller_name)']; //Iterate through each factory $the_row1 = $leads_generated1['date_day']; $strXML1 .= "<set name='" . $the_row1 . "' value='250'" . " />"; //Finally, close <graph> element } $strXML1 .= "</dataset>"; $strXML1 .= "<dataset seriesname='Leads Sold' color='F6BD0F' showValues='0'> "; $ciqfy2 = "CIQFY"; $query_str2 = "SELECT DAY( date_day ), COUNT( afid_seller_name ) " . " FROM lead_partners_pages " . " WHERE afid_seller_name = '$ciqfy2' AND MONTH(date_day)=MONTH(NOW()) " . " GROUP BY DATE( date_day ) "; $result2 = mysql_query($query_str2) or die(mysql_error()); $row2 = mysql_fetch_array($result2); foreach($row2 as $leads_generated2) { $chardollers2 = $leads_generated2['COUNT(afid_seller_name)']; //Iterate through each factory $the_row2 = $leads_generated1['date_day']; $strXML1 .= "<set name='" . $the_row2 . "' value='250'" . " />"; //Finally, close <graph> element } $strXML1 .= "</dataset>"; $strXML1 .= "</graph>"; //Create the chart - Pie 3D Chart with data from $strXML echo renderChart("../../admin/FusionCharts/FCF_StackedColumn2D.swf", "", $strXML1, "leads_gen_and_sold", 855, 320,"dataFormat"); ?>here is the code it generates for the user. how the chart is showing but i don't see the accusal chat itself. I have also added an image for you to see.
<!-- START Script Block for Chart leads_gen_and_sold --> <div id="leads_gen_and_soldDiv" align="center"> Chart. </div> <script type="text/javascript"> //Instantiate the Chart var chart_leads_gen_and_sold = new FusionCharts("../../admin/FusionCharts/FCF_StackedColumn2D.swf", "leads_gen_and_sold", "855", "320", "1", "0"); chart_leads_gen_and_sold.setTransparent("false"); //Provide entire XML data using dataXML method chart_leads_gen_and_sold.setDataXML(" <graph yaxisname='Leads Generatd' canvasBorderColor='333333' numdivlines='4' divLineColor='333333' > <dataset seriesname='Leads Generatd' color='AFD8F8' showValues='0'> <set name='1' value='250' /> <set name='1' value='250' /> <set name='2' value='250' /> <set name='2' value='250' /> </dataset> <dataset seriesname='Leads Sold' color='F6BD0F' showValues='0'> <set name='2' value='250' /> <set name='2' value='250' /> <set name='2' value='250' /> <set name='2' value='250' /> </dataset> </graph>a ") //Finally, render the chart. chart_leads_gen_and_sold.render("leads_gen_and_soldDiv"); </script> <!-- END Script Block for Chart leads_gen_and_sold -->
-
I have having a problem i have this code it looks perfect but its not working for some reason. I have the JavaScript file FusionCharts.js linked currently and all of my pathing info is right
<script type="text/javascript"> //Instantiate the Chart var chart_myFirst = new FusionCharts("http://mydomain.com/admin/FusionCharts/FCF_StackedColumn2D.swf", "myFirst", "855", "220", "1", "0"); chart_myFirst.setTransparent("false"); //Provide entire XML data using dataXML method chart_myFirst.setDataXML(" <graph bgColor="FCFCFC" xaxisname="Month" yaxisname="Revenue" canvasBorderColor="333333" numdivlines="4" divLineColor="333333" yAxisMaxValue="100" decimalPrecision="1" numberPrefix="$"> <dataset seriesname="Leads Generatd" color="AFD8F8"> <set name='2' value='2' /> <set name='2' value='2' /> <set name='C' value='C' /> <set name='C' value='C' /> <set name='2' value='2' /> <set name='2' value='2' /> </dataset> <dataset seriesname="Leads Sold" color="F6BD0F"> <set name='2' value='2' /> <set name='2' value='2' /> <set name='2' value='C' /> <set name='2' value='C' /> <set name='2' value='2' /> <set name='2' value='2' /> </dataset> <trendLines> <line startValue="1" endValue="1000" color="8BBA00" thickness="1" alpha="20" showOnTop="1" displayValue="Estimated" isTrendZone="1"/> </trendLines> </graph>") //Finally, render the chart. chart_myFirst.render("myFirstDiv"); </script>
Debug Mode
in FusionCharts and PHP
Posted · Edited by Atrhick · Report reply
I can't remove the debug code please help me below is the code. the chart is working but it is always showing debug mode
PHP Code
<?php $strXML = "<chart caption='Day To Month Chart' decimalPrecision='' showNames='1' formatNumberScale='1' showValues='1'>"; ?> <?php foreach($chart_monthly_watched_videos_data as $chart_monthly_watched_videos_data_results1): ?> <?php { $chardollers1 = $chart_monthly_watched_videos_data_results1['newmembers']; //Iterate through each facter $the_row = $chart_monthly_watched_videos_data_results1["DATE_FORMAT( FROM_UNIXTIME( addtime ) , '%d' )"]; $strXML .= "<set name='" . $the_row . "' value='". $chardollers1 . "'" . " />"; //Finally, close <graph> element } ?> <?php endforeach; ?> <?php $strXML .= "</chart>";?> <?php //Create the chart - Pie 3D Chart with data from $strXML echo renderChart("http://mydomain.com/administration/FusionCharts_Evaluation/Charts/Column3D.swf", "", $strXML, "myFirst", 620, 220,"dataFormat"); ?>Generated Code