Re: Photo Album Schema

I'm going to play Devil's advocate a little bit more here. Lets say user #1 uploads 1family.jpg, and user 11 uploads family.jpg. "1" . "1family.jpg" == "11family.jpg" "11" . "family.jpg" == "11family.jpg" You run into stuff like this anytime you let users upload files of any sort. Justin Buist Trident Technology, Inc. 4700 60th St. SW, Suite 102 Grand Rapids, MI 49512 Ph. 616.554.2700 Fx. 616.554.3331 Mo. 616.291.2612 On Tue, 21 Aug 2001, Sheridan Saint-Michel wrote: > If you are going to use a single directory with a filename > convention I would suggest something simple, yet unique > like > > "id" . "filename" > > Where id is the unique userid from the DB and filename > is the original name of the file. > > This would avoid conflicts (which is the point of a naming convention) > and be fairly easy to implement. > > Sheridan Saint-Michel > Website Administrator > FoxJet, an ITW Company > www.foxjet.com > > > ----- Original Message ----- > From: "Anthony Carlos" <anthony@digitalphenom.com> > To: "Rick Emery" <remery@excel.com>; "PHP-DB" > <php-db@lists.php.net> > Sent: Tuesday, August 21, 2001 11:47 AM > Subject: RE: [PHP-DB] Photo Album Schema > > > > I vote for one directory to simplify the programming side of things. What > do > > you guys recommend for the filename convention? > > > > Would you let users determine it or would you force them into something > like > > a primary key? > > > > Anthony Carlos > > > > -----Original Message----- > > From: Rick Emery [mailto:remery@excel.com] > > Sent: Tuesday, August 21, 2001 11:55 AM > > To: PHP-DB > > Subject: RE: [PHP-DB] Photo Album Schema > > > > > > I vote for a single directory. Then use Sheridan's naming suggestion. > > > > Richard Emery > > Excel Communications, Inc. > > IT Sr. Project Manager > > (972) 478-3398 > > (972) 944-0542 (pager) > > > > There is no "trying"... > > There is only "Do" or "Not Do" > > > > > > > > -----Original Message----- > > From: Jeff Oien [mailto:jeff@webdesigns1.com] > > Sent: Tuesday, August 21, 2001 10:49 AM > > To: PHP-DB > > Subject: RE: [PHP-DB] Photo Album Schema > > > > > > I should have said photo_filename. That was what I intended to do. > > Would you suggest one directory for all photos or separate directories > > for each user? > > Jeff Oien > > > > > Rick: I don't see any .php tags there... plus just because someone > > > else has done it doesn't mean he can't do it as well =) > > > > > > Jeff: The only critique I would give from the description you have > > > given us thus far is the fact that you appear to be storing the photo > > > in the DB. > > > > > > The biggest bottleneck in a server-side script is usually the DB calls. > > > With this in mind, you want to limit these calls as much as possible. > > > > > > I would suggest setting up a naming and/or directory scheme to store > > > the pictures on the website, and then store the URL of the picture in > the > > > DB, rather than the image itself. > > > > > > Then when outputing the page just do something like > > > > > > echo "<Img src=\"$queryresult['location']\">"; > > > > > > Sheridan Saint-Michel > > > Website Administrator > > > FoxJet, an ITW Company > > > www.foxjet.com > > > > > > ----- Original Message ----- > > > From: "Rick Emery" <remery@excel.com> > > > To: <jeff@webdesigns1.com>; "PHP-DB" <php-db@lists.php.net> > > > Sent: Tuesday, August 21, 2001 10:19 AM > > > Subject: RE: [PHP-DB] Photo Album Schema > > > > > > > > > > This has been done. see > > > > http://www.photopoint.com > > > > > > > > This is a free service available to the public. > > > > > > > > rick > > > > > > > > Richard Emery > > > > Excel Communications, Inc. > > > > IT Sr. Project Manager > > > > (972) 478-3398 > > > > (972) 944-0542 (pager) > > > > > > > > There is no "trying"... > > > > There is only "Do" or "Not Do" > > > > > > > > > > > > > > > > -----Original Message----- > > > > From: Jeff Oien [mailto:jeff@webdesigns1.com] > > > > Sent: Tuesday, August 21, 2001 10:12 AM > > > > To: PHP-DB > > > > Subject: [PHP-DB] Photo Album Schema > > > > > > > > > > > > I want to make a photo album that will have users who sign up > > > > to create an album and then have the albums open to the public. > > > > I was thinking of doing it like this but I've never done a relational > > > > database before so if anyone thinks of anything I should change > > > > please let me know. Thanks. > > > > Jeff Oien > > > > > > > > Table1: > > > > -username > > > > -password > > > > -album_title > > > > -creation_date > > > > -id > > > > > > > > Table2: > > > > -id (from Table1) > > > > -photo (jpg or gif) > > > > -date > > > > -photo_title > > > > -description (limited length) > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-db-help@lists.php.net > > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >