ID: 35338
Updated by: [EMAIL PROTECTED]
Reported By: f dot engelhardt at 21torr dot com
-Status: Open
+Status: Feedback
Bug Type: PDO related
Operating System: Linux
PHP Version: 5CVS-2005-11-22 (CVS)
New Comment:
Are you able to reproduce it with something different than PgSQL?
Sqlite, for example?
Are you able to reproduce it with PHP CLI?
Previous Comments:
------------------------------------------------------------------------
[2005-11-22 20:57:09] f dot engelhardt at 21torr dot com
Description:
------------
I tried to write binary data into a postgresql table, that work, but i
can not get this data out the table anymore.
Reproduce code:
---------------
<?php
$dbh = new PDO('pgsql:host=localhost;dbname=test','root','fo0224');
$q = 'SELECT data FROM foobar';
$stmt = $dbh->prepare($q);
if ($stmt)
{
$stmt->bindColumn('DATA',$sData);
if (!$stmt->execute())
{
print_r($stmt->errorInfo());
die('DAMN');
}
if (!$stmt->fetch(PDO::FETCH_BOUND))
{
print_r($stmt->errorInfo());
die('DAMN');
}
header('Content-Type: image/jpeg');
echo $sData;
} else {
print_r($dbh->errorInfo());
}
?>
Table foobar only has a bytea column named data
Expected result:
----------------
should display the image
Actual result:
--------------
the php-process does not do anything, the browser waits for an answer
(i waited 5 minutes, but nothing happened)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=35338&edit=1
