userRegister.php

 <?php #userRegister.php

require_once("connection.php"); # $con

$firstName=addslashes($_POST['firstName']);

$lastName=addslashes($_POST['lastName']);

$username=addslashes($_POST['username']);

$psw=sha1($_POST['psw']);

require_once("token.php"); # $token

$sql="SELECT idUsername FROM username WHERE username = '$username'";

$query=mysqli_query($con, $sql) or die ($sql);

$total=mysqli_num_rows($query);

if($total==0) {

    $sql="CALL register_username ('$firstName', '$lastName', '$username', '$psw', '$token')";

    mysqli_query($con, $sql) or die($sql);

    $path="mail/userActivation.php?email=$username&token=$token";

} else {

    $path="register.html?msg=usernameInvalido";

}

header("Location:$path");

?>