pappu Report post Posted March 7, 2011 Hi.. I have a MySql database with images (datatype used is Blob) in it. Can I plot these database records into a fusion chart?? Is that possible?? If so how can i do that?? Thanks !! Share this post Link to post Share on other sites
Guest Angie Report post Posted March 7, 2011 Hi, Welcome to FusionCharts Forum! Please refer to the link: http://www.fusioncharts.com/docs?/PHP_DB.html Hope this helps. Share this post Link to post Share on other sites
pappu Report post Posted March 7, 2011 (edited) Hey thank you so much for the reply !! The link is really good,useful. But there is nothing like MySql related topics in that. I need to plot the Mysql database to fusion charts.Can we?? Thank You. Hi, Welcome to FusionCharts Forum! Please refer to the link: http://www.fusioncha...cs?/PHP_DB.html Hope this helps. Edited March 7, 2011 by pappu Share this post Link to post Share on other sites
pappu Report post Posted March 7, 2011 Hey..Yeah.. I can plot the Sql DB also.. Thankz to U n fusioncharts..!! Hey thank you so much for the reply !! The link is really good,useful. But there is nothing like MySql related topics in that. I need to plot the Mysql database to fusion charts.Can we?? Thank You. Share this post Link to post Share on other sites
Guest Angie Report post Posted March 7, 2011 (edited) Hi, Thanks for your appreciation. FusionCharts cannot directly access any database. Using FusionCharts, you'll always need to provide data to the charts in XML format. FusionCharts JavaScript class also provides for the option to specify data in JSON format. For this, you'll have to set a middleware script (like ASP, PHP, .NET, ColdFusion, J2EE etc.), which would access your database and then build the XML or JSON output for FusionCharts. Hope this helps. Edited March 7, 2011 by Angie Share this post Link to post Share on other sites
pappu Report post Posted March 7, 2011 Yeah I made use of XML files.I am able to get the data records in xml file and plot also. But I have one more doubt too. I am able to select (by dragging) one plot on chart and display the corresponding 'id' details of the selected plot.But i want to get back the selected plot details(ie. want to save the selected plot details) into an xml file or some document.How can i do this? which funtion will be helpful?? Thank You. Hi, Thanks for your appreciation. FusionCharts cannot directly access any database. Using FusionCharts, you'll always need to provide data to the charts in XML format. FusionCharts JavaScript class also provides for the option to specify data in JSON format. For this, you'll have to set a middleware script (like ASP, PHP, .NET, ColdFusion, J2EE etc.), which would access your database and then build the XML or JSON output for FusionCharts. Hope this helps. Share this post Link to post Share on other sites
Guest Angie Report post Posted March 7, 2011 (edited) Hi, Could you please send us a screenshot of your requirement? Awaiting for your reply. Edited March 7, 2011 by Angie Share this post Link to post Share on other sites
pappu Report post Posted March 7, 2011 Hi.. Yeah,if u see the screenshot attached, u can find that i have selected 3plots on the chart and the corresponding details(like id,etc) of those 3 plots are displayed at the bottom like INVEQ324_7,INVEQ324_37,INVEQ324_62. I want to save these 3 details back to a separate xml file or somehow i want to save these details.How can i do this? Hope you clear with my question :) Thank You. Hi, Could you please send us a screenshot of your requirement? Awaiting for your reply. Share this post Link to post Share on other sites
Guest Angie Report post Posted March 7, 2011 (edited) Hi, Please refer to the link below: http://www.fusioncha.../?PHP_Form.html http://www.fusioncha...PHP_JS_URL.html http://www.fusioncha...PHP_JS_XML.html Hope this helps. Edited March 7, 2011 by Angie Share this post Link to post Share on other sites
