1) there is no need to fiddle with directory permissions to write images.
2) if the content is sensitive you have the added security of the database password (and the fact that the database is ususally not directly accessible).
3) a mysqldump gives a backup of all images along with other persistent data
Other disadvantages follow:
1) excessive load on the server for loading each image
2) the load mentioned above causes a slow down in the script
3) images usually need to be written to file before using GD for manipulation, inclusion in PDFs, etc.
I have found that when I decide to store image data in the database I will usually also store a copy of the image on the server (as a file) also, primarily for performance reasons.
----- Original Message ----- From: "GH" <[EMAIL PROTECTED]>
To: "Daniel Watrous" <[EMAIL PROTECTED]>
Cc: "GH" <[EMAIL PROTECTED]>
Sent: Monday, September 27, 2004 4:31 PM
Subject: Re: [PHP] Images in PHP and MySQL
Do you know of a good tutorial on this topic.
On Mon, 27 Sep 2004 16:25:15 -0600, Daniel Watrous <[EMAIL PROTECTED]> wrote:consider using a blob field type. you will need to prepare your data on the
way in, but not on the way out of DB:
$content = addslashes(fread(fopen($_FILES["imgb_sizedesc"]["tmp_name"], "r"), filesize($_FILES["imgb_sizedesc"]["tmp_name"])));
then instert $content into your DB using insert!
----- Original Message ----- From: "GH" <[EMAIL PROTECTED]> To: "php-general" <[EMAIL PROTECTED]> Sent: Monday, September 27, 2004 4:19 PM Subject: [PHP] Images in PHP and MySQL
>I was wondering how to get images into and out of a Mysql database > with in php... I do not have anything in my book... but was told it > was possible. > > I have PHP 4.3.4 and mysql 4.0.18 > > Thanks > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
