ingres_fetch_assoc

(PECL ingres >= 2.2.2)

ingres_fetch_assocFetch a row of result into an associative array

Beschreibung

ingres_fetch_assoc ( resource $result ) : array

This function is stores the data fetched from a query executed using ingres_query() in an associative array, using the field names as keys.

With regard to speed, the function is identical to ingres_fetch_object(), and almost as quick as ingres_fetch_row() (the difference is insignificant).

By default, arrays created by ingres_fetch_assoc() 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.

Hinweis: Related Configurations

See also the ingres.array_index_start, ingres.fetch_buffer_size and ingres.utf8 directives in Runtime Configuration.

Parameter-Liste

result

The query result identifier

Rückgabewerte

Returns an associative array that corresponds to the fetched row, or FALSE if there are no more rows

Beispiele

Beispiel #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"];
}
?>

Siehe auch