Hi Sean,

Sean C. McCarthy wrote:
> If you mean http://www.webtechniques.com/archives/1998/02/lerdorf/ what
> inserts in the DB is just the image's name, but not the file itself.

I had trouble opening up the upload.php3 file in list six, so I couldn't verify 
by looking at the code.  Not sure if it was the javascript or what, but I 
couldn't open it.

> What is exactly the problem you are having with the class? Just a couple
> days ago I had a problem uploading files into a MySQL DB because the
> addslashes function. As I have seen in this code it also uses it. Your
> problem is with getting corrupt data from the DB?

Add slashes are included as the file is added to the array:
$this->daten["image"] = addslashes(fread(fopen($userfile, "r"), 
filesize($userfile)));

Some content almost gets inserted.  However it only gets as far as:
        Content-Type: image/jpeg 

The image filed is just a blob

> If it is this use base64_encode and base64_decode. This is a tip Chris
> (only know his name) gave me as no solution for addslashes was given...
> Thanks again Chris!!

Ok..  This is getting better..

http://php.net/manual/en/function.base64-encode.php
$this->daten["image"] = addslashes(base64_encode(
fread(fopen($userfile, "r"), filesize($userfile))));

gives me quite a lot more information.  Even looks like when I upload different 
images, that it is different information (unlike previous attempts)

Unfortunately, it still isn't producing the graphic that I'm looking for... 
Hmm..

I get raw code easily enough:
http://pgs.ca/WLP/profiles/getimage-simple.php3?imageID=16
http://pgs.ca/WLP/profiles/getimage-simple.php3?imageID=17
http://pgs.ca/WLP/profiles/getimage-simple.php3?imageID=18

Which is generated by:
mysql_connect($DBHOST, $DBUSER, $DBPASS);
mysql_select_db($DATABASE);
$resultset = mysql_query($query);
$query = "SELECT image FROM ztpv_images WHERE imageID = $imageID";
$resultset = mysql_query($query);
print(stripslashes(base64_decode(mysql_result($resultset, 0, "Image"))));

So I couldn't either view the file here..  or within a <SRC="">.  See:
        http://pgs.ca/WLP/profiles/test.html

Also thanks for providing the direct URL for :>>Rasmus' classic Photo Album is still 
online with source code.
>>Google:
>>"Rasmus Lerdorf" and "Photo Album"


The google reference was a bit indirect (but it got to the same place too). 
Thanks Richard for this.  Although I did have problems actually viewing the script.

Mike


>>----- Original Message -----
>>From: Mike Gifford <[EMAIL PROTECTED]>
>>Newsgroups: php.general
>>To: <[EMAIL PROTECTED]>
>>Sent: Tuesday, September 11, 2001 2:45 PM
>>Subject: Uploading Photos to MySQL
>>
>>
>>>Hello,
>>>
>>>Has anyone developed another class for uploading images to a MySQL
>>>
>>database?
>>
>>>I downlaoded upload_db.zip from:
>>>http://circle.ch/scripts/
>>>
>>>as it was a phplib based and it looks like it should do what is required.
>>>However it doesn't seem to be working.
>>>
>>>Does anyone else have any good pointers to scripts to store jpg/png files
>>>
>>in
>>
>>>MySQL using PHP?
>>>
>>>Thanks.
>>>
>>>Mike
>>>--
>>>Mike Gifford, OpenConcept Consulting, http://openconcept.ca
>>>Offering everything your organization needs for an effective web site.
>>>Abolish Nuclear Weapons Now!: http://pgs.ca/petition/
>>>In all things it is better to hope than to despair.Wolfgang von Goethe
>>>
>>>
>>--
>>PHP General Mailing List (http://www.php.net/)
>>To unsubscribe, e-mail: [EMAIL PROTECTED]
>>For additional commands, e-mail: [EMAIL PROTECTED]
>>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>>
> 



-- 
Mike Gifford, OpenConcept Consulting, http://openconcept.ca
Offering everything your organization needs for an effective web site.
Regarding Sept 11, http://www.fgcquaker.org/statement091101.html
In all things it is better to hope than to despair.Wolfgang von Goethe


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to