How to use PHP script in TCPDF?

Question

I have a table in a database like this

expedition_name | Phone | CP | __________________________________________ Starsindo | 09890 | John | Iron Bird | 09891 | Gina | MSA Cargo | 09890 | John | 

Now I will create a PDF from this table using TCPDF using the HTML function.

But I'm still embarrassed how to combine this with 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 someone help me how to fix this? and data can be written in pdf?

Answer 1

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>';