<?php
include 'db.php';

if (!isset($_POST['username']))
{
  $username = $_POST['username'];
  $pw = $_POST['password'];
  $email = $_POST['mail'];
  $password = sha1($pw);
  $password = stringslashes($password);
  $username = stripslashes($username);
  $email = stripslashes($email);
  $username = strtolower(trim(strip_tags($username)));
  $rank = 1;
  $query = mysql_query("SELECT * FROM users WHERE username ='$username'");
    $aantalrijen = mysql_num_rows($query);
    if($aantalrijen == 1){
      header("Location: register.php");
      }
      else{
         $query1 = "INSERT INTO users(username, password, email, rank) VALUES ('$username','$password', '$email','$rank')";
         if(mysql_query($query1)){
            echo "test";
         }
      }
}
?>