Firebird 2.0
PHP5 Programming
Manual

Overview of retrieving data in result sets

The SELECT statement of the SQL language returns a result set. A result set consists of rows and columns. The data is retrieved row-by-row and the columns of each row are stored in an array.

Syntax

<result_set_function> ::=
     <fetch_assoc>
   | <fetch_object>
   | <fetch_row>
   | <num_columns>
   | <column_info>
   | <free_result>



Description

The functions to work with result sets are:

  • fetch_assoc
    This function retrieves the data row into an associative array, using the column names as index

  • fetch_object
    This function retrieves the data row into an PHP5 object, using the column names as property identifiers

  • fetch_row
    This function retrieves the data row into a regular array, indexed from zero to the number columns minus 1

  • num_columns
    This function returns the number of columns in a result set

  • column_info
    This function returns information about a cooumn in the result set, such as its name, type and size.

  • free_result
    This function closes the result set and frees the resources associated with the it

Data is converted from SQL types to PHP types as described in the next section.


previous page goto index next page

Legal information