#register.php?firstName&lastName&username&pass&pass_repeat®ister
# 1 garantir que a pass e a pass_repeat são iguais
# 2 tendo garantido o ponto 1, vou testar se o username já existe
# tenho que perguntar à tabela dos users se o username existe
if(isset($_POST['register'])){
#testar as Passes
if($_POST['pass']==$_POST['pass_repeat']){
#testa o user
require_once("../connection.php");
$table="users";
$username=addslashes($_POST['username']);
$sql="SELECT id FROM $table WHERE username LIKE '$username'";
$query=mysqli_query($connect,$sql);
$total=mysqli_num_rows($query); // retorna o número de registos
if($total==0){
// registar
//1
$table="users";
$sql="INSERT INTO $table (username) VALUES ('$username')";
mysqli_query($connect,$sql);
$idUser=mysqli_insert_id($connect);
//2
$table="users_privilegios";
$sql="INSERT INTO $table (idUser) VALUES ($idUser)";
mysqli_query($connect,$sql);
//3
$table="passwords";
$pass=addslashes($_POST['pass']);
$sql="INSERT INTO $table (idUser, pass) VALUES ($idUser, '$pass')";
mysqli_query($connect,$sql);
//4
$table="pessoas";
$firstName=addslashes($_POST['firstName']);
$lastName=addslashes($_POST['lastName']);
$sql="INSERT INTO $table (firstName, lastName) VALUES ('$firstName', '$lastName')";
mysqli_query($connect,$sql);
$idPessoa=mysqli_insert_id($connect);
//5
$table="users_pessoas";
$sql="INSERT INTO $table (idUser, idPessoa) VALUES ($idUser, $idPessoa)";
mysqli_query($connect,$sql);
// 6
// envio de email para o passo seguinte
$path="emailConfirmacaoUser.php";
}
else {
// repetido e não registo
$path="?userRepetido";
}
}
else{
$path="?errorPass";
} // informo que as passwords estão erradas
header("Location:$path");
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, shrink-to-fit=no">
<title>Register - TPW-BackOffice</title>
<meta name="description" content="Técnicas Avançadas de programação WEB Backoffice">
<link rel="stylesheet" href="assets/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i">
<link rel="stylesheet" href="assets/fonts/fontawesome-all.min.css">
</head>
<body class="bg-gradient-primary">
<div class="container">
<div class="card shadow-lg o-hidden border-0 my-5">
<div class="card-body p-0">
<div class="row">
<div class="col-lg-5 d-none d-lg-flex">
<div class="flex-grow-1 bg-register-image" style="background-image: url("assets/img/dogs/image2.jpeg");"></div>
</div>
<div class="col-lg-7">
<div class="p-5">
<div class="text-center">
<h4 class="text-dark mb-4">Create an Account!</h4>
</div>
<form class="user" method="post">
<div class="form-group row">
<div class="col-sm-6 mb-3 mb-sm-0"><input class="form-control form-control-user" type="text" id="exampleFirstName" placeholder="First Name" name="firstName" required></div>
<div class="col-sm-6"><input class="form-control form-control-user" type="text" id="exampleFirstName" placeholder="Last Name" name="lastName" required></div>
</div>
<div class="form-group"><input class="form-control form-control-user" type="email" id="exampleInputEmail" aria-describedby="emailHelp" placeholder="Email as Username" name="username" required></div>
<div class="form-group row">
<div class="col-sm-6 mb-3 mb-sm-0"><input class="form-control form-control-user" type="password" id="examplePasswordInput" placeholder="Password" name="pass" required></div>
<div class="col-sm-6"><input class="form-control form-control-user" type="password" id="exampleRepeatPasswordInput" placeholder="Repeat Password" name="pass_repeat" required></div>
</div><button name="register" class="btn btn-primary btn-block text-white btn-user" type="submit">Register Account</button>
<hr><a class="btn btn-primary btn-block text-white btn-google btn-user" role="button"><i class="fab fa-google"></i> Register with Google</a><a class="btn btn-primary btn-block text-white btn-facebook btn-user" role="button"><i class="fab fa-facebook-f"></i> Register with Facebook</a>
<hr>
</form>
<div class="text-center"><a class="small" href="forgot-password.php">Forgot Password?</a></div>
<div class="text-center"><a class="small" href="login.php">Already have an account? Login!</a></div>
</div>
</div>
</div>
</div>
</div>
</div>
<script src="assets/js/jquery.min.js"></script>
<script src="assets/bootstrap/js/bootstrap.min.js"></script>
<script src="assets/js/chart.min.js"></script>
<script src="assets/js/bs-init.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.4.1/jquery.easing.js"></script>
<script src="assets/js/theme.js"></script>
</body>
</html>
Sem comentários:
Enviar um comentário