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);
