I suggested a naming scheme, but as I think about it
that may be overcomplicating things.

You may want to, instead, create a directory for each user
with their name.  This has several benefits.  The first is that it
is an easy way to avoid conflicts.  If Rick and I both upload
an image 'beach.jpg' one won't be overwritten.

The second is that if you also create an index.php page (as
simple as copying a template) when you create the directory
the user will be able to see their album by simply visiting
www.youralbum.com/username

Finally, this opens up a variety of possibilities for the future.
Things like FTP access, and having random pictures on the
user's initial album page wouldn't be too dificult with this setup.

Well, I guess that's enough rambling for one e-mail  =P

Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com

----- Original Message -----
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "PHP-DB" <[EMAIL PROTECTED]>
Sent: Tuesday, August 21, 2001 10:55 AM
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:[EMAIL PROTECTED]]
> 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" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>; "PHP-DB" <[EMAIL PROTECTED]>
> > 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:[EMAIL PROTECTED]]
> > > 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to