ID:               25510
 Updated by:       [EMAIL PROTECTED]
 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:

Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip

2 informix bugs were fixed since 4.3.3 was released.



Previous Comments:
------------------------------------------------------------------------

[2003-09-16 23:24:20] tqnam at pmail dot vnn dot vn

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".

------------------------------------------------------------------------

[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

Reply via email to