Re: [ubuntu-uk] FLOSS solution for graphing in PHP
On Friday 22 June 2007 18:36, Mark Harrison wrote: Hi all, I've got what I thought would be a simple problem, and google is not being my friend this afternoon. I have a database (MySQL5), and a webserver (Apache), and a programming language that lets me extract info from one and display it with the other (PHP5.) These all run on a nice friendly thing you may have heard of called Ubuntu :-) What I'm after is a free (in both senses) thing (library, probably), that can grab some data, and turn it into a pretty-looking bar graph. I don't mind particularly how it outputs the graph provided it's something that can display within Firefox, so something that could dynamically build a PNG or a Flash, or whatever really. However, Google has let me down - lots of chargeable libraries, but adding the search term free gives me free trial, $69 to buy or the like results. Has anyone any personal recommendations? M. rrdtool - takes a bit of getting the hang of, but will take data e.g temperatures - and output as graphs. Have a look at my brother in laws temperature graphs - http://www.hoagieshouse.com/temperature/ Thats the sort of thing you get - you can of course tweak them a bit too. A cron job gets the data every x seconds and adds the next point to your graph. Mark -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.kubuntu.org/UKTeam/
[ubuntu-uk] FLOSS solution for graphing in PHP
Hi all, I've got what I thought would be a simple problem, and google is not being my friend this afternoon. I have a database (MySQL5), and a webserver (Apache), and a programming language that lets me extract info from one and display it with the other (PHP5.) These all run on a nice friendly thing you may have heard of called Ubuntu :-) What I'm after is a free (in both senses) thing (library, probably), that can grab some data, and turn it into a pretty-looking bar graph. I don't mind particularly how it outputs the graph provided it's something that can display within Firefox, so something that could dynamically build a PNG or a Flash, or whatever really. However, Google has let me down - lots of chargeable libraries, but adding the search term free gives me free trial, $69 to buy or the like results. Has anyone any personal recommendations? M. -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.kubuntu.org/UKTeam/
Re: [ubuntu-uk] FLOSS solution for graphing in PHP
I think imagemagick might help, but I'm not sure... On Fri, 2007-06-22 at 18:36 +0100, Mark Harrison wrote: Hi all, I've got what I thought would be a simple problem, and google is not being my friend this afternoon. I have a database (MySQL5), and a webserver (Apache), and a programming language that lets me extract info from one and display it with the other (PHP5.) These all run on a nice friendly thing you may have heard of called Ubuntu :-) What I'm after is a free (in both senses) thing (library, probably), that can grab some data, and turn it into a pretty-looking bar graph. I don't mind particularly how it outputs the graph provided it's something that can display within Firefox, so something that could dynamically build a PNG or a Flash, or whatever really. However, Google has let me down - lots of chargeable libraries, but adding the search term free gives me free trial, $69 to buy or the like results. Has anyone any personal recommendations? M. -- Alec Wright New Mobile Number: 07932 217 288 -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.kubuntu.org/UKTeam/
Re: [ubuntu-uk] FLOSS solution for graphing in PHP
There's a perl module that makes graphs - I think it's used in the wifidog system I use for wireless auth to create user stats. http://cpan.uwinnipeg.ca/htdocs/GDGraph/GD/Graph.html Chris -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.kubuntu.org/UKTeam/
Re: [ubuntu-uk] FLOSS solution for graphing in PHP
Thanks to all who responded - it looks like Alan's suggestion of gd is probably what I need. rrdtool looked interesting, but the home is pretty much all xAP/xPL stuff, not least because the HomeVision connector was the first GPL application I ever released :-) Time was (about 2002) when I logged every telemetry event in the house (temp changes, lights on-off, occupancy sensors, etc) for about 2 months into a MySQL database - trouble was, 1: I couldn't work out what to do with the data set, and 2: we had kids :-) I still have a ludicrous amount of home automation hardware sitting on a shelf in the study awaiting the day when I'll get the fabled Round Tuit and set it up in a child-friendly way. Too many interesting projects, not enough time. GD - good call, though. Seems to be what I need. M. Alan Pope wrote: Hi Mark, On Fri, 2007-06-22 at 18:36 +0100, Mark Harrison wrote: What I'm after is a free (in both senses) thing (library, probably), that can grab some data, and turn it into a pretty-looking bar graph. I don't mind particularly how it outputs the graph provided it's something that can display within Firefox, so something that could dynamically build a PNG or a Flash, or whatever really. gd is the library in php that can generate pretty much any graphical output. http://www.partdigital.com/tutorials/bar-chart/ http://www.weberdev.com/get_example-4619.html Also as previously mentioned rrdtool is often used to generate graphs. An example of rrdtool can be seen if you ever view cacti performance and other resource usage graphs. You can see an example on the front page of the cacti site. http://cacti.net/ Cheers, Al. -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.kubuntu.org/UKTeam/
