I’m looking for a web-based reporting framework which is PHP-based and works with MySQL.
Here’s my problem (besides being too lazy to program this on my own): I have a large (50k+ rows) table which stores log data for multiple clients. These clients need to be able to sort and search and do all those grand things.
I’d really like something with a decent amount of power behind it, which is why I’m apprehensive about building one myself. This isn’t a big enough need to merit putting an exorbitant amount of time into, but it is a necessary function for my clients.
Ideally, I would like some sort of framework which I can either pass data or it get the data itself with a templating engine (so it would do all the presentation). I could get the rendered presentation and drop it into my site.
Something so nice probably doesn’t exist, but maybe I’ll be lucky.
Advertisement
Answer
I’ve found a decent substitute that fits my needs pretty well: a Symfony plugin called laiguExtGridPlugin. It’s not a framework, but it using JSON calls to get data and displays it with sorting and pagination. I haven’t actually implemented it yet, I’m going to read though the source code tonight to see how to do so–there’s very little documentation on the plugin, go figure. I’ll end up posting something on my blog once I do implement it.
Update: the laiguExtGridPlugin has been implemented, but it sits ontop of a Javascript library called ext. This library is massive, over 27 megs. That’s for the full library. The part that I use is around 100KB. I also use jQuery, so both of those libraries loading (which, thankfully, it’s only for one page) is quite unacceptable. I will be switch to a jQuery-base grid system.
I also found a commerically licensed jQuery plugin called jqGrid from Trirand. It’s a bit out of my price range at $599 for a one seat license with subscription, source, and priority support or $450 for just a license. However, it does look quite nice and reminds me very much of the newer Msoft Office UIs.
For now the former will do just fine; however, I am going to be looking around for a framework. I may just make one myself.