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_PREPARE(3)							 1							 CUBRID_PREPARE(3)

cubrid_prepare - Prepare a SQL statement for execution

SYNOPSIS

       resource cubrid_prepare (resource  $conn_identifier, string  $prepare_stmt, [int  $option])

DESCRIPTION

	The  cubrid_prepare(3)	function  is  a sort of API which represents SQL statements compiled previously to a given connection handle. This
       pre-compiled SQL statement will be included in the cubrid_prepare(3).

	Accordingly, you can use this statement effectively to execute several times repeatedly or to process long data. Only a  single  statement
       can  be used and a parameter may put a question mark (?) to appropriate area in the SQL statement. Add a parameter when you bind a value in
       the VALUES clause of INSERT statement or in the WHERE clause. Note that it  is  allowed	to  bind  a  value  to	a  MARK(?)  by	using  the
       cubrid_bind(3) function only.

PARAMETERS

	      o $conn_identifier
		-Connection identifier.

	      o $prepare_stmt
		-Prepare query.

	      o $option
		-OID return option CUBRID_INCLUDE_OID.

RETURN VALUES

	Request identifier, if process is successful;

       FALSE, if process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_prepare(3) example

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

	      $sql = <<<EOD
	      SELECT g.event_code, e.name
	      FROM game g
	      JOIN event e ON g.event_code=e.code
	      WHERE host_year = ? AND event_code NOT IN (SELECT event_code FROM game WHERE host_year=?) GROUP BY event_code;
	      EOD;

	      $req = cubrid_prepare($conn, $sql);

	      cubrid_bind($req, 1, 2004);
	      cubrid_bind($req, 2, 2000);
	      cubrid_execute($req);

	      $row_num = cubrid_num_rows($req);
	      printf("There are %d event that exits in 2004 olympic but not in 2000. For example:

", $row_num);

	      printf("%-15s %s
", "Event_code", "Event_name");
	      printf("----------------------------
");

	      $row = cubrid_fetch_assoc($req);
	      printf("%-15d %s
", $row["event_code"], $row["name"]);
	      $row = cubrid_fetch_assoc($req);
	      printf("%-15d %s
", $row["event_code"], $row["name"]);

	      cubrid_disconnect($conn);
	      ?>

	      The above example will output:

	      There are 27 event that exits in 2004 olympic but not in 2000. For example:

	      Event_code      Event_name
	      ----------------------------
	      20063	      +91kg
	      20070	      64kg

SEE ALSO

       cubrid_execute(3), cubrid_bind(3).

PHP Documentation Group 													 CUBRID_PREPARE(3)

Linux and UNIX Man Pages

cubrid_commit(3) [php man page]

Check Out this Related Man Page