[PHP] Php, Blob, Oracle

2003-02-27 Thread M.ALPER KARASAHIN 

Hi,

How can i display a blob column that contins a MS word object.
OR
How can i display a blob column that contins a bitmap object.

   function foo()
   {
  $this-statement  = OCIParse($this-db_con_id,
  SELECT blobcolumn
   FROM XX );
  if (!$this-statement) { 
 $oerr = OCIError($this-statement); 
 echo Fetch Code 1:.$oerr[message]; 
 exit; 
  }else{
 OCIExecute($this-statement);
  }
  
$displaypage=
table;
while (OCIFetchInto($this-statement,$row,OCI_ASSOC)){  
 $displaypage =$displaypage.
  
  tr
   td align=\center\ class=\td_yazi\.$row[blobcolumn]./td;

   };
$displaypage=
\table;
return$displaypage;
}

Re: [PHP] Php, Blob, Oracle

2003-02-27 Thread Thies C. Arntzen 
On Thu, Feb 27, 2003 at 05:51:01PM +0200, M.ALPER KARASAHIN wrote:
 
 Hi,
 
 How can i display a blob column that contins a MS word object.
 OR
 How can i display a blob column that contins a bitmap object.
 
function foo()
{
   $this-statement  = OCIParse($this-db_con_id,
   SELECT blobcolumn
FROM XX );
   if (!$this-statement) { 
  $oerr = OCIError($this-statement); 
  echo Fetch Code 1:.$oerr[message]; 
  exit; 
   }else{
  OCIExecute($this-statement);
   }
   
 $displaypage=
 table;
 while (OCIFetchInto($this-statement,$row,OCI_ASSOC)){  

  while (OCIFetchInto($this-statement,$row,OCI_ASSOC|OCI_RETURN_LOBS)){

  $displaypage =$displaypage.
   
   tr
td align=\center\ class=\td_yazi\.$row[blobcolumn]./td;

td align=\center\ class=\td_yazi\.$row[BLOBCOLUMN]./td;

 
};
 $displaypage=
 \table;
 return$displaypage;
 }

-- 
Thies C. Arntzen   -   Looking for all sorts of freelance work  -   just ask..
  http://www.amazon.de/exec/obidos/wishlist/AB9DY62QWDSZ

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php