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.
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.