-
Notifications
You must be signed in to change notification settings - Fork 0
/
cadastraUsuario.php
43 lines (36 loc) · 1.43 KB
/
cadastraUsuario.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
<?php
include 'conexao.php';
$VARlogin = $_POST['nome'];
$VARsenha = $_POST['senha'];
$VARemail = $_POST['email'];
$VARcpf = $_POST['cpf'];
if(strlen($VARcpf) == 14){
//VERIFICAÇÃO EMAIL
$SELECT = mysqli_query($conexao, "SELECT * FROM usuario WHERE Email = '".$VARemail."'");
if(mysqli_num_rows($SELECT)>=1){
echo "<script> alert('Email já existe') </script>";
echo "<meta http-equiv=refresh content='0, url=index.php?modal=cadastra.html'';>";
}else{
//VERIFICAÇÃO CPF
$SELECT = mysqli_query($conexao, "SELECT * FROM usuario WHERE CPFCNPJ = '".$VARcpf."'");
if(mysqli_num_rows($SELECT)>=1){
echo "<script> alert('CPF já existe') </script>";
echo "<meta http-equiv=refresh content='0, url=index.php?modal=cadastra.html'';>";
}else{
//INSERINDO DADOS
$INSERT = "INSERT INTO usuario(Login, Senha, Email, CPFCNPJ, Admin) VALUES('$VARlogin','$VARsenha','$VARemail','$VARcpf','1')";
$conexao->query($INSERT);
if (isset($conexao)){
echo "<script> alert('Parabéns ".$VARlogin." cadastrado com sucesso '); </script>";
echo "<meta http-equiv=refresh content='0, url=index.php';>";
}else{
echo "<script> alert('ERRO!!!: '.$VARlogin.' CADASTRO NÃO REALIZADO') </script>";
echo "<meta http-equiv=refresh content='0, url=index.php';>";
}
}
}
}else{
echo "<script> alert('CPF INVÁLIDO') </script>";
echo "<meta http-equiv=refresh content='0, url=index.php?modal=cadastra.html'';>";
}
?>