read BLOB from mysql using php PDO

Question

I have a database with a BLOB field (weeklyOccupancy). I am trying to access the data in PHP using:

$sqlCmd = 'select weeklyOccupancy from Occupancy order by startDate;';
$pdoStmt = $dbh->query($sqlCmd);
$pdoStmt->bindColumn(1, $lob, PDO::PARAM_LOB);
$pdoStmt->fetch(PDO::FETCH_BOUND);
foreach($pdoStmt as $row){
    $weeklyData = stream_get_contents($lob); 
    ....
}

However, stream_get_contents says that $lob is a string (named "Resource id #1) although I believe it should be a stream. I have seen this mentioned as a bug (http://www.php.net/manual/en/pdo.lobs.php#96311) but the workaround is not relevant for my application - in which the blob holds a bit string not an image to be displayed.

Any ideas how I can get the data out of a blob field in PHP? Thanks

Explosion Pills · Accepted Answer · 2012-01-19 02:43:31Z

-1

Not all PDO drivers return a LOB as a file stream; mysql 5 is one example. You can try treating lob as a string after the bind.

answered Jan 19, 2012 at 2:43

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

LenB Over a year ago

I am happy to treat it as a string; however, I need to know the function which allows me to retrieve the data from the DB.

LenB · Accepted Answer · 2012-01-19 13:12:16Z

-1

Oops. There was an earlier error in my code. Problem gone.

answered Jan 19, 2012 at 13:12

LenB

1,2024 gold badges16 silver badges32 bronze badges

Collectives™ on Stack Overflow

read BLOB from mysql using php PDO

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related