script for reading BLOB data


 
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
IBASE_BLOB_GET(3)							 1							 IBASE_BLOB_GET(3)

ibase_blob_get - Get len bytes data from open blob

SYNOPSIS
string ibase_blob_get (resource $blob_handle, int $len) DESCRIPTION
This function returns at most $len bytes from a BLOB that has been opened for reading by ibase_blob_open(3). Note It is not possible to read from a BLOB that has been opened for writing by ibase_blob_create(3). PARAMETERS
o $blob_handle - A BLOB handle opened with ibase_blob_open(3). o $len - Size of returned data. RETURN VALUES
Returns at most $len bytes from the BLOB, or FALSE on failure. EXAMPLES
Example #1 ibase_blob_get(3) example <?php $result = ibase_query("SELECT blob_value FROM table"); $data = ibase_fetch_object($result); $blob_data = ibase_blob_info($data->BLOB_VALUE); $blob_hndl = ibase_blob_open($data->BLOB_VALUE); echo ibase_blob_get($blob_hndl, $blob_data[0]); ?> Whilst this example doesn't do much more than a 'ibase_blob_echo($data->BLOB_VALUE)' would do, it does show you how to get information into a $variable to manipulate as you please. SEE ALSO
ibase_blob_open(3), ibase_blob_close(3), ibase_blob_echo(3). PHP Documentation Group IBASE_BLOB_GET(3)