Código PHP:
//set initial y axis position per page
$y_axis_initial = 25;
//print column titles
$pdf->SetFillColor(116,219,253);
$pdf->SetFont('Arial','B',12);
$pdf->SetY($y_axis_initial);
$pdf->SetX(25);
$pdf->Ln(80);
$pdf->Cell(49,6,'INVENTARIO',1,0,'C',1);
$pdf->Cell(49,6,'MARCA',1,0,'C',1);
$pdf->Cell(49,6,'MODELO',1,0,'C',1);
$pdf->Cell(49,6,'SERIE',1,0,'C',1);
$y_axis = $y_axis + $row_height;
//Select the Products you want to show in your PDF file
$result=mysql_query('select inventario,marca,modelo,serie from inv_total ORDER BY inventario');
//initialize counter
$i = 0;
//Set maximum rows per page
$max = 20;
//Set Row Height
$row_height = 6;
while($row = mysql_fetch_array($result))
{
//If the current row is the last one, create new page and print column title
if ($i == $max)
{
$pdf->AddPage();
//print column titles for the current page
$pdf->SetY($y_axis_initial);
$pdf->SetX(25);
$pdf->Ln(10);
$pdf->SetFillColor(116,219,253);
$pdf->Cell(49,6,'INVENTARIO',1,0,'C',1);
$pdf->Cell(49,6,'MARCA',1,0,'C',1);
$pdf->Cell(49,6,'MODELO',1,0,'C',1);
$pdf->Cell(49,6,'SERIE',1,0,'C',1);
//Go to next row
$y_axis = $y_axis + $row_height;
//Set $i variable to 0 (first row)
$i = 0;
}
$pdf->SetFillColor(255,255,255);
$in = $row['inventario'];
$ma = $row['marca'];
$mo = $row['modelo'];
$sr = $row['serie'];
$pdf->SetFont('Arial','',12);
$pdf->SetY($y_axis);
$pdf->SetX(25);
$pdf->Ln(112);
$pdf->Cell(49,5,$in,1,0,'L',1);
$pdf->Cell(49,5,$ma,1,0,'C',1);
$pdf->Cell(49,5,$mo,1,0,'C',1);
$pdf->Cell(49,5,$sr,1,0,'C',1);
//Go to next row
$y_axis = $y_axis + $row_height;
$i = $i + 1;
}
mysql_close;
//Send file
$pdf->Output();
imagen 2