Profile Picture For Each User_ID

Question

2.00/5 (1 vote)

See more:

Good evening all,

I have a question regarding allowing each user id upload a profile picture. I'm building a dynamic website that allows users to register and have their own profile. In their profile, they can upload a profile picture. I have many tables in my database, including a table for registration which has the user_id as the primary key, and a table for uploading profile pictures which has picture_id as the primary key and user_id as the foreign key.

Now here's the problem: When I login, the user_id is inserted into the database, but when I go to the profile page to upload a picture, I get a "user id does not exist" error (I added that error message). Then I'd have to go to the profile picture table and manually add the user_id to the table and then the profile picture gets uploaded.

So, my question is, when a user logs in and the user_id(primary key) in the registration table is inserted, is there a way to also update and insert that same id in the user_id(foreign key) in the profile picture table without doing it manually? So that each user can have his own profile picture.

PS: I'm not uploading the pictures themselves into the database, i'm inserting the path of the image into the database.

I appreciate any help.
Thanks!

Posted 17-Feb-12 12:28pm

AmeeR-89

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

krumia · Answer 1 · 2012-02-17T16:34:00

First of all, why would you need to insert a record into user data table when the user LOGS IN? You should insert that record only when the user SIGNS UP. And reuse the same record every subsequent time the user logs in.

You can insert a record to the profile picture table the same way you inserted data to the user table. Write a mysql_query to insert that data into profile picture table and place it after the mysql_query to insert a record to users table.

But wait. Assuming you have one-to-one mapping with user and profile picture, why would you ever want to store the profile picture in a separate table. Surely you have the same keys in two tables. Move all the columns in the profile pictures to the users table. And before doing that, Google "database normalization" and read some of the links that pop up, because this is BAD NORMALIZATION. (Of course this is assuming you have one-to-one mapping with user and profile picture. If not, ignore.)