如何在TCPDF中使用PHP脚本?

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

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