PHWinfo banniere

Titres
PORTAIL ANNUAIRE ARTICLES COMPARATEUR HÉBERGEURS DEVIS FORUMS RÉDUCTEUR D'URL
Précédent   PHWinfo > Autres forums > Forum Programmation & Conception > comp.lang.php > Displaying an image from inside Mysql database..
S'inscrire FAQ Membres Recherche Messages du jour Marquer les forums comme lus
Displaying an image from inside Mysql database..

Réponse
 
LinkBack Outils de la discussion
Vieux 18/09/2007, 17h00   #9
Erwin Moller
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: Displaying an image from inside Mysql database..

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/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..


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
  Réponse avec citation
Vieux 18/09/2007, 18h09   #10
The Natural Philosopher
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: Displaying an image from inside Mysql database..

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/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..

>
> 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..
  Réponse avec citation
Réponse


Outils de la discussion

Règles de messages
Vous ne pouvez pas créer de nouvelles discussions
Vous ne pouvez pas envoyer des réponses
Vous ne pouvez pas envoyer des pièces jointes
Vous ne pouvez pas modifier vos messages

Les balises BB sont activées : oui
Les smileys sont activés : oui
La balise [IMG] est activée : oui
Le code HTML peut être employé : non
Trackbacks are oui
Pingbacks are oui
Refbacks are oui


Fuseau horaire GMT +1. Il est actuellement 13h03.


Édité par : vBulletin® version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC5 Tous droits réservés.
Version française #16 par l'association vBulletin francophone
PHWinfo est un site Éducation Sans Frontières ©2000-2008
Ad Management by RedTyger
©Tous droits réservés par les parties respectives
Page generated in 0,11998 seconds with 10 queries