PHP Help: Photo Album

[ChibiDusk]

I'm working on a site that will act as a personal photo gallery. Basically you go to the site and get a log-in panel in which if I have given you the password you can enter.

From there you go into the actual site. Basically I just want a simple gallery (implemented into a layout I already designed). I want it so there are three sections: People, Scenery, and Events. Each 'section' is "connected" to a folder on my webspace in which the images are stored. So basically, upload an image into "people" and that image would appear in the "people" section of the gallery in a small thumbnail form.

Of course, what also would be handy is if you could click on this thumbnail and be brought to a page where guests can leave comments and rate the image.

So that's all gallery-wise. I would also like to have an upload script in which i can upload directly via the site to the three categories. So an upload script with a dropdown box asking which category I wanted the image uploaded into.

On the main page I would have stats like "10 newest", "10 most popular (based on votes)", "most viewed", etc. if possible.

So, I was wondering if this is possible? And if anyone knows of any scripts like this?

[AnimeOni]

Some PhP like Fantastico has this feature pre-built. Check to see if this feature is installed. It will save you a lot of work. If not, check out this site: http://www.advancescripts.com/PHP/index.html

The feature you are asking for, is it similar to the gallery on http://wallpapers.downloadanime.org? If yes, they use the Coppermine Photo Gallery php script. You will need access to MySQL server.

[subcool]

Here are some of my own scripts that you can use

http://subcool.ath.cx/image_admin/index.phps <-- Uses files

http://subcool.ath.cx/myimageadmin/src/ <-- Uses MySQL

You'll need to following code for the MySQL version. and of course you'll need to modify it a bit. mine dont require login... So have fun =)

DROP TABLE IF EXISTS `images`;
CREATE TABLE IF NOT EXISTS `images` (
  `id` int(9) unsigned NOT NULL auto_increment,
  `image` mediumblob NOT NULL,
  `name` tinytext NOT NULL,
  `type` tinytext NOT NULL,
  `size` tinytext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `thumbnails`;
CREATE TABLE IF NOT EXISTS `thumbnails` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` tinytext NOT NULL,
  `image` mediumblob NOT NULL,
  `type` tinytext NOT NULL,
  `size` tinytext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;