File Uploads And MySQL

SP8600

Hi, i need to build a system which uploads images into a /images file and then puts the URL of the images into the database. Has any one done this before or do you have any idea how i could do this.

Thanks for any help.

junkie_doodle

if you're going to use mysql as your database, have a blob field to store your file in the table, instead of "copy"ing uploaded file, fopen it and "insert" the content of the file into the db..

you better keep

file name
content type of the file [you can get it from HTTP vars]

too, while keeping the file content..

SP8600

Are there any Tutorials about this method as i have not used it before.

SP8600

Just thought i can not do it like that because the image has got to be added into a dir called images. So is there anyway i can just grab the URL of the image when it is being uploaded and then add it to the database

NiXXeD

I never saw the advantages to putting images into a database... wouldn't that just increase the amount of database calls/use you have? I have a site that uses a large amount of image uploading, and all I do is copy the image over to the user's folder, and thumbnail it. I form the filename based on the time the picture was generated (timestamp) and the user's name. The thumbnail is named the same, but in the immediate directory 'thumbs'. That way I don't even have to keep track of the filename. I just keep track of the info associated with the image (skater, photographer, title, and the timestamp).

rebelo

Originally posted by SP8600
Just thought i can not do it like that because the image has got to be added into a dir called images. So is there anyway i can just grab the URL of the image when it is being uploaded and then add it to the database

Maybe I missed the problem or something but what I do is copy_uploaded_file to my /images directory, whose url is stored in $imgDirUrl, the result url $imgDirUrl.$filename could then be put into a database for reference. You will need to prune filename a little to make it just the file.

gijs

Hi SP8600,

Maybe take a look at ther following article at www.php4.com .

After reading this, decide for yourself wether its better or not to store the images in a blob-field.

Hope it helps,

Gijs

jonsof

So i wanna asking something like this one in the first post

I also have an /images directory so i wanna rename the file and especially the prefix to the id of a table so how can i manage that?

I wanna the extension remains as it is ( etc .jpg .gif and jpeg as well)

Could you help me?

Thanks in advance!