allow users to post on other users profile pages

allow users to post on other users profile pages.

ok so am learning php :)

i can register a user get him to log in and display a profile page with info about them that they can edit.

now i am moving on to allow other registered users who also have there own profiles to be able to post on there friends profiles (like face book) but i cant get my head around the database relationships to allow posts to only appear on the profile page that it was posted on.
can any one push me in a direction to what to look at that can help me understand how to do this
LVL 1
helpchrisplzAsked:
Who is Participating?
 
rationalbossConnect With a Mentor Commented:
Since you mentioned that you can already register/authenticate users, you need to utilize this information to handle the posts.

For example, create the following table:
posts
------
postid INT PRIMARY KEY AUTO_INCREMENT NOT NULL
post_date DATETIME
post_text TEXT
post_to INT
post_by INT

post_to and post_by are user IDs of your users. This would be the primary key you used in your users table.

Whenever there is a new post, you insert the data to 'posts'
INSERT INTO posts (postid,post_date,post_text,post_to,post_by) VALUES (NULL,NOW(),'This is an example post!',1,2); // this means userID=2 posted to userID=1

Hope this made sense :)
0
 
helpchrisplzAuthor Commented:
this is great thx i have been AFK for a bit and only getting this sorted now but thx for this help
0
All Courses

From novice to tech pro — start learning today.