this is my code:
<?php
include 'dbconnect.php';
session_start();
$username = $_POST['username'];
$password = $_POST['password'];
$repeatpassword = $_POST['repeatpassword'];
$email = $_POST['email'];
if ($username&&$password&&$repeatpassword&&$email) {
$connect;
$selectdb;
$query = mysql_query("SELECT * FROM users WHERE naam='$username'");
$numrows = mysql_num_rows($query);
if($numrows !=0){
while ($rows = mysql_fetch_assoc($query)){
$dbusername = $rows['naam'];
}
if ($username==$dbusername){
die ('Username already in use');
} else {
if ($password==$repeatpassword){
mysql_query("INSERT INTO users (naam, wachtwoord, email) VALUES ('$username', '$password', '$email')");
echo 'registered';
} else {
echo "passwords don't match";
}
}
}
}else {
die ("Please enter all data");
}
?>
<?php
include 'dbconnect.php';
session_start();
$username = $_POST['username'];
$password = $_POST['password'];
$repeatpassword = $_POST['repeatpassword'];
$email = $_POST['email'];
if ($username&&$password&&$repeatpassword&&$email) {
$connect;
$selectdb;
$query = mysql_query("SELECT * FROM users WHERE naam='$username'");
$numrows = mysql_num_rows($query);
if($numrows !=0){
while ($rows = mysql_fetch_assoc($query)){
$dbusername = $rows['naam'];
}
if ($username==$dbusername){
die ('Username already in use');
} else {
if ($password==$repeatpassword){
mysql_query("INSERT INTO users (naam, wachtwoord, email) VALUES ('$username', '$password', '$email')");
echo 'registered';
} else {
echo "passwords don't match";
}
}
}
}else {
die ("Please enter all data");
}
?>