Re: [PHP3] Uploaded files stored in Database or Filesystem? From: Rasmus Lerdorf (rasmus <email protected>)
Date: 08/31/99

> 1) I never authenticate people to a realm. They are verified only by their unique key which travels in post and get variables. So there can be no .htaccess type protection on directories/files.
> Plus I can't guarantee that the system will be running on a php module.
> 2) The files would have to be stored in the webtree to be visible via the web to the user.
>
>
> But if I store them in the database they have the potential to slow down or crash the mysql server. As I have experienced with large files.

This question make very little sense to me. You say "the files would have
to be stored in the webtree to be visible via the web to the user" which
by definition implies they have to be in the filesystem and not in the
database.

Now, if you put them in the database you would obviously need a little
wrapper script that would check your auth stuff and then serve up the
file. But you can do that just as well, and probably better, by storing
files outside the webtree but still in your filesystem and simply doing:

 <?if(check_my_auth()) ReadFile("/private/dir/$PATH_INFO")?>

This little script could be done using a ForceType so it looks like a dir
in your web tree. See my little article on this on www.phpbuilder.com
entitled URL Tricks.

-Rasmus 

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>