BLOB via Database

Anon

I've tried to show the contents of BLOB on SQLServer format [database], but it didn't satisfied me enough. Because the picture didn't look like it had to.

I think there are some limitations on PHP to show BLOB. And perhaps it limitations are not only hard to show the contents of BLOB followed by text, but may be the resolution of the picture [contents] too.

Can anyone help me and give some responds?

spider_man

I've successfully stored pictures in a database with MySQL and PostgreSQL and never had any problem.
Are your headers Ok? Could it be the SQL Server?

neuromancer

Blob will not read more than 4095 bytes at a time.

Try calling odbc_fetch more than once, if your using the odbc_* functions anyway

fleymingmasc

Have a look here for how this problem was solved using mssql drivers:

http://www.faqts.com/knowledge_base/view.phtml/aid/7108/fid/10

neuromancer

Thats a solution, but a very poor one.

Anon

We also push the refresh button more than once, but the picture just change not much.

please see our script:

$koneksi=odbc_connect("passgo","passgo","passgo");
$eksekusi=odbc_exec($koneksi,"select * from photo where Nip='$nipnya' ");
$nip=odbc_result($eksekusi,1);
$pict=odbc_result($eksekusi,2);
odbc_free_result($eksekusi);
print $pict;
odbc_close_all();

this script will result bad picture.

now if we add one statement before "print $pict" like:

print $nip;

the picture will disapear and we will see the ascii code from the pict [BLOB].

Can you give us your analyse and solution?