cubrid_rollback(3) [php man page]

CUBRID_ROLLBACK(3)							 1							CUBRID_ROLLBACK(3)

cubrid_rollback - Roll back a transaction

SYNOPSIS

       bool cubrid_rollback (resource  $conn_identifier)

DESCRIPTION

	The cubrid_rollback(3) function executes rollback on the transaction pointed by $conn_identifier, currently in progress.

	Connection to server is closed after calling cubrid_rollback(3). Connection handle, however, is still valid.

PARAMETERS

	      o $conn_identifier
		-Connection identifier.

RETURN VALUES

       TRUE, when process is successful.

       FALSE, when process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_rollback(3) example

	      <?php
	      $conn = cubrid_connect("127.0.0.1", 33000, "demodb", "dba");
	      cubrid_set_autocommit($conn,false);

	      @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;

	      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_commit(3), cubrid_disconnect(3).

PHP Documentation Group 													CUBRID_ROLLBACK(3)

Check Out this Related Man Page

CUBRID_SET_DROP(3)							 1							CUBRID_SET_DROP(3)

cubrid_set_drop - Delete an element from set type column using OID

SYNOPSIS

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

DESCRIPTION

	The  cubrid_set_drop(3)  function  is  used to delete an element that you request from the given set type (set, multiset) attribute of the
       database.

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 delete an element from.

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

RETURN VALUES

       TRUE, when process is successful.

       FALSE, when process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_set_drop(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_drop($conn, $oid, "b", "1");

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

SEE ALSO

       cubrid_set_add(3).

PHP Documentation Group 													CUBRID_SET_DROP(3)

Linux and UNIX Man Pages

cubrid_rollback(3) [php man page]

Check Out this Related Man Page