Código PHP:
<?php
define('FPDF_FONTPATH','font/');
require('fpdf.php');
//Connect to your database
include("connect.php");
//Create new pdf file
$pdf=new FPDF();
//Open file
$pdf->Open();
//Disable automatic page break
$pdf->SetAutoPageBreak(false);
//Add first page
//$pdf->AddPage();
//set initial y axis position per page
$y_axis_initial = 25;
//print column titles for the actual page
$pdf->SetFillColor(232,232,232);
$pdf->SetFont('Arial','B',12);
$pdf->SetY($y_axis_initial);
$pdf->SetX(25);
//$pdf->Cell(30,6,'CODE',1,0,'L',1);
//$pdf->Cell(100,6,'NAME',1,0,'L',1);
//$pdf->Cell(30,6,'PRICE',1,0,'R',1);
$y_axis = $y_axis + $row_height;
$Dni_inqui=$_POST['Dni_inqui'];
//Select the Products you want to show in your PDF file
$result=mysql_query("SELECT Dni_inqui, Sueldo_inqui, Nombre_inqui
FROM alqui
WHERE
Dni_inqui = '$Dni_inqui'");
//initialize counter
$i = 0;
//Set maximum rows per page
$max = 25;
//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->Cell(30,6,'CODE',1,0,'L',1);
//$pdf->Cell(100,6,'NAME',1,0,'L',1);
//$pdf->Cell(30,6,'PRICE',1,0,'R',1);
//Go to next row
$y_axis = $y_axis + $row_height;
//Set $i variable to 0 (first row)
$i = 0;
}
$Nombre_inqui = $row['Nombre_inqui'];
$Dni_inqui = $row['Dni_inqui'];
$Sueldo_inqui = $row['Sueldo_inqui'];
//$name = $row['Code'];
$pdf->SetY($y_axis);
$pdf->SetX(25);
$pdf->Cell(30,6,$Nombre_inqui,1,0,'L',1);
$pdf->Cell(30,6,$Dni_inqui,1,0,'L',1);
$pdf->Cell(100,6,$Sueldo_inqui,1,0,'L',1);
//$pdf->Cell(30,6,$price,1,0,'R',1);
//Go to next row
$y_axis = $y_axis + $row_height;
$i = $i + 1;
}
//________________-BARRAS-__________________
define('FPDF_FONTPATH','font/');
require('code39.php');
$pdf=new PDF_Code39();
$pdf->AddPage();
$pdf->Code39(60, 30, $Dni_inqui, $Sueldo_inqui, Nombre_inqui);
$pdf->Output();
//_________________________________________
$pdf->Cell(30,6,$Nombre_inqui,1,0,'L',1);
mysql_close();
//Create file
$pdf->Output();
?>