The two biggest reasons why 

1.  Bloats the database
2.  Slow at retrieving the images

-----Original Message-----
From: Reuben D Budiardja [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, February 14, 2002 9:30 AM
To: Todd Williamsen; [EMAIL PROTECTED]
Subject: Re: insert picture file in MySQL (+php)


On Thursday 14 February 2002 10:16 am, Todd Williamsen wrote:
> Reuben,
>
> You can store the images into a database, but no one recommends it. 
> What I do, is actually store the location of the file in the database 
> then have PHP open it.

Any reason why it is not recommended? 
I was going to do it that way (store the location of the file only), and
have 
php open it and then use something like <IMG SRC=$location>.

But the problem is, that way everyone who knows a bit about html can use
view 
source and know the locations of the image file, and can open it
directly. 
It's a problem for my particular case because we want to restrict access
to 
the images, and only certain people can see certain image, and so on. 

The only I can think about right now to achieve that is to store the
image 
directly in the table. That's why I asked.

Thanks.
Reuben D. Budiardja



>
> -----Original Message-----
> From: Reuben D Budiardja [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 14, 2002 9:08 AM
> To: [EMAIL PROTECTED]
> Subject: insert picture file in MySQL (+php)
>
>
>

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to