cubrid_error_code(3) [php man page]

CUBRID_ERROR_CODE(3)							 1						      CUBRID_ERROR_CODE(3)

cubrid_error_code - Get error code for the most recent function call

SYNOPSIS

       int cubrid_error_code (void  )

DESCRIPTION

	The  cubrid_error_code(3) function is used to get the error code of the error that occurred during the API execution. Usually, it gets the
       error code when API returns false as its return value.

PARAMETERS

       This function has no parameters.

RETURN VALUES

	Error code of the error that occurred, or 0 (zero) if no error occurred.

EXAMPLES

       Example #1

	      cubrid_error_code(3) example

	      <?php
	      $conn = cubrid_connect("localhost", 33000, "demodb");
	      $req = cubrid_prepare($conn , "SELECT * FROM code WHERE s_name=?");

	      $req = @cubrid_execute($req);
	      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: 4
	      Error code: -30015
	      Error msg: Some parameter not binded

SEE ALSO

       cubrid_error_code_facility(3), cubrid_error_msg(3).

PHP Documentation Group 												      CUBRID_ERROR_CODE(3)

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)