[Resolved] Upload/download from an account

knobby2k

Hi All,

Im a bit stuck and looking for help.

My situation. I have a MySQL database that a user can register and log in to. Whilst registering the user may require to upload a file, mainly an image.

I am desperate need to find out how to write a script that will allow the user to upload a picture and store it within the database in a field belonging to that user. I dont want to actually display the picture, just to display the file name as an attached file.

For example:

I have a table called users. Within this table I have 3 fields. Field 1: user_id, field 2: user_name, field 3: file.

I have 1 user. user_id = joe, user_name = joe bloggs, file = .....

I want the picture to be uploaded and stored as the file name within that field. Can anyone please help as I am getting desperate and I dont think I can handle another sleepless night!!!

Knobby 😕

devinemke

http://www.php.net/manual/en/features.file-upload.php

knobby2k

Originally posted by devinemke
http://www.php.net/manual/en/features.file-upload.php

Thanks, had a quick look but feels like im reading spanish at this time of night. From what I looked I didnt notice any indication of how to store it within the users field, just within a location in the databse, maybe I missed it, I'll have a better look tomorrow. I am new to this so any detailed help will be much appreciated.

Thanks
Knobby

maxxd

The file itself shouldn't be stored in the database - just the upload path. You can return the path from a select statement and place it inside an image tag on your html page to pull the image in to the page. This helps to keep the database more compact and cleaner.
During your insert or update statement, simply place the path info in the proper table field - I did this on a site about a year ago, but haven't had to use it since, so I can't really be any more specific off the top of my head - all my php books are at work and it's saturday, so I can't get to tehm right now...

knobby2k

I think im gettin to grips with it. Correct me if i'm wrong.

Ive made a form and the php to take the image into my webspace. now i dont want to display the image, so i take the filename variable and insert it into the 'file' field of my table as a link. This should allow sum1 to click on this and download the file.
Just tryin to get my head arround it as i havent got round to doing this part yet. So would this work??

Knobby

maxxd

Theoretically, yes. Just wrap the recordset result for file name in <a> tags, and all should be well.

knobby2k

Thanks alot for your help lads. Just found out that my ISP doesnt allow uploading to webspace from forms!!! Cheers tho.