PHP Classes

My Query Report: Generate HTML reports from MySQL query results

Recommend this page to a friend!
  Info   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 42%Total: 2,573 All time: 1,487 This week: 488Up
Version License Categories
myqueryreport 1.0GNU General Publi...HTML, Databases


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: 122269 in India India
Week rank: 234 Up21 in India India Up

  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  
This week:0
All time:1,487
This week:488Up
 User Ratings  
 All time