php man page for cubrid_lob_get

Query: cubrid_lob_get

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

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)
Related Man Pages
cubrid_affected_rows(3) - php
cubrid_lob2_bind(3) - php
cubrid_lob_close(3) - php
cubrid_lob_export(3) - php
cubrid_lock_write(3) - php
Similar Topics in the Unix Linux Community
How to read from txt file and use that as an array
Using gawk to clean up SQL
Creating CLOB object in unix
ORA-01756 Error while inserting a file in CLOB field
SQL Server import csv or txt on a Solaris box