ODBC_FETCH_ARRAY(3) 1 ODBC_FETCH_ARRAY(3)odbc_fetch_array - Fetch a result row as an associative arraySYNOPSIS
array odbc_fetch_array (resource $result, [int $rownumber])
DESCRIPTION
Fetch an associative array from an ODBC query.
PARAMETERS
o $result
- The result resource from odbc_exec(3).
o $rownumber
- Optionally choose which row number to retrieve.
RETURN VALUES
Returns an array that corresponds to the fetched row, or FALSE if there are no more rows.
NOTES
Note
This function exists when compiled with DBMaker, IBM DB2 or UnixODBC support.
SEE ALSO odbc_fetch_row(3), odbc_fetch_object(3), odbc_num_rows(3).
PHP Documentation Group ODBC_FETCH_ARRAY(3)
Check Out this Related Man Page
INGRES_FETCH_ASSOC(3) 1 INGRES_FETCH_ASSOC(3)ingres_fetch_assoc - Fetch a row of result into an associative arraySYNOPSIS
array ingres_fetch_assoc (resource $result)
DESCRIPTION
This function is stores the data fetched from a query executed using ingres_query(3) in an associative array, using the field names as
keys.
With regard to speed, the function is identical to ingres_fetch_object(3), and almost as quick as ingres_fetch_row(3) (the difference is
insignificant).
By default, arrays created by ingres_fetch_assoc(3) start from position 1 and not 0 as with other DBMS extensions. The starting position
can be adjusted to 0 using the configuration parameter ingres.array_index_start.
Note
Related Configurations
See also the ingres.array_index_start, ingres.fetch_buffer_size and ingres.utf8 directives in Runtime Configuration.
PARAMETERS
o $result
- The query result identifier
RETURN VALUES
Returns an associative array that corresponds to the fetched row, or FALSE if there are no more rows
EXAMPLES
Example #1
Fetch a row into an associative array
<?php
$link = ingres_connect($database, $user, $password);
$result = ingres_query($link,"select * from table");
while ($row = ingres_fetch_assoc($result)) {
echo $row["user_id"]; // using associative array
echo $row["fullname"];
}
?>
SEE ALSO ingres_query(3), ingres_num_fields(3), ingres_field_name(3), ingres_fetch_array(3), ingres_fetch_object(3), ingres_fetch_row(3).
PHP Documentation Group INGRES_FETCH_ASSOC(3)