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_LOB2_BIND(3)							 1						       CUBRID_LOB2_BIND(3)

cubrid_lob2_bind - Bind a lob object or a string as a lob object to a prepared statement as parameters.

SYNOPSIS

       bool cubrid_lob2_bind (resource	$req_identifier, int  $bind_index, mixed  $bind_value, [string	$bind_value_type])

DESCRIPTION

	The  cubrid_lob2_bind(3)  function  is used to bind BLOB/CLOB datas to a corresponding question mark placeholder in the SQL statement that
       was passed to cubrid_prepare(3). If $bind_value_type is not given, string will be "BLOB" as the default. But if you use	cubrid_lob2_new(3)
       before, $bind_value_type will be consistent with $type in cubrid_lob2_new(3) as the default.

PARAMETERS

	      o $req_identifier
		-Request identifier as a result of cubrid_prepare(3).

	      o $bind_index
		-Location of binding parameters. It starts with 1.

	      o $bind_value
		-Actual value for binding.

	      o $bind_value_type
		-It must be "BLOB" or "CLOB" and it won't be case-sensitive. If it not be given, the default value is "BLOB".

RETURN VALUES

       TRUE, when process is successful.

       FALSE, when process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_lob2_bind(3) example

	      <?php
	      // Table: test_lob (id INT, contents CLOB)

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

	      cubrid_execute($conn,"DROP TABLE if exists test_lob");
	      cubrid_execute($conn,"CREATE TABLE test_lob (id INT, contents CLOB)");

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

	      cubrid_bind($req,1, 3);

	      $lob = cubrid_lob2_new($conn, 'CLOB');
	      cubrid_lob2_bind($req, 2, $lob);

	      cubrid_execute($req);

	      cubrid_bind($req, 1, 4);

	      cubrid_lob2_bind($req, 2, 'CUBRID LOB2 TEST', 'CLOB');

	      cubrid_execute($req);

	      cubrid_disconnect($conn);
	      ?>

SEE ALSO

       cubrid_lob2_new(3), cubrid_lob2_close(3).

PHP Documentation Group 												       CUBRID_LOB2_BIND(3)

Linux and UNIX Man Pages

cubrid_rollback(3) [php man page]

Check Out this Related Man Page