How can I integrate an FPDF with my query to the database?

Question

How can I integrate an FPDF with my query to the database?

Navigation

#1 by (0 votes)
#2 by (0 votes)

0

Thanks to the help of the members of SO, I managed to consult the database and I also managed to run my FPDF correctly but separately, if I wanted to make this query

<?php
    $TIPO_BUSQUEDA = $_POST["TIPO_BUSQUEDA"];
    function ejecuta_consulta($labusqueda)
    {
        include("conexiond.php");

        $conexion= mysqli_connect($db_host, $db_usuario, $db_contra);

        if (mysqli_connect_errno()) {
            echo "Fallo al conectar con la base de datos";
            exit();
        }

        mysqli_select_db($conexion, $db_nombre) or die("No se encuentra la base de datos.");


        $consulta = "SELECT datosbasicos.CED_PAC,datosbasicos.NOM_PAC,datosbasicos.APE_PAC,datosbasicos.SEX_PAC,datosmedicos.COD_CONSULTA,datosmedicos.ALT_PAC,datosmedicos.PESO_PAC,datosmedicos.FECHA,datosmedicos.TIPO_CONSULTA,datosmedicos.SINTOMAS,datosmedicos.OBSERV,datosmedicos.HIS_PAC,datosmedicos.MEDI_PAC,datosmedicos.OPERADO,datosmedicos.ALERGIAS FROM datosbasicos INNER JOIN datosmedicos ON datosbasicos.CED_PAC=datosmedicos.CED_PAC WHERE datosbasicos.NOM_PAC LIKE '%$labusqueda%' OR datosbasicos.CED_PAC LIKE '%$labusqueda%' OR datosmedicos.COD_CONSULTA LIKE '%$labusqueda%' OR datosbasicos.CED_PAC LIKE '%$labusqueda%' OR datosmedicos.FECHA LIKE '%$labusqueda%'  ";

        $resultados = mysqli_query($conexion, $consulta);

        $filas = array(); // Crea la variable $filas y se le asigna un array vacío
        // (Si la consulta no devuelve ningún resultado, la función por lo menos va a retornar un array vacío)

        while ($fila=mysqli_fetch_array($resultados, MYSQLI_ASSOC)) {
            $filas[] = $fila; // Añade el array $fila al final de $filas
        }

        mysqli_close($conexion);

        return $filas; // Devuelve el array $filas
    }
?>

<!DOCTYPE html>
<html>

<head>
    <title>Sistema de historias médicas - Dr. Darling Davila</title>
    <meta charset="utf-8">
    <link rel="stylesheet" href="css/bootstrap.css">
    <link rel="stylesheet" type="text/css" href="css/estilo.css">
    <link href="https://fonts.googleapis.com/css?family=Lato|Roboto" rel="stylesheet">
</head>

