cubrid_result

Return the value of a specific field in a specific row

説明

string cubrid_result(resource $result, int $row, mixed $field = 0)

This function returns the value of a specific field in a specific row from a result set.

パラメータ

result: result comes from a call to cubrid_execute
row: The row number from the result that is being retrieved. Row numbers start at 0.
field: The name or offset of the field being retrieved. It can be the field's offset, the field's name, or the field's table dot field name (tablename.fieldname). If the column name has been aliased ('select foo as bar from...'), use the alias instead of the column name. If undefined, the first field is retrieved.

戻り値

Value of a specific field, on success (NULL if value if null).

false on failure.

例

例1 cubrid_result example

<?php
$conn = cubrid_connect("localhost", 33000, "demodb");

$req = cubrid_execute($conn, "SELECT * FROM code");

$result = cubrid_result($req, 0);
var_dump($result);

$result = cubrid_result($req, 0, 1);
var_dump($result);

$result = cubrid_result($req, 5, "f_name");
var_dump($result);

cubrid_close_request($req);
cubrid_disconnect($conn);
?>

上の例の出力は以下となります。

string(1) "X"
string(5) "Mixed"
string(4) "Gold"