<?php
error_reporting(E_ALL);

if(
   empty($_POST['nickname']) OR
      empty($_POST['kennwort']) OR
         empty($_POST['email1']) OR
            empty($_POST['email2']) OR
               empty($_POST['sichfra']) OR
                  empty($_POST['vorname']) OR
                     empty($_POST['nachname']) OR
                        empty($_POST['strasse']) OR
                           empty($_POST['hausnr']) OR
                              empty($_POST['plz']) OR
                                 empty($_POST['ort']) OR
                                    empty($_POST['land'])
  )
  {
   header("Location: fehler0003.php");
   exit();
  }
 ;

//Serveradresse
$mysql_host = "localhost";

//MySQL User
$mysql_user = "root";

//MySQL Passwort
$mysql_pw = "";

//MySQL Datenbank
$mysql_dbname = "website";

//Verbindungsaufbau
@$db = mysql_connect ($mysql_host, $mysql_user, $mysql_pw) or die (mysql_errno().":". mysql_error());
@mysql_select_db($mysql_dbname, $db) or die(mysql_errno().":". mysql_error());

$sql = "SELECT
			*
        FROM
            `user`
        WHERE
			`nickname`='".$_POST['nickname']."' OR
			`email1` = '".$_POST['email1']."' OR
			`email2` = '".$_POST['email2']."'";

$found = false;

$result = mysql_query($sql);

while($row = mysql_fetch_assoc($result)) {
	if($row['nickname'] == "`nickname`") {
       header("Location: fehler0004.php");
	}
	if($row['email1'] == "".$email1."" OR $row['email2'] == "".$email2."") {
   header("Location: fehler0005.php");
	}
}

if(empty($errmsg)) {
	mysql_query("INSERT INTO user
    		        	 (nickname,
           		 	     kennwort,
          			   	 email1,
			             email2,
			             sichfra,
			             sichant,
			             vorname,
			             nachname,
			             strasse,
			             hausnr,
			             plz,
			             ort,
			             land
			            )
			             VALUES
			            ('$nickname',
			             MD5('$kennwort'),
			             '$email1',
			             '$email2',
			             '$sichfra',
			             '$sichant',
			             '$vorname',
			             '$nachname',
			             '$strasse',
			             '$hausnr',
			             '$plz',
			             '$ort',
			             '$land')");

   header("Location: index.php");
}
else {
 header("Location: fehler0006.php");
}
Mysql_close();

?>