Atrhick

Members
 View Profile  See their activity

  • Content count

    5

  • Joined

  • Last visited

  • Days Won

    1

About Atrhick

  • Rank
    Forum Newbie

  1. Debug Mode

    Atrhick posted a topic in FusionCharts and PHP

    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 <div id="myFirstDiv" align="center"><object id="myFirst" class="FusionCharts" width="620" lang="EN" height="220" type="application/x-shockwave-flash" data="http://3angelstube.com/administration/FusionCharts_Evaluation/Charts/Column3D.swf"><param name="scaleMode" value="noScale"><param name="scale" value="noScale"><param name="wMode" value="transparent"><param name="allowScriptAccess" value="always"><param name="quality" value="best"><param name="flashvars" value="lang=EN&debugMode=1&scaleMode=noScale&DOMId=myFirst&registerWithJS=1&chartWidth=620&chartHeight=220&InvalidXMLText=Invalid data.&dataXML=%3Cchart%20caption%3D'Day%20To%20Month%20Chart'%20decimalPrecision%3D''%20showNames%3D'1'%20formatNumberScale%3D'1'%20showValues%3D'1'%3E%3Cset%20name%3D'01'%20value%3D'4'%20%2F%3E%3Cset%20name%3D'02'%20value%3D'10'%20%2F%3E%3Cset%20name%3D'03'%20value%3D'7'%20%2F%3E%3Cset%20name%3D'04'%20value%3D'6'%20%2F%3E%3Cset%20name%3D'05'%20value%3D'4'%20%2F%3E%3Cset%20name%3D'06'%20value%3D'5'%20%2F%3E%3Cset%20name%3D'07'%20value%3D'2'%20%2F%3E%3Cset%20name%3D'08'%20value%3D'6'%20%2F%3E%3Cset%20name%3D'09'%20value%3D'12'%20%2F%3E%3Cset%20name%3D'10'%20value%3D'7'%20%2F%3E%3Cset%20name%3D'11'%20value%3D'7'%20%2F%3E%3Cset%20name%3D'12'%20value%3D'3'%20%2F%3E%3Cset%20name%3D'13'%20value%3D'5'%20%2F%3E%3Cset%20name%3D'14'%20value%3D'11'%20%2F%3E%3Cset%20name%3D'15'%20value%3D'4'%20%2F%3E%3C%2Fchart%3E&dataURL="></object></div>

  2. No Data To Display

    Atrhick posted a topic in Installation and Upgrades

    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>

  3. No Data Error

    Atrhick posted a topic in FusionCharts and PHP

    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); ?>

  4. Charts In Flash Don't Show Data

    Atrhick replied to bigz's topic in Installation and Upgrades

    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 -->

  5. Chart Not Displayign

    Atrhick posted a topic in Javascript Problems

    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>