Ho provato a ridurre lo script che funziona se non richiamo tutta la parte che si collega al database. E qui è il mio problema perchè i dati li devo poi inserire nel PDF (parte finale all'interno di $tbl = <<<EOD ... EOD;
<?php
$nome_file_inc = "include/aperturadatabase.php";
if (file_exists("../".$nome_file_inc)) {
include_once ("../".$nome_file_inc);
}
else {
if (file_exists($nome_file_inc)) {
include_once ($nome_file_inc);
}
}
$sql = "SELECT tabella.ID,tabella.NOME,tabella.altro FROM tabella WHERE trim(tabella.ID)='".$ID."'";
//print $sql;
$result = mysql_query($sql,$global_db);
$nresult=0;
while ($ris = mysql_fetch_array($result)) {
$res[$nresult]["ID"] = trim ($ris["ID"]);
$res[$nresult]['nome'] = htmlspecialchars(utf8_encode($res[0]["nome"]),ENT_QUOTES);
$res[$nresult]["altro"] = $ris["altro"];
if ($res[$nresult]["ID"]) {
$nresult++;
}
}
//print "////".$nresult;
//var_dump($res);
require('/var/www/vhosts/nome del dominio/httpdocs/tcpdfPDF/config/lang/eng.php');
require('/var/www/vhosts/nome del dominio/httpdocs/tcpdfPDF/tcpdf.php');
$pdf = new TCPDF(PDF_PAGE_ORIENTATION,PDF_UNIT,PDF_PAGE_FORMA T,true,'UTF-8',false);
$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN,'',PDF_FON T_SIZE_MAIN));
$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA,'',PDF_FON T_SIZE_DATA));
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP,PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
$pdf->SetAutoPageBreak(TRUE,PDF_MARGIN_BOTTOM);
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
$pdf->setLanguageArray($l);
$pdf->SetFont('helvetica','',6);
$pdf->AddPage();
$tbl = <<<EOD
<table width="590" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="125" align="center">GENITORI
</td>
<td width="185" align="center">NONNI
</td>
<td width="120"align="center" >BISNONNI
</td>
<td width="160" align="center">TRISNONNI
</td>
</tr>
</table>
<table border="1" cellspacing="0" cellpadding="0" width="590">
<tr>
<td rowspan="8" width="125">Padre
1 text riga2
1 text riga3
1 text riga4
1 text riga5
1 text riga6
1 text riga7
1 text riga8
1 text riga9
1 text riga10
1 text riga11
1 text riga12
1 text riga13
1 text riga14
1 text riga15
1 text riga16
</td>
<td rowspan="4" width="185">nonnopa (3)
3 text riga2
3 text riga3
3 text riga4
3 text riga5
3 text riga6
3 text riga7
3 text riga8
</td>
<td rowspan="2" width="120">bis7
05 text riga2
05 text riga3
05 text riga4
</td>
<td width="160">bis15
16 text riga2
</td>
</tr>
<tr>
<td width="160">bis16
18 text riga2
</td>
</tr>
<tr>
<td rowspan="2" width="120">bis8
06 text riga2
06 text riga3
06 text riga4
</td>
<td width="160">bis17
20 text riga2
</td>
</tr>
<tr>
<td width="160">bis18
22 text riga2
</td>
</tr>
<tr>
<td rowspan="4" width="185">nonnapa (4)
4 text riga2
4 text riga3
4 text riga4
4 text riga5
4 text riga6
4 text riga7
4 text riga8
</td>
<td rowspan="2" width="120">bis9
07 text riga2
07 text riga3
07 text riga4
</td>
<td width="160">bis19
24 text riga2
</td>
</tr>
<tr>
<td width="160">bis20
26 text riga2
</td>
</tr>
<tr>
<td rowspan="2" width="120">bis10
08 text riga2
08 text riga3
08 text riga4
</td>
<td width="160">bis21
28 text riga2
</td>
</tr>
<tr>
<td width="160">bis22
30 text riga2
</td>
</tr>
</table>
EOD;
$pdf->writeHTML($tbl,true,false,false,false,'');
$pdf->Output('pedigreesolopadre.pdf');
$nome_file_inc = "include/uscitadatabase.php";
if (file_exists("../".$nome_file_inc)) {
include_once ("../".$nome_file_inc);
}
else {
if (file_exists($nome_file_inc)) {
include_once ($nome_file_inc);
}
}
?>