Bug #40913 [Com]: PDO::PARAM_LOB does not bind to a stream for fetching a BLOB

From: Date: Wed, 07 Nov 2012 08:55:18 +0000
Subject: Bug #40913 [Com]: PDO::PARAM_LOB does not bind to a stream for fetching a BLOB
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-174546@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=40913&edit=1

 ID:                 40913
 Comment by:         vicrry at yahoo dot com dot hk
 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:

As of PHP 5.3.15, this bug still exists.


Previous Comments:
------------------------------------------------------------------------
[2012-08-04 12:40:50] david dot palella at gmail dot com

The problem is still present with PHP v. 5.3.10 and Ubuntu 12.10

------------------------------------------------------------------------
[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] uw@php.net

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] uw@php.net

5.2 only gets security fixes, if at all. 

Can this be reproduced with 5.3.4-RC, using libmysql (recent one!), using mysqlnd?

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


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

Thread (39 messages)

« previous php.bugs (#174546) next »