How to determine if 0 rows were returned from query

[Claus Mygind]

I use the following construct to query my MySQL database tables. Instead of using the flag $recFound, I would like to just examine and determine if the associative array in $result is empty.

I know that the "while" loop will not execute if $result is empty, but that is not enough for me. I would like to test the difference between an invalid query and a successful query with zero rows returned

if ($result = $db->query($sql)){
 
        $recFound = false;
        while ($c = $result->fetch_assoc()) {
..... some processing steps here.....
 
                $recFound = true;
        }
 
        if ($recFound){
            $cResponse = subStr( $cResponse, 0, strlen($cResponse)-3) )
        }else{
            $cResponse = "none";
        }
    }
 

Can this code be used, if so how would it be re-written to fit my code.

if (mysql_num_rows($result) == 0) {
    echo "No rows found, nothing to print so am exiting";
    exit;
}

[Dormilich]

a) don’t use the outdated mysql extension.
b) you can use the SQL function COUNT() for that
c) rewriting that code depends on your actual database code, of which I have not enough information to give any sensible advice

[Claus Mygind]

Actually it is more of a php question than mysql. Also while I am not using PDO I am using mysqli.

The example I gave from the online help is only an example of code that should be available. I do not believe it has been deprecated.

I define my connection code in an object called db, the query result is then stored in $results. $result then contains all rows returned from the mysqli->query.

So then is it reasonable to expect there is a mysqli_num_rows equivelent. Also if db is a reference to the mysqli connection, is there something like db_num_rows.

here is how I define the reference to mysqli

class dbcnx extends mysqli
{
.... functions and methods
}
 
    $db = new dbcnx(my connection info);
 
 
 

From this additional info, is there a way using php to determine if zero rows have been returned?

[Dormilich]

first your question:

I would like to just examine and determine if the associative array in $result is empty.

from MySQLi_Result->fetch_assoc():
Returns an associative array of strings representing the fetched row in the result set, where each key in the array represents the name of one of the result set's columns or NULL if there are no more rows in resultset.

I think that is unambiguous …

From this additional info, is there a way using php to determine if zero rows have been returned?

MySQLi_Result->num_rows

[Claus Mygind]

Thank you very much for turning me in the right direction. I think the associative array aspect of $result is what confused me. From what you provided me I found this in the online php manual.

/* determine number of rows result set */
    $row_cnt = $result->num_rows;