Check field on the bank

Question

I’m doing a search in the bank to see if the amount sent already exists in it.

This is the function I’m using:

 function buscaSubdominio($conexao, $nome_subdominio){

     $query = "select * from subdominio where nome_subdominio = ('{$nome_subdominio}')";
     return mysqli_query($conexao, $query);
   }

So I’m making this condition on another page:

 $confere = buscaSubdominio($conexao, $nome_subdominio);

 if($confere == null){
   echo "registro inexistente";
 }
 else{
   echo "registro existente";
 }

He gives me back that mistake, you can help me?

 Notice: Undefined property: mysqli_result::$nome_subdominio in C:\xampp   \htdocs\daLuz\subdominio.php on line 8

Answer 1

Maybe it’s because the variable $nome_subdominio was not defined before being used in the function.

Answer 2

function buscaSubdominio($conexao, $nome_subdominio){

     $query = "select * from subdominio where nome_subdominio = ('{$nome_subdominio}')";
     $stmt = mysqli_query($conexao, $query);
     $row_cnt = mysqli_num_rows($stmt);

     return $row_cnt;
   }