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?

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.

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.

..oO(The Natural Philosopher)

>How does the browser know if its a jpeg or a gif? Mime type I guess?

Correct. For example

header('Content-Type: image/jpeg');

Micha

Michael Fesser wrote:
> .oO(The Natural Philosopher)
>
>> How does the browser know if its a jpeg or a gif? Mime type I guess?
>
> Correct. For example
>
> header('Content-Type: image/jpeg');
>
> Micha
Ok. Thats all coded in now anyway. I'll test later. Many thanks all.

On 14 Sep, 15:00, The Natural Philosopher <a...@b.c> wrote:
> Michael Fesser wrote:
> > .oO(The Natural Philosopher)
>
> >> How does the browser know if its a jpeg or a gif? Mime type I guess?
>
> > Correct. For example
>
> > header('Content-Type: image/jpeg');
>
> > Micha
>
> Ok. Thats all coded in now anyway. I'll test later. Many thanks all.

BTW, I used this as a resource to save writing it all from scratch:

http://www.onlamp.com/pub/a/onlamp/2...09/webdb2.html

Captain Paralytic wrote:
> On 14 Sep, 15:00, The Natural Philosopher <a...@b.c> wrote:
>> Michael Fesser wrote:
>>> .oO(The Natural Philosopher)
>>>> How does the browser know if its a jpeg or a gif? Mime type I guess?
>>> Correct. For example
>>> header('Content-Type: image/jpeg');
>>> Micha
>> Ok. Thats all coded in now anyway. I'll test later. Many thanks all.
>
> BTW, I used this as a resource to save writing it all from scratch:
>
> http://www.onlamp.com/pub/a/onlamp/2...09/webdb2.html
>
Well I've done it all, but it still doesn't work.

On safari a direct call to the program nets me a question mark graphic,
in Firefox it just echoes the browser URL..

Inside teh actual display I just get a fractured graphic symbol..

The Natural Philosopher wrote:
> Captain Paralytic wrote:
>> On 14 Sep, 15:00, The Natural Philosopher <a...@b.c> wrote:
>>> Michael Fesser wrote:
>>>> .oO(The Natural Philosopher)
>>>>> How does the browser know if its a jpeg or a gif? Mime type I guess?
>>>> Correct. For example
>>>> header('Content-Type: image/jpeg');
>>>> Micha
>>> Ok. Thats all coded in now anyway. I'll test later. Many thanks all.
>>
>> BTW, I used this as a resource to save writing it all from scratch:
>>
>> http://www.onlamp.com/pub/a/onlamp/2...09/webdb2.html
>>
> Well I've done it all, but it still doesn't work.
>
> On safari a direct call to the program nets me a question mark graphic,
> in Firefox it just echoes the browser URL..
>
> Inside teh actual display I just get a fractured graphic symbol..
>
>
Oh..it works inside the program now, but not as a standalone. Hmm.

I had an SQL permissions problem..