How to use the PHP script in TCPDF?

html, php, tcpdf

Solution

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

Problem

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?

Original source