Tweet
<?php
require("../../inc/fpdf.php");
include("../../inc/db_data.inc.php");
class PDF extends FPDF
{
//Page header
function Header()
{
//Logo
$this->Image("lutra.png",10,8,20);
//Arial bold 15
$this->SetFont("Arial","",12);
//Move to the right
$this->Cell(80);
//Title
$this->Cell(50,10,"Lutra Pressedienst",0,0,"C");
//Line break
$this->Ln(20);
}
// Page body
function Table($sql)
{
$res = mysql_query($sql);
while($row = mysql_fetch_array($res))
{
$this->SetFont("Arial","",10);
$this->Cell(13,6,"Nr.:",0,0,"L");
$this->Cell(20,6,$row["Nummer"],0,0,"L");
$this->Ln(5);
$this->Cell(13,6,"Datum:",0,0,"L");
$this->Cell(20,6,$row["datum"],0,0,"L");
$this->Ln(20);
$this->SetFont("Arial","B",12);
$this->MultiCell($w[1],6,stripslashes($row["Titel"]),0,"C");
$this->SetFont("Arial","",12);
$this->MultiCell($w[1],6,stripslashes($row["Untertitel"]),0,"C");
$this->Ln(10);
$this->MultiCell($w[2],6,stripslashes(wordwrap($row["Meldung"],90,"\n",1)),0,"J");
}
}
// Page footer
function Footer()
{
//Position at 1.5 cm from bottom
$this->SetY(-15);
//Arial italic 8
$this->SetFont("Arial","I",8);
//Page number
$this->Cell(0,10,"Page ".$this->PageNo()."/{nb}",0,0,"C");
}
}
$pdf = new PDF();
$pdf->Open();
$pdf->AddPage();
$pdf->SetAuthor('Lutra Pressedienst');
$pdf->SetFont("Arial","",10);
$pdf->Table("SELECT *,DATE_FORMAT(Sperrfrist,'%d.%m.%Y')AS datum FROM presse WHERE Nummer='$show'");
$pdf->AliasNbPages();
$pdf->Output();
?>
Kommentar