Example with MS Access

Add-On Example with MS Access

Informations

Author: Goldboy
License: FPDF

Description

This is an example how to generate a PDF file from an MS Access database through ODBC.
It requires to setup the data source name 'COFFEE' first.

Source

<?php
require('fpdf.php');

class PDF extends FPDF
{
function Table($sql, $col)
{
    global $conn;

    //Query
    $res=odbc_do($conn, $sql);
    if(!$res)
        die('SQL error');

    //Header
    $this->SetFillColor(255, 0, 0);
    $this->SetTextColor(255);
    $this->SetDrawColor(128, 0, 0);
    $this->SetLineWidth(.3);
    $this->SetFont('', 'B');
    $tw=0;
    foreach($col as $label=>$width)
    {
        $tw+=$width;
        $this->Cell($width, 7, $label, 1, 0, 'C', 1);
    }
    $this->Ln();

    //Rows
    $this->SetFillColor(224, 235, 255);
    $this->SetTextColor(0);
    $this->SetFont('');
    $fill=false;
    while(odbc_fetch_row($res))
    {
        foreach($col as $field=>$width)
            $this->Cell($width, 6, odbc_result($res, $field), 'LR', 0, 'L', $fill);
        $this->Ln();
        $fill=!$fill;
    }
    $this->Cell($tw, 0, '', 'T');
}
}
?>

Example

<?php
require('access.php');

$conn=odbc_connect('COFFEE', '', '');
if(!$conn)
    die('Connection failed');
$pdf=new PDF();
$pdf->AddPage();
$pdf->SetFont('Arial', '', 14);
$sql='SELECT COFFEE_NAME, ROAST_TYPE, QUANTITY FROM COFFEE_INVENTORY ORDER BY QUANTITY DESC';
$col=array('COFFEE_NAME'=>50, 'ROAST_TYPE'=>40, 'QUANTITY'=>100);
$pdf->Table($sql, $col);
$pdf->Output();
?>

View the result here.

Download

ZIP | TGZ