cubrid_lob2_export(3) [php man page]

CUBRID_LOB2_EXPORT(3)							 1						     CUBRID_LOB2_EXPORT(3)

cubrid_lob2_export - Export the lob object to a file.

SYNOPSIS

       bool cubrid_lob2_export (resource  $lob_identifier, string  $file_name)

DESCRIPTION

	The  cubrid_lob2_export(3)  function  is  used	to  save  the  contents  of  BLOB/CLOB	data to a file. To use this function, you must use
       cubrid_lob2_new(3) or fetch a lob object from CUBRID database first. If the file already exists, the operation  will  fail.  This  function
       will not influence the cursor position of the lob object. It operates the entire lob object.

PARAMETERS

	      o $lob_identifier
		-Lob identifier as a result of cubrid_lob2_new(3) or get from the result set.

	      o $filename
		-File name you want to store BLOB/CLOB data. It also supports the path of the file.

RETURN VALUES

       TRUE if the process is successful and FALSE for failure.

EXAMPLES

       Example #1

	      cubrid_lob2_export(3) example

	      <?php
	      // Table: test_lob (id INT, contents CLOB)

	      $conn = cubrid_connect("localhost", 33000, "demodb", "dba", "");

	      cubrid_execute($conn,"DROP TABLE if exists doc");
	      cubrid_execute($conn,"CREATE TABLE doc (id INT, doc_content CLOB)");
	      cubrid_execute($conn,"INSERT INTO doc VALUES (5,'hello,cubrid')");

	      $req = cubrid_prepare($conn, "select * from doc");

	      cubrid_execute($req);

	      cubrid_move_cursor($req, 1, CUBRID_CURSOR_FIRST);

	      $row = cubrid_fetch($req, CUBRID_NUM | CUBRID_LOB);

	      cubrid_lob2_export($row[1], "doc_3.txt");

	      cubrid_lob2_close($row[1]);
	      cubrid_disconnect($conn);
	      ?>

SEE ALSO

       cubrid_lob2_new(3), cubrid_lob2_close(3), cubrid_lob2_import(3), cubrid_lob2_bind(3).

PHP Documentation Group 												     CUBRID_LOB2_EXPORT(3)

CUBRID_LOCK_WRITE(3)							 1						      CUBRID_LOCK_WRITE(3)

cubrid_lock_write - Set a write lock on the given OID

SYNOPSIS

       bool cubrid_lock_write (resource  $conn_identifier, string  $oid)

DESCRIPTION

	The cubrid_lock_write(3) function is used to put write lock on the instance pointed by the given $oid.

PARAMETERS

	      o $conn_identifier
		-Connection identifier.

	      o $oid
		-OID of the instance that you want to put write lock on.

RETURN VALUES

       TRUE, when process is successful.

       FALSE, when process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_lock_write(3) example

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

	      @cubrid_execute($conn, "DROP TABLE foo");
	      cubrid_execute($conn, "CREATE TABLE foo(a int AUTO_INCREMENT, b set(int), c list(int), d char(10))");
	      cubrid_execute($conn, "INSERT INTO foo(a, b, c, d) VALUES(1, {1,2,3}, {11,22,33,333}, 'a')");
	      cubrid_execute($conn, "INSERT INTO foo(a, b, c, d) VALUES(2, {4,5,7}, {44,55,66,666}, 'b')");

	      $req = cubrid_execute($conn, "SELECT * FROM foo", CUBRID_INCLUDE_OID);

	      cubrid_move_cursor($req, 1, CUBRID_CURSOR_FIRST);
	      $oid = cubrid_current_oid($req);

	      cubrid_lock_write($conn, $oid);

	      $attr = cubrid_col_get($conn, $oid, "b");
	      var_dump($attr);

	      cubrid_put($conn, $oid, "b", array(2, 4, 8));

	      $attr = cubrid_col_get($conn, $oid, "b");
	      var_dump($attr);

	      cubrid_close_request($req);
	      cubrid_disconnect($conn);
	      ?>

	      The above example will output:

	      array(3) {
		[0]=>
		string(1) "1"
		[1]=>
		string(1) "2"
		[2]=>
		string(1) "3"
	      }
	      array(3) {
		[0]=>
		string(1) "2"
		[1]=>
		string(1) "4"
		[2]=>
		string(1) "8"
	      }

SEE ALSO

       cubrid_lock_read(3).

PHP Documentation Group 												      CUBRID_LOCK_WRITE(3)