Enumeracao no relatorio fpdf

hortencio2016
(usa Outra)

Enviado em 28/03/2016 - 22:31h

Ola a todos, estou aprendendo a criar relatorio com fpdf no php. Ja tenho feito mas nao sei como enumerar. Tenho uma lista e quero que cada vez que inserto um dado que me inumere. Consegui no principio mas ja para dar continuidade nao consigo. Alguem pode me ajudar?

Dexo o codigo abaixo


<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<?php

$cateq = $_POST['catequista'];
$etapa = $_POST['etapa'];
$ano = $_POST['ano'];

ob_end_clean();

require("fpdf/fpdf.php");


$pdf=new FPDF('L','mm','Letter');
//$pdf=new FPDF('L','mm','A4');
$pdf->AddPage();
$pdf->SetFont('times','B',11);
$pdf->SetLeftMargin(18);
$pdf->SetFillColor(192,195,10);
$pdf->Ln(8);
// ENCABEZADO
$pdf->Cell(240,4,"ARQUIDIOCESE DA BEIRA",0,1,"C");
$pdf->Cell(240,4,"Paróquia de Nossa Senhora do Rosario-Sé Catedral da Beira",0,1,'C');
$pdf->SetFont('times','I',11);
$pdf->Ln(2);
$pdf->Cell(240,4,"MAPA DE CONTROL DA CATEQUESE",0,1,'C');
$pdf->Ln(2);
$pdf->Cell(240,4,"Ano Lectivo: " .$ano ,0,1,'C');
$pdf->SetLeftMargin(5);

$pdf->SetFont('times','B',11);
$pdf->Cell(195,4);
$pdf->SetFont('times','',11);
$pdf->Image('fpdf/NSRA.png',10,10,15);

$pdf->Ln(1);

$pdf->SetFillColor(128,255,190);

require 'conector.php';
if(strlen($cateq)>0){
$sql = "select * from tb_mapa where catequista = '$cateq' and ano = '$ano'";
$res = mysql_query($sql) or die("Error ".mysql_error());
$num = mysql_num_rows($res);

}
$res = mysql_query($sql) or die("Error ".mysql_error());
$num = mysql_num_rows($res);
if($num<1){
echo "<script>alert('Este catequista nao existe')</script>";
include("print_etapa.php");
return;
}

$pdf->Ln(5);

$pdf->Cell(8,5,"Nº",1,0,'C',true);

$pdf->Cell(15,5,"Codigo",1,0,'C',true);
$pdf->Cell(41,5,"Catequizando",1,0,'L',true);
//$pdf->Cell(20,5,"Etapa",1,0,'L',true);
$pdf->Cell(20,5,"Feve",1,0,'L',true);
$pdf->Cell(20,5,"Marc",1,0,'L',true);
$pdf->Cell(25,5,"Abri",1,0,'C',true);
$pdf->Cell(20,5,"Ma",1,0,'L',true);
$pdf->Cell(20,5,"Jun",1,0,'L',true);
$pdf->Cell(25,5,"Jul",1,0,'L',true);
$pdf->Cell(20,5,"Agos",1,0,'L',true);
$pdf->Cell(20,5,"Set",1,0,'C',true);
$pdf->Cell(20,5,"Outu",1,0,'L',true);
$pdf->Cell(16,5,"Nove",1,1,'L',true);


