有没有很好的与PHP MySQL兼容的报告框架? [英] Any good PHP MySQL-compatible reporting frameworks out there?

问题描述

我正在寻找一个基于Web的报告框架，该框架基于PHP并且可以与MySQL一起使用.

I'm looking for a web-based reporting framework which is PHP-based and works with MySQL.

这是我的问题(除了懒得自己编程外):我有一个很大的表(超过5万行)，用于存储多个客户端的日志数据.这些客户需要能够进行分类和搜索，并完成所有这些宏伟的事情.

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.

更新:laiguExtGridPlugin已实现，但位于名为

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.

我还从Trirand找到了一个商业许可的jQuery插件，名为 jqGrid .带有订阅，来源和优先支持的一个席位许可证的价格略高于我的价格范围，即599美元，而仅许可证的价格为450美元.但是，它看起来确实不错，并且使我想起了许多较新的Msoft Office UI.

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.

这篇关于有没有很好的与PHP MySQL兼容的报告框架?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！