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.
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?
It's just a regular HTML <script> tag that calls a PHP file instead of a JavaScript file. But there's one catch: In that PHP file, you still have to use JavaScript.
you need to prepare your html with something like:
$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>';
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With