ID: 25510
User updated by: tqnam at pmail dot vnn dot vn
Reported By: tqnam at pmail dot vnn dot vn
-Status: Feedback
+Status: Open
Bug Type: Informix related
Operating System: window 2000
PHP Version: 4.3.3
New Comment:
I used PHP4.3.3, Webserver ISS.
I used code follow to insert Blob value in too table
$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);
But when I get Blob value by the code
$query="select pit_image from blobimage ";
ifx_blobinfile_mode(0);
ifx_nullformat(1);
$stmt=ifx_query($query,$con);
if(!$stmt){print("errors");}
$row=ifx_fetch_row($stmt);
$content=ifx_get_blob($row["pit_image"]);
ifx_free_blob($row["pit_image"]);
ifx_free_result($stmt);
ifx_close($con);
PHP show error massege "The instruction at "0x250075f0" preferenced
memory at "0x0000000".
The memory could not read".
Previous Comments:
------------------------------------------------------------------------
[2003-09-16 10:23:40] [EMAIL PROTECTED]
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.
------------------------------------------------------------------------
[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
