Reply to Re: Displaying an image from inside Mysql database..

Your name:

Reply:


Posted by The Natural Philosopher on 09/18/07 17:09

Erwin Moller wrote:
> The Natural Philosopher wrote:
>> 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/2002/05/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..
>
> Hi,
>
> A little tip that saved me some time during the type of work you do now:
> If you think your script is screwing up somewhere, and you want to see
> the errors, simply change the header for mimetype into text/plain, and
> call the image directly from the browser.
>
> You won't see the image, but you will see notices and such.
> (Of course you can also look into the errorlog, but that is such a hassle)
> Once you receive a bunch a data that doesn't make sense, you propably
> have the image delivered, and it is time to put the old header back. ;-)
>
> Regards,
> Erwin Moller

Mm. I sorta did that.

There were two issues..one is my test database had not got the right
permissions - there is something odd gong on because according to my
understanding the user had full rights, but I had to give that user full
rights in the database as well. Odd. Anyway that was half the problem.

The second half is that while the image now pops up when and IMG tag is
wrapped round it, a direct call to the image sender program results in a
file download, not an image being displayed..well I haven;t go time to
delve into either if those issues right now, so they stand..

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация