Edit report at http://bugs.php.net/bug.php?id=40913&edit=1
ID: 40913
Comment by: samuel at ingessons dot se
Reported by: dennis at inmarket dot lviv dot ua
Summary: PDO::PARAM_LOB does not bind to a stream for
fetching a BLOB
Status: Verified
Type: Bug
Package: PDO related
Operating System: Win XP
PHP Version: 5.2.6
Assigned To: wez
Block user comment: N
New Comment:
Is there a way to solve the problem and get a stream?
I want to make a pipeline directly from a longblob to the client.
Previous Comments:
------------------------------------------------------------------------
[2010-08-24 11:22:11] david at futuresbright dot com
I have experienced the same issue with Windows 2003 using SQL Server 9.0
and php 5.2.13.
Really disappointing that this bug can have been around for so many
years without being fixed.
------------------------------------------------------------------------
[2010-02-19 21:02:32] jcook at macmillanmarketing dot com
I've just been able to reproduce this bug today running PHP 5.3.1 on
Windows.
Reproduce Code:
$db = db::getConn();
$st = $db->prepare($sql);
$st->execute(array(':id' => $id));
$st->bindColumn(1, $image, PDO::PARAM_LOB);
$st->fetch(PDO::FETCH_BOUND);
header ('Content-type: image/jpeg');
fpassthru($image);// this call fails with 'supplied argument is not a
valid stream resource'
Expected result:
Resource
Actual result:
string
I can work around this error for what I'm trying to do but it would be
nice if this was fixed.
------------------------------------------------------------------------
[2009-07-27 15:12:53] ralph dot reckert at web dot de
That error still does not seem to be solved in the current PHP version
5.3.0 nor in 5.2.10. At least it is not listed in the ChangeLog list of
fixed bugs of that versions.
It would be nice if, four years after PDO was released and almost two
and a half years after that bug was first reported, someone could try to
fix it, really test that fix and make shure it finds it's way into some
release version of PHP.
Until then, in my opinion the status of this bug report should be OPEN!
Best regards,
Ralph
------------------------------------------------------------------------
[2009-06-30 14:13:16] ralfbecker at egroupware dot org
Hi,
I still can reproduce the Problem with php5.3.0RC2.
Ralf
------------------------------------------------------------------------
[2009-05-29 14:25:59] linuxuser586 at yahoo dot com
Problem still exists on Windows 2003 with PHP Version 5.2.10RC2-dev
Build Date May 29 2009 11:39:28
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/bug.php?id=40913
--
Edit this bug report at http://bugs.php.net/bug.php?id=40913&edit=1
