MySql Reporting System with Basic Interface

Question

We need a MySQL reporting / monitoring system. Our end-users want to see some informations from databases. They need read-only access permission. We don't want to use PhpMyAdmin because PHPMYADMIN's interface is a little complicated for our end-users. (They don't know SQL or other programming languages)

Because of this we need more basic interface. User's can select columns which what to see, and order them according to they want.

For example there will be a table, users can columns and order datas. Datas will come from our database.

If they are end-users, what exactly do you need them to monitor? Can you describe your requirements more closely? This might be easiest to solve through a simple custom PHP script though — Pekka
– Pekka, Commented May 29, 2011 at 16:55
Actually, our managers want to check database, for example they want to list our customers etc. etc. . But they can't use PHPMYADMIN . Because of this we need more more more basically interface :) We don't want to lost time for writing a script for this :) In shortly, we need an script which list datas like a table from database and filtering it easily. If there is any script related with this, we can improve it :) — Eray
– Eray, Commented May 29, 2011 at 16:58

karim kamal · Accepted Answer · 2022-07-03 19:58:58Z

2

Try the following reporting tools :

Smart Report Maker: very easy to install and use can do precisely the features you mentioned (i.e., select specific columns, tables, filters, ..etc.) in addition to many advanced features.
Report Engine: A new PHP reporting framework, that will help you add the reporting capabilities you need to your project.
Reportico: a web reporting tool with a very easy to use wizard-style interface

edited Jul 3, 2022 at 19:58

karim kamal

526 bronze badges

answered Dec 6, 2015 at 2:35

Abdel Rahman Karim

11410 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pekka · Accepted Answer · 2011-05-29 18:18:10Z

1

I'm sure there is a PHP script somewhere that does what you need, but in my experience, trying them all out, customizing them and fixing crappy code can easily cost more time than writing it yourself. But maybe you get lucky, and somebody knows something. Other than that, I guess you'll just have to browse the net.

One unorthodox idea that comes to mind is Microsoft Access. It's relatively easy to build a reporting application in it (including filters and such); connecting to a MySQL database is easy through the ODBC connector.

It wouldn't be completely out of the box, though, and of course it wouldn't run in the browser, so it may not be the right thing.

edited May 29, 2011 at 18:18

answered May 29, 2011 at 17:29

Pekka

451k150 gold badges989 silver badges1.1k bronze badges

Comments

hankry · Accepted Answer · 2011-05-29 19:48:50Z

-1

Since you tagged php, here is a tutorial:

http://www.freewebmasterhelp.com/tutorials/phpmysql/

As for finding an existing script, it will probably be quicker and easier to write your own.

answered May 29, 2011 at 19:48

hankry

376 bronze badges

Collectives™ on Stack Overflow

MySql Reporting System with Basic Interface

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related