How Did Mark Zuckerberg Do This?

Am wondering how Facebook did their timeline with comment box attached to each post.am trying to do something similar only that my comments shows on other posts due too

javascript

Sql query

wharley01:
Sql query

Yea I know that nw..

cbrass:


Yea I know that nw..

then to do that, include comment box when looping though posts, submit comment with ajax

wharley01:
then to do that, include comment box when looping though posts, submit comment with ajax

When I comment on each post it shows on the other comments since it's in a loop, am using a div to show users their comments immediately else they will have to refresh the page before they see the comment, (it's Ajax am using to post the comments )

cbrass:


When I comment on each post it shows on the other comments since it's in a loop, am using a div to show users their comments immediately else they will have to refresh the page before they see the comment, (it's Ajax am using to post the comments )

when you post with ajax, then you should refresh comments with ajax too, and to avoid comment appearing in other people's post except the one you are commenting on, create table for comments, then create a colomn specifying the post id in the comment's table, now when inserting your comment insert post's id too, and when fetching comments fetch with the post's id

wharley01:
when you post with ajax, then you should refresh comments with ajax too, and to avoid comment appearing in other people's post except the one you are commenting on, create table for comments, then create a colomn specifying the post id in the comment's table, now when inserting your comment insert post's id too, and when fetching comments fetch with the post's id

What am saying is, it's not like those comments tie to another Id in the database but am just trying to let users know that their comments have been posted since Ajax will not refresh the page so in my own wisdom or folly I decided to tied the $_Post[post ] to a div element and later added it to the loop so as you post a comment you see your comment immediately but since it's a loop it will show in all the loops but in truth it's not like that in the db because if the user refresh the browser they will see the comment under the exact post it should be but I don't want them confused and beside that doesn't look professional since Facebook doesn't behave like that when you comment on a wall post. So is there a way out of this

cbrass:


What am saying is, it's not like those comments tie to another Id in the database but am just trying to let users know that their comments have been posted since Ajax will not refresh the page so in my own wisdom or folly I decided to tied the $_Post[post ] to a div element and later added it to the loop so as you post a comment you see your comment immediately but since it's a loop it will show in all the loops but in truth it's not like that in the db because if the user refresh the browser they will see the comment under the exact post it should be but I don't want them confused and beside that doesn't look professional since Facebook doesn't behave like that when you comment on a wall post. So is there a way out of this

do you know much about json ? Before i proceed

Make sure the comment sections under each post has a unique id e.g
For post one

Div class= comments id=1
 Comment1
 comment 2
 comment 3
/div

For post two
Div class =comments id=2
 comment1
 comment 2
 comment 3
/div

You get my drift? Don't mind me, I'm too lazy to post correct html in mobile. Find a way to tie the comment with the id you gave the comment area. Something like this

Div class=post
 div class=post-content> bla bla</div
 div class= comments id=1
  comment 1
  comment 2
  comment 3
 /div
 textarea data-id=1></textarea

Once the user submits the comment, get the data-id with JavaScript and make sure the comment is appended in div class= comments where id is the same as the data -id obtained from the comment submitted which is 1 in this case.

wharley01:
do you know much about json ? Before i proceed

Yea

Djtm:
Make sure the comment sections under each post has a unique .g
For post one

Div class= comments id=1
 Comment1
 comment 2
 comment 3
/div

For post two
Div class =comments id=2
 comment1
 comment 2
 comment 3
/div

You get my drift? Don't mind me, I'm too lazy to post correct html in mobile. Find a way to tie the comment with the id you gave the comment area. Something like this

Div class=post
 div class=post-content> bla bla</div
 div class= comments id=1
  comment 1
  comment 2
  comment 3
 /div
 textarea data-id=1></textarea

Once the user submits the comment, get the data-id with JavaScript and make sure the comment is appended in div class= comments where id is the same as the data -id obtained from the comment submitted which is 1 in this case.

It can't work like that nw, reason because the form is coming from a loop. So as the posts are echoed from the db the comment box is echoed with them so having a unique id will only work for the first comment box in the loop

cbrass:


It can't work like that nw, reason because the form is coming from a loop. So as the posts are echoed from the db the comment box is echoed with them so having a unique id will only work for the first comment box in the loop

No it will, I've done something like this before. Make sure reach comment box has a unique id. You can tie the comment box id with the post's id from the database.

Each post you're getting from the database has an id right? And I'm sure you know how to retrieve that id in your loop so that each post can show its id. Just pass the id into the comment box. Simple. This isn't difficult at all.

Djtm:

No it will, I've done something like this before. Make sure reach comment box has a unique id. You can tie the comment box id with the post's id from the database.

Each post you're getting from the database has an id right? And I'm sure you know how to retrieve that id in your loop so that each post can show its id. Just pass the id into the comment box. Simple. This isn't difficult at all.

But how will you be able to use that with ajax, you know id is unique in js

cbrass:


But how will you be able to use that with ajax, you know id is unique in js

Use another attribute. You can use id for the post and data-id for the comment box.

cbrass:


But how will you be able to use that with ajax, you know id is unique in js

ive once done that though i cant recall all the processes i followed then, also it is not in PHP, i did it in ASP.NET (C#). I must state categorically here, that i did not use ajax, just webforms......


I created a database table for name, date and comment.

So i created a webform; connect it database and attached appropriate textboxes and textarea. However, i disabled my datetime texbox visibility. So the user dont get to see the datetime textbox........so when i wrote my insert statement for datetime, i used 'insert into user_rec values(..........., + ' DateTime.Now.ToString()'


So......after that, i now applied hashtable and sort a datagrid table binded to my database.

I think i sorted the date header in my datagrid, in descending order...........i cant remember exactly how i did but it worked......updating the datagrid with latest post each time the submit button is clicked and page refreshed.......


I dont know whether it solved your problem but i believe you will find it helpful.

Djtm:

Use another attribute. You can use id for the post and data-id for the comment box.

Yea, you are right, I actually converted it to class attributes

It's not like I really need help but just created this thread so others can learn especially beginers, have noticed that WordPress guys have taken over the webmaster section and no o one is posting code problems again so I ran here.