PHP Classes
elePHPant
Icontem

SQL 2 PDF Report: Generate PDF documents from MySQL query results

Recommend this page to a friend!
  Info   View files Example   Screenshots Screenshots   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2006-06-23 (10 years ago) RSS 2.0 feedStarStarStar 43%Total: 7,716 This week: 1All time: 219 This week: 745Down
Version License PHP version Categories
sql2pdfreport 1.0.1GNU General Publi...4Databases, Files and Folders, Web ser...
Description Author

This class can be used to generate a PDF document from the results of MySQL database queries.

The class can execute one or more given queries and generate dump the results as HTML tables to a temporary page file.

The PDF document is generated by calling a remote Web service that fetches the generated HTML page and convert it to the PDF format.

Recommendations

What is the best PHP class to create PDF table from SQL results
Create query results table in PDF

What is the best PHP mysql to pdf class?
Export MySQL query results to pdf or excel

PHP page to PDF
Output PHP page to pdf

What is the best PHP print to pdf class?
I want to generate PDF print outs from a MySQL application

  Performance   Level  
Name: Rupom Razzaque is available for providing paid consulting. Contact Rupom Razzaque .
Classes: 12 packages by
Country: Bangladesh Bangladesh
Age: 35
All time rank: 161 in Bangladesh Bangladesh
Week rank: 399 Down13 in Bangladesh Bangladesh Down
Innovation award
Innovation award
Nominee: 1x

Winner: 1x

Details

Class: Sql2PdfReport

This class generates PDF Report from SQL query.

Here's how it works:

  • Executes given query and generates HTML report first
  • Appends query reports to previous report(if any)
  • Creates a temporary HTML file and store that as HTML report
  • Creates PDF report for that HTML report by using remote application

For Remote PDF Application, I have used html2ps and html2pdf (supplied by http://www.tufat.com/script19.htm). It is 100% FREE for commercial AND non-commercial use! It renders pages as PDF documents and PostScript files. I have deployed this application to phpResource(http://groups.yahoo.com/group/phpresource/) group's server for easy and reliable access. My special thanks goes to phpResource group.

And Me: I am a hardcore C/C++ and PHP programmer. I enjoy my times in implementing varities of freelancing works.

Please rate this class if you like and if it comes to your needs. Please feel free to contact me for any suggestion and/or further assistance regarding the technique and its implementation.

MA Razzaque Rupom Moderator, phpResource Group http://groups.yahoo.com/group/phpresource/ My Blog : http://www.rupom.info Emails: rupom_315@yahoo.com rupom.bd@gmail.com

Screenshots  
  • screenshot.jpg
  Files folder image Files  
File Role Description
Accessible without login Plain text file book.sql Data Example SQL File
Accessible without login Plain text file ReadMe.txt Data Documentation
Plain text file Sql2PdfReport.class.php Class Sql2PdfReport Class
Accessible without login Plain text file usage.php Example Example Usage

 Version Control Unique User Downloads Download Rankings  
 0%
Total:7,716
This week:1
All time:219
This week:745Down
User Ratings User Comments (1)
 All time
Utility:62%StarStarStarStar
Consistency:62%StarStarStarStar
Documentation:-
Examples:62%StarStarStarStar
Tests:-
Videos:-
Overall:43%StarStarStar
Rank:2570
 
thanks
4 years ago (Leon Nguyen)
70%StarStarStarStar