PHP Classes

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

Recommend this page to a friend!
     
  Info   Example   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 42%Total: 7,802 All time: 226 This week: 67Up
Version License PHP version Categories
sql2pdfreport 1.0.1GNU General Publi...4Databases, Files and Folders, Web ser...
Description 

Author

Rupom Razzaque

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.

Picture of Rupom Razzaque
  Performance   Level  
Name: Rupom Razzaque <contact>
Classes: 12 packages by
Country: Bangladesh Bangladesh

Level 1 Star

 Innovation award
Innovation award
Nominee: 1x

Winner: 1x

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

Example

<?php
/**
* SQL2PDFReport Generator Class
*
* @author : MA Razzaque Rupom <rupom_315@yahoo.com>, <rupom.bd@gmail.com>
* Moderator, phpResource Group(http://groups.yahoo.com/group/phpresource/)
* URL: http://www.rupom.info
* @version : 1.0
* @date 06/05/2006 (modified on 06/23/2006)
* Purpose : Generating Pdf Report from SQL Query
*/

require_once('Sql2PdfReport.class.php');

//make sure the DB connection is ok
mysql_connect('localhost','root','');
mysql_select_db('test');

//queries whose output will be used as report data
$query_1 = "SELECT * FROM book";
$query_2 = "SELECT title,author FROM book";
$query_3 = "SELECT book_id,publisher,reader FROM book";

$obj = new Sql2PdfReport();

//sets absolute path where temporary report HTML file will be saved (should be under doc_root so that its URL can be set)
$obj->setHtmlPath("/projects/rupom/phpclasses/sql2pdfreport/first_test.html"); //change this according to your Path

//sets URL of the temporary report HTML file
$obj->setHtmlUrl("http://localhost/phpclasses/sql2pdfreport/first_test.html");//change this according to your URL

//inits row colors. colors will be repeated automatically
$obj->initRowColors(array('#336699','#f5f5f5'));

//generates report from $query_1
$obj->generateReport($query_1);

//changes row colors for the second report.
$obj->initRowColors(array('#f8f8f8','#336699','#353535'));

//generates report from $query_2 and appends it to previous report data
$obj->generateReport($query_2);

//generates report from $query_3 and appends it to previous report data
$obj->generateReport($query_3);

//pdf version
$pdfVersion = '1.4'; //change it according to your need
/*
$pdfVersion = 1.3 for Acrobat Reader 4
$pdfVersion = 1.4 for Acrobat Reader 5
$pdfVersion = 1.5 for Acrobat Reader 6
*/

//sets PDF version
$obj->setPdfVersion($pdfVersion);

//gets the pdf report of all the report data
$obj->getPdfReport();
?>

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 (1)  
  • screenshot.jpg
  Files folder image Files (5)  
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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadsql2pdfreport-2006-06-23.zip 44KB
Downloadsql2pdfreport-2006-06-23.tar.gz 44KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:7,802
This week:0
All time:226
This week:67Up
User Ratings User Comments (1)
 All time
Utility:61%StarStarStarStar
Consistency:61%StarStarStarStar
Documentation:-
Examples:61%StarStarStarStar
Tests:-
Videos:-
Overall:42%StarStarStar
Rank:3633
 
thanks
12 years ago (Leon Nguyen)		70%StarStarStarStar
 

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.


  Pages that reference this package  
i am the top downloaded author for this week at phpclasses.org...
If you are looking for creating PDF output of your HTML pages, you can do it using PHP’s PDFlib module....

Latest pages that reference packages Latest pages that reference packages