CODEWITHSUNDEEP
phpmysqlreporting
Eray
Eray

Reputation: 7128

MySql Reporting System with Basic Interface

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.

Upvotes: 2

Views: 2383

Answers (3)

Abdel Rahman Karim
Abdel Rahman Karim

Reputation: 114

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

Upvotes: 2

hankry
hankry

Reputation: 37

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.

Upvotes: -1

Pekka
Pekka

Reputation: 449395

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.

Upvotes: 1

Related Questions