Php/docs/function.cubrid-col-size

来自菜鸟教程
跳转至:导航、​搜索

cubrid_col_size

(PECL CUBRID >= 8.3.0)

cubrid_col_sizeGet the number of elements in collection type column using OID


说明

cubrid_col_size ( resource $conn_identifier , string $oid , string $attr_name ) : int

The cubrid_col_size() function is used to get the number of elements in a collection type (set, multiset, sequence) attribute.


参数

conn_identifier
Connection identifier.
oid
OID the instance that you want to work with.
attr_name
Name of the attribute that you want to work with.


返回值

Number of elements, when process is successful.

false, when process is unsuccessful.


更新日志

版本 说明
8.3.1 Change return value: when process is unsuccessful, return false, not -1.


范例

Example #1 cubrid_col_size() example

<?php$conn = cubrid_connect("localhost", 33000, "demodb", "dba");@cubrid_execute($conn, "DROP TABLE foo");cubrid_execute($conn, "CREATE TABLE foo(a int AUTO_INCREMENT, b set(int), c list(int), d char(10))");cubrid_execute($conn, "INSERT INTO foo(a, b, c, d) VALUES(1, {1,2,3}, {11,22,33,333}, 'a')");$req = cubrid_execute($conn, "SELECT * FROM foo", CUBRID_INCLUDE_OID);cubrid_move_cursor($req, 1, CUBRID_CURSOR_FIRST);$oid = cubrid_current_oid($req);$attr = cubrid_col_get($conn, $oid, "b");var_dump($attr);$size = cubrid_col_size($conn, $oid, "b");var_dump($size);cubrid_close_request($req);cubrid_disconnect($conn);?>

以上例程会输出:


array(3) {
  [0]=>
  string(1) "1"
  [1]=>
  string(1) "2"
  [2]=>
  string(1) "3"
}
int(3)