<?php

      $host = "localhost";
      $user = "root";
      $pass = "rahasia";
      $dbnm = "project";
      $conn = mysql_connect($host, $user, $pass);
if ($conn) {
$open = mysql_select_db($dbnm);
if (!$open) {
die ("Database tidak dapat dibuka karena ".mysql_error());
}
} else {
die ("Server MySQL tidak terhubung karena ".mysql_error());
}
//akhir koneksi
#ambil data di tabel dan masukkan ke array
    $query  = "SELECT * FROM tenant ORDER BY kode";
    $sql    = mysql_query ($query);
    $data   = array();
    while ($row = mysql_fetch_assoc($sql)) {
array_push($data, $row);
}
#setting judul laporan dan header tabel
$judul = "Tenant";
$header = array(
array("label"=>"Code Tenant", "length"=>30, "align"=>"L"),
array("label"=>"Company Name", "length"=>50, "align"=>"L"),
array("label"=>"Corporate Name", "length"=>30, "align"=>"L"),
array("label"=>"Location", "length"=>50, "align"=>"L"),
array("label"=>"Room", "length"=>30, "align"=>"L"),
array("label"=>"Water", "length"=>50, "align"=>"L"),
array("label"=>"Telephone", "length"=>30, "align"=>"L"),
array("label"=>"Fax", "length"=>50, "align"=>"L"),
array("label"=>"Email", "length"=>80, "align"=>"L"),
array("label"=>"Website", "length"=>30, "align"=>"L")
);
#sertakan library FPDF dan bentuk objek
require_once ("fpdf/fpdf.php");
$pdf = new FPDF();
$pdf->AddPage();
#tampilkan judul laporan
$pdf->SetFont('Arial','B','16');
$pdf->Cell(0,20, $judul, '0', 1, 'C');
#buat header tabel
$pdf->SetFont('Arial','','10');
$pdf->SetFillColor(255,0,0);
$pdf->SetTextColor(255);
$pdf->SetDrawColor(128,0,0);
foreach ($header as $kolom) {
$pdf->Cell($kolom['length'], 5, $kolom['label'], 1, '0',
$kolom['align'], true);
}
$pdf->Ln();
#tampilkan data tabelnya
$pdf->SetFillColor(224,235,255);
$pdf->SetTextColor(0);
$pdf->SetFont('');
$fill=false;
foreach ($data as $baris) {
$i = 0;
foreach ($baris as $cell) {
$pdf->Cell($header[$i]['length'], 5, $cell, 1, '0',
$kolom['align'], $fill);
$i++;
}
$fill = !$fill;
$pdf->Ln();
}
#output file PDF
$pdf->Output();
?>