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:[EMAIL PROTECTED]]
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:[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