以PDF格式显示数据

问题描述:

为什么我无法在PDF文件中显示数据库中的数据? 我用DOMPDF来转换我的HTML。任何人都请帮忙。以PDF格式显示数据

下面是PDF结果

PDF result image

这里是连接代码

<?php 


    $id = $_GET['id']; 

    $conn = pg_connect("host=localhost dbname=mydatabase user=postgres password=admin"); 
    if (!$conn) { 
    echo "An error occurred. cannot connectect to localhost.\n"; 
    exit; 
    } 

    $sql = pg_query($conn, "SELECT * FROM mytable WHERE reference_no = $id "); 
    if (!$sql) { 
     echo "Error Ariel 7:50 !!!.\n"; 

    } 

    while ($row = pg_fetch_assoc($sql)) { 
     $reference_no = $row['reference_no']; 
     $wo_name = $row['wo_name']; 

    } 

这里是我的皈依代码:

error_reporting(0); 
    require_once ('xdompdf/dompdf_config.inc.php'); 
    $pdf_content=' 
       <style type="text/css"> 

       div.refno{padding-left: 190px;} 
        .line{padding-left: 260px; padding-top: -37px;} 

       </style> 

    <body> 
    <div> 

     <h4> Work Order Form </h4> 
     <p> Reference No.   <div class="refno"><?php echo  $reference_no;?></div>  </p> 
     <p class="line">:_________________________________________________</p> 

     <p> Work Order Name   <div class="woname"><?php echo $wo_name;?></div>  </p> 
     <p class="line">:_________________________________________________</p> 
    </div> 

    </body>' 
     ; 
     $name = date("Ymd").rand().'.pdf'; 
     $reportPDF=createPDF(12, $pdf_content, 'activity_Report', $name); 
     function createPDF($pdf_userid, $pdf_content, $pdf_For, $filename){ 

     $path='xdompdf/'; 
     /*$rndNumber=rand(); 
     $filename=$pdf_userid.date("Ymd").$rndNumber.'.pdf';*/ 
     $dompdf=new DOMPDF(); 
     $dompdf->load_html($pdf_content); 
     $dompdf->render(); 
     $output = $dompdf->output(); 
     file_put_contents($path.$filename, $output); 
     return $filename;  
     } 
     echo '<a href="xdompdf/'.$name.'" > Download </a>'; 
     ?> 

请帮助我如何显示数据。

变化$pdf_content

$pdf_content=' 
    <style type="text/css"> 
    div.refno{padding-left: 190px;} 
    .line{padding-left: 260px; padding-top: -37px;} 
    </style> 
    <body> 
     <div> 
      <h4> Work Order Form </h4> 
      <p> Reference No.   <div class="refno">' . $reference_no . '</div>  </p> 
      <p class="line">:_________________________________________________</p> 

      <p> Work Order Name   <div class="woname">' . $wo_name . '</div>  </p> 
      <p class="line">:_________________________________________________</p> 
     </div> 
    </body>'; 
+0

谢谢您的回答。我试了一下,它的工作原理。 A BIG THANKS :) –

我想你只需要在Concat的$ pdf_content数据:

$pdf_content=' 
      <style type="text/css"> 

      div.refno{padding-left: 190px;} 
       .line{padding-left: 260px; padding-top: -37px;} 

      </style> 

<body> 
<div> 

    <h4> Work Order Form </h4> 
    <p> Reference No.   <div class="refno">'.$reference_no.'</div>    </p> 
    <p class="line">:_________________________________________________</p> 

    <p> Work Order Name   <div class="woname">'.$wo_name.'</div>  </p> 
    <p class="line">:_________________________________________________</p> 
</div> 

</body>'; 
+0

谢谢你的回答。我试了一下,它的工作原理。大感谢:) –