Can anyone tell me why if Else is not returning Is it?

Question

Come on, guys, I’ll try to be as enlightening as possible on the question. Next: I have an if Else that is done by a Pdo query, when I type an existing Cpf it does the job properly, until then ok! But when I type in a Cpf that doesn’t exist in the database, it should display Else, where it’s not doing that, someone can help me?

CODE

$acao  = (isset($_POST['acao'])) ? $_POST['acao'] : '';
$name  = (isset($_POST['name'])) ? $_POST['name'] : '';
$indicated_by  = (isset($_POST['indicated_by'])) ? $_POST['indicated_by'] : '';
$password  = (isset($_POST['password'])) ? $_POST['password'] : '';
$cpf   = (isset($_POST['cpf'])) ? str_replace(array('.','-'), '',         
$_POST['cpf']): '';
$telefone   = (isset($_POST['telefone'])) ? str_replace(array('(',')','','-'), '', $_POST['telefone']): '';
$data_cadastro   = (isset($_POST['data_cadastro'])) ? str_replace(array('.','-'), '', $_POST['data_cadastro']): '';
$password  = (isset($_POST['password'])) ? $_POST['password'] : '';
$id_ind = (isset($_POST['id_ind'])) ? $_POST['id_ind'] : '';


$conexao = conexao::getInstance();
$sql = "SELECT * FROM users WHERE cpf = ".$cpf;
$stm = $conexao->prepare($sql);
$stm->execute();
$clientes = $stm->fetchAll(PDO::FETCH_OBJ);
foreach($clientes as $cliente):

    if($cliente->cpf === $cpf):
        CPF EXISTE


    else:
        CPF NÃO EXISTE

    endif;

endforeach;

Answer 1

You make a search in the database looking for the CPF informed, so if vc type a CPF that does not exist in the base your select will not return any record, making it not enter nor the foreach.

You can directly check if the query returned any value, if it returns the CPF exists, if it returns nothing the CPF does not exist

$conexao = conexao::getInstance();
$sql = "SELECT * FROM users WHERE cpf = ".$cpf;
$stm = $conexao->prepare($sql);
$stm->execute();
$clientes = $stm->fetchAll(PDO::FETCH_OBJ);

if($clientes ):
    CPF EXISTE
else:
    CPF NÃO EXISTE
endif;

Thus the if checks if there is any value for the variable $clientes, if there is, the CPF has been found, if there is no CPF.