ใช้ TCPDF ดึงข้อมูลจากเทเบิ้ล แต่หน้ารายงานไม่แสดงข้อมูล มีแต่หน้าขาวๆ

// -----------------------------------------------------------------------------
			mysql_connect("localhost", "root", "") or die("Error connecting to database: ".mysql_error());
			mysql_select_db("ims_db") or die(mysql_error());
			$sql_show = "select * from ims_inventory";
			$result_show = mysql_query($sql_show) or die(mysql_error());

			
$tbl = '
<table cellpadding="2" cellspacing="2" >
	<tr style="background-color:#666666;color:#FFFFFF;font-size:1.5em;" align = "center">
		<th colspan="9" >ASSET LIST</th>
	</tr>
	<tr style="background-color:#999999;color:#ffffff;font-size:1em; font-weight: bold;" align = "center">
		<th>Code</th>
		<th>Name</th>
		<th>Acc. Code</th>
		<th>P/O No.</th>
		<th>Brand</th>
		<th>Model</th>
		<th>Type</th>
		<th>Price</th>
		<th>Status</th>  
	</tr>';
	
		while($row_show = mysql_fetch_array($result_show))
			{
				/*$Code = $row_show['invent_code'];
				$Name = $row_show['invent_name'];
				$AccCode = $row_show['account_code'];
				$PONo = $row_show['po_number'];
				$Brand = $row_show['invent_brand'];
				$Model = $row_show['invent_model'];
				$Type = $row_show['typeName'];
				$Price = $row_show['invent_prize'];
				$Status = $row_show['invent_status'];				
			} */
	
	
$tbl.='	
    <tr style="background-color:#ffffcc;color:#000000;font-size:1em;">
        <th>'.$row_show['invent_code'].'</th>
        <th>'.$row_show['invent_name'].'</th>
        <th>'.$row_show['account_code'].'</th>
		<th>'.$row_show['po_number'].'</th>
		<th>'.$row_show['invent_brand'].'</th>
        <th>'.$row_show['invent_model'].'</th>
        <th>'.$row_show['typeName'].'</th>
		<th>'.$row_show['invent_prize'].'</th>
		<th>'.$row_show['invent_status'].'</th>
    </tr>';
}

$tbl.='</table>'; //+
	
$pdf->writeHTML($tbl, true, false, false, false, '');

// -----------------------------------------------------------------------------
			mysql_connect("localhost", "root", "") or die("Error connecting to database: ".mysql_error());
			mysql_select_db("ims_db") or die(mysql_error());
			
$tbl = '
<table cellpadding="2" cellspacing="2" >
	<tr style="background-color:#666666;color:#FFFFFF;font-size:1.5em;" align = "center">
		<th colspan="9" >ASSET LIST</th>
	</tr>
	<tr style="background-color:#999999;color:#ffffff;font-size:1em; font-weight: bold;" align = "center">
		<td>Code</td>
		<td>Name</td>
		<td>Acc. Code</td>
		<td>P/O No.</td>
		<td>Brand</td>
		<td>Model</td>
		<td>Type</td>
		<td>Price</td>
		<td>Status</td>  
	</tr>';
		
	
		$sql_show = "select * from ims_inventory";
		$result_show = mysql_query($sql_show) or die(mysql_error());
		while($row_show = mysql_fetch_array($result_show))
			{
				
				$tbl2='	
						<tr style="background-color:#ffffcc;color:#000000;font-size:1em;">
							<td>'.$row_show['invent_code'].'</td>
							<td>'.$row_show['invent_name'].'</td>
							<td>'.$row_show['account_code'].'</td>
							<td>'.$row_show['po_number'].'</td>
							<td>'.$row_show['invent_brand'].'</td>
							<td>'.$row_show['invent_model'].'</td>
							<td>'.$row_show['typeName'].'</td>
							<td>'.$row_show['invent_prize'].'</td>
							<td>'.$row_show['invent_status'].'</td>
						</tr>'; 
			}

$tbl3='</table>';
	
$pdf->writeHTML($tbl.$tbl2.$tbl3, true, false, false, false, '');
	
// -----------------------------------------------------------------------------

<?php
require_once('../tcpdf.php');

$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);	

// remove default header/footer
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);

// set font
$pdf->SetFont('angsanaupc', '', 13);

// add a page
$pdf->AddPage();

// -----------------------------------------------------------------------------
		//mysql_connect("localhost", "root", "") or die("Error connecting to database: ".mysql_error());
		//mysql_select_db("ims_db") or die(mysql_error());
			
$tbl = '
<table cellpadding="2" cellspacing="2" >
	<tr style="background-color:#666666;color:#FFFFFF;font-size:1.5em;" align = "center">
		<th colspan="9" >ASSET LIST</th>
	</tr>
	<tr style="background-color:#999999;color:#ffffff;font-size:1em; font-weight: bold;" align = "center">
		<td>Code</td>
		<td>Name</td>
		<td>Acc. Code</td>
		<td>P/O No.</td>
		<td>Brand</td>
		<td>Model</td>
		<td>Type</td>
		<td>Price</td>
		<td>Status</td>  
	</tr>';
		
	
		//$sql_show = "select * from ims_inventory";
		//$result_show = mysql_query($sql_show) or die(mysql_error());
		//while($row_show = mysql_fetch_array($result_show))
			//{
			for($i=0; $i<6; $i++){	
				$tbl.='	
						<tr style="background-color:#ffffcc;color:#000000;font-size:1em;">
							<td>invent_code'.$i.'</td>
							<td>invent_name'.$i.'</td>
							<td>account_code'.$i.'</td>
							<td>po_number'.$i.'</td>
							<td>invent_brand'.$i.'</td>
							<td>invent_model'.$i.'</td>
							<td>typeName'.$i.'</td>
							<td>invent_prize'.$i.'</td>
							<td>invent_status'.$i.'</td>
						</tr>'; 
			}

$tbl.='</table>';

// output the HTML content
$pdf->writeHTML($tbl, true, false, true, false, '');

//Close and output PDF document
$pdf->Output('example_test.pdf', 'I');
	
// -----------------------------------------------------------------------------