使用mpdf创建动态发票单 [英] create dynamic invoice bill using mpdf
问题描述
MPDF
$html='
<body>
<div id="page">
<div id="logo">
<a href="http://www.danifer.com/"><img src="./HTML Invoice Template_files/invoice_logo.jpg"></a>
</div><!--end logo-->
<div id="address">
<p><strong>'.$company.'</strong><br>
<a href="mailto:'.$dbobj->getAdminEmail().'">'.$dbobj->getAdminEmail().'</a>
<br><br>
Transaction # xxx<br>
Created on 2008-10-09<br>
</p>
</div><!--end address-->
<div id="content">
<p>
<strong>Customer Details</strong><br>
Name: '.$dbobj->UserFullName().'<br>
Email: '.$dbobj->UserEmail().'<br>
Contact: '.$dbobj->UserContact().'<br>
Payment Type: MasterCard </p>
<hr>
<table>
<tbody>
<tr>
<td><strong>Description</strong></td>
<td><strong>Qty</strong></td>
<td><strong>Unit Price</strong></td>
<td><strong>Amount</strong></td>
</tr>
<tr class="odd">
<td>Product 1</td>
<td>1</td>
<td>Rs 1495.00</td>
<td>Rs 1495.00</td>
</tr>
<tr class="even">
<td>Product 2</td>
<td>1</td>
<td>Rs 1495.00</td>
<td>Rs 1495.00</td>
</tr>
<tr class="odd">
<td>Product 3</td>
<td>1</td>
<td>Rs 1495.00</td>
<td>Rs 1495.00</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><strong>Total</strong></td>
<td><strong>Rs 24485.00</strong></td>
</tr>
</tbody></table>
<hr>
<p>
Thank you for your order.<br>
If you have any questions, please feel free to contact us at <a href="mailto:'.$dbobj->getAdminEmail().'">'.$dbobj->getAdminEmail().'</a>.
</p>
<hr>
<p>
</p><center><small>This communication is for the exclusive use of the addressee and may contain proprietary, confidential or privileged information. If you are not the intended recipient any use, copying, disclosure, dissemination or distribution is strictly prohibited.
<br><br>
© '.$dbobj->sitename.' All Rights Reserved
</small></center>
<p></p>
</div><!--end content-->
</div>
</body>;
，请问我已经在网站中嵌入了mpdf lib.
现在，我想为发票生成动态pdf.
如何为$ html变量建立动态表?那么我应该将其传递给WriteHTML()
$mpdf->WriteHTML($html);
然后我将调用$ mpdf-> Output('downloads/application.pdf'，'F');下载pdf
Then i will call $mpdf->Output('downloads/application.pdf','F'); to download pdf
SQL PART
select desc,qty,price,total from orders where productid=1
PHP PART
$mpdf=new mPDF();
$mpdf->SetDisplayMode('fullpage');
$mpdf->WriteHTML($html);
$mpdf->Output('downloads/application.pdf','F');
我正在使用mysql
推荐答案
我只有我的手机来写这个，所以代码可能并不完美.
I just have my cellphone to write this, so the code may be no perfect.
使用foreach循环遍历查询结果以构造$ htmlRows字符串.您没有向我们展示您要查询的php命令和结果变量.因此，我假设$ rows为记录数组.
Use a foreach loop to iterate over your query results to construct a $htmlRows string. You didn't show us your php command to query and the result variable. So I assume $rows as an array of records.
$htmlRows = "";
foreach($rows as $row) {
$htmlRows .= "
</tr>
<tr class="even">
<td>".$row->desc."</td>
<td>".$row->qty."</td>
<td>Rs ".$row->price."</td>
<td>Rs ".$row->total."</td>
</tr>
";
}
在生成$ html之前执行此循环.
Do this loop before you generate $html.
然后，当您将代码附加到$ html时，只需将所有非动态行替换为
Then when you assing the code to $html just replace all the non dynamic rows by
$html = " ....
.....</tr>"
. $htmlRows
. "<tr>...."
;
这篇关于使用mpdf创建动态发票单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
