Edit report at https://bugs.php.net/bug.php?id=40913&edit=1
ID: 40913
Comment by: david dot palella at gmail dot com
Reported by: dennis at inmarket dot lviv dot ua
Summary: PDO::PARAM_LOB does not bind to a stream for
fetching a BLOB
Status: Closed
Type: Bug
Package: PDO related
Operating System: Win XP
PHP Version: 5.2.6
Assigned To: mysql
Block user comment: N
Private report: N
New Comment:
The problem is still present with PHP v. 5.3.10 and Ubuntu 12.10
Previous Comments:
------------------------------------------------------------------------
[2011-10-20 09:48:17] oridan82 at gmail dot com
PHP 5.3.5
PARAM_LOB is returning a string instead of a stream.
Code:
-----
$stmt = $conn->prepare($qry);
$stmt->bindValue(1, $_GET['id']);
$stmt->bindValue(2, $_GET['aid']);
$stmt->execute();
$stmt->bindColumn(4, $mimeType, PDO::PARAM_STR, 256);
$stmt->bindColumn(6, $lob, PDO::PARAM_LOB);
$stmt->fetch(PDO::FETCH_BOUND);
echo gettype($lob);
Expected Result:
----------------
resource
Actual Result:
--------------
string
------------------------------------------------------------------------
[2011-01-04 13:21:09] [email protected]
See last comment, works with 5.3.4
------------------------------------------------------------------------
[2010-12-27 01:02:32] php at paloch dot net
Seems to be fixed in 5.3.4 final. I was struggling with this issue (and PHP
5.2.16) all evening before finding this post. I tried installing PHP 5.3.4 and
voila, problem solved.
------------------------------------------------------------------------
[2010-11-22 10:43:16] [email protected]
5.2 only gets security fixes, if at all.
Can this be reproduced with 5.3.4-RC, using libmysql (recent one!), using
mysqlnd?
------------------------------------------------------------------------
[2010-10-05 18:10:13] samuel at ingessons dot se
And another reason why I need a stream and not a string is that a string would
consume all the memory for a large object.
------------------------------------------------------------------------
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
https://bugs.php.net/bug.php?id=40913
--
Edit this bug report at https://bugs.php.net/bug.php?id=40913&edit=1
