Example with MS Access

This is an example how to generate a PDF file from an MS Access database

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

Quelle

http://www.fpdf.org/en/script/script22.php, zuletzt abgerufen 02.10.2016 02:11