<?


$host = '#';
$user = '#';
$pass = '#';
$db = '#';



$dbc = mysqli_connect($host,$user,$pass,$db) or die('Could Not Connect');
if (isset($_POST['submit'])){
$username = mysqli_real_escape_string($dbc, trim($_POST['name']));
$password = mysqli_real_escape_string($dbc,trim($_POST['pass']));
$email = mysqli_real_escape_string($dbc,trim($_POST['email']));

if (!empty($username) && !empty($password) && !empty($email)){

$query = "SELECT * FROM accounts WHERE login='$username'";

$data = mysqli_query($dbc,$query);

if (mysqli_num_rows($data) == 0){


$query = "INSERT INTO accounts(login,password,email,flags)VALUES" .
"('$username' , '$password','$email', '24')";



mysqli_query($dbc,$query);

echo 'Your account has been created';


}else {

echo 'That username is already taken';


}


}else {


echo 'Please enter all form data';
}


}




mysqli_close($dbc);



?>