Ecco spiegato qui il problema: devo modificare per esempio questo file php in un file php che crei il PDF (ovviamente ho dovuto tagliare molte righe perchè non ci stanno in questa videata)
<?php
//pedigreedatabase,lupus-on-line
echo "<html>\n";
echo "<body>\n";
$nome_file_inc = "include/config.inc.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 ospite.NUM,ospite.NAME,albero.padre,albero.npadre, albero.hdpadre,albero.brepadre,albero.selpadre, ...WHERE trim(ospite.num)='".$num."'";
$result = mysql_query($sql, $global_db);
$nresult=0;
while ($ris = mysql_fetch_array($result)) {
$res[$nresult]["NUM"] = trim ($ris["NUM"]);
$res[$nresult]['name'] = htmlspecialchars (utf8_encode (trim ($res[0]["name"])),ENT_QUOTES);
$res[$nresult]["kb"] = utf8_encode (trim ($ris["kb"]));
$res[$nresult]["kb1"] = utf8_encode (trim ($ris["kb1"]));
$res[$nresult]["kb2"] = utf8_encode (trim ($ris["kb2"]));
$res[$nresult]["wider"] = $ris["wider"];
$res[$nresult]["brustief"] = $ris["brustief"];
$res[$nresult]["vorderbein"] = $ris["vorderbein"];
$res[$nresult]["brustang"] = $ris["brustang"];
$res[$nresult]["gewicht"] = $ris["gewicht"];
$res[$nresult]["padre"] = trim ($ris["padre"]);
$res[$nresult]["npadre"] = utf8_encode (trim ($ris["npadre"]));
$res[$nresult]["hdpadre"] = $ris["hdpadre"];
$res[$nresult]["brepadre"] = utf8_encode (trim ($ris["brepadre"]));
....
if ($res[$nresult]["NUM"]) {
$nresult++;
}
}
echo "<div align=\"center\">\n";
echo "<center>\n";
echo "<table border=\"1\" width=\"100%\" height=\"\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#FFFFFF\" bordercolor=\"#000000\">\n";
echo " <tr>\n";
echo " <td align=\"center\" width=\"21%\"><font face=\"Arial Narrow\" size=\"2\" color=\"#000000\">GENITORI</font></td>\n";
echo " <td align=\"center\" width=\"32%\"><font face=\"Arial Narrow\" size=\"2\" color=\"#000000\">NONNI</font></td>\n";
echo " <td align=\"center\" width=\"20%\"><font face=\"Arial Narrow\" size=\"2\" color=\"#000000\">BISNONNI</font></td>\n";
echo " <td align=\"center\" width=\"27%\"><font face=\"Arial Narrow\" size=\"2\" color=\"#000000\">TRISNONNI</font></td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td width=\"21%\" rowspan=\"8\" valign=\"top\">\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Padre </font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['npadre']."</font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Nr. </font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['padre']."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\"></font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['brepadre']."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Sel.=</font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['selpadre']."</font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Grado HD=</font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$ancaHD."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Qualifica=</font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".trim ($res[0]['zbpa'])."/".trim ($res[0]['zbnazpa'])." </font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Giudizio all.to : </font><font face=\"Vrinda\" size=\"1\" color=\"#000000\">".$res[0]['padrekb'].$res[0]['padrekb1'].$res[0]['padrekb2']."</font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Fratelli=</font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['fra1m']."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Sorelle=</font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['fra1f']."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\"></font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['fra1']."</font>\n";
echo " </td>\n";
echo " <td width=\"36%\" rowspan=\"4\" valign=\"top\">\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['nnonnopa']."</font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Nr. </font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['nonnopa']."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\"></font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['brenonnopa']."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Sel.=</font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['selnonnopa']."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Qualifica=</font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['zb3']."/".$res[0]['zbnaz3']."</font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Grado HD=</font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$ancaHD."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Giudizio all.to : </font><font face=\"Vrinda\" size=\"1\" color=\"#000000\">".$res[0]['nonnopakb'].$res[0]['nonnopakb1'].$res[0]['nonnopakb2']."</font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Fratelli=</font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['fra3m']."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Sorelle=</font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['fra3f']."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\"></font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['fra3']."</font>\n";
echo " </td>\n";
echo " <td rowspan=\"2\" width=\"21%\" valign=\"top\">\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['bis7name']."</font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Nr. </font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['bis7']."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\"></font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['bis7bre']."</font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Grado HD=</font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$ancaHD."</font>\n";
echo " </td>\n";
echo " <td width=\"23%\" valign=\"top\">\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['tri15name']."</font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Nr. </font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['tri15']."</font>\n";
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td width=\"23%\" valign=\"top\">\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['tri16name']."</font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Nr. </font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['tri16']."</font>\n";
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td rowspan=\"2\" width=\"21%\" valign=\"top\">\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['bis8name']."</font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Nr. </font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['bis8']."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\"></font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['bis8bre']."</font> \n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Grado HD=</font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$ancaHD."</font>\n";
echo " </td>\n";
echo " <td width=\"23%\" valign=\"top\">\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['tri17name']."</font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Nr. </font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['tri17']."</font>\n";
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td width=\"23%\" valign=\"top\">\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['tri18name']."</font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Nr. </font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['tri18']."</font>\n";
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td width=\"36%\" rowspan=\"4\" valign=\"top\">\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['nnonnapa']."</font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Nr. </font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['nonnapa']."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\"></font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['brenonnapa']."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Sel.=</font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['selnonnapa']."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Qualifica=</font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['zb4']."/".$res[0]['zbnaz4']."</font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Grado HD=</font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$ancaHD."</font>\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Giudizio all.to : </font><font face=\"Vrinda\" size=\"1\" color=\"#000000\">".$res[0]['nonnapakb'].$res[0]['nonnapakb1'].$res[0]['nonnapakb2']."</font>\n";
echo "
<font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">Fratelli=</font><font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['fra4m']."</font>\n";
echo " Sorelle=".$res[0]['fra4f']."\n";
echo "
".$res[0]['fra4']."\n";
echo " </td>\n";
echo " <td rowspan=\"2\" width=\"21%\" valign=\"top\">\n";
echo " <font face=\"Arial Narrow\" size=\"1\" color=\"#000000\">".$res[0]['bis9name']."\n";
echo "
Nr. ".$res[0]['bis9']."\n";
echo " ".$res[0]['bis9bre']."\n";
echo "
Grado HD=".$ancaHD."\n";
echo " </td>\n";
echo " <td width=\"23%\" valign=\"top\">\n";
echo " ".$res[0]['tri19name']."\n";
echo "
Nr. ".$res[0]['tri19']."\n";
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td width=\"23%\" valign=\"top\">\n";
echo " ".$res[0]['tri20name']."\n";
echo "
Nr. ".$res[0]['tri20']."\n";
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td rowspan=\"2\" width=\"21%\" valign=\"top\">\n";
echo " ".$res[0]['bis10name']."</font>\n";
echo "
Nr. ".$res[0]['bis10']."\n";
echo " ".$res[0]['bis10bre']."\n";
echo "
Grado HD=".$ancaHD."\n";
echo " </td>\n";
echo " <td width=\"23%\" valign=\"top\">\n";
echo " ".$res[0]['tri21name']."\n";
echo "
Nr. ".$res[0]['tri21']."\n";
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td width=\"23%\" valign=\"top\">\n";
echo " ".$res[0]['tri22name']."\n";
echo "
Nr. ".$res[0]['tri22']."\n";
echo " </td>\n";
echo " </tr>\n";
echo "</table>\n";
}
echo "</div>\n";
$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);
}
}
echo "</body>\n";
echo "</html>\n";
?>