[dwoody]

I am making a photo album for my site and I am pretty new to php and mySQL. I would like to upload the photos into a mySQL database. I was just wondering if someone would show me the script for handleing an image (jpg is fine for now) from an HTML form by saving it and inserting it into the database. I will probably need help trying to view the image later but for now i just want to get the uploading into the DB working.

thanx alot guys

[greybird]

Check out some of the scripts ive written for this kind of thing:

http://www.redvodkajelly.com/code/

There is a class for uploading files and...i think...one for maniplating the image if you need to do that - create thumbnails and such. I always tend to save the images in a database as a longtext field and insert the picture as a base64 encoded version of the file:

PHP Code:

$file = "path/to/the/tmp/image";

$data = base64_encode(fread(fopen($file, 'r'), filesize($file))); 

mysql_query("INSERT INTO table VALUES ......."); 

etc.

[loewydesign]

Greybird,

Maybe you or others might know of a simple photo gallery script that also includes a eamil this photo to a friend feature. Similar to this gallery:
http://www.southflorida.com/news/sfl...a.photogallery.

I'd like a simple gallery and do not require the options for viewers to rate or comment on a photo. I love the simplicity of this web album:
http://www.ornj.net/software/webalbum/sample1/
But it doesn't have that email photo to a friend option.

I'm more of a visual designer and looking to commission a programmer to set this up for us.

Thanks