<?php
$host = localhost;
$user = couxakqb_lid2;
$pass = *******;
$db   =  couxakqb_lid1;;

mysql_connect("$host", "$user", "$pass");
mysql_select_db("$db");

IF($_POST['register']) {
    $username = TRIM($_POST['username']);
    $password = TRIM($_POST['password']);
    IF(!$username == "" && !$password == "") {
        IF($_POST['password'] == $_POST['passopnieuw']) {
            $data = mysql_query("SELECT * FROM shady_beheer WHERE gebruikersnaam='" . $username . "'");
            IF(!$data) {
                mysql_query("INSERT INTO shady_beheer (gebruikersnaam, wachtwoord) VALUES ('" . $username . "', '" . $password . "')");
                echo 'Je account is aangemaakt. <a href="index.php">Log direct in</a>';
            } ELSE {
                echo "Deze gebruikersnaam is al in gebruik.";
            }
        } ELSE {
            echo "De wachtwoorden komen niet met elkaar overeen.";
        }
    } ELSE {
        echo "Vul alle velden in.";
    }
} ELSE {
?>


   <TABLE width="500" cellpadding="2">
   <tr>
     <td width="100%" colspan="2"><b>Nieuw ledenaccount</b></td>

   </tr>
   <tr>

<form method="post" action="#">
   <tr>
 <td width="35%">Gebruikersnaam:</td>
<td width="65%"><input TYPE="text" name="username" /></td> <br />
</tr>


   <tr>
<td width="35%">Wachtwoord:</td>
<td width="65%"><input TYPE="text"  name="password" /></td> <br />
     </tr>

   <tr>
<td width="35%">Wachtwoord opnieuw:</td>
<td width="65%"><input TYPE="text" name="passopnieuw" /></td> <br />
</tr>

<td width="100%" colspan="2"><input TYPE="submit" name="register" VALUE="Registreer" /></td>
  </tr>
   </table>
   </form>

<?php } ?>