How do I make a cpf validator for my database values?

Question

How do I make a cpf validator for my database values?

Navigation

#1 by (1 votes)
#2 by (0 votes)

1

I have the following code, which accepts values in its inputs and then sends them to the database. I want, when the user clicks send, if cpf is invalid (EX: 111.111.111-11), it does not send any value to the database and shows an alert on the screen indicating that nothing has been added, need an if that has as condition the valid cpf, only if the cpf is valid the values will be sent

Here we have the inputs

	<form action="Dados.php"  method="POST" >
			<table class="table table-striped">
			<thead>
			<tr>
				<th>Nome</th>
				<th>Cpf</th>
				<th>Cep</th>
				<th>Rua</th>
				<th>Bairro</th>
				<th>Cidade</th>
				<th>Estado</th>
				<th>Ibge</th>
				</tr>			
			</thead>
			
			<tbody>
			<tr>
				<td><input type="text" class="form-control input-sm" name="nom" required><br></td>
				
				<td><input type="text" class="form-control input-sm" id="cpf"  name="cpf" required><br></td>
				
				<td><input type="text" class="form-control input-sm" id="cep" name="end" required><br></td>
				
        		<td><input name="rua" class="form-control input-sm" type="text" id="rua" required /><br /></td>
        		
        		<td><input name="bairro" class="form-control input-sm" type="text" id="bairro" required/><br /></td>
        		
        		<td><input name="cidade" class="form-control input-sm" type="text" id="cidade" required/><br /></td>
        		
        		<td><input name="uf" class="form-control input-sm" type="text" id="uf" required/><br /></td>
        	
        		<td><input name="ibge" class="form-control input-sm" type="text" id="ibge" required/><br /></td>
				
			</tr>
			</tbody>
			</table>
			<input type="submit" value="Criar Registro" onclick="function validaCPF()" class="btn btn-default"><input type="button" class="btn btn-warning" value="Voltar"
onclick="window.location='/Banco_de_dados/index.php';"/>
			</form>

And here is the code that sends the values to the Bank

<body>
<?php
//declarando variaveis//
    $servername = 'localhost';
    $username = 'root';
    $password = '';
    $dbname = 'meubd';
    $nome = $_POST['nom'];
    $cpf = $_POST['cpf'];
    $cep = $_POST['end'];
    $rua = $_POST['rua'];
    $bairro = $_POST['bairro'];
    $cidade = $_POST['cidade'];
    $uf = $_POST['uf'];
    $ibge = $_POST['ibge'];
    function validaCPF($cpf = null) {

        // Verifica se um número foi informado
        if(empty($cpf)) {
            return false;
            echo "Cpf";
        }

        // Elimina possivel mascara
        $cpf = ereg_replace('[^0-9]', '', $cpf);
        $cpf = str_pad($cpf, 11, '0', STR_PAD_LEFT);

        // Verifica se o numero de digitos informados é igual a 11
        if (strlen($cpf) != 11) {
            return false;
        }
        // Verifica se nenhuma das sequências invalidas abaixo
        // foi digitada. Caso afirmativo, retorna falso
        else if ($cpf == '00000000000' ||
                $cpf == '11111111111' ||
                $cpf == '22222222222' ||
                $cpf == '33333333333' ||
                $cpf == '44444444444' ||
                $cpf == '55555555555' ||
                $cpf == '66666666666' ||
                $cpf == '77777777777' ||
                $cpf == '88888888888' ||
                $cpf == '99999999999') {
                    return false;
                    // Calcula os digitos verificadores para verificar se o
                    // CPF é válido
                } else {

                    for ($t = 9; $t < 11; $t++) {

                        for ($d = 0, $c = 0; $c < $t; $c++) {
                            $d += $cpf{$c} * (($t + 1) - $c);
                        }
                        $d = ((10 * $d) % 11) % 10;
                        if ($cpf{$c} != $d) {
                            return false;
                        }
                    }

                    return true;
                    $sql = 'INSERT INTO pessoas VALUES ("'.$nome.'", "'.$cpf.'", "'.$cep.'" , "'.$rua.'", "'.$bairro.'", "'.$cidade.'", "'.$uf.'", "'.$ibge.'")';
                    //verificando se os valores foram inseridos//
                    if ($conn->query($sql) === TRUE) {
                        echo "<br>Os valores foram adicionados corretamente";
                    } else {
                        echo "<br>Error: " . $sql . "<br>" . $conn->error;

                    }

                }
    }

//conectando ao banco de dados//verificando conexão//
    $conn = new mysqli($servername, $username, $password, $dbname);
    if ($conn->connect_error) {
        die("Conecxão Falhou: " . $conn->connect_error);
    }

    echo "Conexao foi um sucesso";


//fechando conexão//
    $conn ->close();
?>
</body>

As I said before, there may be many errors in my code, so I ask for your help.

php mysql javascript

asked by anonymous 10.05.2016 / 12:54

2 answers

0

You could check the customer-entered CPF with a JS function.

It would look like this:

    <script>
 function validaCPF(cpf)
  {
    var numeros, digitos, soma, i, resultado, digitos_iguais;
    digitos_iguais = 1;
    if (cpf.length < 11)
          return false;
    for (i = 0; i < cpf.length - 1; i++)
          if (cpf.charAt(i) != cpf.charAt(i + 1))
                {
                digitos_iguais = 0;
                break;
                }
    if (!digitos_iguais)
          {
          numeros = cpf.substring(0,9);
          digitos = cpf.substring(9);
          soma = 0;
          for (i = 10; i > 1; i--)
                soma += numeros.charAt(10 - i) * i;
          resultado = soma % 11 < 2 ? 0 : 11 - soma % 11;
          if (resultado != digitos.charAt(0))
                return false;
          numeros = cpf.substring(0,10);
          soma = 0;
          for (i = 11; i > 1; i--)
                soma += numeros.charAt(11 - i) * i;
          resultado = soma % 11 < 2 ? 0 : 11 - soma % 11;
          if (resultado != digitos.charAt(1))
                return false;
          return true;
          }
    else
        return false;
  }
    </script>

Follow test: link

10.05.2016 / 14:55

Hiding process by clicking the button how to add white space between Strings

score 1 · Accepted Answer

The only way to ensure that a CPF is valid is by checking its verifying digits. A CPF is formed as follows: XXX.XXX.XXX-DD. The "X" are the base numbers and the "DD" are the verifying digits of the "X".

The calculation of these two digits checkers is done through Module 11

To understand how it works:

More information about Module 11 can be found here here

Down a Java code (not very explanatory) but it gets a String (of numbers) and returns Module 11 of that value.

public Integer getDVModulo11(String valor){
    StringBuilder valorFiltrado = new StringBuilder().append(valor);
    Integer indiceMultiplicacao = 2;
    Integer soma = 0;
    //1º PASSO
    for (Integer i = valorFiltrado.length()-1; i > -1; i--) {
        Integer numero = Character.getNumericValue(valorFiltrado.toString().charAt(i));
        Integer multiplicacao = (numero * indiceMultiplicacao);
        //2º PASSO
        soma = soma + multiplicacao;
        if(indiceMultiplicacao < 9) {
            indiceMultiplicacao++;
        }else{
            indiceMultiplicacao = 2;
        }
    }
    //3º PASSO
    Integer resultado = soma % 11;
    //4º PASSO
    resultado = 11 - resultado;
    if(resultado > 9){
        return 0;
    }else{
        return resultado;
    }
}