cubrid_fetch_assoc

(PECL CUBRID >= 8.3.0)

cubrid_fetch_assoc — Returns the associative array that corresponds to the fetched row

说明

array cubrid_fetch_assoc ( resource $result )

This function returns the associative array, that corresponds to the fetched row and, then, moves the internal data pointer ahead, or it returns FALSE when the end is reached.

参数

result: result comes from a call to cubrid_execute()

返回值

Associative array, when process is successful.

FALSE when the end is reached, or error.

范例

Example #1 cubrid_fetch_assoc() example


<?php
    $link = cubrid_connect("localhost", 30000, "demodb2", "dba", "");
    if (!$link)
    {
        die('Could not connect.');
    }
    $query = 'SELECT name, address, salary FROM employees';
    $result = cubrid_execute($link, $query);
    if ($result) 
    {
        echo "seek to row 0 and fetching fields: ";
        cubrid_data_seek($result, 0);
        $row = cubrid_fetch_assoc($result);
        echo $row["name"]."|". $row["address"]."|".$row["salary"]."<br>";

        echo "seek to row 2 and fetching fields: ";    
        cubrid_data_seek($result, 2);
        $row = cubrid_fetch_assoc($result);
        echo $row["name"]."|". $row["address"]."|".$row["salary"]."<br>";

        cubrid_close_request($result); 
    }
?>

以上例程会输出：

Result:
seek to row 0 and fetching fields: Peter|1st Avenue, New York|1000.0000000000000000
seek to row 2 and fetching fields: Peter Norton|81254, CA|19834.0000000000000000