MySQL Export to PDF...คือข้อมูลในฐานข้อมูลผมยาวมากครับ พอ export เป็น PDF ปรากฎว่า

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

class PDF extends FPDF_Thai
{

//Load data
function LoadData($file)
{
	//Read file lines
	$lines=file($file);
	$data=array();
	foreach($lines as $line)
		$data[]=explode(';',chop($line));
	return $data;
}


//Simple table
function BasicTable($header,$data)
{
	//Header
	$w=array(30,160);
	//Header
	for($i=0;$i<count($header);$i++)
		$this->Cell($w[$i],7,$header[$i],1,0,'C');
	$this->Ln();
	//Data
	foreach ($data as $eachResult) 
	{
		$this->Cell(30,6,$eachResult["dec_id"],1,0,'C');
		$this->Cell(160,6,$eachResult["dec_name"],1);
		$this->Ln();
	}
}
}

$pdf=new PDF();
//Column titles
$header=array('รหัสโรค','ชื่อโรค');
//Data loading

//*** Load MySQL Data ***//
include ("../connect.php");

$strSQL = "SELECT * FROM tb_decide";
mysql_query("SET NAMES tis620");
$objQuery = mysql_query($strSQL);
$resultData = array();
for ($i=0;$i<mysql_num_rows($objQuery);$i++) {
	$result = mysql_fetch_array($objQuery);
	array_push($resultData,$result);
}
//************************//


$pdf->AddFont ( 'AngsanaNew', '', 'angsa.php' );
$pdf->AddFont ( 'AngsanaNew', 'B', 'angsab.php' );
$pdf->AddFont ( 'LilyUPC', '', 'upcll.php' );
$pdf->AddFont ( 'LilyUPC', 'B', 'upclb.php' );
$pdf->SetFont ( 'AngsanaNew', '', 14);



//*** Table 1 ***//
$pdf->AddPage();
//$pdf->Image('logo.png',80,8,33);
$pdf->Ln(5);
$pdf->BasicTable($header,$resultData);



$pdf->Output("../MyPDF/MyPDF.pdf","F");
?>