[Wolves] PHP image management

[Matthew Revell]

Thanks to everyone who gave their advice on this. Just to let you know,
for the time being I've decided to dump the BLOB route and use the
database to store a link to a file on the server, plus other details.

Thanks again!

gary at walsall.uk.com said:
> I wouldn't suggest storing images in a database, as this tends to add a
> little strain on the db server and webserver. Its much easier to you to
> store your image in a file and then use a mysql table with a reference to
> that file, but then again, if you have all your mysql/php/apache setting
> correct and you aren't putting all these under any stress, then this
> shouldn't prove a problem.
>
> have a look at http://www.webmasterworld.com/forum88/754.htm - this may
> provide some help to your problem.
>
> When i did this a long time ago, I found that the most common error I had
> was with the headers. Make sure your image is using the correct header,
> and try loading the image.php page from another page pointing to this, ie
>
> index.php
> <img src='image.php'>
>
> Another thing to check when you have uploaded your image, is that the
> length of the image in your sql field, is exactly the same length as the
> file you uploaded.
>
>
> Gary
>
>
>
> "Matthew Revell" <wolveslug at understated.co.uk> wrote ..
>> Hello chaps,
>>
>> I'm trying to set up some form of mySQL/PHP image management for my
>> site.
>> I've had a look at an O'Reilly tutorial
>> http://www.onlamp.com/pub/a/onlamp/2002/05/09/webdb2.html which has a
>> script for uploading images to a database, then displaying them from
>> within a web page.
>>
>> However, I just can't get the bugger to work on my server. The only way
>> I
>> can get an image into the database is through PHPMyAdmin. Then, when I
>> run
>> the view.php script, I get a opening and closing HTML and body tags.
>>
>> I'm not asking for direct assistance with this script but I'm really
>> just
>> wondering if anyone knows of PHP or mySQL config probs that could stop
>> the
>> image from being output properly. The exact same scripts work fine on
>> the
>> example set up given in the tutorial.
>>
>> Ugh.
>>
>> Matthew.
>>
>> _______________________________________________
>> Wolves LUG mailing list
>> Homepage: http://www.wolveslug.org.uk/
>> Mailing list: Wolves at mailman.lug.org.uk
>> Mailing list home: http://mailman.lug.org.uk/mailman/listinfo/wolves
> _______________________________________________
> Wolves LUG mailing list
> Homepage: http://www.wolveslug.org.uk/
> Mailing list: Wolves at mailman.lug.org.uk
> Mailing list home: http://mailman.lug.org.uk/mailman/listinfo/wolves