Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

script for reading BLOB data

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting script for reading BLOB data
# 1  
Old 04-25-2007
script for reading BLOB data
Hi,

this may not be a right place to post my question. But still....

I have database table of which one field contains BLOB data. Actually the BLOB data is xml script.

Now How do I retrieve that xml script to xml file on unix(or windows). I will have to loop thru the records. There are more than 50 records with such BLOB field.

I tried googling around but did not get much help.

Any pointers would help....

Thanks in advance,
-Ashish
Login or Register to Ask a Question

Previous Thread | Next Thread
Login or Register to Ask a Question

LEARN ABOUT PHP

cubrid_lob_send

CUBRID_LOB_SEND(3)							 1							CUBRID_LOB_SEND(3)

cubrid_lob_send - Read BLOB/CLOB data and send straight to browser

SYNOPSIS

       bool cubrid_lob_send (resource  $conn_identifier, resource  $lob_identifier)

DESCRIPTION

       cubrid_lob_send(3) reads BLOB/CLOB data and passes it straight through to the browser. 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.

RETURN VALUES

       TRUE, when process is successful.

       FALSE, when process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_lob_send(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");

	      cubrid_lob_send($conn, $lobs[0]);
	      cubrid_lob_close($lobs);
	      cubrid_disconnect($conn);
	      ?>

SEE ALSO

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

PHP Documentation Group 													CUBRID_LOB_SEND(3)