#25510 [Opn->Fbk]: How to get Blob in informix
| From: | sniper@php.net | Date: | Tue, 16 Sep 2003 14:23:41 +0000 |
| Subject: | #25510 [Opn->Fbk]: How to get Blob in informix | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-47636@lists.php.net to get a copy of this message | ||
ID: 25510
Updated by: sniper@php.net
Reported By: tqnam at pmail dot vnn dot vn
-Status: Open
+Status: Feedback
Bug Type: Informix related
Operating System: window 2000
PHP Version: 4.3.3
New Comment:
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
Previous Comments:
------------------------------------------------------------------------
[2003-09-12 05:38:38] tqnam at pmail dot vnn dot vn
Description:
------------
I insert a blob value into table, but when i get blob value it is erro,
please help me get it.
Reproduce code:
---------------
// the code insert blob value
$query="insert into blobimage(pit_id,pit_image)
values(5,FILETOBLOB('".$pathfile."','server'))";
$stmt=ifx_query($query,$con);
if(!$stmt){print("errors");}
ifx_free_result($stmt);
ifx_close($con);
// The code I get blob value
$query="select pit_image from blobimage where pit_id=5";
ifx_blobinfile_mode(1);
$stmt=ifx_query($query,$con);
if(!$stmt){print("errors");}
$row=ifx_fetch_row($stmt);
$content=ifx_get_blob($row["pit_image"]);
ifx_free_result($stmt);
ifx_close($con);
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=25510&edit=1