Search the Community

Showing results for tags 'php'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Company Forums
    • Company News
  • Product Forums
    • FusionCharts XT
    • FusionWidgets XT
    • PowerCharts XT
    • FusionMaps XT
    • Collabion Charts for SharePoint
    • jQuery Plugin for FusionCharts
    • AngularJS plugin
    • ReactJS plugin
  • General Forums
    • FusionCharts Jobs and Consultation
    • FusionLounge

Found 37 results

  1. Hi, I am trying to create a piechart under the following circumstances: My each row in my table contains a gender. I want to be able to sum up the number of males and females and then plot that in a pie chart. The query that I am using SELECT SUM(gender = 'male') AS male, SUM(gender = 'female') AS female FROM markers; presents 2 columns (male and female) with a count below. How is it possible to get this into the array for the chart seeing that the data required should be by row rather than column? Query Results: | male | female | | 23 | 43 | Should be | male | 23 | | female | 43 | Thanks Steve
  2. Hello, I have rendered fusion chart using php wrappers. I want to store the chart, to be stored in a variable so that i can print it wherever I need it. Basically I want to do this to print the chart in a html page which will be later converted to pdf. Any information or suggestion on how to perform either of them? Thank You
  3. Hello, I have been working with Fusion Charts for quite some time now and the product is great. I am now trying to create a Real Time Line Graph using Fusion Charts with the data to be fetched from MySQL. Following your documentation for the same, I have successfully implemented "Line Chart". However if change the chart type to "realtimeline", the chart does not load. It says "No data to display". The code: if ($resulthum) { // The `$arrData` array holds the chart attributes and data $arrDatahum = array( "chart" => array( "caption" => "Real-time stock price monitor", "subCaption" => "Harry's SuperMart", "xAxisName" => "Time", "yAxisName" => "Stock Price", "numberPrefix" => "$", "refreshinterval" => "5", "yaxisminvalue" => "35", "yaxismaxvalue" => "36", "numdisplaysets" => "10", "labeldisplay" => "rotate", "showValues" => "0", "showRealTimeValue" => "0", "theme" => "fint" ) ); $arrDatahum["data"] = array(); // Push the data into the array while($row = mysqli_fetch_array($resulthum)) { array_push($arrDatahum["data"], array( "label" => $row["timestamp"], "value" => $row["humidity"] ) ); } /*JSON Encode the data to retrieve the string containing the JSON representation of the data in the array. */ $jsonEncodedDatahum = json_encode($arrDatahum); /*Create an object for the column chart using the FusionCharts PHP class constructor. Syntax for the constructor is ` FusionCharts("type of chart", "unique chart id", width of the chart, height of the chart, "div id to render the chart", "data format", "data source")`. Because we are using JSON data to render the chart, the data format will be `json`. The variable `$jsonEncodeData` holds all the JSON data for the chart, and will be passed as the value for the data source parameter of the constructor.*/ $columnCharthum = new FusionCharts("realtimeline", "myFirstChart2" , 600, 330, "chart-2", "json", $jsonEncodedDatahum); // Render the chart $columnCharthum->render(); // Close the database connection $dbhandle->close(); If you could please identify the mistake I am making, it would be great. Waiting for a reply soon. Abhijit Nathwani
  4. I'm using following FusionChart option to Save the image to Server-Side PHP: [ 'chart' => [ "exportEnabled" => "1", "exportAtClient" => "0", "exportAction" => "save", "exportHandler" => "/fusioncharts/export-handlers/php-export-handler/index.php", "exportFileName" => $chartImagesFileName, 'categories' => [ ['category' => $labels] ], 'dataset' => [ ['seriesname' => '...', 'data' => $reg], ['seriesname' => '...', 'data' => $billed] ] ] Javascript: $(document).on('click', '#download-csv', function(e) { var id = "#" + chartUid + " .fusioncharts-container div:contains('Export As PNG')" ; $( id ).trigger("click"); }); Here, /fusioncharts/export-handlers/php-export-handler/index.php is able to generate image and print the filename. But my problem is, on triggering click, I'm unable to get the filename. How can I resolve this issue in FusionChart?
  5. Good day, I am trying to create a heat map / color range based on time values ie. Seconds. I have used the following code sample with great success to display the data but I am struggling to implement the color range within the associative array if values between a certain range. example: if seconds between 0 and 60 then red, if seconds between 60 and 100 then yellow, if seconds between 100 and 120 then green else normal color (bar chart) Can someone please be so kind as to point me in the right direction on how to achieve this with the below code? Code // Form the SQL query that returns the top 10 most populous countries $strQuery = "SELECT Name, Population FROM Country ORDER BY Population DESC LIMIT 10"; // Execute the query, or else return the error message. $result = $dbhandle->query($strQuery) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}"); // If the query returns a valid response, prepare the JSON string if ($result) { // The `$arrData` array holds the chart attributes and data $arrData = array( "chart" => array( "caption" => "Top 10 Most Populous Countries", "showValues" => "0", "theme" => "zune" ) ); $arrData["data"] = array(); // Push the data into the array while($row = mysqli_fetch_array($result)) { array_push($arrData["data"], array( "label" => $row["Name"], "value" => $row["Population"] ) ); } /*JSON Encode the data to retrieve the string containing the JSON representation of the data in the array. */ $jsonEncodedData = json_encode($arrData); /*Create an object for the column chart using the FusionCharts PHP class constructor. Syntax for the constructor is ` FusionCharts("type of chart", "unique chart id", width of the chart, height of the chart, "div id to render the chart", "data format", "data source")`. Because we are using JSON data to render the chart, the data format will be `json`. The variable `$jsonEncodeData` holds all the JSON data for the chart, and will be passed as the value for the data source parameter of the constructor.*/ $columnChart = new FusionCharts("column2D", "myFirstChart" , 600, 300, "chart-1", "json", $jsonEncodedData); // Render the chart $columnChart->render(); // Close the database connection $dbhandle->close(); } Thank you in advance...
  6. Adding the <axis> as strXML prevents the chart from Rendering. $strXML .="<axis title='item 2014' tickwidth='10' divlinedashed='1'>"; $strXML .="<dataset seriesName='item 2014' >"; if ($result2) { while($ors1 = mysql_fetch_array($result2)) { $strXML .= "<set value='".$ors1['item']."' />"; } } $strXML .= "</dataset>"; $strXML .="</axis>"; $strXML .="<axis title='item 2015' tickwidth='10' divlinedashed='1'>"; $result3 = mysql_query($strQuery15) or die(mysql_error()); $strXML .="<dataset seriesName='item 2015'>"; if ($result3) { while($ors1 = mysql_fetch_array($result3)) { $strXML .= "<set value='".$ors1['item']."' />"; } } $strXML .= "</dataset>"; $strXML .="</axis>"; $strXML .="<axis title='item 2016' numdivlines='10' tickwidth='10' divlinedashed='1'>"; $result4 = mysql_query($strQuery16) or die(mysql_error()); $strXML .="<dataset seriesName='item 2016'>"; if ($result4) { while($ors1 = mysql_fetch_array($result4)) { $strXML .= "<set value='".$ors1['item']."' />"; } } mysql_close($link); $strXML .= "</dataset></axis>";
  7. I am trying to pass an xml string into the datasource argument and I keep getting an invalid data message when I load the page. Any help would be appreciated. <head> <title>FusionCharts XT - Column 2D Chart - Data from a database</title> <link rel="stylesheet" type="text/css" href="css/style.css" /> <!-- Include the `fusioncharts.js` file. This file is needed to render the chart. Ensure that the path to this JS file is correct. Otherwise, it may lead to JavaScript errors. --> <script src="fusioncharts/fusioncharts.js"></script> </head> <?php include("fusioncharts/fusioncharts.php"); $servername = "localhost"; $username = "*****"; $password = "****"; $dbname = "***"; // Create connection $dbhandle = new mysqli($servername, $username, $password, $dbname); // Check connection if ($dbhandle->connect_error) { die("Connection failed: " . $dbhandle->connect_error); } $dbhandle = new mysqli($servername, $username, $password, $dbname); // Render an error message, to avoid abrupt failure, if the database connection parameters are incorrect if ($dbhandle->connect_error) { exit("There was an error with your connection: ".$dbhandle->connect_error); } // Form the SQL query that returns the top 10 most populous countries $strQuery = "SELECT * FROM scores"; //$retval = mysql_query( $sql, $conn ); // Execute the query, or else return the error message. $result = $dbhandle->query($strQuery) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}"); //while($row = mysql_fetch_assoc($result)) { // echo "Category :{$row['category']} <br> ". // "score : {$row['score']} <br> ". // "--------------------------------<br>"; // } $strXML ="'<chart><categories>"; // If the query returns a valid response, prepare the XML string if ($result) { // The `$arrData` array holds the chart attributes and data //$arrData["data"] = array(); // Push the data into the array while($row = mysqli_fetch_array($result)) { $strQuery2 = "select * from desirescores where ID =" . $row['ID']; //echo $strQuery2; $result2 = mysqli_query($dbhandle, $strQuery2) or die(mysqli_error()); $ors2 = mysqli_fetch_array($result2); //Generate <set label='..' value='..'/> //free the resultset $strXML .= "<category label='" . $ors2['category'] . "' />"; mysqli_free_result($result2); } } $strXML .= "</categories><dataset seriesName='Athlete Scores'>"; $strXML .="<set value='35' /><set value='48' /><set value='31' /><set value='40' /><set value='36' /><set value='36' /><set value='36' /><set value='36' /></dataset></chart>'"; echo $strXML; $radarChart = new FusionCharts("radar", "myFirstChart" , 600, 300, "chart-1", "XML", $strXML); $radarChart->render(); $dbhandle->close(); ?> <div id="chart-1"><!-- Fusion Charts will render here--></div>
  8. I am trying to create an msline chart using PHP and JSON to display data from my SQL database using the Fusion Charts Factory Sample database as my guide. In both cases (with Factory Sample data and my own data) the first value in each data series are duplicated as the first and second data point, and the last value does not appear on the chart. My SQL query returns the following datasets $strQueryCategories Game R9,2015 R9,2015 R20,2015 R20,2015 EF,2015 R1,2016 R1,2016 $strQuery​Data Team Game Total Claremont R9,2015 60 Claremont R20,2015 60 Claremont EF,2015 61 Claremont R1,2016 110 East Perth R9,2015 21 East Perth R20,2015 70 East Perth EF,2015 93 East Perth R1,2016 34 // Form the SQL query $strQueryCategories = "SELECT CONCAT(RoundNo, ',',Season) AS Game FROM MatchDetails WHERE (Team = 'East Perth' OR Opponent = 'East Perth') AND (Team = 'Claremont' OR Opponent = 'Claremont') AND Season > 2014 ORDER BY GameID ASC"; $resultCategories = $dbhandle->query($strQueryCategories)or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}"); $strQueryData = "SELECT Team, CONCAT(RoundNo, ',',Season) AS Game, Total FROM MatchDetails WHERE (Team = 'East Perth' OR Opponent = 'East Perth') AND (Team = 'Claremont' OR Opponent = 'Claremont') AND Season >2014 ORDER BY Team, GameId ASC"; $resultData = $dbhandle->query($strQueryData)or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}"); if ($resultData) { $arrData = array( "chart" => array( "caption" => "Head to Head Since Start 2015", "subcaption" => "Scores For & Against", "theme" => "fint" ) ); $arrData["categories"] = array(array("category" => array())); if ($resultCategories) { $controlBreakValue = ""; while ($row = mysqli_fetch_array($resultCategories)) { if ($controlBreakValue != $row["Game"]) { $controlBreakValue = $row["Game"]; array_push( $arrData["categories"][0]["category"], array("label" => $controlBreakValue)); $controlBreakValue == ""; } } } $arrData["dataset"] = array(); $i = 0; if ($resultData) { $controlBreakValue = ""; while ($row = mysqli_fetch_array($resultData)) { if ($controlBreakValue != $row["Team"]) { $controlBreakValue = $row["Team"]; array_push($arrData["dataset"], array("seriesname" => $controlBreakValue, "data" => array(array("value" => $row["Total"])))); $controlBreakValue == ""; $i++; } array_push($arrData["dataset"][$i-1]["data"], array("value" => $row["Total"])); } } } $jsonEncodedData = json_encode($arrData); $dbhandle->close(); echo $jsonEncodedData; ?> <html> <body> <?php $columnChart = new FusionCharts("msline", "myFirstChart" , 850, 300, "chart-1", "json", $jsonEncodedData); $columnChart->render(); ?> <div id="chart-1"><!-- Fusion Charts will render here--></div> </body> </html> ​ Chart output is attached. You can see the first value is duplicated.
  9. Hello, I'm struggling with the tutorial based on php and database. I'm using xampp as web hosting server. The link of the tutorial is as follows: http://www.fusioncharts.com/tutorials/php-mysql-charts/ There are four steps in the tutorial. As far as I have understood, the first three steps ask to create a file name "char_data.php". I have saved the file with the code from tutorial. The complete code is as follows: <?php> <html> <head> <body> <title>My first chart using FusionCharts Suite XT</title> <script type="text/javascript" src="fusioncharts/fusioncharts.js"></script> <script type="text/javascript" src="fusioncharts/themes/fusioncharts.theme.zune.js"></script> USE test; C REATE TABLE top_odi_wicket_takers(player varchar(255),wickets integer, PRIMARY KEY (player) ); INSERT INTO top_odi_wicket_takers(player, wickets) VALUES('MA Starc', 34); INSERT INTO top_odi_wicket_takers(player, wickets) VALUES('ST Finn', 27); INSERT INTO top_odi_wicket_takers(player, wickets) VALUES('Imran Tahir', 25); INSERT INTO top_odi_wicket_takers(player, wickets) VALUES('M Morkel', 21); INSERT INTO top_odi_wicket_takers(player, wickets) VALUES('TA Boult', 36); INSERT INTO top_odi_wicket_takers(player, wickets) VALUES('TG Southee', 28); INSERT INTO top_odi_wicket_takers(player, wickets) VALUES('CJ Anderson', 25); INSERT INTO top_odi_wicket_takers(player, wickets) VALUES('Wahab Riaz', 25); INSERT INTO top_odi_wicket_takers(player, wickets) VALUES('JH Davey', 21); INSERT INTO top_odi_wicket_takers(player, wickets) VALUES('UT Yadav', 22); SELECT * FROM top_odi_wicket_takers; +-------------+---------+ | player | wickets | +-------------+---------+ | CJ Anderson | 25 | | Imran Tahir | 25 | | JH Davey | 21 | | M Morkel | 21 | | MA Starc | 34 | | ST Finn | 27 | | TA Boult | 36 | | TG Southee | 28 | | UT Yadav | 22 | | Wahab Riaz | 25 | +-------------+---------+ 10 rows in set (0.00 sec) With this we have the required data i //address of the server where db is installed $servername = "localhost"; //username to connect to the db //the default value is root $username = "root"; //password to connect to the db //this is the value you would have specified during installation of WAMP stack $password = ""; //name of the db under which the table is created $dbName = "test"; //establishing the connection to the db. $conn = new mysqli($servername, $username, $password, $dbName); //checking if there were any error during the last connection attempt if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } //the SQL query to be executed $query = "SELECT * FROM top_odi_wicket_takers"; //storing the result of the executed query $result = $conn->query($query); //initialize the array to store the processed data $jsonArray = array(); //check if there is any data returned by the SQL Query if ($result->num_rows > 0) { //Converting the results into an associative array while($row = $result->fetch_assoc()) { $jsonArrayItem = array(); $jsonArrayItem['label'] = $row['player']; $jsonArrayItem['value'] = $row['wickets']; //append the above created object into the main array. array_push($jsonArray, $jsonArrayItem); } } //Closing the connection to DB $conn->close(); //set the response content type as JSON header('Content-type: application/json'); //output the return value of json encode using the echo function. echo json_encode($jsonArray); //Closing the connection to DB $conn->close(); //set the response content type as JSON header('Content-type: application/json'); //output the return value of json encode using the echo function. echo json_encode($jsonArray); var apiChart = new FusionCharts({ type: 'column2d', renderAt: 'api-chart-container', width: '550', height: '350', dataFormat: 'json', dataSource: { "chart": chartProperties, "data": chartData } }); $(function(){ $("#background-btn").click(function(){ modifyBackground(); }); $("#canvas-btn").click(function(){ modifyCanvas(); }); $("#dataplot-btn").click(function(){ modifyDataplot(); }); apiChart.render(); }); function modifyBackground(){ //to be implemented } function modifyCanvas(){ //to be implemented } function modifyDataplot(){ //to be implemented } <div id="chartContainer">FusionCharts XT will load here!</div> </body> </head> </html> </?php> As i try to run the file "chart_data.php" in local host and I get the following page showing up: The fourth step ask to create another file under name "char_sample.html". The code is as follows: <html> <head> <body> <title>My first chart using FusionCharts Suite XT</title> <script type="text/javascript" src="fusioncharts/js/fusioncharts.js"></script> <script type="text/javascript" src="fusioncharts/js/themes/fusioncharts.theme.fint.js"></script> <!DOCTYPE html> <title>FusionCharts Column 2D Sample</title> </head> <body> <div id="chart-container">FusionCharts will render here</div> <script src="js/jquery-2.1.4.js"></script> <script src="js/fusioncharts.js"></script> <script src="js/fusioncharts.charts.js"></script> <script src="js/themes/fusioncharts.theme.zune.js"></script> <script src="js/app.js"></script> $(function(){ $.ajax({ url: 'http://localhost/chart_data.php' type: 'GET', success : function(data) { chartData = data; var chartProperties = { "caption": "Top 10 wicket takes ODI Cricket in 2015", "xAxisName": "Player", "yAxisName": "Wickets Taken", "rotatevalues": "1", "theme": "zune" }; apiChart = new FusionCharts({ type: 'column2d', renderAt: 'chart-container', width: '550', height: '350', dataFormat: 'json', dataSource: { "chart": chartProperties, "data": chartData } }); apiChart.render(); } }); }); <div id="chartContainer">FusionCharts XT will load here!</div> </body> </head> </html> Running the file in the localhost gives this result: I don't see any chart by running both these files in the localhost. Whereas, I'm supposed to end up having chart. Any help would be great.
  10. Hello, I have xampp with apache server and mysql. I have downloaded the trial version of fusionchart suite. I don't what to do with these files or where to save them in order to work with xamp and mysql. I have tried copying the sample code of chart and try to run it on my localhost but it say these libraries are not found in httdocs. In your quick start guide, steo 1 says to add libraries to html. i don't know where is html. Please help regarding the issue as I'm new to this thing. Regards Farooq
  11. Here is my code: <?php // This is a simple example on how to draw a chart using FusionCharts and PHP. // We have included includes/fusioncharts.php, which contains functions // to help us easily embed the charts. echo' <html> <script type="text/javascript" src="http://static.fusioncharts.com/code/latest/fusioncharts.js"></script> <script type="text/javascript" src="fusioncharts/js/themes/fusioncharts.theme.ocean.js"></script> </html> '; include(dirname(__FILE__) . "/fusioncharts/fusioncharts.php"); // Create the chart - Pie 3D Chart with data given in constructor parameter $columnChart = new FusionCharts("column2d", "ex1" , 600, 400, "chart-1", "json", '{ "chart":{ "caption":"Harry\'s SuperMart", "subCaption":"Top 5 stores in last month by revenue", "numberPrefix":"$", "theme":"ocean" }, "data":[ { "label":"Bakersfield Central", "value":"880000" }, { "label":"Garden Groove harbour", "value":"730000" }, { "label":"Los Angeles Topanga", "value":"590000" }, { "label":"Compton-Rancho Dom", "value":"520000" }, { "label":"Daly City Serramonte", "value":"330000" } ] }'); // Render the chart $columnChart->render(); ?> Here is the error I am getting: Uncaught RuntimeException: #03091456 ex1.render() Error >> Unable to find the container DOM element. I am using the example from the site.....
  12. Halo, Can Somebody help me for make example multiple series using JSON in PHP Framework Codeigniter with MySQL, Not using XML but JSON. Please can someone to help me.
  13. hi i have problem with MSLine chart. here is my database look like: ------------|--------------------------|----------------------------| id | Generator | Date | -------------------------------------------------------------------| 1 | Plant 1 | 2015-12-01 | ------------------------------------------------------------------- 2 |Plant 2 | 2015-12-02 | ------------------------------------------------------------------- 3 | Plant 1 | 2015-12-03 | ------------------------------------------------------------------- here is mycode: <?php $q = intval($_GET['q']); $strQueryCategories = "select distinct DATE_FORMAT(tblmarketable.date,'%c-%d-%Y') as DatePro from tblmarketable where ae = 'juan' and YEAR(date) = YEAR(NOW()) and MONTH(date) = '".$q."' order by DatePro"; $resultCategories = mysql_query($strQueryCategories) or die(mysql_error()); $strQueryData = "SELECT ref, date, gen, SUM(amount) as amount from tblmarketable where ae = 'juan' and YEAR(date) = YEAR(NOW()) and MONTH(date) = '".$q."' group by gen, ref, date order by gen"; $resultData = mysql_query($strQueryData) or die(mysql_error()); $strXML = "<graph legendPostion='' caption='Marketable Sales' subCaption='By Juan' xAxisName='Group By Reference No: ' yAxisName='Amount' showValues='0' formatNumberScale='0' rotateValues='1' theme='fint'>"; $strXML .= buildCategories ($resultCategories, "DatePro"); $strXML .= buildDatasets ( $resultData, "amount", "gen"); $strXML .= "</graph>"; echo renderChartHTML("Charts/MSLine.swf", "", $strXML, "FactorySum", 600, 300, false, true); mysql_free_result($resultCategories); mysql_free_result($resultData); function buildCategories ( $result, $labelField ) { $strXML = ""; if ($result) { $strXML = "<categories>"; while($ors = mysql_fetch_array($result)) { $strXML .= "<category label='" . $ors[$labelField]. "'/>"; } $strXML .= "</categories>"; } return $strXML; } function buildDatasets ($result, $valueField, $controlBreak ) { $strXML = ""; if ($result) { $controlBreakValue =""; while( $ors = mysql_fetch_array($result) ) { echo" "; if( $controlBreakValue != $ors[$controlBreak] ) { $controlBreakValue = $ors[$controlBreak]; $strXML .= ( $strXML =="" ? "" : "</dataset>") . ( "<dataset seriesName='" . $controlBreakValue . "'>" ) ; } $strXML .= "<set value='" . $ors[$valueField] . "'/>"; } $strXML .= "</dataset>"; } return $strXML; } ?> the PLANT 1 (id 1) is correct in the position date, but the problem is the PLANT 2 date become 2015-12-01 that shows in a graph instead of 2015-12-02 and the PLANT 1 (id 3) date become 2015-12-02 instead of 2015-12-03 anyone can help me? regards.. -
  14. So, i have DB like these : +----------+------------+-------+ | Time | Date | A0 | +----------+------------+-------+ | 17:00:00 | 2015-06-23 | 100 | | 17:05:00 | 2015-06-23 | 120 | | 17:10:00 | 2015-06-23 | 200 | | 17:00:00 | 2015-06-24 | 200 | | 17:05:00 | 2015-06-24 | 190 | | 17:10:00 | 2015-06-24 | 200 | | 08:00:00 | 2015-06-25 | 90 | +----------+------------+-------+ and I use these code : <?php //We have included ../Includes/FusionCharts.php, which contains functions //to help us easily embed the charts. include("class/Includes/FusionCharts.php"); include("class/Includes/DBConn.php"); ?> <HTML> <HEAD> <TITLE> FusionCharts XT - </TITLE> <SCRIPT LANGUAGE="Javascript" SRC="fusioncharts/fusioncharts.js"></SCRIPT> <SCRIPT LANGUAGE="Javascript" SRC="fusioncharts/themes/fusioncharts.theme.fint.js"></SCRIPT> </HEAD> <BODY> <?php $link = connectToDB(); $strQueryCategories = "select distinct Time from input where Date between '2015-06-23' and '2015-06-27' order by Time"; $resultCategories = mysql_query($strQueryCategories) or die(mysql_error()); $strQueryData = "select * from input where Date between '2015-06-23' and '2015-06-27' "; $resultData = mysql_query($strQueryData) or die(mysql_error()); $strXML = "<chart legendPostion='' caption='Konsentrasi CO2' subCaption='By Quantity' xAxisName='Time' yAxisName='Concentration (ppm)' showValues='0' formatNumberScale='0' rotateValues='1' theme='fint'>"; $strXML .= buildCategories ($resultCategories, "Time"); $strXML .= buildDatasets ( $resultData, "A0", "Date"); $strXML .= "</chart>"; echo renderChart("MSLine", "", $strXML, "FactorySum", 600, 300, false, true); mysql_free_result($resultCategories); mysql_free_result($resultData); mysql_close($link); function buildCategories ( $result, $labelField ) { $strXML = ""; if ($result) { $strXML = "<categories>"; while($ors = mysql_fetch_array($result)) { $strXML .= "<category label='" . $ors[$labelField]. "'/>"; } $strXML .= "</categories>"; } return $strXML; } function buildDatasets ($result, $valueField, $controlBreak ) { $strXML = ""; if ($result) { $controlBreakValue =""; while( $ors = mysql_fetch_array($result) ) { echo" "; if( $controlBreakValue != $ors[$controlBreak] ) { $controlBreakValue = $ors[$controlBreak]; $strXML .= ( $strXML =="" ? "" : "</dataset>") . ( "<dataset seriesName='" . $controlBreakValue . "'>" ) ; } $strXML .= "<set value='" . $ors[$valueField] . "'/>"; } $strXML .= "</dataset>"; } return $strXML; } ?> </BODY> </HTML> But what I get is a chart with false value. the 1st value of A0 data at 2015-06-23 and 2015-06-24 are at 08:00:00 instead of 17:00:00, and so goes on for the other data. Please someone help me So the only data at 08:00:00 only 2015-06-25 data
  15. Hello to Forum, I am new one with combining Charts with FusionChart XT. I have created some normal charts with Pie,Column,Line but i have some difficulties with MultiSeries Line Chart and would be appreciate if you can help me please. In the text below i will provide you my php code: <?php //We have included ../Includes/FusionCharts.php and ../Includes/DBConn.php, which contains //functions to help us easily embed the charts and connect to a database. include("FusionCharts.php"); #include("../Includes/DBConn.php"); ?> <HTML> <HEAD> <TITLE>FusionCharts XT - Database Example</TITLE> <SCRIPT LANGUAGE="Javascript" SRC="FusionCharts.js"></SCRIPT> </HEAD> <BODY> <CENTER> <?php //In this example, we show how to connect FusionCharts to a database. //For the sake of ease, we have used an MySQL databases containing two //tables. // Connect to the DB mysql_connect('localhost','root','google'); mysql_select_db('Difference_Output'); // SQL query for category labels $strQueryCategories ="SELECT DISTINCT `CHANNEL_ID` FROM `DIFFERENTS` WHERE `SECONDS_ID2`>0 AND `SECONDS_ID1`>0 ORDER BY `CHANNEL_ID`"; // Query database $resultCategories = mysql_query($strQueryCategories) or die(mysql_error()); // SQL query for factory output data $strQueryData = "SELECT `SECONDS_ID2`, `SECONDS_ID1`, `CHANNEL_ID` FROM `DIFFERENTS` WHERE `SECONDS_ID2`>0 AND `SECONDS_ID1`>0 ORDER BY `SECONDS_ID2`,`SECONDS_ID1`"; // Query database $resultData = mysql_query($strQueryData) or die(mysql_error()); //We also keep a flag to specify whether we have to animate the chart or not. //If the user is viewing the detailed chart and comes back to this page, he shouldn't //see the animation again. //$strXML will be used to store the entire XML document generated //Generate the chart element $strXML = "<chart legendPosition='' caption='Records Output report' subCaption='By Seconds' xAxisName='Factory' yAxisName='Units' showValues='0' formatNumberScale='0' rotateValues='1' animation='1'>"; // Build category XML $strXML .= buildCategories ($resultCategories, "CHANNEL_ID"); // Build datasets XML $strXML .= buildDatasets ( $resultData, "SECONDS_ID2", "SECONDS_ID1"); //Finally, close <chart> element $strXML .= "</chart>"; //Create the chart - Pie 3D Chart with data from strXML echo renderChart("MSLine.swf", "", $strXML, "FactorySum", 1000, 700, false, true); // Free database resource # mysql_free_result($resultCategories); # mysql_free_result($resultData); # mysql_close($link); /*********************************************************************************************** * Function to build XML for categories * @param $result Database resource * @param $labelField Field name as String that contains value for chart category labels * * @return categories XML node */ function buildCategories ( $result, $labelField ) { $strXML = ""; if ($result) { $strXML = "<categories>"; while($ors = mysql_fetch_array($result)) { $strXML .= "<category label='" . $ors[$labelField]. "'/>"; } $strXML .= "</categories>"; } return $strXML; } /*********************************************************************************************** * Function to build XML for datasets that will contain chart data * @param $result Database resource. The data should come ordered by a control break field which will require to identify datasets and set its value to dataset's series name * @param $valueField Field name as String that contains value for chart dataplots * @param $controlBreak Field name as String that contains value for chart dataplots * * @return Dataset XML node */ function buildDatasets ($result, $valueField, $controlBreak ) { $strXML = ""; if ($result) { $controlBreakValue =""; while( $ors = mysql_fetch_array($result) ) { if( $controlBreakValue != $ors[$controlBreak] ) { $controlBreakValue = $ors[$controlBreak]; $strXML .= ( $strXML =="" ? "" : "</dataset>") . ( "<dataset seriesName='" . $controlBreakValue . "'>" ) ; } $strXML .= "<set value='" . $ors[$valueField] . "'/>"; } $strXML .= "</dataset>"; } return $strXML; } ?> </BODY> </HTML> The cart is running fine but is giving me all of the values, the thing that i need is 2 lines with dots.The CHANNEL_ID i want to be in X axis value and SECONDS1 and SECONDS2 IN Y values. For every other Details i can provide you my help. Thanks
  16. Sorry for the repost i just attach the file for my work i wish i can get an immediate response....... hi i am newbie in FusionCharts......... following samples in goes smoothly until i reach this problem...... i am following this sample http://docs.fusionch...s-of-chart.html My problem is the Thumbnail atttributes is not DISABLING........ the difference between my codes and the sample is the source of the data....... In my codes i am getting the json data from an external json file......... besides that difference nothing else differs...... more info my thumbnail resize it works....... it just the attributes are not disabling.......... it like i have small charts......... il post my codes here hope i can get an immediate response......... Thank You very much in advance.................. FusionCharts.ready(function(){ var createThumbNail = function(chartId, width, height, divId) { var chartRef = FusionCharts(chartId), clonedChart = chartRef.clone({ "width": width, "height": height }); ///////////////////////////////////////////////////////////////////////////////////// // i think this part of the codes is not working............ ///////////////////////////////////////////////////////////////////////////////////// clonedChart.setChartAttribute({ "showValues": "0", "showLabels": "0", "animation": "0", "exportEnabled": "0", "showTooltip": "0", "showHoverEffect": "0", "showYAxisValues": "0", "caption": "", "subCaption": "", "xAxisName": "", "yAxisName": "", "showXAxisLine": "0", "showYAxisLine": "0", "numDivLines": "0", "enableSlicing": "0", "enableRotation": "0" }); ///////////////////////////////////////////////////////////////////////////////////// // i think this part of the codes is not working............ ///////////////////////////////////////////////////////////////////////////////////// clonedChart.addEventListener('chartClick', function() { FusionCharts(chartId).render('chart-container'); }); clonedChart.render(divId, 'append'); }; var daily = new FusionCharts({ "type": "msstackedcolumn2d", "renderAt": "chart-container", "width": "800", "height": "500", "dataFormat": "jsonurl", "id": "chart1", //"dataSource": Drupal.settings.basePath + "/chartdata2.json" "dataSource": Drupal.settings.basePath + Drupal.settings.fusion.link + "/js/jsondata/jsondataDaily.json" }); var weekly = new FusionCharts({ "type": "msstackedcolumn2d", "renderAt": "chart-container", "width": "800", "height": "500", "dataFormat": "jsonurl", "id": "chart2", //"dataSource": Drupal.settings.basePath + "/chartdata2.json" "dataSource": Drupal.settings.basePath + Drupal.settings.fusion.link + "/js/jsondata/jsondataQuarter.json" }); // create thumbnails for all the three charts createThumbNail('chart1', 300, 300, 'thumbnail1'); createThumbNail('chart2', 300, 300, 'thumbnail2'); weekly.render(); }); // end of code fusion2.zip
  17. I am using PHP with fusioncharts I have two charts - a column and a line chart working perfectly. They each get data from 2 diferent MSQL queries. I am trying to combine the charts into 1 combination chart . The documentation I found refers to a addDataset and addChartData methods but neither seem to be supported Could you provide any examples that achieve the above please Thanks
  18. Hi, Anyone who need FusionChart DashBoard using Mysql/php Application feel free to hire me
  19. hi i am using Multi-series Stacked Column 2D + Line Dual Y Axis and i want to force my secondary y axis to show these values 14, 29, 43, 57, 71, 86, 100 how to i set my secondary y-axis to these values?????????????????
  20. hi i am newbie in FusionCharts......... following samples in goes smoothly until i reach this problem...... i am following this sample http://docs.fusioncharts.com/tutorial-how-to-guides-render-thumbnail-versions-of-chart.html My problem is the Thumbnail atttributes is not DISABLING........ the difference between my codes and the sample is the source of the data....... In my codes i am getting the json data from an external json file......... besides that difference nothing else differs...... more info my thumbnail resize it works....... it just the attributes are not disabling.......... it like i have small charts......... il post my codes here hope i can get an immediate response......... Thank You very much in advance.................. FusionCharts.ready(function(){ var createThumbNail = function(chartId, width, height, divId) { var chartRef = FusionCharts(chartId), clonedChart = chartRef.clone({ "width": width, "height": height }); ///////////////////////////////////////////////////////////////////////////////////// // i think this part of the codes is not working............ ///////////////////////////////////////////////////////////////////////////////////// clonedChart.setChartAttribute({ "showValues": "0", "showLabels": "0", "animation": "0", "exportEnabled": "0", "showTooltip": "0", "showHoverEffect": "0", "showYAxisValues": "0", "caption": "", "subCaption": "", "xAxisName": "", "yAxisName": "", "showXAxisLine": "0", "showYAxisLine": "0", "numDivLines": "0", "enableSlicing": "0", "enableRotation": "0" }); ///////////////////////////////////////////////////////////////////////////////////// // i think this part of the codes is not working............ ///////////////////////////////////////////////////////////////////////////////////// clonedChart.addEventListener('chartClick', function() { FusionCharts(chartId).render('chart-container'); }); clonedChart.render(divId, 'append'); }; var daily = new FusionCharts({ "type": "msstackedcolumn2d", "renderAt": "chart-container", "width": "800", "height": "500", "dataFormat": "jsonurl", "id": "chart1", //"dataSource": Drupal.settings.basePath + "/chartdata2.json" "dataSource": Drupal.settings.basePath + Drupal.settings.fusion.link + "/js/jsondata/jsondataDaily.json" }); var weekly = new FusionCharts({ "type": "msstackedcolumn2d", "renderAt": "chart-container", "width": "800", "height": "500", "dataFormat": "jsonurl", "id": "chart2", //"dataSource": Drupal.settings.basePath + "/chartdata2.json" "dataSource": Drupal.settings.basePath + Drupal.settings.fusion.link + "/js/jsondata/jsondataQuarter.json" }); // create thumbnails for all the three charts createThumbNail('chart1', 300, 300, 'thumbnail1'); createThumbNail('chart2', 300, 300, 'thumbnail2'); weekly.render(); }); // end of code
  21. Hi, I need urgent help. I am trying to show prettyphoto with jquery change event. In the first time change of html dropdown data, prettyphoto working fine but when I am changing again the html dropdown data the the prettyphoto does not work. Can any1 help me? Here is the attachment of the full job. Thanks Julhas Sujan FusionCharts_Drill_down.zip
  22. Hi, I need urgent help. I am trying to show prettyphoto with jquery change event. In the first time change of html dropdown data, prettyphoto working fine but when I am changing again the html dropdown data the the prettyphoto does not work. And Can any1 help me? Here is the attachment of the full job. Thanks Julhas Sujan FusionCharts_Drill_down.zip
  23. Hi I have setup our server to export a graph back to the client using Batik. Everything is set up correctly and when the 'export chart' button is clicked and either 'download as jpeg' or 'png' is selected the image is downloaded except the quality between the image downloaded this way and an image downloaded from the 'export.api3.fusioncharts.com' greatly differs as downloaded from our server is a lower quality image. Is there any other setting I need to change to increase the quality of the image from our server. I have attached the image comparison to the post
  24. We noticed that the logo we display in the bottom-right corner of the chart looks fine (using logoURL='sssss.png'). However, when we download the chart in pure JavaScrpt the logo is not included in the saved file.
  25. I cannot get LogMSColumn2D. swf javascript chart in PhP to display the category dates on X-Axis. The feature works fine in non-logarithmic Column2D For the regular I am using : $date = date("D (jS)",strtotime($ors[0])) ; $strXML .= "<set label='".$date."' value='".$ors[1]."' color='00FF00'/>"; $strXML .= ""; For the LogMSColumn2D ( to get chart to display) I am using: $date .= date("D (jS)",strtotime($ors[0])) ; $strXML.="<categories> <category label='".$date."'/>"; $strXML.="</categories>"; $strXML.="<dataset> <set value='".$ors[1]."' color='00FF00'/>"; $strXML.="</dataset>"; $strXML .= ""; What am I missing?