fhiiqm/inc/tel_dat_show.inc.php
changeset 32 c2d325791e24
child 34 fc60ef80a7ad
equal deleted inserted replaced
31:0a1eb975fbd9 32:c2d325791e24
       
     1 <?php
       
     2 
       
     3 /**
       
     4  * @author Bettina Schwarzer, Fritz-Haber-Institut
       
     5  * @copyright 11/2012
       
     6  * 
       
     7  * Anlisten INSERT/UPDATE Daten Mitarbeiter - Telefon
       
     8  */
       
     9 
       
    10             echo "<table>\n";
       
    11             echo "<tr><td>Nummer: </td><td>" . $tf["tel"] . "</td></tr>\n";
       
    12             $tt = ($tf["typ"] == "fax")? strtoupper($tf["typ"]) : $tf["typ"];
       
    13             echo "<tr><td>Typ: </td><td>$tt</td></tr>\n";
       
    14             if ($tf["raum"] > "-1")
       
    15             {
       
    16                 $sql = "SELECT raum_nr, geb_ID FROM Raum WHERE raum_ID=" . $tf["raum"];
       
    17                 if ($res = $dbc -> queryObjectArray($sql))
       
    18                 {
       
    19                     foreach ($res as $row)
       
    20                     echo "<tr><td>Ort: </td><td>" . $row->geb_ID . "&nbsp;" . $row->raum_nr ."</td></tr>\n";
       
    21                 }
       
    22             }
       
    23             else
       
    24                 echo "<tr><td>Ort: </td><td>&nbsp;</td></tr>\n";
       
    25             echo "</table>\n";
       
    26 
       
    27 
       
    28 ?>