Does anybody have any good experiences with creating Line Graphs using relational data in CakePHP?
I’ve used PHPlot without a framework.
I guess I could just write a custom helper myself?
As always - any feedback grateful received!
My suggestion is use highcharts:
Create a cotroller function that return the series data as json and highcharts load that throuth ajax function
If you don’t need to embed the graphs in documents like PDF. I had high success using highcharts, chart.js o morris.js… there are a lot of libraries, but all of them works with json data.
You could implement a controller method returning data in json format or simply, do json_encode in a script tag after formatting the data. I usually grab all the required data from the db and put the transformation login in the view file, so I can transform my entities data to the json format used by the chart library I’m using.