How to create reports in PHP Application

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
anupkeskar
Forum Newbie
Posts: 1
Joined: Wed Feb 17, 2010 7:12 am

How to create reports in PHP Application

Post by anupkeskar »

I have developed a Material Request Web application using PHP And MySQL.
Now i want to create various reports, Stock, In, Out Etc.

Is there any tool or method through which i can create web based reports to my application?

Please Help.

Thanks And Regards,
-Anup.
User avatar
emmbec
Forum Contributor
Posts: 112
Joined: Thu Sep 21, 2006 12:19 pm
Location: Queretaro, Mexico

Re: How to create reports in PHP Application

Post by emmbec »

Take a look at Jasper Reports if you don't need to have the reports embedded into the website, or use OpenFlash Charts to create your reports, they are really nice 8)
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Re: How to create reports in PHP Application

Post by pickle »

Moved thread.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: How to create reports in PHP Application

Post by josh »

http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html RTFM (not that you didn't, I just like saying that!). Pay particular attention to the functions on this page though ;-) like SUM and COUNT and MAX, MIN, AVG.

Also I wrote a tool that deals with the problem of having to SUM *billions* of rows. It uses an algorithm to make that a little faster. http://code.google.com/p/socks/

I would recommend just learning the mysql functions to start with. If you are looking to deal with scaling issues I would look into the stuff I am researching.
Post Reply