Pictures and mysql

micaencephalon

I have been struggling with getting an upload/move script to work. I could do thing easier with mysql storing the pictures instead of a name and pulling it from a directory but I was told that this is not a good way to use mysql. Could someone set me straight on storing pictures in mysql vs. referencing a pic in a directory?

Thanks!

bengt

if ($_FILES['userfile']['name']) {
$uploadfile = $uploaddir . $_FILES['userfile']['name'];
if (move_uploaded_file($_FILES['userfile']['tmp_name'], $uploadfile) {
echo "move-OK";
} else { 
echo "move-FAILED";
}
}

The form

<html>
<head><title>File upload</head>
<body>
<form enctype="multipart/form-data" method=post>
image: <input name="userfile" type="file" size=42>
<input type=submit value="Store">
</form>
</body>
</html>

micaencephalon

Thank you for the script bengt but I don't think I was clear enough on my first post. I am able to upload images to my server but I am struggling with moving the files from a secure directory to a standard chmod 755 directory not to mention future file maintenace. I am wondering what the pros/cons of storing the image inside the mysql db is becuase it would make thing so much easier but I don't want to do it if its not best practice.

Thanks again!

micaencephalon

I will close this thread. Thanks for the feedback