在PDF中打印HTML表，生成许多PDF

发布于 2025-01-18 20:19:43 字数 1748 浏览 0 评论 0原文

我有一个页面是使用数据库中的数据生成表格式的。学生的每个结果都显示在一页上，以便在打印机上打印时，每个结果都打印在一页上。我现在需要为每个学生生成一个 pdf 文件。如何添加代码以使用学生姓名生成 pdf？

提前致谢。

<body>
   <?php
      $grade=7;
      require 'GetStudentNames.php';  
      while ($row1 = $result1->fetch_assoc()) {  ?>
   <P style="page-break-before: always"> 
   <table margin-top="70px"  width="100%">
      <tr>
         <td rowspan="2"><img src="logo.PNG"  alt="logo"></td>
         <td style="text-align:center" rowspan="1">
            <h2>xyz School</h2>
         </td>
      <tr>
         <td rowspan="1" style="text-align: center; ">
            <h3 style="text-decoration: underline ;text-align:center">Student Report Sheet - First Term 2021</h3>
         </td>
      </tr>
   </table>
   <?php echo '<br><table width="100%"><th width="50%">Student Name: '.@$row1["name"].'   '.@$row1["firstname"].'</th>';
      echo '</td>';
      require 'db.php';
      $sql = "select subject from results where SN = '".@$row1["sn"]."' order by listorder";
      $result = $conn->query($sql);
      $count=1;
      while ($row = $result->fetch_assoc()) {
          echo '<tr class="oneSubj"><td class="oneSubj">'. $count.'.  '.@$row["subject"].'</td>
         
          </tr>';
          $count++;
      }?>
   </table>
   <br>
   <table style="width: 100%">
      <th style="width:25%">Absences..................</th>
      <br>
      <h5 style="text-decoration: underline ;text-align:center">Special Mention</h5>
   </table>
   <?php }?>
</body>

原文

I have a page that is generated using data from a database into a table format.
Each result of a student is displayed on a page so that when printed on a printer, each result is printed on a page. I need now to generate a pdf for each student. How can I add code to generate the pdf, using the name of the student?

Thanks in advance.

<body>
   <?php
      $grade=7;
      require 'GetStudentNames.php';  
      while ($row1 = $result1->fetch_assoc()) {  ?>
   <P style="page-break-before: always"> 
   <table margin-top="70px"  width="100%">
      <tr>
         <td rowspan="2"><img src="logo.PNG"  alt="logo"></td>
         <td style="text-align:center" rowspan="1">
            <h2>xyz School</h2>
         </td>
      <tr>
         <td rowspan="1" style="text-align: center; ">
            <h3 style="text-decoration: underline ;text-align:center">Student Report Sheet - First Term 2021</h3>
         </td>
      </tr>
   </table>
   <?php echo '<br><table width="100%"><th width="50%">Student Name: '.@$row1["name"].'   '.@$row1["firstname"].'</th>';
      echo '</td>';
      require 'db.php';
      $sql = "select subject from results where SN = '".@$row1["sn"]."' order by listorder";
      $result = $conn->query($sql);
      $count=1;
      while ($row = $result->fetch_assoc()) {
          echo '<tr class="oneSubj"><td class="oneSubj">'. $count.'.  '.@$row["subject"].'</td>
         
          </tr>';
          $count++;
      }?>
   </table>
   <br>
   <table style="width: 100%">
      <th style="width:25%">Absences..................</th>
      <br>
      <h5 style="text-decoration: underline ;text-align:center">Special Mention</h5>
   </table>
   <?php }?>
</body>

分享到QQ

分享到微博