php - 如何使用 fpdf 将 mysql 数据库中的数据行显示到 pdf 文档中

Question

我试图从 MYSQL DATABASE 中获取信息以显示在 pdf 文档上，但我生成的 PDF 文档上只显示徽标和标题。不显示来自 DB 的数据。

请帮助以下是代码：

$con = mysqli_connect('localhost','branch','branch2012');
mysqli_select_db($con,"branch");

$sql="SELECT FirstName, PostalAddress, LastName, MobileNo FROM Patients WHERE Id = 1";
$result = mysqli_query($con,$sql);
while($rows= (mysqli_fetch_array($result,MYSQLI_ASSOC)))
{           
    $name = $rows['FirstName'];
    $address = $rows['PostalAddress'];
    $class = $rows['LastName'];
    $phone = $rows['MobileNo'];

    $pdf->SetXY (20,60);
    $pdf->SetFontSize(12);
    $pdf->SetTextColor(0,0,0);
    $pdf->Write(7,$name);
    $pdf->SetXY (20,65);
    $pdf->Write(7,$address);
    $pdf->SetXY (20,70);
    $pdf->Write(7,$class);
    $pdf->SetXY (20,90);
    $pdf->Write(7,$phone);
    $pdf->Ln(); 
}

//Output the document
$pdf->Output('test.pdf','I');     

标签： phpfpdf