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