cubrid_commit(3) php man page | unix.com

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)