jlomeli

Members
 View Profile  See their activity

  • Content count

    6

  • Joined

  • Last visited

Everything posted by jlomeli

  1. Drill Down Links

    jlomeli posted a topic in FusionCharts and PHP

    Hello, I have a line chart that shows a data point for 30 days. I need to be able to click one of the data points and get the value for the DAY that was clicked. I have the drill down working I just need to get the day. Can I do this with just PHP and XML? How? $stringData = "<set label='$date' Value='$xnum' link='http://mydomain.com/SPAWeb/ProbeApp/OneProbe.1.Day.Hourly.php?prbname=$prbname&day=DataFromClick' />"; Thank you.

  2. Drill Down Links

    jlomeli replied to jlomeli's topic in FusionCharts and PHP

    I posted a reply here on Friday, that appears to have been deleted ? I will post again.. I dont think we are understanding each other.. My question is how do I get the value from the data point that is clicked on the chart? My chart has 30 days of the month for the x axis. Each data point is a date like this: 2007-03-21 I want to retrive the DATE value for my URL http://mydomain.com/SPAWeb/ProbeApp/OneProbe.1.Day.Hourly.php?prbname=$probename&date=<---HOW DO I GET THIS VALUE? When I code the php to write the XML: $stringData = "<set value='$xnum' link='http://d2ml2491.dev.sprint.com/SPAWeb/ProbeApp/OneProbe.1.Day.Hourly.php?prbname=$prbname' /> "; <<-- this works I want to add "&date=" to the end of the link but I dont know the value of DATE until the chart is clicked. Is there a function that I should put here? &date=(function)? that will tell me what is clicked? Please advise. Thank you.

  3. Drill Down Links

    jlomeli replied to jlomeli's topic in FusionCharts and PHP

    Hello. I dont understand how to get the click data. The date is in my xml file like this: <category label='2007-02-28' /> If I move the mouse over the datapoint I can see the date. How do I get that value when I click and get it into my drill down link?? Thanks $stringData = "<set label='$date' Value='$xnum' link='http://mydomain.com/SPAWeb/ProbeApp/OneProbe.1.Day.Hourly.php?prbname=$prbname&day=DataFromClick' />";
  4. Hello. My code follows your basic suggeston for php: <?php //We've included ../Includes/FusionCharts.php, which contains functions //to help us easily embed the charts. include("../Includes/FusionCharts.php"); ?> <HTML> <HEAD> <TITLE>FusionCharts - Simple Column 3D Chart</TITLE> </HEAD> <BODY> <?php //Create the chart - Column 3D Chart with data from Data/Data.xml echo renderChartHTML("../../FusionCharts/Column3D.swf", "Data/Data.xml", "", "myFirst", 600, 300, false); ?> Using this example it seems that if multiple users hit the server at the same time they may get a chart using the data.xml file generated for another user. Is this correct? Do you have a recommendation for session control? Or any way to ensure each user gets his own chart data? Please advise. Thank you. JL

  5. Stop Caching PHP

    jlomeli posted a topic in FusionCharts and PHP

    I keep getting the same chart. My PHP page is succesfully recieving my variable via the URL and XML code is written correctly but the last chart keeps showing. I found a post where a JavaScript solution was shown but I dont think it will work with my PHP. I am including the FusionCharts.php file and have found the following code, however it is not clear. Can I change something here to fix? // encodeDataURL function encodes the dataURL before it's served to FusionCharts. // If you've parameters in your dataURL, you necessarily need to encode it. // Param: $strDataURL - dataURL to be fed to chart // Param: $addNoCacheStr - Whether to add aditional string to URL to disable caching of data function encodeDataURL($strDataURL, $addNoCacheStr=false) { //Add the no-cache string if required.. DO I CHANGE THE FOLLOWING TO $strDataURL ? if ($addNoCacheStr==true) { // We add ?FCCurrTime=xxyyzz // If the dataURL already contains a ?, we add &FCCurrTime=xxyyzz // We replace : with _, as FusionCharts cannot handle : in URLs if (strpos(strDataURL,"?")<>0) $strDataURL .= "&FCCurrTime=" . Date("H_i_s"); else $strDataURL .= "?FCCurrTime=" . Date("H_i_s"); } // URL Encode it return urlencode($strDataURL); } Please advise. Thanks.

  6. Stop Caching PHP

    jlomeli replied to Pallav's topic in FusionCharts and PHP

    Im sorry, this is still not clear. Below is where I render the chart. And this is what appears to be caching. Do I need to add date/time after OneProbe.xml ?? If so what format?? <table border="1" cellspacing="2" WIDTH=80% ALIGN=CENTER <?php //Create the chart - Column 3D Chart with data from Data/Data.xml echo renderChartHTML("FusionCharts/Charts/Line.swf", "OneProbe.xml", "", "myFirst", 750, 450, false); ?> </table> ALSO... Do I need to change something in the FusionCharts.php file? Does $addNoCacheStr need to be set to true? Please clarify how to stop the same chart from loading. Thank you very much. // encodeDataURL function encodes the dataURL before it's served to FusionCharts. // If you've parameters in your dataURL, you necessarily need to encode it. // Param: $strDataURL - dataURL to be fed to chart // Param: $addNoCacheStr - Whether to add aditional string to URL to disable caching of data function encodeDataURL($strDataURL, $addNoCacheStr=false) { //Add the no-cache string if required if ($addNoCacheStr==true) { // We add ?FCCurrTime=xxyyzz // If the dataURL already contains a ?, we add &FCCurrTime=xxyyzz // We replace : with _, as FusionCharts cannot handle : in URLs if (strpos(strDataURL,"?")<>0) $strDataURL .= "&FCCurrTime=" . Date("H_i_s"); else $strDataURL .= "?FCCurrTime=" . Date("H_i_s"); } // URL Encode it return urlencode($strDataURL); }