MySQL database export to pdf using PHP

 
To export whole database or whole table content we can use phpMyAdmin Export option but if you want to export some rows or any query result then we should perform some other way.
 
To create PDF file we should first download the FPDF Library – Click Here.
 
Copy the following code and create a new PHP file called exportpdf.php and paste the content into it or download the file – Click Here
 
Sample Output

Export PDF

Sample Code
 
<?php
require('fpdf.php');
$d=date('d_m_Y');
 

 
class PDF extends FPDF
{
 
function Header()
{
    //Logo
$name="Testing PDF Creation";
    $this->SetFont('Arial','B',15);
    //Move to the right
    $this->Cell(80);
    //Title
    $this->Cell(20,40,"Data Generated For $name on ".date('d-m-Y'),0,0,'C');
$this->SetFont('Arial','B',9);
$this->Cell(10,60,"Test Place 1",0,0,'C');
$this->Cell(-10,70,"Test Place 2",0,0,'C');
    //Line break
    $this->Ln(20);
}
 
//Page footer
function Footer()
{
   
}
 
//Load data
function LoadData($file)
{
//Read file lines
$lines=file($file);
$data=array();
foreach($lines as $line)
$data[]=explode(';',chop($line));
return $data;
}
 
//Simple table
function BasicTable($header,$data)
 
$this->SetFillColor(255,0,0);
$this->SetDrawColor(128,0,0);
$w=array(30,15,20,10,10,10,10,10,15,15,15,15,15);
 
//Header
for($i=0;$i<count($header);$i++)
$this->Cell($w[$i],7,$header[$i],1,0,'C',true);
$this->Ln();
//Data
foreach ($data as $eachResult) 
{ //width
$this->Cell(30,6,$eachResult["bookstall_id"],1);
$this->Cell(15,6,$eachResult["name"],1);
$this->Cell(20,6,$eachResult["location"],1);
$this->Cell(10,6,$eachResult["address"],1);
$this->Cell(10,6,$eachResult["telephone"],1);
$this->Ln();
 
}
}
 
//Better table
}
 
$pdf=new PDF();
$header=array('Name','Date','Transaction Data','Failed Trasactions','Banks Transffered');
//Data loading
//*** Load MySQL Data ***//
$objConnect = mysql_connect("localhost","databaseuser","databasepassword") or die("Error:Please check your database username & password");
$objDB = mysql_select_db("databasename");
$strSQL = "SELECT bookstall_id, name, location, address, telephone FROM bookstall";
$objQuery = mysql_query($strSQL);
$resultData = array();
for ($i=0;$i<mysql_num_rows($objQuery);$i++) {
$result = mysql_fetch_array($objQuery);
array_push($resultData,$result);
}
//************************//
 
 
function forme()
 
{
$d=date('d_m_Y');
echo "PDF generated successfully. To download document click on the link >> <a href=".$d.".pdf>DOWNLOAD</a>";
}
 
 
$pdf->SetFont('Arial','',6);
 
//*** Table 1 ***//
$pdf->AddPage();
$pdf->Image('mylogo.jpg',80,8,33);
$pdf->Ln(35);
$pdf->BasicTable($header,$resultData);
forme();
$pdf->Output("$d.pdf","F");
 
?>


You can leave a response, or trackback from your own site.

Leave a Reply