upload images

[Anon]

i don't know if this is the right place to ask this but i want to create a sort of photolog site. i have a regular text journal using mysql and php but i was wondering how i would go about working it so i could upload a picture from a page and maybe a caption. can you upload an image to a mysql database? i don't think so, and if not, how can you jsut upload images to a dir on your site? thanks for the help

[Anon]

you CAN use photos in the database, but i haven't done it in a while so i would have to point you at the manual.

as for storing the pictures in a dir, just use the 'file' form input type and php will do the rest. just make your form multipart (again check the manual) and you're set.

[johanm]

You can upload images to a self-made directory Images (or so) at your webspace, but keep an eye on the MB's that available. I always put paths into my databases:
e.g.
photo1 -> Images/photo1.jpg
You just ask you database for the path of photo1, put this path in a variable $path en then you use that variable in your html:
<img src=$path>

You can also 'store' other mediatypes like this into your database (like mp3). The methode is called relative referencing (it keeps your database light-weight and fast).

Johan