cubrid_lob2_seek(3) [php man page]

CUBRID_LOB2_SEEK(3)							 1						       CUBRID_LOB2_SEEK(3)

cubrid_lob2_seek - Move the cursor of a lob object.

SYNOPSIS

       bool cubrid_lob2_seek (resource	$lob_identifier, int  $offset, [int  $origin = CUBRID_CURSOR_CURRENT])

DESCRIPTION

	The  cubrid_lob2_seek(3)  function  is	used  to move the cursor position of a lob object by the value set in the $offset argument, to the
       direction set in the $origin argument.

	To set the $origin argument, you can use CUBRID_CURSOR_FIRST to set the cursor position moving forward $offset units from the first begin-
       ning. In this case, $offset must be a positive value.

	If you use CUBRID_CURSOR_CURRENT for $origin, you can move forward or backward. and $offset can be positive or negative.

	If  you  use  CUBRID_CURSOR_LAST for $origin, you can move backward $offset units from the end of LOB object and $offset only can be posi-
       tive.

PARAMETERS

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

	      o $offset
		-Number of units you want to move the cursor.

	      o $origin
		-This parameter can be the following values:CUBRID_CURSOR_FIRST: move forward from the first beginning.CUBRID_CURSOR_CURRENT: move
		forward or backward from the current position.CUBRID_CURSOR_LAST: move backward at the end of LOB object.

RETURN VALUES

       TRUE if the process is successful and FALSE for failure.

EXAMPLES

       Example #1

	      cubrid_lob2_seek(3) example

	      <?php
	      // test_lob (id INT, contents CLOB)
	      $conn = cubrid_connect("localhost", 33000, "demodb", "dba", "");

	      cubrid_execute($conn,"DROP TABLE if exists test_lob");
	      cubrid_execute($conn,"CREATE TABLE test_lob (id INT, contents CLOB)");
	      $req = cubrid_prepare($conn, "INSERT INTO test_lob VALUES(2, ?)");

	      $lob = cubrid_lob2_new($conn, 'CLOB');
	      $len = cubrid_lob2_write($lob, "Hello world");

	      cubrid_lob2_seek($lob, 0, CUBRID_CURSOR_LAST);
	      cubrid_lob2_write($lob, "beautiful");

	      cubrid_lob2_seek($lob, 15, CUBRID_CURSOR_FIRST);
	      $data = cubrid_lob2_read($lob, 5);

	      echo $data."
";

	      cubrid_lob2_bind($req, 1, $lob);
	      cubrid_execute($req);

	      cubrid_disconnect($conn);
	      ?>

SEE ALSO

       cubrid_lob2_read(3),   cubrid_lob2_write(3),   cubrid_lob2_seek64(3),   cubrid_lob2_tell(3),   cubrid_lob2_tell64(3),  cubrid_lob2_size(3),
       cubrid_lob2_size64(3).

PHP Documentation Group 												       CUBRID_LOB2_SEEK(3)

Check Out this Related 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)

Linux and UNIX Man Pages

cubrid_lob2_seek(3) [php man page]

Check Out this Related Man Page