<?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(mysql_num_rows($data) >= 1) {
                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 } ?>