cubrid_fetch_array
(PECL CUBRID >=8.3.0)
cubrid_fetch_array — Fetch a result row as an associative array, a numeric array, or both
Description
The cubrid_fetch_array() function is used to get a single row from the query result and returns an array. The cursor automatically moves to the next row after getting the result.
Parameters
- req_identifier
-
Request identifier.
- type
-
Array type of the fetched result CUBRID_NUM, CUBRID_ASSOC, CUBRID_BOTH.
Return Values
Returns an array of strings that corresponds to the fetched row, when process is successful.
FALSE, when process is unsuccessful.
The type of returned array depends on how type is defined. By using CUBRID_BOTH (default), you'll get an array with both associative and number indices, and you can decide which data type to use by setting the type argument. The type variable can be set to one of the following values:
- CUBRID_NUM : Numerical array (0-based)
- CUBRID_ASSOC : Associative array
- CUBRID_BOTH : Numerical & Associative array (default)
Examples
Example #1 cubrid_fetch_array() example
<?php
$req = cubrid_execute($con, "select * from members", CUBRID_INCLUDE_OID | CUBRID_ASYNC);
if ($req) {
while (list($id, $name) = cubrid_fetch_array($req)){
echo $id;
echo $name;
}
cubrid_close_request($req);
}
$req = cubrid_execute($con, "select * from teams");
if ($req) {
while($row = cubrid_fetch_array($req, CUBRID_ASSOC)) {
echo $row["id"];
echo $row["name"];
}
}
?>