On Wednesday 13 April 2005 09:11, Cima wrote:
hi,
what is the best way to display an image, that is stored in a database in
postgres, in a table form along with other fields that are in the same
table?
postgresql 8.0
e.g my_table(name varchar(15),sex character (1), picture_id oid)
in a table in php, i'd like to show all the rows in my_table with all the
fields including the picture.
You'll have to write a separate php script that sends an image MIME type,
reads the image from the pgsql database and sends it to the client.
You can't use a single script since the images in a browser are loaded by
separate http requests and the MIME type of the web page (text/html) is
different from the MIME type of the image (image/jpeg, image/gif, image/png
etc.).
thanx.
--
Cyberly yours,
Petar Nedyalkov
Devoted Orbitel Fan :-)
PGP ID: 7AE45436
PGP Public Key: http://bu.orbitel.bg/pgp/bu.asc
PGP Fingerprint: 7923 8D52 B145 02E8 6F63 8BDA 2D3F 7C0B 7AE4 5436
pgpVoaxdU44z6.pgp
Description: PGP signature