At 3:53 PM -0300 2/25/07, zerof wrote:
Alain Roger escreveu:
Hi,
i stored all my pictures in my PostgreSQL DB as bytea type.
Now i would like to know how can i display them in my PHP pages ?
where can i find some example ?
thanks a lot,
------------------
It is not a good practice to store pictures in DataBases, use links,
instead of.
<Flame suit on>
Let's not go there again. Both techniques have up-sides and
down-sides -- and I use both depending upon needs.
For example, have you ever tried to back-up an image dB? It's a *lot*
easier if the files are all stored in a dB rather than in a file
system. One is saving just a dB and the other is saving both a dB and
the file system (a lot can go wrong there).
Plus, ask that question on a MySQL list and the MySQL experts will
not advise you to stay away from storing images in MySQL. And every
MySQL book I've ever read that address that issue says that both
techniques have valid points.
The *only* ones that I've ever heard complain about storing an image
file in a dB have been a few php programmers on this list. And no
one, to my knowledge, has ever demonstrated that saving an image in
MySQL is poor practice, other than providing lip-service to that
effect.
My advice, if it works -- use it. Both techniques are valid, have
their advantages, and are good practice.
<Flame suit off>
Cheers,
tedd
--
-------
http://sperling.com http://ancientstones.com http://earthstones.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
