Plan for this

DivaX007

running win98,abyss server(it's thelocalhost for testing)
i need to do this:
1. let user send photo to me(a simple email link will do right?)
2. put image in folder and path in db(i'm so lost on this)
or
2b. put image in db(i prefer the former, but at this point i'm desperate)
3. display photos
4. rate photos using mysql (only one vote)
5. let users learn points for visiting the site

i have read SO many tutorials(yank's too) and downloaded SO many gallery scripts(hotscripts, too) and read books.

i need to know how to tackle the making of this site. i need to know the SIMPLE way to do it. i am NOT web developer.i've been working on this for months, but i think my problem is that i'm having a problem weeding out the information that i do not need.

please, please help

barand

Everything is simple when you know how.

If everything was as simple as you want it to be, everyone would be doing it, and where would that leave the professional developer?

DivaX007

barand: could your re-read my post, try to comprehend what i am saying, and respond with guidance i can use?

if my post is hard to understand, apologize.

barand

You can let your users upload a photo by an HTML form like this

<FORM ENCTYPE="multipart/form-data" ACTION="_URL_" METHOD=POST>
<INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="10000">
Send this file: <INPUT NAME="userfile" TYPE="file">
<INPUT TYPE="submit" VALUE="Send File">
</FORM>

In sample form above, the file input is called "userfile" so the uploaded temp filename will be in $username.

To store the file, [man]copy[/man] the uploaded file to your chosen image directory and store path/to/file.name in your database. This has two advantages

 [list]

[]Its easy then to create <img source="path/to/file"> in your displayed page
[*]browsers can cache files but not images in a database field
[/list]

hth

DivaX007

thank you, barand
🙂

chriskl

Storing images is easy.

DON'T store them in your database - it's slow.

Instead, create a known area on your site to put the images. eg. /images/photos/

Now, whenever someone uploads a JPG say, insert a row into your table with the date and user or whatever for that photo. Then, save the image into the /images/photos/ directory as {primary key}.jpg.

Then viewing and deleting the images is easy. You could even record the original filename in your table.

Use the move_uploaded_file() PHP command to do it safely.

Chris