duanqiao3608 2017-06-23 14:38
浏览 30

FPDF和LOOP WHILE

i have a problem I want to display for each result the pdf I want, if I have 8 result, I want 8 separate pdf page. Except that I have blank page doesn't work

here is my code.

    <?php
    require('fpdf/fpdf.php');

    class PDF extends FPDF
    {

    // En-tête
    function Header()
    {
$level  = $_GET['level'];
        $level_id = $_GET['level_id'];

        include('db_connect.php');
        $requette   =   $bdd->query('   SELECT spare_parts_sn.id,spare_parts_sn.SN,spare_parts_item.description,spare_parts_item.name,level_'.$level.'.completName AS place
                                        FROM spare_parts_item,spare_parts_sn,level_'.$level.'
                                        WHERE spare_parts_sn.spare_parts_item_id = spare_parts_item.id
                                        AND spare_parts_sn.level = '.$level.'
                                        AND spare_parts_sn.level_id = '.$level_id.'
                                        AND level_'.$level.'.id = '.$level_id.'
                                        ORDER BY spare_parts_item.name ASC');

        while ($donnees =$requette->fetch()){

            $this->SetFont('Arial','',6);
            $this->Cell(34,2,''.$donnees['description'].'');
            $this->Ln(3);
            $this->Cell(6,2,''.$donnees['name'].'');
            $this->Cell(15);
            $this->Cell(15,2,''.$donnees['place'].'');
            $this->Ln(3);
            $this->Cell(4,2,'S/N : ');$this->Cell(1);$this->Cell(10,2,''.$donnees['SN'].'') ;   
            $this->Ln(3);
            $this->Cell(5,2,'ID   : ');$this->Cell(10,2,''.$donnees['id'].'');

            // $this->Image('img/'.$donnees['id'].'.png',0,16,24);

        }
     }
}
$pdf = new PDF('L','mm',array(38,24));
$pdf->SetLeftMargin(1);
$pdf->SetRightMargin(1);
$pdf->SetTopMargin(4);
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times','',7);
$pdf->Output();

Thanks for you help Any Ideas ?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 flink cdc无法实时同步mysql数据
    • ¥100 有人会搭建GPT-J-6B框架吗?有偿
    • ¥15 求差集那个函数有问题,有无佬可以解决
    • ¥15 【提问】基于Invest的水源涵养
    • ¥20 微信网友居然可以通过vx号找到我绑的手机号
    • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
    • ¥15 解riccati方程组
    • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
    • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
    • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决