@mysql_connect("localhost","wwwnetadm","$dbpassword") or die("Connection died or wrong database password!"); mysql_select_db("net"); /* ======================================================================= */ if ($task=="austausch"): /* ======================================================================= */ /* Austausch 2er Rechner */ $pagetitle="Rechneraustausch"; $pageheadline="Austausch 2er Rechner"; include "../netheader.phtml"; include "../netfuncs.php"?>
include "../netfooter.phtml"; exit; endif; /* ======================================================================= */ if ($task=="makeaustausch"): /* ======================================================================= */ /* Austausch 2er Rechner durchfuehren */ $pagetitle="Rechneraustausch"; $pageheadline="Austausch 2er Rechner"; include "../netheader.phtml"; include "../netfuncs.php"; /* lade daten vom 1. rechner */ $select = "hostdb.id,hostdb.ip,hostdb.hostname,patchverbindung.id,patchverbindung.room,patchverbindung.dose"; $from = "hostdb,patchverbindung"; $rule = "where hostdb.id = $host1 and hostdb.id=patchverbindung.id"; $result=mysql_query( "SELECT $select FROM $from $rule"); $rechner1_name = mysql_result($result,0,"hostdb.hostname"); $rechner1_ip = mysql_result($result,0,"hostdb.ip"); $rechner1_room = mysql_result($result,0,"patchverbindung.room"); $rechner1_dose = mysql_result($result,0,"patchverbindung.dose"); /* lade daten vom 2. rechner */ $select = "hostdb.id,hostdb.ip,hostdb.hostname,patchverbindung.id,patchverbindung.room,patchverbindung.dose"; $from = "hostdb,patchverbindung"; $rule = "where hostdb.id = $host2 and hostdb.id=patchverbindung.id"; $result=mysql_query( "SELECT $select FROM $from $rule"); $rechner2_name = mysql_result($result,0,"hostdb.hostname"); $rechner2_ip = mysql_result($result,0,"hostdb.ip"); $rechner2_room = mysql_result($result,0,"patchverbindung.room"); $rechner2_dose = mysql_result($result,0,"patchverbindung.dose"); ?> Der Austausch von folgenden beiden Rechnern durchgeführt:| Austausch von | Rechner 1 | Rechner 2 |
| HOSTNAME | echo $rechner1_name?> | echo $rechner2_name?> |
| IP Adresse | echo $rechner1_ip?> | echo $rechner2_ip?> |
| im Raum | echo $rechner1_room?> | echo $rechner2_room?> |
| an TP-Dose | echo $rechner1_dose?> | echo $rechner2_dose?> |