mdemetri2 Posted April 23, 2013 Share Posted April 23, 2013 (edited) Hi, I have tried a few times to look into something that will allow me to pull data from mysql database to produce charts on a site that is currently coded in PHP, but quickly loose the plot when I come across the need to install library's on the server running the site - which I have access to but would need step by step instructions on what to do. Also, I have looked into some dreamweaver plugins but not quite done what I needed. So, can anyone recommend something that is fairly straightforward to implement and then configure to create the charts?? Many thanks Demetri Edited April 23, 2013 by mdemetri2 Quote Link to comment https://forums.phpfreaks.com/topic/277210-php-and-mysql-graphing-options-recommendations/ Share on other sites More sharing options...
lemmin Posted April 23, 2013 Share Posted April 23, 2013 You can use the GD library to create images however you want. There are a few libraries out there that provide graphing functions; Here is one: http://pchart.sourceforge.net/ Or, you could generate the graph in HTML and have the client render it. Here is a tutorial on graphing using the canvas tag: http://www.html5canvastutorials.com/labs/html5-canvas-graphing-an-equation/ Quote Link to comment https://forums.phpfreaks.com/topic/277210-php-and-mysql-graphing-options-recommendations/#findComment-1426110 Share on other sites More sharing options...
Barand Posted April 23, 2013 Share Posted April 23, 2013 There is also a charting class in my signature Quote Link to comment https://forums.phpfreaks.com/topic/277210-php-and-mysql-graphing-options-recommendations/#findComment-1426150 Share on other sites More sharing options...
mdemetri2 Posted April 24, 2013 Author Share Posted April 24, 2013 thanks for all your replies guys, appreciated once again. I will take a look...at these and see where I get to. Quote Link to comment https://forums.phpfreaks.com/topic/277210-php-and-mysql-graphing-options-recommendations/#findComment-1426291 Share on other sites More sharing options...
mdemetri2 Posted April 24, 2013 Author Share Posted April 24, 2013 hmmm, ok taken a look at these. I think I'm leaning towards potentially using baaChart....but I have no clue how to configure it....so if I have a set data from a query (recordset in dreamweaver) how do I implement this being plotted? sorry, fairly new to all this I don't quite get the use of classes...... Quote Link to comment https://forums.phpfreaks.com/topic/277210-php-and-mysql-graphing-options-recommendations/#findComment-1426292 Share on other sites More sharing options...
Barand Posted April 24, 2013 Share Posted April 24, 2013 You need the baaChart php file on you server so you can include it. As with any dynamic image file the code needs to be in its own file (say mychart.php) and you place it on the page with an image tag <img src="mychart.php" /> There is a tutorial in the user guide. If you get stuck PM me Quote Link to comment https://forums.phpfreaks.com/topic/277210-php-and-mysql-graphing-options-recommendations/#findComment-1426298 Share on other sites More sharing options...
mdemetri2 Posted April 24, 2013 Author Share Posted April 24, 2013 Ok, I will do that and take a look at the tutorial. As always appreciate the offer to help. Leave it with me a few days. Have a good day! Quote Link to comment https://forums.phpfreaks.com/topic/277210-php-and-mysql-graphing-options-recommendations/#findComment-1426313 Share on other sites More sharing options...
Jessica Posted April 24, 2013 Share Posted April 24, 2013 A completely different approach would be to use Flotr - it's a JavaScript library for graphing. It's one of the prettiest I've seen http://www.solutoire.com/experiments/flotr/examples/basic-axis.html You could very easily use PHP to generate the JS, or better yet JSON to send to Flotr. Quote Link to comment https://forums.phpfreaks.com/topic/277210-php-and-mysql-graphing-options-recommendations/#findComment-1426314 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.