while($row=mysql_fetch_array($res)){

$nome = utf8_decode($row['catequista']); //Para remover os caracteres nos nomes

$pdf->Cell(8,5,"01",1,0); //Daqui consigo enumerar apenas o numero 1 e na primeira fila depois do titulo. Quando inserto o segundo dado me aparece na fila seguinte 01. Quero que aparece enumerado consoante os dados.

$doc = $row['codigo'];

$cate = $row['catequizando'];
$f1 = $row['f1'];
$f2 = $row['f2'];
$f3 = $row['f3'];
$f4 = $row['f4'];
$mr1 = $row['mr1'];
$mr2 = $row['mr2'];
$mr3 = $row['mr3'];
$mr4 = $row['mr4'];
$ab1 = $row['ab1'];
$ab2 = $row['ab2'];
$ab3 = $row['ab3'];
$ab4 = $row['ab4'];
$ab5 = $row['ab5'];
$ma1 = $row['ma1'];
$ma2 = $row['ma2'];
$ma3 = $row['ma3'];
$ma4 = $row['ma4'];
$jn1 = $row['jn1'];
$jn2 = $row['jn2'];
$jn3 = $row['jn3'];
$jn4 = $row['jn4'];
$jl1 = $row['jl1'];
$jl2 = $row['jl2'];
$jl3 = $row['jl3'];
$jl4 = $row['jl4'];
$jl5 = $row['jl5'];
$ag1 = $row['ag1'];
$ag2 = $row['ag2'];
$ag3 = $row['ag3'];
$ag4 = $row['ag4'];
$st1 = $row['st1'];
$st2 = $row['st2'];
$st3 = $row['st3'];
$st4 = $row['st4'];
$out1 = $row['out1'];
$out2 = $row['out2'];
$out3 = $row['out3'];
$out4 = $row['out4'];
$out5 = $row['out5'];
$nov1 = $row['nov1'];
$nov2 = $row['nov2'];
$nov3 = $row['nov3'];
$nov4 = $row['nov4'];



$pdf-> Cell(15,5,$doc,1,0,'L');
$pdf-> Cell(41,5,$cate,1,0,'L');

$pdf-> Cell(5,5,$f1,1,0,'L');
$pdf-> Cell(5,5,$f2,1,0,'L');
$pdf-> Cell(5,5,$f3,1,0,'L');
$pdf-> Cell(5,5,$f4,1,0,'L');
$pdf-> Cell(5,5,$mr1,1,0,'L');
$pdf-> Cell(5,5,$mr2,1,0,'L');
$pdf-> Cell(5,5,$mr3,1,0,'L');
$pdf-> Cell(5,5,$mr4,1,0,'L');
$pdf-> Cell(5,5,$ab1,1,0,'L');
$pdf-> Cell(5,5,$ab2,1,0,'L');
$pdf-> Cell(5,5,$ab3,1,0,'L');
$pdf-> Cell(5,5,$ab4,1,0,'L');
$pdf-> Cell(5,5,$ab5,1,0,'L');
$pdf-> Cell(5,5,$ma1,1,0,'L');
$pdf-> Cell(5,5,$ma2,1,0,'L');
$pdf-> Cell(5,5,$ma3,1,0,'L');
$pdf-> Cell(5,5,$ma4,1,0,'L');
$pdf-> Cell(5,5,$jn1,1,0,'L');
$pdf-> Cell(5,5,$jn2,1,0,'L');
$pdf-> Cell(5,5,$jn3,1,0,'L');
$pdf-> Cell(5,5,$jn4,1,0,'L');
$pdf-> Cell(5,5,$jl1,1,0,'L');
$pdf-> Cell(5,5,$jl2,1,0,'L');
$pdf-> Cell(5,5,$jl3,1,0,'L');
$pdf-> Cell(5,5,$jl4,1,0,'L');
$pdf-> Cell(5,5,$jl5,1,0,'L');
$pdf-> Cell(5,5,$ag1,1,0,'L');
$pdf-> Cell(5,5,$ag2,1,0,'L');
$pdf-> Cell(5,5,$ag3,1,0,'L');
$pdf-> Cell(5,5,$ag4,1,0,'L');
$pdf-> Cell(5,5,$st1,1,0,'L');
$pdf-> Cell(5,5,$st2,1,0,'L');
$pdf-> Cell(5,5,$st3,1,0,'L');
$pdf-> Cell(5,5,$st4,1,0,'L');
$pdf-> Cell(4,5,$out1,1,0,'L');
$pdf-> Cell(4,5,$out2,1,0,'L');
$pdf-> Cell(4,5,$out3,1,0,'L');
$pdf-> Cell(4,5,$out4,1,0,'L');
$pdf-> Cell(4,5,$out5,1,0,'L');
$pdf-> Cell(4,5,$nov1,1,0,'L');
$pdf-> Cell(4,5,$nov2,1,0,'L');
$pdf-> Cell(4,5,$nov3,1,0,'L');
$pdf-> Cell(4,5,$nov4,1,1,'L');



//$pdf->Ln(5);
//$pdf->Cell(5,5,"ETAPA:" .$etapa,0,0,'L');
//$pdf-> Cell(50,5,$etapa,0,0,'L');


}
function Footer()
{
// Posición: a 1,5 cm del final
$this->SetY(265);
// Arial italic 8
$this->SetFont('Arial','I',8);
// Número de página
$this->Cell(0,10,'Page '.$this->PageNo().'/{nb}',0,0,'C');
}


// Creación del objeto de la clase heredada
//$pdf = new PDF();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times','',12);
for($i=1;$i<=40;$i++)
//$pdf->Cell(0,10,'Imprimiendo línea número '.$i,0,1);
$pdf->Output();

?>