cubrid_error_code_facility(3) [php man page]

CUBRID_ERROR_CODE_FACILITY(3)						 1					     CUBRID_ERROR_CODE_FACILITY(3)

cubrid_error_code_facility - Get the facility code of error

SYNOPSIS

       int cubrid_error_code_facility (void  )

DESCRIPTION

	The cubrid_error_code_facility(3) function is used to get the facility code (level in which the error occurred) from the error code of the
       error that occurred during the API execution. Usually, you can get the error code when API returns false as its return value.

PARAMETERS

       This function has no parameters.

RETURN VALUES

	Facility code of the error code that occurred: CUBRID_FACILITY_DBMS, CUBRID_FACILITY_CAS, CUBRID_FACILITY_CCI, CUBRID_FACILITY_CLIENT

EXAMPLES

       Example #1

	      cubrid_error_code_facility(3) example

	      <?php
	      $conn = cubrid_connect("localhost", 33000, "demodb");
	      $req = @cubrid_execute($conn, "SELECT * FROM unknown");
	      if (!$req) {
		  printf("Error facility: %d
Error code: %d
Error msg: %s
",
		      cubrid_error_code_facility(), cubrid_error_code(), cubrid_error_msg());

		  cubrid_disconnect($conn);
		  exit;
	      }
	      ?>

	      The above example will output:

	      Error facility: 1
	      Error code: -493
	      Error msg: Syntax: In line 1, column 15 before END OF STATEMENT
	      Syntax error: unexpected 'unknown'

SEE ALSO

       cubrid_error_code(3), cubrid_error_msg(3).

PHP Documentation Group 											     CUBRID_ERROR_CODE_FACILITY(3)

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)