PHWinfo - Afficher un message - Displaying an image from inside Mysql database..

14/09/2007, 12h17

Captain Paralytic wrote:
> On 14 Sep, 11:55, The Natural Philosopher <a...@b.c> wrote:
>> Ok. what I want to do, is have pictures as BLOBS in a database.
>>
>> And show them onscreen.
>>
>> If I have a generic program called say - showpic.php - which is capable
>> of spitting out an image suitable for downloading, and I write a bit of
>> HTML like
>>
>> <IMG URL="showpic.php?id=1112233456">Picture of item 1112233456</IMG>
>>
>> where the id is and index to the actual picture I want, for example,
>> will that work?
>
> It will only work if the script executed from showpic.php reads the
> data from the database and sends it with the correct headers to the
> browser.
>
Thanks buddy!

That is down to debugging, that's all.

How does the browser know if its a jpeg or a gif? Mime type I guess? OK.
That all makes sense.

14/09/2007, 12h17	#3
The Natural Philosopher Messages: n/a Hébergeur:	Re: Displaying an image from inside Mysql database.. Captain Paralytic wrote: > On 14 Sep, 11:55, The Natural Philosopher <a...@b.c> wrote: >> Ok. what I want to do, is have pictures as BLOBS in a database. >> >> And show them onscreen. >> >> If I have a generic program called say - showpic.php - which is capable >> of spitting out an image suitable for downloading, and I write a bit of >> HTML like >> >> <IMG URL="showpic.php?id=1112233456">Picture of item 1112233456</IMG> >> >> where the id is and index to the actual picture I want, for example, >> will that work? > > It will only work if the script executed from showpic.php reads the > data from the database and sends it with the correct headers to the > browser. > Thanks buddy! That is down to debugging, that's all. How does the browser know if its a jpeg or a gif? Mime type I guess? OK. That all makes sense.