readColumn() public method Returns a single column from the next row of a result set. public mixed readColumn ( $columnIndex )$columnIndex integer Zero-based column index return mixed The column of the current row, false if no more rows available

read() public method Advances the reader to the next row in a result set. public array read ( )return array The current row, false if no more row available

nextResult() public method Advances the reader to the next result when reading the results of a batch of statements. This method is only useful when there are multiple result sets returned by the query. Not all DBMS support this feature. public boolean nextResult ( )return boolean Returns true on success or false on failure.

key() public method Returns the index of the current row. This method is required by the interface Iterator. public integer key ( )return integer The index of the current row.

next() public method Moves the internal pointer to the next row. This method is required by the interface Iterator. public void next ( )

getRowCount() public method Returns the number of rows in the result set. Note, most DBMS may not give a meaningful count. In this case, use "SELECT COUNT(*) FROM tableName" to obtain the number of rows. public integer getRowCount ( )return integer Number of rows contained in the result.

getColumnCount() public method Returns the number of columns in the result set. Note, even there's no row in the reader, this still gives correct column number. public integer getColumnCount ( )return integer The number of columns in the result set.

current() public method Returns the current row. This method is required by the interface Iterator. public mixed current ( )return mixed The current row.

getIsClosed() public method Whether the reader is closed or not. public boolean getIsClosed ( )return boolean Whether the reader is closed or not.

close() public method Closes the reader. This frees up the resources allocated for executing this SQL statement. Read attempts after this method call are unpredictable. public void close ( )