<body>
    <?php
        $mibusqueda=$_GET["buscar"];

        $mipag=$_SERVER["PHP_SELF"];

        if ($mibusqueda!=null) {
            $pacientes = ejecuta_consulta($mibusqueda);
    ?>

        <div id="main-container">
        <img src='imagenes/header.png' class='img'>
            <table>
                <thead>
                    <tr>
                        <th>Codigo Consulta</th>
                        <th>Fecha</th>
                        <th>Cedula</th>
                        <th>Nombres</th>
                        <th>Apellidos</th>
                        <th>Sexo</th>
                        <th>Altura</th>
                        <th>Peso</th>
                        <th>Sintomas</th>
                        <th>Observaciones</th>
                        <th>Tipo de consulta</th>
                        <th>Medicamentos actuales</th>
                        <th>Alergias</th>
                        <th>Operado</th>
                    </tr>
                </thead>
                <tbody>
                    <?php
                    // Si la variable $pacientes esta definida y no está vacía
                    if (isset($pacientes) && !empty($pacientes)) {
                        // Recorre cada $paciente dentro del array $pacientes
                        foreach ($pacientes as $paciente) {
                            ?>
                        <tr>
                            <td><?php echo $paciente['COD_CONSULTA'] ?></td>
                            <td><?php echo $paciente['FECHA'] ?></td>
                            <td><?php echo $paciente['CED_PAC'] ?></td>
                            <td><?php echo $paciente['NOM_PAC'] ?></td>
                            <td><?php echo $paciente['APE_PAC'] ?></td>
                            <td><?php echo $paciente['SEX_PAC'] ?></td>
                            <td><?php echo $paciente['ALT_PAC'] ?></td>
                            <td><?php echo $paciente['PESO_PAC'] ?></td>
                            <td><?php echo $paciente['SINTOMAS'] ?></td>
                            <td><?php echo $paciente['OBSERV'] ?></td>
                            <td><?php echo $paciente['TIPO_CONSULTA'] ?></td>
                            <td><?php echo $paciente['MEDI_PAC'] ?></td>
                            <td><?php echo $paciente['ALERGIAS'] ?></td>
                            <td><?php echo $paciente['OPERADO'] ?></td>
                        </tr>
                    <?php
                        }
                    } ?>
                </tbody>
        </div>
    <?php
        } else {
            echo("<form action='". $mipag . "' method='GET'>
                <img src='imagenes/header.png'>
                    <h2>Busqueda de paciente</h2>
                    <div class='contenedor'>
                    <select name='TIPO_BUSQUEDA' class='input-100 text-center col-md-12'>
                        <option value='Cedula' selected='selected' <?PHP if($TIPO_BUSQUEDA=='Cedula'){ echo 'selected='selected'; } ?> Cedula</option>
                        <option value='Edad' <?PHP if($TIPO_BUSQUEDA=='Edad'){ echo 'selected='selected'; } ?> Edad</option>
                        <option value='Nombre' <?PHP if($TIPO_BUSQUEDA=='Nombre'){ echo 'selected='selected'; } ? >Nombre</option>
                        <option value='Fecha' <?PHP if($TIPO_BUSQUEDA=='Fecha'){ echo 'selected='selected'; } ?> Fecha</option>
                    </select>
                    <input type='text' name='buscar' class='input-100 text-center inline-block col-md-6 btn-enviar espacio-arriba'></label>

                    <input type='submit' name='enviando' value='Consulta' class='text-center inline-block col-md-12 espacio-arriba btn-enviar'>
                </div>
                </form>");
        }
     ?>

</body>

</html>

Allow me to print in PDF what the query throws. How would you do? because I have the code of FPDF but doing a general query that does not allow me according to what I look for, for that I know I must have the additional button in the first form where the query shows me which says something like "Print" and there I generated it in PDF.

EDIT

I have already made the button that generates the PDF which is the following

<form name="reporte" action="database.php" method="post">
        <input type='submit' name='generar' value='PDF' class='text-center inline-block col-md-12 espacio-arriba btn-enviar2'>
        </form>
        </div>

But now I can not make this code take me the variables that I already had in the query to take me to PDF.

FPDF code

<?php
require('tfpdf.php');
$con=mysqli_connect('localhost','root','12345678');
mysqli_select_db($con,'pacientes');


class PDF extends TFPDF {
    function Header(){
        $this->SetFont('Arial','B',15);

        //dummy cell to put logo
        //$this->Cell(12,0,'',0,0);
        //is equivalent to:
        $this->Cell(12);

        //put logo
        $this->Image('imagenes/header.png',150,10,60);

        $this->Cell(1,50,'Lista de pacientes',0,1);

        //dummy cell to give line spacing
        //$this->Cell(0,5,'',0,1);
        //is equivalent to:
        $this->Ln(5);
        $this->SetFont('Arial','B',11);

        $this->SetFillColor(54,150,129);
        $this->SetDrawColor(36,99,85);
        $this->Cell(40,5,'Nombre ',1,0,'',true);
        $this->Cell(40,5,'Apellido',1,0,'',true);
        $this->Cell(25,5,'Edad',1,0,'',true);
        $this->Cell(25,5,'Sexo',1,0,'',true);
        $this->Cell(30,5,'Telefono',1,0,'',true);
        $this->Cell(30,5,'Celular',1,0,'',true);
        $this->Cell(130,5,'Direccion',1,1,'',true);


    }
    function Footer(){
        //add table's bottom line
        $this->Cell(190,0,'','T',1,'',true);

        //Go to 1.5 cm from bottom
        $this->SetY(-15);

        $this->SetFont('Arial','',8);

        //width = 0 means the cell is extended up to the right margin
        $this->Cell(0,10,'Page '.$this->PageNo()." / {pages}",0,0,'C');
    }
}


//A4 width : 219mm
//default margin : 10mm each side
//writable horizontal : 219-(10*2)=189mm


$pdf = new PDF('L','mm',array(400,200)); //use new class

//define new alias for total page numbers
$pdf->AliasNbPages('{pages}');

$pdf->SetAutoPageBreak(true,15);
$pdf->AddPage();

$pdf->SetFont('Arial','',9);
$pdf->SetDrawColor(36,99,85);

// Add a Unicode font (uses UTF-8)
$pdf->AddFont('Arial','','Arial.ttf',true);
$pdf->SetFont('Arial','',11);

$query=mysqli_query($con,"select * from datosbasicos");
while($data=mysqli_fetch_array($query)){
    $pdf->Cell(40,5,$data['NOM_PAC'],'LR',0);
    $pdf->Cell(40,5,$data['APE_PAC'],'LR',0);
    $pdf->Cell(25,5,$data['EDAD_PAC'],'LR',0);
    $pdf->Cell(25,5,$data['SEX_PAC'],'LR',0);
    $pdf->Cell(30,5,$data['TEL_PAC'],'LR',0);
    $pdf->Cell(30,5,$data['CEL_PAC'],'LR',0);
    $pdf->Cell(130,5,$data['DIR_PAC'],'LR',0);

    if($pdf->GetStringWidth($data['email']) > 65){
        $pdf->SetFont('Arial','',7);
        $pdf->Cell(65,5,$data['email'],'LR',0);
        $pdf->SetFont('Arial','',9);
    }else{
        $pdf->Cell(65,5,$data['email'],'LR',0);
    }
    $pdf->Cell(60,5,$data['address'],'LR',1);
}














$pdf->Output();
?>

php fpdf

asked by Pablo Pernia 22.08.2017 в 14:44

source

2 answers

Json poorly formed by PHP function How to make an increment of one value every 3 inserted records?

score 0 · Answer 1

If what you want to do is like a history with the patient's data you could make a template

$plantilla .= ('
            <table>
                <tr>
                    <td> Nombre del paciente: '. $data['nombre_paciente'] .' </td>
                    <td> Nombre del paciente: '. $data['apellido_paciente'] .' </td>
                    <td> Nombre del paciente: '. $data['edad_paciente'] .' </td>
                    <td> Nombre del paciente: '. $data['telefono_paciente'] .' </td> 
                </tr>
            </table>
          ');
//Al final de armarla copias WriteHTML
$pdf->WriteHTML($plantilla);

score 0 · Answer 2

I need something very similar and I think it will help the director of this initial consultation

I have a clinical history per patient. What I need is to show the data already stored in the HClinica table in the report, but all those that have that same patient in other words that do not show me one on each sheet of the same patient. that within the same sheet I will be showing all the clinical records of the same patient that does not repeat the header with the same patient's data but shows all the stories one below the other of that same patient and if I look for another one equal