cubrid_result

(PECL CUBRID >= 8.3.0)

cubrid_result — Return the value of a specific field in a specific row

説明

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

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"

関連キーワード:

cubrid specific Return retrieved conn dump execute offset column real escape unbuffered query MySQL resource mixed comes call number numbers start table tablename fieldname aliased