phpBB.de

Code: Alles auswählen

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method=post>
Benutzername:<input type="text" size="40" maxlength="35" name="name"><br>
Passwort:<input type="password" size="40" maxlength="35" name="passwort"><br>
Icq Nummer:<input type="text" size="40" maxlength="9" name="icq"><br>
Wohnort:<input type="text" size="40" maxlength="38" name="wohnort"><br>
<input type="submit" value="Registrieren">
</form>
<?php
include ("dbconnect.php");
$name = "'".mysql_real_escape_string($_POST['name']) . "'";
$passwort = "'".mysql_real_escape_string($_POST['passwort']) . "'";
$icq = "'".mysql_real_escape_string($_POST['icq']) . "'";
$wohnort = "'".mysql_real_escape_string($_POST['wohnort']) . "'";
$sql_update = "SELECT name FROM User WHERE name=$name";
$sql_update_now = mysql_query($sql_update);
$row = mysql_fetch_assoc($sql_update_now);
$exist_name = $row['name'];
$name = strtolower($name);
if (!isset ($exist_name))
{
echo "Der Benutzername existiert bereits, bitte wähle einen anderen";
}
else
{
$db_update = "INSERT INTO User (name, passwort, icq, wohnort) VALUES ($name, $passwort, $icq, $wohnort)";
		$db_update_now = mysql_query($db_update) OR die("SQL FEHLER:<br>" . mysql_error() . "<br><br>SQL Code:<br>" . $db_update);
?>