(PECL maxdb >= 1.0)
Gets the number of rows in a result
int maxdb_num_rows ( resource $result )
Procedural style
Object oriented style
int $maxdb->num_rows;
Returns the number of rows in the result set.
The use of maxdb_num_rows() depends on whether you use buffered or unbuffered result sets. In case you use unbuffered resultsets maxdb_num_rows() will not correct the correct number of rows until all the rows in the result have been retrieved.
Returns:
Returns number of rows in the result set.
Note:
If the number of rows is greater than maximal int value, the number will be returned as a string.
Examples:
Object oriented style
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | <?php $maxdb = new maxdb( "localhost" , "MONA" , "RED" , "DEMODB" ); /* check connection */ if (maxdb_connect_errno()) { printf( "Connect failed: %s\n" , maxdb_connect_error()); exit (); } if ( $result = $maxdb ->query( "SELECT cno, name FROM hotel.customer ORDER BY name" )) { /* determine number of rows result set */ $row_cnt = $result ->num_rows; printf( "Result set has %d rows.\n" , $row_cnt ); /* close result set */ $result ->close(); } /* close connection */ $maxdb ->close(); ?> |
Procedural style
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | <?php $link = maxdb_connect( "localhost" , "MONA" , "RED" , "DEMODB" ); /* check connection */ if (maxdb_connect_errno()) { printf( "Connect failed: %s\n" , maxdb_connect_error()); exit (); } if ( $result = maxdb_query( $link , "SELECT cno, name FROM hotel.customer ORDER BY name" )) { /* determine number of rows result set */ $row_cnt = maxdb_num_rows( $result ); printf( "Result set has %d rows.\n" , $row_cnt ); /* close result set */ maxdb_free_result( $result ); } /* close connection */ maxdb_close( $link ); ?> |
See also:
Please login to continue.