Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 | 



cubrid_put

Description

The cubrid_put function changes attribute values of an instance by using the given OID. You can update single attribute by using string data type to set attr. In such case, you can use integer, floating-point, or character string data type for the value argument. To change multiple attributes simultaneously, pass value argument in the form of associative array data type without specifying the attr argument.

Syntax

int cubrid_put (resource $conn_identifier, string $oid[, string $attr], mixed $value)

  • conn_identifier : Connection identifier
  • oid : OID of the instance whose value you want to change
  • attr : Name of the attribute whose value you want to change
  • value : Value of the attribute you want to change
Return Value
  • Success : TRUE
  • Failure : FALSE
Example

<?php

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

 

@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')");

cubrid_execute($conn, "INSERT INTO foo(a, b, c, d) VALUES(2, {4,5,7}, {44,55,66,666}, 'b')");

 

$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);

 

cubrid_put($conn, $oid, "b", array(2, 4, 8));

 

$attr = cubrid_col_get($conn, $oid, "b");

var_dump($attr);

 

cubrid_close_request($req);

cubrid_disconnect($conn);

?>

 

The above example will output:

 

array(3) {

  [0]=>

  string(1) "1"

  [1]=>

  string(1) "2"

  [2]=>

  string(1) "3"

}

array(3) {

  [0]=>

  string(1) "2"

  [1]=>

  string(1) "4"

  [2]=>

  string(1) "8"

}

See Also