Home / Questions / 556205
Accepted
Luis Jair Juarez Sanchez
Asked: 2022-09-10 11:29:40 +0800 CST 2022-09-10 11:29:40 +0800 CST

Adjust the content of a report generated with FPDF

  • 772

Greetings, I am generating a report with FPDF in PHP

//Solicitando la conexion con la BD
require 'conexion.php';
//Efectuando la consulta de las vista
$consulta = "SELECT * FROM diferencias ORDER BY falla";
//Almaceando el resultado de la consulta en una variable
$resultado = $mysqli->query($consulta);

// Creación del objeto de la clase heredada
$pdf = new PDF('L','mm','A4');//Indicando formato horizontal del reporte
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Helvetica', '', 8);

//Encabezados de la tabla
$pdf->SetFont('Helvetica', 'B', 8);//Colocando letras en negritas
$pdf->Cell(28, 10, 'Service Tag', 1, 0, 'C', 0);
$pdf->Cell(50, 10, 'Usuario', 1, 0, 'C', 0);
$pdf->Cell(65, 10, 'Diferencia 1', 1, 0, 'C', 0);
$pdf->Cell(65, 10, 'Diferencia 2', 1, 0, 'C', 0);
$pdf->Cell(65, 10, 'Falla', 1, 1, 'C', 0);
$pdf->SetFont('Helvetica', '', 8);//Devolviendo valores de letra

My specific problem is here, some column data fails are too wide, I would like to know if there is a way to adjust the letters to the assigned size of the cell

//Ciclo para recorrer la tabla e insertar registros en la tabla
$a=0;
while ($row = $resultado->fetch_assoc()) {
    //Ancho alto,borde,salto de linea justificacion relleno
    //$pdf->Cell(15,10, utf8_decode($row['consecutivo']), 1, 0, 'C', 0);
    $pdf->Cell(28,10, utf8_decode($row['servicetag']), 1, 0, 'C', 0);
    $pdf->Cell(50,10, utf8_decode($row['usuario']), 1, 0, 'C', 0);
    $pdf->Cell(65,10, utf8_decode($row['dif1']), 1, 0, 'C', 0);
    $pdf->Cell(65,10, utf8_decode($row['dif2']), 1, 0, 'C', 0);
    $pdf->Cell(65,10, utf8_decode($row['falla']), 1, 1, 'C', 0);
    $a=$a+1;

}

Since when you made the report it looks like this enter image description here

php

1 Answers

  1. Best Answer

    FPDFsupports the feature multicell, so instead of doing this:

    $pdf->Cell(65,10, utf8_decode($row['falla']), 1, 1, 'C', 0);

    Do this:

    $pdf->multiCell(65,10,utf8_decode($row['falla']), 1, 1);

    And with it the height of the cell will adjust to the amount of text it contains.

    • 0