<? include ('inc/header.php') ?>
<?
$date = date("d.m.Y") ;
?>
<html>
<head>
<title>Kein Titel</title>
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<form action="<? $PHPSELF ?>" method=post>
<table cellpadding="0" cellspacing="0" width="100%">
<tr>
<td colspan="3" width="975"></td>
</tr>
<?
$max = "SELECT MAX(kunden_id) AS max from kunden";
$result = mysql_db_query ($dbname, $max, $dbverbindung);
$ausgabe_max = mysql_fetch_array ($result);
$wert = $ausgabe_max['max']+1;
?>
<tr>
<td height="7" width="181" valign="top"><? include ('inc/navigation.php') ?></td>
<td width="20" height="7"> </td>
<td width="774" height="7">
<table cellpadding="0" cellspacing="0" width="100%">
<tr>
<td class="main" width="182" valign="top">Datum:</td>
<td class="main" width="592"> <? echo $date ; ?></td>
</tr>
<tr>
<td class="main" width="182" height="25">Kunden-Nummer:</td>
<td class="main" width="592" height="25"><? echo $wert; ?></td>
</tr>
<tr>
<td class="main" width="182" height="1" valign="top">Kunden-Gruppe:</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_gruppe" size= "20"></td>
</tr>
<tr>
<td width="182" height="1" valign="top"> </td>
<td width="592" height="23" valign="top"> </td>
</tr>
<tr>
<td class="main" width="182" height="1" valign="top">Anrede:</td>
<td class="main" width="592" height="23" valign="top"><select name="kunden_anrede" size="1">
<option>Herr</option>
<option>Frau</option>
<option>Firma</option>
</select></td>
</tr>
<tr>
<td class="main" width="182" height="11" valign="top">Firma:</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_firma" size= "20"></td>
</tr>
<tr>
<td class="main" width="182" height="11" valign="top">Vorname:</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_vorname" size= "20"></td>
</tr>
<tr>
<td class="main" width="182" height="1" valign="top">Nachname</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_nachname" size= "20"></td>
</tr>
<tr>
<td class="main" width="182" height="11" valign="top">Titel:</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_titel" size= "20"></td>
</tr>
<tr>
<td class="main" width="182" height="11" valign="top">Zusatz:</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_zusatz" size= "20"></td>
</tr>
<tr>
<td width="182" height="11" valign="top"> </td>
<td width="592" height="23" valign="top"> </td>
</tr>
<tr>
<td class="main" width="182" height="1" valign="top">Straße/Haus-Nr.:</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_strasse" size= "20"></td>
</tr>
<tr>
<td class="main" width="182" height="1" valign="top">PLZ/ Wohnort</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_ort" size= "20"></td>
</tr>
<tr>
<td class="main" width="182" height="1" valign="top">Land:</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_land" size= "20"></td>
</tr>
<tr>
<td width="182" height="1" valign="top"> </td>
<td width="592" height="23" valign="top"> </td>
</tr>
<tr>
<td class="main" width="182" height="5" valign="top">Email:</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_email" size= "20"></td>
</tr>
<tr>
<td class="main" width="182" height="5" valign="top">Telefon:</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_telefon" size= "20"></td>
</tr>
<tr>
<td class="main" width="182" height="5" valign="top">Telefax:</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_telefax" size= "20"></td>
</tr>
<tr>
<td class="main" width="182" height="5" valign="top">Handy:</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_handy" size= "20"></td>
</tr>
<tr>
<td class="main" width="182" height="5" valign="top">Website:</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_website" size= "20"></td>
</tr>
<tr>
<td class="main" width="182" height="5" valign="top">Kontakt-Person:</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_kontakt" size= "20"></td>
</tr>
<tr>
<td width="182" height="5" valign="top"> </td>
<td width="592" height="23" valign="top"> </td>
</tr>
<tr>
<td class="main" width="182" height="5" valign="top">Benutzername:</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_benutzername" size= "20"></td>
</tr>
<tr>
<td class="main" width="182" height="5" valign="top">Passwort:</td>
<td width="592" height="23" valign="top"><input class="inputboxen" type=text name="kunden_passwort" size= "20"></td>
</tr>
<tr>
<td width="182" height="5" valign="top"> </td>
<td width="592" height="23" valign="top"> </td>
</tr>
<tr>
<td class="main" width="182" height="5" valign="top">Bemerkungen:</td>
<td width="592" height="23" valign="top"> <textarea class="inputboxen" name="kunden_bemerkung" rows=8 cols=49></textarea></td>
</tr>
<tr>
<td width="182" height="5" valign="top"> </td>
<td width="592" height="23" valign="top"> </td>
</tr>
<tr>
<td width="182" height="5" valign="top"> </td>
<td width="592" height="23" valign="top"><input type=submit name="SUBMIT" value="Anlegen"></td>
</tr>
<tr>
<td width="182" height="5" valign="top"> </td>
<td width="592" height="23" valign="top"> </td>
</tr>
<tr>
<td width="182" height="5" valign="top"> </td>
<td width="592" height="23" valign="top"> </td>
</tr>
<tr>
<td width="182" height="5" valign="top"> </td>
<td width="592" height="23" valign="top"> </td>
</tr>
</table></form>
</td>
</tr>
<tr>
<td height="7" colspan="3" width="975"><? include ('inc/footer.php') ?></td>
</tr>
</table>
</body>
<?
if(($SUBMIT) && $SUBMIT == "Anlegen") {
$dbanfrage = "INSERT into kunden values ('', '$kunden_nummer', '$kunden_gruppe', '$kunden_anrede', '$kunden_firma', '$kunden_vorname', '$kunden_nachname', '$kunden_titel', '$kunden_zusatz', '$kunden_strasse', '$kunden_ort', '$kunden_land', '$kunden_email', '$kunden_telefon', '$kunden_telefax', '$kunden_handy', '$kunden_website', '$kunden_kontakt', '$kunden_benutzername', '$kunden_passwort', '$kunden_bemerkung', '', '$datum' )"; }
if (mysql_db_query ($dbname, $dbanfrage, $dbverbindung)) {
print ("Datenbankeintrag erfolgreich.");
} else {
print ("Es traten Probleme auf.");
}
header('Location: boxen_neu.php');
?>