ccrevcypsys Posted October 15, 2007 Share Posted October 15, 2007 To set up a database table for friend adding. Like i want to be able to let the visitors of my site add friends. But i dont know how to set up the database. What is the best reference or columns i should have? Link to comment https://forums.phpfreaks.com/topic/73261-what-is-the-best-way/ Share on other sites More sharing options...
hvle Posted October 15, 2007 Share Posted October 15, 2007 what do you mean by "friends"? What exactly will "friends" be included? Link to comment https://forums.phpfreaks.com/topic/73261-what-is-the-best-way/#findComment-369599 Share on other sites More sharing options...
ccrevcypsys Posted October 15, 2007 Author Share Posted October 15, 2007 well by friends i mean like on myspace(ughh) where you can add other people as your friends by clicking the add friend button then it would send the other person a request and they would either approve or deny so if they approve it will add them to the friends list. Link to comment https://forums.phpfreaks.com/topic/73261-what-is-the-best-way/#findComment-369602 Share on other sites More sharing options...
hamza Posted October 15, 2007 Share Posted October 15, 2007 Man just simply make new database for the friends and simple execute the insert query and add your friends. AND about accepting and deny your friends. Just bring the details of your friend and put into the mail and send them for adding friend and denying friends thats it Link to comment https://forums.phpfreaks.com/topic/73261-what-is-the-best-way/#findComment-370013 Share on other sites More sharing options...
MmmVomit Posted October 15, 2007 Share Posted October 15, 2007 I'm assuming you have a user table that looks something like this. User ------------- ID Username etc. You want to add a table that looks like this Friends ---------------- ID UserID => User.ID FriendID => User.ID Link to comment https://forums.phpfreaks.com/topic/73261-what-is-the-best-way/#findComment-370031 Share on other sites More sharing options...
Barand Posted October 15, 2007 Share Posted October 15, 2007 You might want to add a datetime field and a status field (accepted/not accepted) to "friends" table. Periodically clear old, non-accepted records. Link to comment https://forums.phpfreaks.com/topic/73261-what-is-the-best-way/#findComment-370124 Share on other sites More sharing options...
simcoweb Posted October 15, 2007 Share Posted October 15, 2007 I would assume you already have people registering as a member on your site? If not, there's no way they'd know who is who. Link to comment https://forums.phpfreaks.com/topic/73261-what-is-the-best-way/#findComment-370142 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.