php - 无法从数组访问数据并将其转换为 pdf

Question

我正在尝试从数据库中获取数据并将其转换为 Pdf 文件，但 pdf 文件是空的，它不显示数据库元素问题是当我在 while 循环中到达变量 $res 时，我得到了数组但是我无法访问它。我不明白我在做什么错，你能帮帮我吗？

  <?php
  /**
   * @package     tool_report
   * @author      Marko
   * @license     http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
   */

   require('../blocks/bbbreport/fpdf/fpdf.php');
   ob_start(); //
   require_once(__DIR__ . '/../config.php');
   defined('MOODLE_INTERNAL') || die();

   $PAGE->set_url(new moodle_url('/course/manage.php'));
   $PAGE->set_context(\context_system::instance());
   $PAGE->set_title(get_string('manage_reports', 'tool_report'));

   global $DB;

   echo $OUTPUT->header();

   $conn = new mysqli($CFG->dbhost, $CFG->dbuser, $CFG->dbpass, $CFG->dbname);


   if ($conn->connect_errno) {
       echo $conn->connect_error;
       return;
   }


   $sql = " SELECT *
            FROM mdl_bigbluebuttonbn
          ";
   $result = $conn->query($sql);
   $res = [];

   $pdf = new FPDF();
   $pdf->AddPage();
   $pdf->SetFont('Courier','B',16);
   $pdf->Cell(50,10,'Course ID', '1', '0', 'C');
   $pdf->Cell(50,10,'Course TYPE', '1', '0', 'C');
   $pdf->Cell(50,10,'Course COURSE', '1', '0', 'C');
   $pdf->Cell(50,10,'Course NAME', '1', '0', 'C');
   ?><?php
    if ($result->num_rows > 0) {
      while ($row = $result->fetch_assoc()) {                   
      **$res[]= $row;
      var_dump($res['name]);**
     ?>
     <tr>
       <td><?php echo $res['id'] ?></td>
       <td><?php echo $res['type'] ?></td>
       <td><?php echo $res['course'] ?></td>
       <td><?php echo $res['name'] ?></td>
     </tr>
   <?php
     var_dump($res);die();

    }
   }
   ob_end_clean();
   $pdf->Output();
   $conn->close();

   echo $OUTPUT->footer();
   ?>

标签： phpmysqlsql