How to Assign a picture to a user

RobRocker

Hello everyone,

Im new here and I have a PHP question.

I am making a wannabe myspace for some friends to fart around with and was wondering if anyone could help me. I used a tutorial on uploading images but I need help assigning the uploaded image to the user that uploaded it.

Can anyone help me?

TheDefender

Well, assuming you are using SESSIONS to track which user is logged in, assuming your database has a unique index key to identify each user and assuming that key value is registered into your SESSION array...

Then, you could (when the picture is uploaded) either use that key value to prepend the file name with the key and an underscore, or if you're using a database to track the pictures, then add a foreign key field that you can insert the user's unique key into...

Examples:
original file name: something.jpg
new file name: 141_something.jpg (where 141 is the user's unique ID key)

OR
Original Image table Structure:
picture_id
picture

New Image table Structure:
picture_id
picture
user_id (where user_id would be the same field type as the user_id field in your user table)

Without knowing exactly how you are tracking things, I can't be more specific, so maybe consider posting some code and table structures...

harmor

Create a new field on the same table that you use to store the users' details called "image" or "avatar", anything relevant.
Have the image upload to the "users" table but only to the row for the user uploading.

RobRocker

Ok, Well I am teaching myself PHP. I didnt know pictures can be assigned to a database.

Thanks guys.

EDIT: What type would I classify that? For example there is "Text, Longtext, int,etc."

TheDefender

No, don't store the actual picture in the DB. Store the picture name, and then when you query the DB, use that picture name to assign the <img> tag's src attribute. harmor's solution will work if you only want to assign one image. If you want the user to have multiple images, then you will need to normalise the table structure per the basic guidelines I gave you above.

plapeyre

if you dont use a database... try:

images/$username.jpg just rename the picture to the users username... unless its a shared image.. then bad things could happen 🙂

RobRocker

Since I am still new to PHP can yall recommend any php tutorials for me to look at the learn how to rename files to a certain user such as The Defender suggested?

Thanks.

TheDefender

No tutorials needed. The manual should have everything you need. Particularly, the section that discusses file upload handling.

Start there, and see how that goes for you...