PHP / FPDF : fpdf表格中的数字

Question

我很难找到如何生产出我想要的产出。

下面是示例输出：

​

​

pdf文件是通过fpdf生成的。

我的问题是，我怎样才能把编号包括在表格中，就像上面的图片一样。

这是我到目前为止的密码。

查询：

$result=mysql_query("SELECT tb_record_grade.*, tb_student.* FROM tb_record_grade 
                    INNER JOIN tb_student ON tb_record_grade.student_no=tb_student.student_no 
                    WHERE tb_record_grade.class_record_id = '$class_id' AND tb_record_grade.term = '$term'
                    AND tb_student.status = 'Active'
                    GROUP BY tb_student.stud_fname 
                    ORDER BY tb_student.stud_lname");

表：

    $pdf->Cell(45,5,'Student Name',1,'','C');
    $pdf->Cell(30,5,'Course',1,'','C');
    $pdf->Cell(30,5,'Rating',1,'','C');
    $pdf->Cell(45,5,'Remark',1,'','C');
    $pdf->Cell(40,5,'Signature',1,'','C');
    $pdf->Ln();
    while($row = mysql_fetch_array($result)){
    $fname = $row['stud_fname'];
    $lname = $row['stud_lname'];
    $course = $row['course_and_year'];
    $grade = $row['grade'];
    $remark = $row['remark'];
    $sig = "";

    $pdf->SetFont('Arial','',11);
    $pdf->Cell(45,5,$fname." ".$lname,1);
    $pdf->Cell(30,5,$course,1,'','');
    $pdf->Cell(30,5,$grade,1,'','C');
    $pdf->Cell(45,5,$remark,1,'','C');
    $pdf->Cell(40,5,$sig,1,'','C');
    $pdf->Ln();
    }

任何想法都会有很大的帮助，谢谢。

Answer 1

尝试为每一行创建一个新的单元格并使用db id：

$pdf->Cell(45,5,'Id',1,'','C');    
$pdf->Cell(45,5,'Student Name',1,'','C');
$pdf->Cell(30,5,'Course',1,'','C');
$pdf->Cell(30,5,'Rating',1,'','C');
$pdf->Cell(45,5,'Remark',1,'','C');
$pdf->Cell(40,5,'Signature',1,'','C');
$pdf->Ln();
$count = 1;
while($row = mysql_fetch_array($result)){
    $id = $count;
    $fname = $row['stud_fname'];
    $lname = $row['stud_lname'];
    $course = $row['course_and_year'];
    $grade = $row['grade'];
    $remark = $row['remark'];
    $sig = "";
    $pdf->SetFont('Arial','',11);
    $pdf->Cell(45,5,$id,1);
    $pdf->Cell(45,5,$fname." ".$lname,1);
    $pdf->Cell(30,5,$course,1,'','');
    $pdf->Cell(30,5,$grade,1,'','C');
    $pdf->Cell(45,5,$remark,1,'','C');
    $pdf->Cell(40,5,$sig,1,'','C');
    $pdf->Ln();
    $count++;
}