How can the error "Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, int given" be resolved?

The error "Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, int given" occurs when the mysqli_query() function does not return a valid mysqli_result object. To resolve this issue, you need to check if the query was successful and returned a valid result set before calling mysqli_num_rows(). 

// Check if the query was successful and returned a valid result set
$result = mysqli_query($conn, $query);
if ($result) {
    // Use mysqli_num_rows() on the valid result set
    $num_rows = mysqli_num_rows($result);
    
    // Process the result set
    if ($num_rows > 0) {
        // Fetch rows from the result set
        while ($row = mysqli_fetch_assoc($result)) {
            // Process each row
        }
    } else {
        // No rows found
    }
} else {
    // Query failed, handle the error
}

Keywords

mysqli_num_rows mysqli_result int PHP error

Related Questions