<h1>Join Us</h1>
 
  <form action="save_join.php" method=get >
   <h5>Angaben zur Person</h5>
    <br>
   Anrede:
    <br>
   <select name="Anrede" size="1">
      <option></option>
	  <option>Herr</option>
      <option>Frau</option>
     </select>
    <br>
   Name:
    <br>
   <input type=text size=60 name="Name">
    <br>
   Vorname:
    <br>
   <input type=text size=60 name="Vorname">
    <br>
   Straße/Hausnummer:
    <br>
   <input type=text size=45 name="Strasse">
   <input type=text size=10 name="Hausnummer">
    <br>
   PLZ/Ort:
    <br>
   <input type=text size=10 name="PLZ">
   <input type=text size=45 name="Ort">
	<br>
   Land:
    <br>
   <select name="Land" size="1">
      <option></option>
	  <option>Deutschland</option>
      <option>Österreich</option>
	  <option>Schweiz</option>
	  <option>---------------</option>
	  <option>Australien</option>
	  <option>Belgien</option>
	  <option>Brasilien</option>
	  <option>Bulgarien</option>
	  <option>China</option>
	  <option>Dänemark</option>
	  <option>Dubai</option>
	  <option>Estland</option>
	  <option>Finnland</option>
	  <option>Frankreich</option>
	  <option>Griechenland</option>
	  <option>Großbritannien</option>
	  <option>Indien</option>
	  <option>Italien</option>
	  <option>Japan</option>
	  <option>Kanada</option>
	  <option>Kroatien</option>
	  <option>Lichtenstein</option>
	  <option>Luxemburg</option>
	  <option>Mexiko</option>
	  <option>Monaco</option>
	  <option>Neuseeland</option>
	  <option>Niederlande</option>
	  <option>Norwegen</option>
	  <option>Polen</option>
	  <option>Portugal</option>
	  <option>Rumänien</option>
	  <option>San Marino</option>
	  <option>Schweden</option>
	  <option>Slowenien</option>
	  <option>Spanien</option>
	  <option>Südkorea</option>
	  <option>Tschechien</option>
	  <option>Türkei</option>
	  <option>Ungarn</option>
	  <option>Vereinigte Staaten von Amerika</option>
	  <option>Zypern</option>
	  </select>
    <br>
	<br>
	<br>
   <h5>Gamerdaten</h5>
   <br>
   Nickname:
    <br>
   <input type=text size=60 name="Nickname">
   <br>
   Games:
   <br>
   <select name="Game1" size="1">
      <option></option>
	  <option>League of Legends</option>
      <option>Minecraft</option>
	  <option>S4 League</option>
   </select>
   <br>
   <br>
   <select name="Game2" size="1">
      <option></option>
	  <option>League of Legends</option>
      <option>Minecraft</option>
	  <option>S4 League</option>
   </select>
	<br>
	<br>
   <select name="Game3" size="1">
      <option></option>
	  <option>League of Legends</option>
      <option>Minecraft</option>
	  <option>S4 League</option>
   </select>
	<br>
    <br>
   <h5>Kontaktmöglichkeiten</h5>
    <br>
   Telefonnummer (optional):
    <br>
   <input type=text size=60 name="Telefonnummer">
    <br>
   Handynummer (optional):
    <br>
   <input type=text size=60 name="Handynummer">
    <br>
   E-Mail:
    <br>
   <input type=text size=60 name="Mail">
    <br>
   Skype (optional):
    <br>
   <input type=text size=60 name="Skype">
    <br>
   XFire (optional):
    <br>
   <input type=text size=60 name="XFire">
    <br>
   MSN (optional):
    <br>
   <input type=text size=60 name="MSN">
    <br>
   Web-Adresse (optional):
    <br>
   <input type=text size=60 name="Web">
    <br>
	<br>
	<br>
   <input type=radio name="AGB">  Ich bestätige hiermit, dass ich die <a href="AGB.php">AGB</a> gelesen habe
	<br>
	<br>
	<br>
   <input type=submit value=Senden>
   </p>
   </form>

<p><h1>Deine Daten:</h1></br></br>
		 
		 <?php
  $Anrede = $_REQUEST['Anrede'];
  $Name = $_REQUEST['Name'];
  $Vorname = $_REQUEST['Vorname'];
  $Strasse = $_REQUEST['Strasse'];
  $Hausnummer = $_REQUEST['Hausnummer'];
  $PLZ = $_REQUEST['PLZ'];
  $Ort = $_REQUEST['Ort'];
  $Land = $_REQUEST['Land'];
  $Nickname = $_REQUEST['Nickname'];
  $Game1 = $_REQUEST['Game1'];
  $Game2 = $_REQUEST['Game2'];
  $Game3 = $_REQUEST['Game3'];
  $Telefonnummer = $_REQUEST['Telefonnummer'];
  $Handynummer = $_REQUEST['Handynummer'];
  $Mail = $_REQUEST['Mail'];
  $Skype = $_REQUEST['Skype'];
  $XFire = $_REQUEST['XFire'];
  $MSN = $_REQUEST['MSN'];
  $Web = $_REQUEST['Web'];
  $AGB = $_REQUEST['AGB'];
  
  $dbname="db rappler";
  $dbhost="localhost";
  $dbuser="root";
  $dbpass="";
  $con = mysql_connect($dbhost,$dbuser,$dbpass);
   if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
  mysql_select_db($dbname, $con);

  mysql_query (
  $QUERY = "INSERT INTO join us (anrede, name, vorname, strasse, hausnummer, plz, ort, land, nickname, game1, game2, game3,
                                 telefonnummer, handynummer, email, skype, xfire, msn, webadresse, agb)
           VALUES ('" . $Anrede . "', '" . $Name . "', '" . $Vorname . "', '" . $Strasse . "', '" . $Hausnummer . "',
		   '" . $PLZ . "', '" . $Ort . "', '" . $Land . "', '" . $Nickname . "', '" . $Game1 . "', '" . $Game2 . "',
		   '" . $Game3 . "','" . $Telefonnummer . "', '" . $Handynummer . "',
		   '" . $Mail . "', '" . $Skype . "', '" . $XFire . "', '" . $MSN . "', '" . $Web . "', '" . $AGB . "',)");
  
	
    echo "Anrede: $Anrede<br>";
	echo "Name: $Name<br>";
	echo "Vorname: $Vorname<br>";
	echo "Straße: $Strasse<br>";
	echo "Hausnummer: $Hausnummer<br>";
	echo "PLZ: $PLZ<br>";
	echo "Ort: $Ort<br>";
	echo "Land: $Land<br><br>";
	echo "Nickname: $Nickname<br>";
	echo "Games: $Game1<br>";
	echo "       $Game2<br>";
	echo "       $Game3<br><br>";
	echo "Telefonnummer: $Telefonnummer<br>";
	echo "Handynummer: $Handynummer<br>";
	echo "Mail: $Mail<br>";
	echo "Skype: $Skype<br>";
	echo "XFire: $XFire<br>";
	echo "MSN: $MSN<br>";
	echo "Web: $Web<br>";
	echo "AGB: $AGB";
	
   mysql_close($con)
   ?>