cubrid_disconnect(3) [php man page]

CUBRID_DISCONNECT(3)							 1						      CUBRID_DISCONNECT(3)

cubrid_disconnect - Close a database connection

SYNOPSIS

       bool cubrid_disconnect ([resource  $conn_identifier])

DESCRIPTION

	The  cubrid_disconnect(3)  function  closes the connection handle and disconnects from server. If any request handle is not closed at this
       point, it will be closed. It is similar to the CUBRID MySQL compatible function cubrid_close(3).

PARAMETERS

	      o $conn_identifier
		-Connection identifier.

RETURN VALUES

       TRUE, when process is successful.

       FALSE, when process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_disconnect(3) example

	      <?php
	      $con = cubrid_connect ("localhost", 33000, "demodb");
	      if ($con) {
		 echo "connected successfully";

		 $req = cubrid_execute( $con, "create table person(id int,name char(10))");
		 if ($req) {
		    cubrid_close_request($req);
		    cubrid_commit($con);
		 } else {
		    cubrid_rollback($con);
		 }

		 $req = cubrid_execute( $con, "insert into person values(1,'James')");
		 if ($req) {
		    cubrid_close_request($req);
		    cubrid_commit($con);
		 } else {
		    cubrid_rollback($con);
		 }
		 cubrid_disconnect($con);
	      }
	      ?>

SEE ALSO

       cubrid_close(3), cubrid_connect(3), cubrid_connect_with_url(3).

PHP Documentation Group 												      CUBRID_DISCONNECT(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)