php -registration

<?php

 $con = mysqli_connect('localhost', 'admin', 'admin', 'carnival_db');

 if(mysqli_connect_errno())
 {
 echo "1: conection failed";
 exit();
}

$username = $_POST["name"];
$password = $_POST["password"];
$house = $_POST["house"];


$namecheckquery = "SELECT username FROM players WHERE username ='".$username."'";


$namecheck = mysqli_query($con, $namecheckquery) or die("2: name check query failed");

if(mysqli_num_rows($namecheck) > 0)
{

 echo "3: name already exist";
}

$salt = "\$5\$rounds=5000\$"."steamedhams".$username."\$";
$hash = crypt($password, $salt);

$insertuserquery = "INSERT INTO players (username, hash, salt, house) VALUES ('".$username."', '".$hash."', '".$salt."', '".$house."')";


mysqli_query($con, $insertuserquery) or die ("4: insert player query failed");

echo("0");

?>