if ($stmt->prepare($sql)) { $stmt->bind_param('i', $_GET['codigo']); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows == 1) { $date = new DateTime(); $rows = $result->fetch_object(); $pdf = new Contrato("P", "mm", "Letter"); $pdf->setAuthor('SSPHCM - Oficinas en Linea Falcon C.A.'); $pdf->setTitle('CONTRATO DE POLIZA HCM - SSPHCM'); $pdf->AliasNbPages(); $pdf->AddPage(); list($anio, $mes, $dia) = explode("-", $rows->fecren); $date->setDate((int) $anio, (int) $mes, (int) $dia); $fechanueva = $date->format('d/m/Y'); $pdf->Cell(65, 5, 'Fecha de Renovacion:', 0, 0, 'C'); $pdf->Cell(32, 5, $fechanueva, 0, 0, 'C'); $pdf->Cell(65, 5, 'Fecha de Inscripcion:', 0, 0, 'C'); list($anio, $mes, $dia) = explode("-", $rows->ingreso); $date->setDate((int) $anio, (int) $mes, (int) $dia); $fechanueva = $date->format('d/m/Y'); $pdf->Cell(32, 5, $fechanueva, 0, 1, 'C'); $pdf->Cell(35, 5, 'Cedula:', 'LT', 0); $cedula = str_pad($rows->cedtit, 10, "0", STR_PAD_LEFT); $pdf->Cell(35, 5, $rows->abrev . " " . $cedula, 'T', 0); $pdf->Cell(35, 5, 'Codigo:', 'T', 0); $pdf->Cell(35, 5, $_GET['codigo'], 'T', 0); $pdf->Cell(54, 5, '', 'TR', 1, 'C'); //194 $pdf->Cell(40, 5, 'Apellidos:', 'L', 0); $pdf->Cell(57, 5, $rows->apetit, 0, 0);