PHP-Code:
<?
$seite=base64_encode("h300_edit.php");
include("./login_check.inc.php");
include("./conf.inc.php");
include("./function.inc.php");
include("./header.inc.php");
include("./hauptmenue.php");
$id=$_GET[id];
if ($id==FALSE)
{
$id=$_POST[c_id];
}
?>
<p class="ueber">TK - Anlage <? echo $id; ?> ändern</p>
<?
if (isset($_POST[speichern]))
{
$id=$_POST[c_id];
echo "<br>";
$checked="2";
mysql_connect($host, $dbuser, $dbpasswd);
mysql_select_db($db);
$ch_res=mysql_query("SELECT * FROM anl_h300 WHERE id NOT LIKE '$_POST[c_id]'");
if ($_POST[b_id]==FALSE)
{
echo "<center><b><font color=\"red\" style=\"font-size: 14;\">ID <font color=\"black\">muss angegeben werden!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_kennung]==FALSE)
{
echo "<center><b><font color=\"red\" style=\"font-size: 14;\">Kennung <font color=\"black\">muss angegeben werden!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_domain]==FALSE)
{
echo "<center><b><font color=\"red\" style=\"font-size: 14;\">Domain <font color=\"black\">muss angegeben werden!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_plz]==FALSE)
{
echo "<center><b><font color=\"red\" style=\"font-size: 14;\">PLZ <font color=\"black\">muss angegeben werden!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_ort]==FALSE)
{
echo "<center><b><font color=\"red\" style=\"font-size: 14;\">Ort <font color=\"black\">muss angegeben werden!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_strasse]==FALSE)
{
echo "<center><b><font color=\"red\" style=\"font-size: 14;\">Strasse <font color=\"black\">muss angegeben werden!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_bezirk]==FALSE)
{
echo "<center><b><font color=\"red\" style=\"font-size: 14;\">Bezirk <font color=\"black\">muss angegeben werden!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_vorwahl]==FALSE)
{
echo "<center><b><font color=\"red\" style=\"font-size: 14;\">Vorwahl <font color=\"black\">muss angegeben werden!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_pilot]==FALSE)
{
echo "<center><b><font color=\"red\" style=\"font-size: 14;\">Pilot <font color=\"black\">muss angegeben werden!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_einwahl]==FALSE)
{
echo "<center><b><font color=\"red\" style=\"font-size: 14;\">Einwahl <font color=\"black\">muss angegeben werden!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_rnb]==FALSE)
{
echo "<center><b><font color=\"red\" style=\"font-size: 14;\">Rufnummerblock <font color=\"black\">muss angegeben werden!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_knotennummer]==FALSE)
{
echo "<center><b><font color=\"red\" style=\"font-size: 14;\">Knotennummer <font color=\"black\">muss angegeben werden!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_angebunden]==FALSE)
{
echo "<center><b><font color=\"red\" style=\"font-size: 14;\">Angebunden an <font color=\"black\">muss angegeben werden!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_version]==FALSE)
{
echo "<center><b><font color=\"red\" style=\"font-size: 14;\">Version <font color=\"black\">muss angegeben werden!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_l_nummer]==FALSE)
{
echo "<center><b><font color=\"red\" style=\"font-size: 14;\">L-Nummer <font color=\"black\">muss angegeben werden!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_ebene]==FALSE)
{
echo "<center><b><font color=\"red\" style=\"font-size: 14;\">Ebene <font color=\"black\">muss angegeben werden!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_ip]==FALSE)
{
$_POST[b_ip]="-----";
}
if ($_POST[b_prf_tln]==FALSE)
{
$_POST[b_prf_tln]="-----";
}
if ($_POST[b_prf_tln_lage]==FALSE)
{
$_POST[b_prf_tln_lage]="-----";
}
if ($_POST[b_mozart]==FALSE)
{
$_POST[b_mozart]="-----";
}
while ($row=mysql_fetch_array($ch_res))
{
if ($_POST[b_id]==$row[id])
{
echo "<center><b><font color=\"black\" style=\"font-size: 14;\">ID <font color=\"red\">$_POST[b_id]<font color=\"black\"> existiert bereits!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_kennung]==$row[kennung])
{
echo "<center><b><font color=\"black\" style=\"font-size: 14;\">Kennung <font color=\"red\">$_POST[b_kennung]<font color=\"black\"> existiert bereits!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_knotennummer]==$row[knotennummer])
{
echo "<center><b><font color=\"black\" style=\"font-size: 14;\">Knotennummer <font color=\"red\">$_POST[b_knotennummer]<font color=\"black\"> existiert bereits!</b><br></center></font>";
$checked=1;
}
if ($_POST[b_l_nummer]==$row[l_nummer])
{
echo "<center><b><font color=\"black\" style=\"font-size: 14;\">L-Nummer <font color=\"red\">$_POST[b_l_nummer]<font color=\"black\"> existiert bereits!</b><br></center></font>";
$checked=1;
}
}
if ($checked==2)
{
$res=mysql_query("UPDATE anl_h300 SET id='$_POST[b_id]',
region='$_POST[b_region]',
domain='$_POST[b_domain]',
plz='$_POST[b_plz]',
ort='$_POST[b_ort]',
strasse='$_POST[b_strasse]',
bezirk='$_POST[b_bezirk]',
kennung='$_POST[b_kennung]',
basa='$_POST[b_basa]',
vorwahl='$_POST[b_vorwahl]',
pilot='$_POST[b_pilot]',
einwahl='$_POST[b_einwahl]',
ip='$_POST[b_ip]',
rnb='$_POST[b_rnb]',
prf_tln='$_POST[b_prf_tln]',
prf_tln_lage='$_POST[b_prf_tln_lage]',
knotennummer='$_POST[b_knotennummer]',
angebunden='$_POST[b_angebunden]',
mozart='$_POST[b_mozart]',
dtb='$_POST[b_dtb]',
phonemail='$_POST[b_phonemail]',
hw_typ='$_POST[b_hw_typ]',
hw_arch='$_POST[b_hw_arch]',
version='$_POST[b_version]',
l_nummer='$_POST[b_l_nummer]',
ebene='$_POST[b_ebene]'
WHERE id='$_POST[c_id]'");
if ($res==1) { echo "<meta http-equiv=\"refresh\" content=\"0; URL=./einzel_h300.php?id=$_POST[b_id]\">"; }
else { echo "<center><br><font color=\"red\"><b>TK-Anlage ändern: Failed</b></font></center>"; }
}
mysql_close();
}
else {
mysql_connect($host, $dbuser, $dbpasswd);
mysql_select_db($db);
$result_h300=mysql_query("SELECT * FROM anl_h300 where id='$_GET[id]'");
$_POST[b_id]=mysql_result($result_h300, 0, "id");
$_POST[b_region]=mysql_result($result_h300, 0, "region");
$_POST[b_domain]=mysql_result($result_h300, 0, "domain");
$_POST[b_plz]=mysql_result($result_h300, 0, "plz");
$_POST[b_ort]=mysql_result($result_h300, 0, "ort");
$_POST[b_strasse]=mysql_result($result_h300, 0, "strasse");
$_POST[b_bezirk]=mysql_result($result_h300, 0, "bezirk");
$_POST[b_kennung]=mysql_result($result_h300, 0, "kennung");
$_POST[b_basa]=mysql_result($result_h300, 0, "basa");
$_POST[b_vorwahl]=mysql_result($result_h300, 0, "vorwahl");
$_POST[b_pilot]=mysql_result($result_h300, 0, "pilot");
$_POST[b_einwahl]=mysql_result($result_h300, 0, "einwahl");
$_POST[b_ip]=mysql_result($result_h300, 0, "ip");
$_POST[b_rnb]=mysql_result($result_h300, 0, "rnb");
$_POST[b_prf_tln]=mysql_result($result_h300, 0, "prf_tln");
$_POST[b_prf_tln_lage]=mysql_result($result_h300, 0, "prf_tln_lage");
$_POST[b_knotennummer]=mysql_result($result_h300, 0, "knotennummer");
$_POST[b_angebunden]=mysql_result($result_h300, 0, "angebunden");
$_POST[b_mozart]=mysql_result($result_h300, 0, "mozart");
$_POST[b_dtb]=mysql_result($result_h300, 0, "dtb");
$_POST[b_phonemail]=mysql_result($result_h300, 0, "phonemail");
$_POST[b_hw_typ]=mysql_result($result_h300, 0, "hw_typ");
$_POST[b_hw_arch]=mysql_result($result_h300, 0, "hw_arch");
$_POST[b_version]=mysql_result($result_h300, 0, "version");
$_POST[b_l_nummer]=mysql_result($result_h300, 0, "l_nummer");
$_POST[b_ebene]=mysql_result($result_h300, 0, "ebene");
mysql_close();
}
Lesezeichen