Using mysqli to count records

Question

I need to do a log count. I wore:

mysql_num_rows($consulta);

How do I do the same thing using mysqli? Because I’m doing it this way:

$tabela_usuarios = "SELECT * FROM owner WHERE owner_email='$email' AND password='$password' ";

$resul = mysqli_query($con, $tabela_usuarios);
$regs = mysqli_num_rows($resul);

And the following message appears on the screen: "Warning: mysqli_num_rows() expects Parameter 1 to be mysqli_result, null Given in /home/petsm976/public_html/php/logon.php on line 15"

Answer 1

One way to use is to count directly into SQL, like this:

<?php
$query = "SELECT COUNT(owner_email) AS TOTAL FROM owner WHERE owner_email='$email' AND password='$password'";
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($result);

echo $row['TOTAL']; 
?>

And in a safer way, using statement:

$connection = mysqli_connect("host","usuario","senha","banco de dados"); 
$query = "SELECT COUNT(owner_email) AS TOTAL FROM owner WHERE owner_email=? AND password=?";

    if ($stmt = mysqli_prepare($connection, $query))
    {
        mysqli_stmt_bind_param($stmt, $email, $password);
        mysqli_stmt_execute($stmt);
        mysqli_stmt_bind_result($stmt, $total);
        mysqli_stmt_fetch($stmt);   
        mysqli_stmt_close($stmt);
    }

    echo $total;

Reference = http://php.net/manual/en/class.mysqli-stmt.php