cubrid_lob_export(3) [php man page]

CUBRID_LOB_EXPORT(3)							 1						      CUBRID_LOB_EXPORT(3)

cubrid_lob_export - Export BLOB/CLOB data to file

SYNOPSIS

       bool cubrid_lob_export (resource  $conn_identifier, resource  $lob_identifier, string  $path_name)

DESCRIPTION

       cubrid_lob_export(3)  is  used to get BLOB/CLOB data from CUBRID database, and saves its contents to a file. To use this function, you must
       use cubrid_lob_get(3) first to get BLOB/CLOB info from CUBRID.

PARAMETERS

	      o $conn_identifier
		-Connection identifier.

	      o $lob_identifier
		-LOB identifier.

	      o $path_name
		-Path name of the file.

RETURN VALUES

       TRUE, when process is successful.

       FALSE, when process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_lob_export(3) example

	      <?php
	      $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')");

	      $lobs = cubrid_lob_get($conn, "SELECT doc_content FROM doc WHERE id=5");
	      echo "Doc size: ".cubrid_lob_size($lobs[0])." bytes";
	      cubrid_lob_export($conn, $lobs[0], "doc_5.txt");
	      cubrid_lob_close($lobs);
	      cubrid_disconnect($conn);
	      ?>

SEE ALSO

       cubrid_lob_get(3), cubrid_lob_close(3), cubrid_lob_size(3), cubrid_lob_send(3).

PHP Documentation Group 												      CUBRID_LOB_EXPORT(3)

CUBRID_LOB_GET(3)							 1							 CUBRID_LOB_GET(3)

cubrid_lob_get - Get BLOB/CLOB data

SYNOPSIS

       array cubrid_lob_get (resource  $conn_identifier, string  $sql)

DESCRIPTION

       cubrid_lob_get(3)  is  used  to	get  BLOB/CLOB	meta  info from CUBRID database, CUBRID gets BLOB/CLOB by executing the SQL statement, and
       returns all LOBs as a resource array. Be sure that the SQL retrieves only one column and its data type is BLOB or CLOB.

	Remember to use cubrid_lob_close(3) to release the LOBs if you don't need it any more.

PARAMETERS

	      o $conn_identifier
		-Connection identifier.

	      o $sql
		-SQL statement to be executed.

RETURN VALUES

	Return an array of LOB resources, when process is successful.

       FALSE, when process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_lob_get(3) example

	      <?php
	      $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')");

	      $lobs = cubrid_lob_get($conn, "SELECT doc_content FROM doc WHERE id=5");
	      echo "Doc size: ".cubrid_lob_size($lobs[0])." bytes";
	      cubrid_lob_export($conn, $lobs[0], "doc_5.txt");
	      cubrid_lob_close($lobs);
	      cubrid_disconnect($conn);
	      ?>

SEE ALSO

       cubrid_lob_close(3), cubrid_lob_size(3), cubrid_lob_export(3), cubrid_lob_send(3).

PHP Documentation Group 													 CUBRID_LOB_GET(3)