cubrid_commit(3) [php man page]

CUBRID_COMMIT(3)							 1							  CUBRID_COMMIT(3)

cubrid_commit - Commit a transaction

SYNOPSIS

       bool cubrid_commit (resource  $conn_identifier)

DESCRIPTION

	The  cubrid_commit(3) function is used to execute commit on the transaction pointed by $conn_identifier, currently in progress. Connection
       to the server is closed after the cubrid_commit(3) function is called; However, the connection handle is still valid.

	In CUBRID PHP, auto-commit mode is disabled by default for transaction management. You can set it by using  cubrid_set_autocommit(3).  You
       can get its status by using cubrid_get_autocommit(3). Before you start a transaction, remember to disable the auto-commit mode.

PARAMETERS

	      o $conn_identifier
		-Connection identifier.

RETURN VALUES

       TRUE, when process is successful.

       FALSE, when process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_commit(3) example

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

	      @cubrid_execute($conn, "DROP TABLE publishers");

	      $sql = <<<EOD
	      CREATE TABLE publishers(
	      pub_id CHAR(3),
	      pub_name VARCHAR(20),
	      city VARCHAR(15),
	      state CHAR(2),
	      country VARCHAR(15)
	      )
	      EOD;
	      cubrid_set_autocommit($conn,false);
	      if (!cubrid_execute($conn, $sql)) {
		  printf("Error facility: %d
Error code: %d
Error msg: %s
", cubrid_error_code_facility(), cubrid_error_code(), cubrid_error_msg());

		  cubrid_disconnect($conn);
		  exit;
	      }

	      $req = cubrid_prepare($conn, "INSERT INTO publishers VALUES(?, ?, ?, ?, ?)");

	      $id_list = array("P01", "P02", "P03", "P04");
	      $name_list = array("Abatis Publishers", "Core Dump Books", "Schadenfreude Press", "Tenterhooks Press");
	      $city_list = array("New York", "San Francisco", "Hamburg", "Berkeley");
	      $state_list = array("NY", "CA", NULL, "CA");
	      $country_list = array("USA", "USA", "Germany", "USA");

	      for ($i = 0, $size = count($id_list); $i < $size; $i++) {
		  cubrid_bind($req, 1, $id_list[$i]);
		  cubrid_bind($req, 2, $name_list[$i]);
		  cubrid_bind($req, 3, $city_list[$i]);
		  cubrid_bind($req, 4, $state_list[$i]);
		  cubrid_bind($req, 5, $country_list[$i]);

		  if (!($ret = cubrid_execute($req))) {
		      break;
		  }
	      }

	      if (!$ret) {
		  cubrid_rollback($conn);
	      } else {
		  cubrid_commit($conn);

		  $req = cubrid_execute($conn, "SELECT * FROM publishers");
		  while ($result = cubrid_fetch_assoc($req)) {
		      printf("%-3s %-20s %-15s %-3s %-15s
",
			  $result["pub_id"], $result["pub_name"], $result["city"], $result["state"], $result["country"]);
		  }
	      }

	      cubrid_disconnect($conn);
	      ?>

	      The above example will output:

	      P01 Abatis Publishers    New York        NY  USA
	      P02 Core Dump Books      San Francisco   CA  USA
	      P03 Schadenfreude Press  Hamburg		   Germany
	      P04 Tenterhooks Press    Berkeley        CA  USA

SEE ALSO

       cubrid_rollback(3), cubrid_get_autocommit(3), cubrid_set_autocommit(3).

PHP Documentation Group 													  CUBRID_COMMIT(3)

Check Out this Related Man Page

CUBRID_SET_ADD(3)							 1							 CUBRID_SET_ADD(3)

cubrid_set_add - Insert a single element to set type column using OID

SYNOPSIS

       bool cubrid_set_add (resource  $conn_identifier, string	$oid, string  $attr_name, string  $set_element)

DESCRIPTION

	The cubrid_set_add(3) function is used to insert a single element to a set type attribute (set, multiset, sequence) you requested.

PARAMETERS

	      o $conn_identifier
		-Connection identifier.

	      o $oid
		-OID of the instance you want to work with.

	      o $attr_name
		-Name of the attribute you want to insert an element.

	      o $set_element
		-Content of the element you want to insert.

RETURN VALUES

       TRUE, when process is successful.

       FALSE, when process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_set_add(3) 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);

	      cubrid_set_add($conn, $oid, "b", "4");

	      $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(4) {
		[0]=>
		string(1) "1"
		[1]=>
		string(1) "2"
		[2]=>
		string(1) "3"
		[3]=>
		string(1) "4"
	      }

SEE ALSO

       cubrid_seq_drop(3).

PHP Documentation Group 													 CUBRID_SET_ADD(3)

Linux and UNIX Man Pages

cubrid_commit(3) [php man page]

Check Out this Related Man Page