Hi there.
I have a problem with selecting and displaying binary data( images)
DB Engine - Postgress
ODBC - unixODBC
PHP - 4.1.2
I connect to postgres via ODBC.
Have problems with displaying data of type BYTEA ( images )
here code of script selecting and displaying images:
= script name print_img ================================================
$dbconn = odbc_connect( "DSN", "DB", "pwd");
$result = odbc_exec ($dbconn,"SELECT image_type, image FROM ogrenci WHERE
id_no=1");
odbc_binmode( $result, 1 );
odbc_longreadlen( $result, 16384 ); // all imges are not greater than 10Kb.
$num = odbc_num_rows($result);
for ($i=0; $i<$num; $i++) {
odbc_fetch_row($result, $i);
odbc_result($result,"image_type");
echo Header("Content/type: ".odbc_result($result,"image_type")."\"");
$img = stripcslashes( odbc_result($result,"image"));
echo $img;
}
==================================================================
All imges are not greater than 10Kb.
most of images can not be displayed and few looks corrupted...
However, when I use Postgres function:
==================================================================
$dbconn1 = pg_connect (".....);
$result = pg_exec ($dbconn1,"SELECT image_type, image FROM ogrenci WHERE
id_no=1");
$num = pg_numrows($result);
for ($i=0; $i<$num; $i++) {
$r = pg_fetch_row($result, $i);
Header("Content/type: ".($r[0])."\"");
echo stripcslashes($r[1]);
}
==================================================================
all imges displayed just fine!
can any body help with ODBC?
Ling.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
