Site Wide Message: (current site time 9/10/2010 9:55:58 AM EDT)
  • We want your input! One of our sponsors wants to know your opinion about development related issues. Click here to tell us what you think.
  • Are you an emerging/young developer (aged 18-30)? If so, would you like the chance to affect future developer tools and products?
    If so, then click here to give your feedback.
 

PHP Report Generator

Print
Email
winzip icon
Submitted on: 8/3/2004 1:38:05 AM
By: Hasin  
Level: Intermediate
User Rating: By 18 Users
Compatibility:PHP 4.0

Users have accessed this code  22076 times.
 
author picture
(About the author)
 
     phpReportGenerator is a PHP class which generates customizable report on any given MySQL query. You need to just pass the query as a resource id and then change the various look-n-feel parameter of your table like text color, header color, table border, size and many more. then finally call Generate Report. Thats all. This class will be very handy for rapid application development where you need not to point out details of writting table generation script, positioning and parsing. The class will do everything for you by default. Very Handy snippet. Hope you will vote for me. A usage.php file is included to demonstrate how to use this class.
 
winzip iconDownload code

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come out every day, so no prevention program can catch 100% of them. For your own safety, please:
  1. Re-scan downloaded files using your personal virus checker before using it.
  2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

If you don't have a virus scanner, you can get one at many places on the net including:McAfee.com

 
Terms of Agreement:   
By using this code, you agree to the following terms...   
  1. You may use this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
  2. You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.   
  3. You may link to this code from another website, but ONLY if it is not wrapped in a frame. 
  4. You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.


Other 5 submission(s) by this author

 

 
 Report Bad Submission
Use this form to notify us if this entry should be deleted (i.e contains no code, is a virus, etc.).
This submission should be removed because:
 
Your Vote!

What do you think of this code(in the Intermediate category)?
(The code with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor See Voting Log
 
Other User Comments
8/3/2004 2:01:43 AM

Very Handy, So Nice. It will really easy development phase.
(If this comment was disrespectful, please report it.)

 
8/3/2004 2:59:06 AM

Its really great. I was looking for such a utility for a long time. Thanks Hasin. Its great.
(If this comment was disrespectful, please report it.)

 
8/3/2004 2:59:44 AM

Keep up good working. Cool.
(If this comment was disrespectful, please report it.)

 
8/17/2004 7:33:38 AMHasin

I will update this class for multi font support very soon
--Hasin
(If this comment was disrespectful, please report it.)

 
9/17/2004 12:08:59 AMrgdelarosa

I get an error message.
User doesn't supply any valid mysql resource after executing query result
(If this comment was disrespectful, please report it.)

 
10/8/2004 5:56:56 PM

I too get the
(If this comment was disrespectful, please report it.)

 
10/8/2004 5:58:58 PM

I too get (I get an error message.
User doesn't
supply any valid mysql resource) after
executing query on a small table

when i use a much bigger table (8000+ rows) the report comes up.

strange

(If this comment was disrespectful, please report it.)

 
11/10/2004 2:56:47 AM

Hasin, I hvnt try this code yet. Am about to do so! Looking at the screenshot,I am convinced that this code rocks. Brilliant work! Thanks!
(If this comment was disrespectful, please report it.)

 
1/5/2005 10:34:19 PM

Good stuff, real easy to use. Thanks!
(If this comment was disrespectful, please report it.)

 
1/29/2005 2:15:57 PM

Your code had help me a lot in my project development.Thanks to u and all the developer of PHP.Good job guys
(If this comment was disrespectful, please report it.)

 
2/11/2005 2:27:26 PM

Not database independent. No grouping. Seen hundreds like this.
(If this comment was disrespectful, please report it.)

 
1/19/2006 3:44:32 AMhi from india

hi where are boss
in chennai
(If this comment was disrespectful, please report it.)

 
10/10/2006 1:56:03 AMUpdated

I've heavily updated this class to the point it only vaguely resembles the original class. if interested I'll pass on the updated class. It now uses stylesheets and strong use of class structures to work. Next would be to add graphical capabiliy.
(If this comment was disrespectful, please report it.)

 
10/10/2006 3:58:18 AMHasin

Hey, Of course we are interested. can you send me your code at hasin_at_somewherein_dot_net?

Thanks
Hasin
(If this comment was disrespectful, please report it.)

 
Add Your Feedback!

Note:Not only will your feedback be posted, but an email will be sent to the code's author from the email account you registered on the site, so you can correspond directly.

NOTICE: The author of this code has been kind enough to share it with you.  If you have a criticism, please state it politely or it will be deleted.

For feedback not related to this particular code, please click here.
 
To post feedback, first please login.