Example with PostgreSQL

This is a simple script example which issues a query to a PostgreSQL database and builds a table

Informations

Author: Ribamar FS
License: FPDF

Description

This is a simple script example which issues a query to a PostgreSQL database and builds a table with the result.

Source

<?php //Example FPDF script with PostgreSQL //Ribamar FS - ribafs@dnocs.gov.br require('fpdf.php'); $pdf=new FPDF(); $pdf->AddPage(); $pdf->SetTitle('Exemplo de Relatório em PDF via PHP'); //Set font and colors $pdf->SetFont('Arial', 'B', 16); $pdf->SetFillColor(255, 0, 0); $pdf->SetTextColor(255); $pdf->SetDrawColor(128, 0, 0); $pdf->SetLineWidth(.3); //Table header $pdf->Cell(20, 10, 'SIAPE', 1, 0, 'L', 1); $pdf->Cell(50, 10, 'Nome', 1, 1, 'L', 1); //Restore font and colors $pdf->SetFont('Arial', '', 10); $pdf->SetFillColor(224, 235, 255); $pdf->SetTextColor(0); //Connection and query $str_conexao='dbname=contabilidade port=5432 user=postgres password=postgres'; $conexao=pg_connect($str_conexao) or die('A conexão ao banco de dados falhou!'); $consulta=pg_exec($conexao, 'select * from conveniologin'); $numregs=pg_numrows($consulta); //Build table $fill=false; $i=0; while($i<$numregs) { $siape=pg_result($consulta, $i, 'siape'); $nome=pg_result($consulta, $i, 'nome'); $pdf->Cell(20, 10, $siape, 1, 0, 'R', $fill); $pdf->Cell(50, 10, $nome, 1, 1, 'L', $fill); $fill=!$fill; $i++; } //Add a rectangle, a line, a logo and some text $pdf->Rect(5, 5, 170, 80); $pdf->Line(5, 90, 90, 90); $pdf->Image('mouse.jpg', 185, 5, 10, 0, 'JPG', 'http://www.dnocs.gov.br'); $pdf->SetFillColor(224, 235); $pdf->SetFont('Arial', 'B', 8); $pdf->SetXY(5, 95); $pdf->Cell(170, 5, 'PDF gerado via PHP acessando banco de dados - Por Ribamar FS', 1, 1, 'L', 1, 'mailto:ribafs@dnocs.gov.br'); $pdf->Output(); ?>

Download

ZIP | TGZ

Quelle

http://www.fpdf.org/en/script/script11.php, zuletzt abgerufen 02.10.2016 00:46