num_rows in php
// Fetch Query
$query = "SELECT user_name from registered_users where user_name like '%ank%'";
// Execute the query and store the result set
$result = mysqli_query($con, $query);
if ($result) {
// it return number of rows in the table.
$row = mysqli_num_rows($result);
}