Social Media Site Expansion : Progress Friends

An internet site is a web site or a collection of web pages. When an account is created in a social networking site, a website is allocated to the user which can be possible to download using the normal URL format ending with /yourpersonalizedusername after the social media web site address. So might there be as many internet sites as there are account holders in a social networking site. After signing up in a social media site, the next thing is to find who to follow along with which can be called friends in Facebook. When you receive people to follow along with, you can connect for them through blogs (in type of comments posted or shared), chat rooms, and web mail in your allocated social media site.

A social media site separates the multiple allocated social media sites of the users into clearly different segments of activities of social connections. The core part of social networking site could be the tracking of all the events, information, and activities concerning a person in his allocated social networking site within the social media site. As an example, tracking people he’s following, his followers, and presenting the proper and appropriate information regarding all of them in his allocated social media site without the mix up like presenting comments by wrong followers and wrong photographs. When the social media site can track everything concerning a person synchronously, his allocated social media site will present all the information strongly related him upon signing in into his site.

The question now’s this,” How will a person allocated social media site within a social media site manage to track everything concerning a person synchronously and correctly?” I will suggest the BASIC way to go about any of it which will work and I will use blogs and photograph processing in a person allocated social media site for illustration. Before making my illustration, let me make some clarifications about the use of some words in this information allow better knowledge of the article. Yellow Pages Scraper When you discover someone you want to follow and the procedure is completed, you are following that person. You’re the follower. When someone wants who to follow along with and he wants to follow along with you and the procedure is completed, see your face is following you. You’re anyone followed.

You create in the database tables for the main account, followership, comments, and photograph (profile picture in this instance which will be appearing beside your comments in the blog). The key account will contain columns for at least primary key designated as userID, names, account number, username and password. It will contain records of all the account holders (users) of the entire social networking site and information they submitted on signing up. A unique account number is likely to be generated dynamically on signing up. When a person signs in, the script will use his username and password to locate the main account table and retrieve his primary key number, names, and account number. These will enable the retrieval of the information concerning him like the comments of his followers for display in his allocated social media site. I will explain how this is done very soon. The followership table may have fields for at least names, primary key column of the main account table which can be the foreign key of a follower (UserID) and the account number of anyone that is being followed designated as person_followed_acct_no. The records in the table is likely to be generated as follows-

When a person signs in into his allocated social media site and finds who to follow along with (friend in Facebook), the script with aid from SQL SELECT statement will retrieve the user’s primary key number from the main account table. It will also retrieve the names and the account number of anyone he wants to follow. All of them is likely to be inserted into the followership table as you record with the user’s primary key number stored in the UserID column and the account number of anyone he’s following stored in the person_followed_acct_no column. The user’s primary key number is likely to be foreign type in the UserID column and a relationship is created between the main account table and the followership table. As more and more users find who to follow along with, the table grows. Because the table contains column UserID for foreign keys representing the principal key variety of the followers, and columns for the names and unique account variety of those they are following (person_followed_acct_no), a research statement making use of SQL SELECT statement with the right WHERE clause will enable the tracking of the persons that a particular user is following and the persons following him. When he signs in, the script retrieves his primary key number from the main account table and uses it to locate the followership table to retrieve the identity of the he’s following.