Login   Register  
PHP Classes
elePHPant
Icontem

My Query Report: Generate HTML reports from MySQL query results

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2004-04-06 (10 years ago) RSS 2.0 feedStarStarStar 42%Total: 2,526 All time: 1,411 This week: 1,344Up
Version License Categories  
myqueryreport 1.0GNU General Public Lice...HTML, Databases
Description Author  

This is a simple class that can connect to a MySQL database, execute an SQL query, retrieve the result set rows and display it in a proper report format with different color flavors.

The class establishes a connection to MySQL and selects the named database. It executes the query using the query string passed. From the result set, the class extracts the number of rows, the number of columns, the names of each column in the result set. Using these and color theme passed as parameter, colorful reports are generated.

Picture of Simon Kuriakose
Name: Simon Kuriakose <contact>
Classes: 1 package by
Country: India India
Age: ???
All time rank: 112159 in India India
Week rank: 1779 Down122 in India India Down

  Files folder image Files  
File Role Description
Plain text file cls_myquery_report.php Class Class File
Accessible without login Plain text file demo_myquery_report.php Example demo script
Accessible without login HTML file doc_myquery_report.html Doc. doc
Accessible without login HTML file example_myquery_report.htm Output Sample HTML report

 Version Control Unique User Downloads Download Rankings  
 0%Total:2,526All time:1,411
 This week:0This week:1,344Up
 User Ratings  
 
 All time
Utility:50%StarStarStar
Consistency:54%StarStarStar
Documentation:58%StarStarStar
Examples:58%StarStarStar
Tests:-
Videos:-
Overall:42%StarStarStar
Rank:2086