PHP/MySQL reporting library [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 7 years ago.

开发者_如何学编程 Improve this question

Is there a known good reporting library? Before I go making my own, I was wondering if anyone who has come up with a solution I can adapt to? Basically, I have a bunch of MySQL queries that I need to "report" on. So, my in-house solution would basically be a bunch of mysql queries that need to be run through a drop down or reporting style menu and they would run the queries requested and build a little report of whatever sql query that was run. Is there something out there that already does THIS, or should I just build something in-house?

---

Take a look at phpreports. It sounds like what you are looking for.

---

Pentaho Reporting, Jasper Reports, or Eclipse BIRT can all work with MySQL. I haven't seen any PHP based reporting libraries out there. So, you can just set up one of those applications and have it communicate with your database to allow for reporting.

If you are just looking build table output from MySQL statments, try this example from jqGrid: http://www.trirand.com/blog/phpjqgrid/examples/loading_data/array_data/default.php#PHPCode

---

Please take a look at Windward Reports. With Windward you design the reports in Microsoft Word, Excel, or PowerPoint - so no learning curve and you can design reports that Crystal, SSRS, etc. can't even dream about. (Disclaimier - I'm the CTO at Windward.)

We have a large number of customers who use MySql for the datasource. And we have a PHP wrapper to call our Java engine.

thanks - dave

---

If you want something simple but effective try my PHP MySQL Reporter Script - https://jellyhound.co.uk/mysql-email-reports/ - it's extremely basic but very effective, I've had over 500 sales and pages of feedback and questions.

UPDATE: THIS IS NOW FREE

It is packaged as a simple way to generate MYSQL reports by email but is used as an effective report generator by a lot of my users.

It includes CSV and PDF attachments and can easily be scheduled using cron or any operating systems scheduling software.

---

I use two reporting engines for converting SQL quires to reports, I think any of them could meet your needs :

Smart Report maker : this one supports creating MySQL reports based on SQL quires , views, and tables

MYDBR : This one supports building reports based on stored procedures

---

I was going to vote to close this as an exact duplicate of a question which has been asked many,many times here. But the previous answers are not great.

Christopher's answer mentions 4 good products. I'd also suggest looking at Agata, phplens, Crystal reports.

I'm surprised nobody has mentioned MSAccess - it has a lot of nice functionality for developing reports, but, IME, managing the software is a major PITA, and there's little scope for scheduling / integration.