T
T
TracKer2011-02-27 01:59:38
Web development
TracKer, 2011-02-27 01:59:38

Implementation of profile links, like "How you're connected" (LinkedIn) and "Network of connections" (TooDoo)?

Hello.
Faced with an interesting task in one of the projects. It is necessary to implement a module with which it will be possible to show links between user profiles, similar to "How you're connected" (LinkedIn) and "Network of connections" (TooDoo).
The project is at the modeling stage, so it is necessary to think over the structure of the database correctly.
Perhaps someone has already encountered similar things and there are some developments that can be used as an example.
Googling didn't turn up much information (maybe I didn't search well), namely one link with thoughts about possible algorithms:
stackoverflow.com/questions/4436348/intelligent-we...
Any help would be welcome.
Thanks in advance.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Deimus, 2011-02-27
@TracKer

Once I came across this, I decided that it’s better to keep information about the connection in a separate table (which has three integer fields / columns - the first is its own ID, the other two are foreign keys to the users table, the first ID shows the user who is connected, the second ID - on the user with whom the first one is connected). For example, if a user with ID 12 is associated with user 15, and the latter, in turn, is associated with user 21, then our search / select in any way will be performed on the connection table.
I don’t think this option is good, but if you like it, I advise you to read it before using it:
Michael Peacock, PHP 5 Social Networking

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question