Logo Search packages:      
Sourcecode: odontolinux version File versions  Download package

visioneanagrafica.php

<? require("testa.php");?>

<B><? echo gettext ("List of all patients");?></B><P>

<TABLE Border="0">
 <TR>
  <TH><? echo gettext ("Surname");?></TH>
  <TH><? echo gettext ("Name");?></TH>
  <TH><? echo gettext ("ID");?></TH>      
  <TH><? echo gettext ("First visit");?></TH>   
  <TH><? echo gettext ("City of birth");?></TH>
</TR><TR><TH><? echo gettext ("birthdate");?></TH>
  <TH><? echo gettext ("Address");?></TH>
  <TH><? echo gettext ("ZIP");?></TH>
  <TH><? echo gettext ("City");?></TH>
  <TH><? echo gettext ("Job");?></TH>
  <TH><? echo gettext ("Phone");?></TH>
 </TR>

<?
   pg_Exec($conn,"SET DATESTYLE TO 'European';");
   $esito = pg_Exec($conn,
            "SELECT * FROM anagrafica ORDER BY cognome;");
   if (!$esito) {
                 echo "Si &egrave; verificato un errore.\n";
                 exit;
                 } // Errore interrogazione database
   $num = pg_NumRows($esito);
   $i = 0;
   while ($i < $num) {
                      echo "<TR><TD>";
                      echo "<FONT COLOR=\"#FF0000\">";
                      echo pg_Result($esito, $i, "cognome");
                      echo "</FONT></TD><TD><FONT COLOR=\"#FF0000\">";
                      echo pg_Result($esito, $i, "nome");
                      echo "</FONT></TD><TD>";
                      echo pg_Result($esito, $i, "id");
                      echo "</TD><TD>";
                      echo pg_Result($esito, $i, "dataarrivo");
                      echo "</TD><TD>";
                      echo pg_Result($esito, $i, "luogonascita");
                      echo "</TD></TR><TR><TD>";
                      echo pg_Result($esito, $i, "datanascita");
                      echo "</TD><TD>";
                      echo pg_Result($esito, $i, "via");
                      echo "</TD><TD>";
                      echo pg_Result($esito, $i, "cap");
                      echo "</TD><TD>";
                      echo pg_Result($esito, $i, "citta");
                      echo "</TD><TD>";
                      echo pg_Result($esito, $i, "professione");
                      echo "</TD><TD>";
                      echo pg_Result($esito, $i, "telefono");
                      echo "</TD><TR><TD COLSPAN=\"6\"><HR NOSHADE SIZE=\"2\"></TD></TR>";
                      $i++;
                     } // Estrazione delle righe dell'interrogazione
   pg_FreeResult($esito);
?>

</TR></TABLE>

<? include("piede.php");?>

Generated by  Doxygen 1.6.0   Back to index