note 21745 rejected from function.ibase-blob-open by didou
| From: | didou@php.net | Date: | Sun, 27 Jul 2003 18:43:28 +0000 |
| Subject: | note 21745 rejected from function.ibase-blob-open by didou | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-52780@lists.php.net to get a copy of this message | ||
Note Submitter:
----
I'd tried to output the info & data of the blob field.:
echo "*******************************************************<br>";
$sql = "SELECT id,name,pic FROM employee";
$result = ibase_query( $dbh, $sql );
if (list($id,$name,$pic) = ibase_fetch_row( $result ))
{
print "$id $name";
$blob_data = ibase_blob_info("pic");
$blob_hndl = ibase_blob_open("pic");
print ibase_blob_get( $blob_hndl, $blob_data[0] );
}
else
echo "Load Failed<br>";
echo "*******************************************************<br>";
or ~~~~~~~~~~~~~~~~~~~~~~
while (list($id,$name,$pic) = ibase_fetch_row( $result ))
{
print "$id $name";
$blob_data = ibase_blob_info($pic);
$blob_hndl = ibase_blob_open($pic);
print ibase_blob_get( $blob_hndl, $blob_data[0] );
}
~~~~~~~~~~~~~~~~~~~~~~~~~
or ~~~~~~~~~~~~~~~~~~~~~~~~
every time i used ibase_fetch_object($result) to fetch records, nothing return!!???
~~~~~~~~~~~~~~~~~~~~~~~~
However the result was not what i want:
*******************************************************
1 kelvin
Warning: InterBase module: invalid blob id
Warning: InterBase module: invalid blob id
Warning: InterBase module: 0 is not blob handle
*******************************************************
did i do something wrong?