Hi,
Anybody who could help me how to display a blob stored in interbase??? I tried the example in php.net but it didn't work. The output pic appears to be corrupted. The example provided by php.net goes like this...
$S = "select emp_no,hire_date,salary,pic,full_name";
$S .= " from employee m join user_permissions p ";
$S .= " on p.dept_no = m.dept_no ";
$S .= " where p.user_name = ? ";
$S .= " and m.emp_no = ?";
$Q = ibase_query($S,$USER_NAME,$EMPNO);
while ($R = ibase_fetch_object($Q))
{
$TEMPFILE = tempnam("temp","TMP");
$TEMPFILE .= ".jpg";
$BLOBID = ibase_blob_open($R->PIC);
$FILEID = fopen($TEMPFILE,"w");
while ($PIC = ibase_blob_get($BLOBID,10240))
{
fputs($FILEID,$PIC);
}
fclose($FILEID);
ibase_blob_close($BLOBID);
$TEMPFILE = "/php3/" . $TEMPFILE;
echo "<BR><BR><CENTER><IMG SRC=$TEMPFILE >
}
ibase_free_result($Q);
ibase_commit();
Am using php4.2.1 and firebird 1.0...
Can anyone help me about this???
thanx...
rsilvs