I have a table in Database like this
我在数据库中有一个这样的表
expedition_name | Phone | CP |
__________________________________________
Starsindo | 09890 | John |
Iron Bird | 09891 | Gina |
MSA Cargo | 09890 | John |
Now I will create the PDF from that table with TCPDF using HTML function.
现在,我将使用HTML函数用TCPDF从该表创建PDF。
But I Still confuses how to combine that my code like this
但我还是搞不懂如何像这样组合代码
<?php
require_once('tcpdf/config/lang/eng.php');
require_once('tcpdf/tcpdf.php');
// create new PDF document
include "koneksi.php";
$sql = "SELECT * FROM tb_exp_local";
$hasil = mysql_query($sql);
$data = mysql_fetch_array($hasil);
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// set font
$pdf->SetFont('times', '', 11);
// add a page
$pdf->AddPage();
$html = '<h2>List Of Expediton</h2> //Title
<table border="1" cellspacing="3" cellpadding="4">
<tr>
<th>Expedition</th> //head of column name
<th align="center">Phoine</th> //head of column name
<th align="center">CP</th> //head of column name
</tr>
while($data=mysql_fetch_array($hasil))
{
<tr>
<td>$data[nama_exp]</td>
</tr>
}
</table>';
$pdf->writeHTML($html, true, false, true, false, '');
$pdf->Output('Local Expedition, 'I');
?>
Can Anyone help me, How to fix it? and the data can be write in PDF?
谁能帮我一个忙吗?数据可以写成PDF格式吗?
1 个解决方案
#1
7
you need to prepare your html with something like:
您需要用以下内容准备html:
$html = '<h2>List Of Expediton</h2> //Title
<table border="1" cellspacing="3" cellpadding="4">
<tr>
<th>Expedition</th> //head of column name
<th align="center">Phoine</th> //head of column name
<th align="center">CP</th> //head of column name
</tr>';
while($data=mysql_fetch_array($hasil)) {
$html .= '<tr><td>'.$data['nama_exp'].'</td></tr>';
}
$html .= '</table>';
#1
7
you need to prepare your html with something like:
您需要用以下内容准备html:
$html = '<h2>List Of Expediton</h2> //Title
<table border="1" cellspacing="3" cellpadding="4">
<tr>
<th>Expedition</th> //head of column name
<th align="center">Phoine</th> //head of column name
<th align="center">CP</th> //head of column name
</tr>';
while($data=mysql_fetch_array($hasil)) {
$html .= '<tr><td>'.$data['nama_exp'].'</td></tr>';
}
$html .= '</table>';