Slideshow

Project On Social Networking Website -- Friends Media

CHAPTER  1 : OVERVIEW

1.1  INTRODUCTION

Social Networking - It's the way the 21st Century communicates now. Social networking is the grouping of individuals into specific groups, like small rural communities or a neighborhood subdivision. Although social networking is possible in person, especially in the workplace, government institutions, universities, colleges, and schools, it is most popular online. This is because unlike most these institutions, the Internet is filled with millions of individuals who are looking to meet other people.

Social network is the mapping and measuring of relationships and flows between people, groups, organizations, computers, URLs, and other connected information/knowledge entities. The nodes in the network are the people and groups while the links show relationships or flows between the nodes. Social network provides both a visual and a mathematical analysis of human relationships. “Social networking sites help you get in touch with those people whom you to longer meet in your everyday life such as buddies from school, colleges or work”.

A social networking service is an online service, platform, or site that focuses on facilitating the building of social networks or social relations among people who, for example, share interests, activities, backgrounds, or real-life connections. A social network service consists of a representation of each user (often a profile), his/her social links, and a variety of additional services. Most social network services are web-based and provide means for users to interact over the Internet, such as e-mail and instant messaging. Online community services are sometimes considered as a social network service, though in a broader sense, social network service usually means an individual-centered service whereas online community services are group-centered. Social networking sites allow users to share ideas, activities, events, and interests within their individual networks.

Social networking sites are not only for one individual to communicate or interact with other people globally but, this is also an effective way for business promotion. A lot of business minded people these days are now doing business online and use these social networking sites to respond to customer queries. It isn't just a social media site used to socialize with one’s friends but also, represents a huge pool of information from day to day living.

Social Networking Website project itself is a huge project comprising various features like profile updating, friend’s list organization and various other applications to enhance the overall look and feel of the website. However, in this project, we are basically working on two essential features or modules (PROFILE MANAGEMENT & FRIENDS ORGANIZATION ).

PROFILE MANAGEMENT module maintains the profile of a user like name, likes, dislikes, hobbies, status etc.

FRIENDS ORGANIZATION module maintains the friend list, handles request and sends request to the other user.

Profiles and Friends lists are two key features on social network sites. The third one is a public comment feature such as 'Comments', 'The Wall’ which allow individuals to comment on their Friends' profiles. These comments are displayed prominently and visible to anyone who has access to that profile.

1.2  OBJECTIVE OF THE PROJECT :-

The main objective of this website is to provide an informal communication environment which allows users to interact within an online community of friends. In details as follows:-

1. To develop an attractive and user friendly social media website.

2.      Make new user account in more user friendly and proper validation of details.

3.      Search friends easily on entire network.

4.      Send friend request to other users to make friends.

5.      Add friends to your friend box to accept request.

6.      Creating a public profile having a social, professional and personal  information .

7.      Ease of editing of profile any time you need.

8.      Upload and share photographs on network.

9.      Add , search and share videos of  Youtube.

10.       Send messages to other friends.

11.   Reply directly to incoming user scraps.

12.   Admin control to keep an eye on user operation.

13.   Easily password recovery processing.

14.   A wall to connect and share information on network.

15.   Game playing.

16.   Search jobs and add jobs.

17.   Selling and purchasing products.

1.3  PROBLEM STATEMENT :-

We define social network sites as web-based services that allow individuals to construct a public or semi-public profile within a bounded system,  articulate a list of other users with whom they share a connection, and view and traverse their list of connections and those made by others within the system. The nature and nomenclature of these connections may vary from site to site.

There are three types of user who can visit the site, namely

1)      Master admin :-The  admin has full right and control over  all aspects of the site. He/She will create a user profile template with custom questions for capturing demographic information about user. Admin can change/ create/delete categories, flag/un-flag users, create/delete topics and to attain all replies.

2)      Registered User :-Registered user can avail all the facilities provided on the site. He/She can create his/her own profile, blog, upload images and videos , and can chat with others.

3)      General user :- All visitors of the site have to register him -selves/her-selves to avail the facilities provided by the site. He/She has to become a member first and then can interact with other members. The facility for search job & selling and purchasing….

1.4  SCOPE OF THE PROJECT :-

The Friends Media social networking website is an online website designed to make social life of people more active and stimulating. The social network can help you maintain existing relationships with people and share pictures and messages, and establish new ones by reaching out to people you've never met before. This system provides the user to maintain their friend list and update. It also provides user to send invitation to another friend and can add to their friend list. This website provides features like  searching & posting jobs all at one place. The main idea behind job module is to provide facility for job opportunities and career improvement. This provides a forum to share your thoughts with all your friends which can be read by all the users using the website and this can be handled by the user as he/she wants for example upload videos and photos and can maintain it’s own album also. People using this website can buy and sell products. The main purpose behind this activity is to help people to buy products which are trusted in their circle .

Other Features :-

• Secure access of confidential data by user name and password. This application is secure for every kind of its users, because if any user logout from any session then nobody will be able to access his profile without knowing his confidential password.
• 24 X 7 availability
• Better component design to get better performance at peak time.
• Flexible service based architecture will be highly desirable for future extension .
• The database used here is robust, reliable & fast. So users will have to wait for the output very short time.
• This application can be accessed from any type of platform.
• There is no case of redundancy in the database so it will not take extra memory space.
• Validation of registration will be done by a confirmation mail send to user account.
• Password recovery system is also provided in case of forgetting the password.

1.5  BENEFITS OF FRIENDS MEDIA :-

Friends Media makes it easy to find people who share your hobbies and interests, look for romantic connections or establish new business contacts .You can create and join a wide variety of online communities to discuss current events, reconnect with old school mates or even exchange your thoughts. It provides facilities to play games, search jobs ,add jobs, buy and sell products of your choice. Important latest News items are also included to facilitate one’s awareness. To join Friends Media, simply register yourself to the website and you can begin to create your own profile right away. It is our mission to help you create a closer, more intimate network of friends. We hope to put you on the path to social bliss soon.

1.6 ADVANTAGE & DISADVANTAGE OF  SNS :-

Advantages :-

1)      Create and maintain many relationships.

2)      Facilitates open communication leading to enhanced information discovery and delivery.

3)      Provides ability to participate and contribute.

4)      Allows to discuss ideas, post news, ask questions and share links.

5)      Provides opportunities to widen business contacts.

6)      SNS  are  free of cost.

7)      Easy to communicate and connect with people.

8)      Can track activities of competitors.

9)      Addictive – SNS  can become addictive. It can take over one’s life, leaving little time for family and friends.

Disadvantages :-

1)      Online harassment

2)      Creating false profile

3)      Chances of malware additions (virus)

4)      Time waste

5)      Privacy issues with FB and Twitter – don’t  accept people you don’t  know .

6)      Replication of themes from one  SNS to another is annoying.

CHAPTER 2 : STUDY OF EXISTING SYSTEM

We have visited several   social networking sites and our observations on these are mentioned below. Majority of the SNS possess common features such as Photo Uploading, Private Message Sending, Public Message Posting, Video Uploading, Blog, Search friends etc.

1)      Facebook :-    This website was launched on February 4, 2004, by Mark Zuckerberg. Membership includes approximately 85 percent college students  , targets students and younger people. It is one of the most popular sites today.

2)      Orkut :-    It is owned and operated by Google. As of March 2013, 47% of Orkut's users were from Brazil, followed by India with 16.1% and United States with 7.3%. On June 30, 2014, Google announced it would be closing Orkut on September 30, 2014. No new accounts could be created starting from July 2014. Users can download their profile archive by Google Takeout.

3)    Twitter :- In 2013 Twitter was one of the ten most visited websites. Twitter is an online social networking service that enables users to send and read short 140-character messages called "tweets". It is a micro blogging application that is more or less a combination of instant messaging and blogging. Registered users can read and post tweets, but unregistered users can only read them. Twitter was created in March 2006 by Jack Dorsey, Evan Williams, Biz Stone and Noah Glass and by July 2006 the site was launched.

4)      Myspace :-    More than 80 million profiles created; Second most viewed site in America . It is a social networking service with a strong music emphasis owned by Specific Media LLC and Justin Timberlake. Myspace was launched in July 2003 

5)     Linkedin :-  LinkedIn helps people with employment via online networking . Join a Group for join discussions and view job postings. It is a business-oriented social networking service. Founded in December 2002 and launched on May 5, 2003, it is mainly used for professional networking. The site is available in 20 languages,

Various activities involved in Social Networking are shown in the figure :

Social Networking Fact Sheet

Highlights of the Pew Internet Project’s research related to social networking. As of January 2014, 74% of online adults use social networking sites.

As of September 2014:

§       71% of online adults use Facebook

§      23% of online adults use Twitter

§      26% use Instagram

§     28% use Pinterest

§     28% use LinkedIn

CHAPTER 3 : PROJECT  FEATURE

1.     For new user, he/she has to enter his/her details with agreement of terms and condition of the site. For this purpose the user has to register by entering basic details i.e. First name, Last name, Email, Password, Birthday, and Gender. On submission, a confirmation email from Friends Media will be sent immediately along with an activation link to proceed further to the user’s registered email. Clicking on the activation link a new page will be displayed asking further details of the user such as his/her address , mobile number, qualification etc and user has to fill and submit for successful registration.

2. For “login” the user has to enter his/her email and password. If user enters valid information he/she will get logged in and home page will get displayed .
3. User can logout any time by clicking logout link. After a few second a screen will appear showing the index page of the site.
4. This page contains various links like Wall, Profile, Friends, Photo, Job, Post, Video, Games, Sales, and News. It also contains name with photo and some basic details of the user. List of friends along with photo are also displayed. This page also includes latest news items uploaded by the administrator.
5.  The wall page is provided for the registered user to express his/her feelings or thoughts with a wall status. Other user can post his/her thoughts, views, opinions, experience and observation etc . The visitors can record their observations ,  like, or dislike.
6. The user can edit  his/her  profile details, if wishes to do so.
7. For search/add friends, there is a friend link option on user’s homepage. From there he/she can add friends and then can see their profiles. This will facilitates the user to add new friends and exchange views/ thoughts etc.
8. An option is  provided for adding video to the user’s profile. For video link we have used YouTube API. The ‘Embed’ details for that video will get added to video tables.
9. An option for adding photo has been provided. Under Photo link there are two options “Add Gallery” and “Add Photo”. First, the user has to create Gallery Name  and then add Photo. All the images added by the user will get displayed on his/her wall.
10. User can play games at any time of his/her own choice. Some selected games like Candy Crush Saga, Pacman , Zombie, Pool have been included.
11. User can give his/her comments,  like/dislike and share on text, images and videos.  Update facility is also provided to facilitate the user to post any thing like images or videos etc which can be viewed by permitted user. After viewing the post , the specific user can respond their comments.
12. User can sell or purchase anything as per his/her convenience. For sell the user has to provide photos, brand names, type , important details of the product along with price. The reason for sale is also to be mentioned. Interested user who want to buy the item has to contact the owner and settle the deal.
13. The user can see various jobs listed on his wall page. For this purpose – Title , Location, and detail of the job can be added by the user, and thereafter this will be available to all users.
14. To control and maintain the website, admin module has been added. The admin is responsible for smooth functioning of the website. The admin is authorized to screen any information and can modify/delete if required. He/She is also responsible to update /add latest news. 

CHAPTER 4  FEASIBILITY STUDY

A detailed investigation and analysis conducted to determine the financial, economic, technical, or other advisability of a proposed project. Part of the systems development life cycle which aims to determine whether it is sensible to develop some  system.  The most popular model of feasibility study is "TELOS",  stands for Technical, Economic, Legal, Operational, Schedule.

·        Technical Feasibility :- The software required to develop the system as well as to run it are easily accessible and free of cost and hence it is technically feasible.

·   Economic Feasibility :-The system is simple, user friendly set up and personalization, cost efficient/free, Easily accessible and hence it is economically feasible.

·         Legal Feasibility :- There is no conflict between the proposed system and legal requirements.

·       Operational Feasibility :-  The current work practices and procedures adequate to support the new system .The system is simple to use, easily accessible and free of cost and hence it is operationally feasible.

·         Schedule Feasibility :- The  system is developed within time limit.

CHAPTER 5 :  PROPOSED SYSTEM

5.1  Description of Languages & Tools used :-

The Friends Media is an online social networking website designed to make one’s social life more active and stimulating. The languages and tools used are as follows

5.1.1 PHP

            PHP is a scripting language designed to fill the gap between SSI (Server Side Includes) and Perl, intended for the web environment. Its principal application is the implementation of web pages having dynamic content. PHP has gained quite a following in recent times, and it is one of the frontrunners in the Open Source software movement. Its popularity derives from its C-like syntax, and its simplicity. PHP is currently divided into two major versions: PHP 4 and PHP 5, although PHP 4 is deprecated and is no longer developed or supplied with critical bug fixes. PHP 6 is currently under development.  PHP was designed by Rasmus Lerdorf to display his resume online and to collect data from his visitors.

 PHP allows a static webpage to become dynamic. "PHP" is an acronym that stands for "PHP: Hypertext Preprocessor". The word "Preprocessor" means that PHP makes changes before the HTML page is created. This enables developers to create powerful applications which can publish a blog, remotely control hardware, or run a powerful website such as Wikipedia or Wikibooks. Of course, to accomplish something such as this, you need a database application such as MySQL.

PHP code is interpreted by a web server with a PHP processor module, which generates the resulting web page: PHP commands can be embedded directly into an HTML source document rather than calling an external file to process data. It has also evolved to include a interface capability and can be used in standalone graphical applications.

The PHP language was originally implemented as an interpreter, and this is still the most popular implementation. Several compilers have been developed which decouple the PHP language from the interpreter. Advantages of compilation include better execution speed, static analysis, and improved interoperability with code written in other languages.

PHP includes free and open source libraries with the core build. PHP is a fundamentally Internet-aware system with modules built in for accessing File Transfer Protocol (FTP) servers, many database servers, embedded SQL libraries such as embedded PostgreSQL, MySQL, Microsoft SQL Server and SQLite, LDAP servers, and others. Many functions familiar to C programmers such as those in the studio family are available in the standard PHP build.

5.1.2 Database (Mysql)

The Friends Media incorporates MYSQL for its database.

MYSQL is an open source relational database management system (RDBMS). It is commonly used for database services for other open source applications.

Why do we use MYSQL Database? 

·       Scalability and Flexibility

The MYSQL database server provides the ultimate in scalability, sporting the capacity to handle deeply embedded applications with a footprint of only 1MB to running massive data warehouses holding terabytes of information.

·         High Performance

A unique storage-engine architecture allows database professionals to configure the MYSQL database server specifically for particular applications, with the end result being amazing performance results.

·         High Availability

Rock-solid reliability and constant availability are hallmarks of MYSQL, with customers relying on MYSQL to guarantee around-the-clock uptime.

·         Robust Transactional Support

MYSQL offers one of the most powerful transactional database engines on the market. Features include complete ACID (atomic, consistent, isolated, durable) transaction support, unlimited row-level locking, distributed transaction capability, and multi-version transaction support where readers never block writers and vice-versa.

·         Web and Data Warehouse Strengths

MYSQL is the de-facto standard for high-traffic web sites because of its high- performance query engine, tremendously fast data inserts capability, and strong support for specialized web functions like fast full text searches.

·         Strong Data Protection

Because guarding the data assets of corporations is the number one job of database professionals, MYSQL offers exceptional security features that ensure absolute data protection. In terms of database authentication, MYSQL provides powerful mechanisms for ensuring only authorized users have entry to the database server, with the ability to block users down to the client machine level being possible.

·         Comprehensive Application Development

One of the reasons MYSQL is the world's most popular open source database is that it provides comprehensive support for every application development need.  Within the database, support can be found for stored procedures, triggers, functions, views, cursors, ANSI-standard SQL, and more.

·         Management Ease

MYSQL offers exceptional quick-start capability with the average time from software download to installation completion being less than fifteen minutes.

·         Open Source Freedom and 24 x 7 Support

Many corporations are hesitant to fully commit to open source software because they believe they can't get the type of support or professional service safety nets they currently rely on with proprietary software to ensure the overall success of their key applications. The questions of indemnification come up often as well.

·         Lowest Total Cost of Ownership

By migrating current database-drive applications to MYSQL, or using MYSQL for new development projects, corporations are realizing cost savings that many times stretch into seven figures.

5.1.3        PHP MyAdmin

PHPMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. PhpMyAdmin supports a wide range of operations on MySQL, Maria DB and Drizzle. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc.) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.

Features provided by the program include:

1.     Web interface

2.     MySQL database management

3.     Import data from CSV and SQL

4.     Export data to various formats: CSV, SQL, XML, PDF (via the TCPDF library), ISO/IEC 26300 - Open Document Text and Spreadsheet, Word, Excel, LaTeX and others

5.     Administering multiple servers

6.     Creating PDF graphics of the database layout

7.     Creating complex queries using Query-by-Example (QBE)

8.     Searching globally in a database or a subset of it

9.     Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link

10.  Live charts to monitor MySQL server activity like connections, processes, CPU/Memory usage, etc.

5.1.4  Server(WAMP)

            WAMP Server is a Windows web development environment. It allows you to create web applications with Apache2, PHP and a MYSQL database. Alongside, PHPMYADMIN allows you to manage easily your database.

WAMP server is a collection of programs you can use to turn your regular desktop PC to a fully compatible web server with HTTP, PHP, MYSQL, PHPMYADMIN, SQLBUDDY applications. The advantage is that it is easy configurable with the built-in tools. Also it is structured in the way that you have everything you need at a click distance. The configuration screens provide extra information how settings should look like. Another thing would be that the packed applications are configured to be compatible between them, all being automatic configured, and you just unpack your script, database, application, run the installer.

5.1.5  Hardware Requirements

Processor                                 :           Intel Pentium IV 2.0 GHz and above

RAM                                       :           512 MB and above

Hard disk                                :           80GB and above

Monitor                                   :           CRT or LCD monitor

Keyboard                                :           Normal or Multimedia

Mouse                         :                       Compatible mouse

Software Requirements

Front End                                :           WAMP

Language                                :           PHP, HTML, CSS, JavaScript

Back End                                :           PHP MyAdmin

Software                         :                   Adobe Photoshop, Dream Viewer, Cute FTP

Operation System                   :           Windows XP or above

Browser                                   :           Any latest browser

CHAPTER 6:- SYSTEM ANALYSIS & DESIGN

6.1 ER Diagram :-

The ER diagram is drawn to have a better understanding of the whole scenario, it was used to conceptualize the phenomena, actions and interactions between various entities and to arrive at the specific requirements in a comprehensive manner. The ER diagram is attached with this SRS.

The overall logic structure of database can be expressed by ER-Diagram, (Entity Relationship Diagram), which is built up with components: Entity Sets (shown as rectangles), Attributes (shown as ellipses), Relationships (shown as diamond) and Links (shown as lines). An entity is a thing or object in the real world that is distinguishable from other objects e.g. user, jobs, etc. The entities are described in a database by a set of attributes e.g. customer id, customer name, customer address etc. A relationship is an association among several entities e.g. post, search etc.

6.2 Data Flow Diagrams :-                                

Data flow diagrams (DFDs) reveal relationships among and between the various components in a program or system. DFDs are an important technique for modeling a system’s high-level detail by showing how input data is transformed to output results through a sequence of functional transformations. The DFD (also known as the bubble chart) is a simple graphical formalism that can be used to represent a system in terms of the input data to the system, various processing carried out on those data, and the output data generated by the system. DFD is very simple formalism, simple to understand and use.

A DFD model uses a very limited number of primitive symbols to represent the functions performed by a system and the data flow among these functions. DFDs consist of four major components : entities, processes, data stores, and data flows. The symbols used to depict how these components interact in a system are simple and easy to understand. A set of DFDs provides a logical model that shows what the system does, not how it does it.

0 Level DFD:- A level 0 DFD, also called a fundamental system model or context diagram represents the entire software element as a single bubble with input and output data indicated by incoming and outgoing arrows, respectively.

1 Level DFD :-

This level of DFD provide more detailed structure. It provides a  detailed view of requirements and flow of data from 1 bubble to another.

6.3  Use-case Diagram

A use case diagram is a graphic depiction of the interactions among the elements of a system. A use case is a methodology used in system analysis to identify, clarify, and organize system requirements. In this context, the term "system" refers to something being developed or operated, such as a mail-order product sales and service Web site. Use case diagrams are employed in UML (Unified Modeling Language), a standard notation for the modeling of real-world objects and systems.

System objectives can include planning overall requirements, validating a hardware design, testing and debugging a software product under development, creating an online help reference, or performing a consumer-service-oriented task. For example, use cases in a product sales environment would include item ordering, catalog updating, payment processing, and customer relations. A use case diagram contains four components. The boundary, which defines the system of interest in relation to the world around it.

·         The actors, usually individuals involved with the system defined according to their roles.

·         The use cases, which are the specific roles played by the actors within and around the system.

·         The relationships between and among the actors and the use cases.

·         Login/Registration

·         Home Page

·         Admin

·         Wall Page

·         Profile Page

·         Search Friend

·         Friend List Page

·         Photo Page

·         Search Job Page

·         Game Page

·         Buy& Sell Product Page

6.4   Design structure :-

CHAPTER  7   APPLICATION  DESIGN

7.1 Login :- For “login” the user has to enter his/her email and password to verify the   login credentials from user_detail table. If user enters valid information he/she will get logged in and home page will get displayed. If login failed then a message “Invalid Username or Password. Please Try Again ”  will be displayed and  the user has an option to enter his/her name and password again. If person is new user he/she will fill register form displayed on the same page.

7.2 Registration :- For new user , he/she has to enter basic details i.e. First name, Last name, Email, Re-enter email, Password(select a password for future use), Birthday, and Gender with agreement of terms and conditions of the site. On click Sign-Up button, a confirmation email to the user’s registered email from Friends Media will be sent immediately along with an activation link to proceed further. Clicking on the activation link a new page will be displayed asking further details of the user such as his/her address ,mobile number, qualification etc and user has to fill and submit for successful registration. After checking the entered values (eg. Empty values, Invalid Password etc.) it will insert all the values in the user_detail table. After successful inserts, user will get directed to his/her home page.

7.3Log –out  :-  User can logout any time by clicking logout link. After a few second a screen will appear  showing the index page of the site.

7.4 User’s home page :- This page contains various links like Wall, Profile, Friends, Photo, Job, Post, Video, Games, Sales, and News. It also contains name with photo and some basic details of the user. List of friends along with photo are also displayed. This page also includes latest news items uploaded by the administrator. An option for Sign-Out is also available.

7.5 Wall :- The wall is a place where the registered user can express his current feeling or thoughts with a wall status. Other users can add their thoughts by creating wall posts that show up below the status. It is basically a way for many users to communicate publicly or simply leave their thoughts about each other. User can post his/her thoughts, views, opinions, experience and observation etc . The visitors can record their observations ,  like, or dislike.

7.6 Edit profile :- Once the user has logged in, he/she can edit the profile details if wishes to do so. On click “Save Profile” button , the modified details will be updated in the user_detail table. These new details will be selected from the user_detail table during future references. As Email-ID is a unique key, the user is not permitted to edit it.

7.7 Search/Add Friend :- For search of old friends/new person, a Friend link  has been provided on the user’s home page .On click, the users name, location along with photo together with “Send Request Button” will be displayed. If user wishes to add then click on the button. The request will be send automatically to the concerned person for his/her acceptance. If accepted, the persons photo will be added in the user’s friend list. . This will facilitates the user to add new friends and exchange views/ thoughts etc. The person’s further details can be seen by clicking his/her photos.

7.8 News :- Important  classified news uploaded by the administrator will be displayed showing message “Admin shared a News on Date and Time ” with news title link on user’s home page. The further details will be displayed on click on the link.

7.9 Video :- For video link we have used YouTube API. For this purpose an option has been provided for adding the video to the profile by submitting Video name  and YouTube URL. On doing so, the video is uploaded showing message “Video is Uploaded Successfully”. All videos will get displayed on the friends wall .The ‘Embed’ details for that video will get added to video tables.

7.10       Photo :- Under Photo link there are two options “Add Gallery” and “Add Photo”. First the user has to create Gallery Name (e.g. Personal, Friends, Family etc) in Add Gallery option and then click on Add Photo button. User has to  browse the button to select photo of his/her own choice from local machine and then select the “Select Gallery” option and then click on “Add Photo” button. After adding the image, it will be stored in the photo_gallery table. All the images added by the user will get displayed on his/her wall.

7.11       Games :- User can play games at any time of his/her own choice. Some selected games like Candy Crush Saga, Pacman , Zombie, Pool have been included. The embed-code for most games are taken from http://www.classicgamesarcade.com . More games may be added at anytime .

7.12       Comments, Like & Share :- User can give his/her comments,  like/dislike and share on text, images and videos. Like and Share links are provided for each upload and it will show latest count. A link Comment  is also provided for expressing one’s view about the uploaded post.

7.13       Daily Update  :- Update  facility is provided through which the user can post any thing like images or videos etc which can be viewed by permitted user. After viewing the post , the specific user can respond their comments.

7.14       Selling and purchasing Products :-  Under this application the user can sell or purchase anything from used cars to mobiles , furniture ,laptops , clothing ,tablets , electronics & computers, books & CDs, & accessories and more. The uploaded image would be saved in the product_detail table. For sell the user has to provide photos, brand names, type , important details of the product along with price and then post it. The reason for sale is also to be mentioned. Interested user who want to buy the item has to contact the owner and settle the deal.

7.15        Search & Update Jobs :- Facility for search job under the heading – Title , Location, and detail is provided. User has an option to add job by simply filling “Job Title”, “Job Location”, “Job Detail” and click on a “Add Job” button, and thereafter this will be available to all users.

7.16       Admin Module :- The admin controls and maintains the website and also keeps an eye on user operation. Important classified news are uploaded by the administrator which will be displayed on user’s home page. This is done by entering  the news “Title”, “Full News” description, insert images, if available and then click on a “Submit” button. The uploaded news will be displayed on the user’s home page. The list of news items will also be displayed on the admin page and can be edited the news items, if required. For security reason, an option for the change of password of admin is provided. Here we included “Old-Password” , “New Password” and “Confirm Password” as  a mandatory field and admin can change his/her password by clicking on the “Change Password” button. Log-Out button is also given.

CHAPTER  8  :  DATABASE  DESIGN

8.1    Database Tables :- :

8.1.1 User_detail  Table :-

CREATE TABLE `user_detail` (

 `ud_id` int(255) NOT NULL AUTO_INCREMENT,

 `ud_profile_id` varchar(500) NOT NULL,

 `ud_first_name` varchar(100) NOT NULL,

 `ud_last_name` varchar(100) NOT NULL,

 `ud_email` varchar(200) NOT NULL,

 `ud_password` varchar(100) NOT NULL,

 `ud_mobile_no` varchar(20) NOT NULL,

 `ud_birth_date` date NOT NULL,

 `ud_gender` varchar(10) NOT NULL,

 `ud_address` text NOT NULL,

 `ud_city` varchar(200) NOT NULL,

 `ud_state` varchar(200) NOT NULL,

 `ud_pin_code` varchar(100) NOT NULL,

 `ud_country` varchar(200) NOT NULL,

 `ud_user_image` varchar(500) NOT NULL,

 `ud_school_name` varchar(500) NOT NULL,

 `ud_college` varchar(500) NOT NULL,

 `ud_occupation` varchar(500) NOT NULL,

 `ud_company_name` varchar(500) NOT NULL,

 `ud_admin_validate` int(5) NOT NULL,

 `ud_user_validate` int(5) NOT NULL,

 `ud_creation_date` datetime NOT NULL,

 PRIMARY KEY (`ud_id`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1

8.1.2 Admin_table :-

 CREATE TABLE `admin_table` (

 `at_id` int(255) NOT NULL AUTO_INCREMENT,

 `at_user_id` varchar(100) NOT NULL,

 `at_password` varchar(500) NOT NULL,

 `at_name` varchar(500) NOT NULL,

 PRIMARY KEY (`at_id`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1

8.1.3 Album_gallery  Table :-

CREATE TABLE `album_gallery` (

 `ag_id` int(255) NOT NULL AUTO_INCREMENT,

 `ag_user_id` int(255) NOT NULL,

 `ag_admin_validate` int(10) NOT NULL,

 `ag_user_validate` int(10) NOT NULL,

 `ag_gallery_name` varchar(500) NOT NULL,

 `ag_creation_date` datetime NOT NULL,

 `del_row` int(10) NOT NULL,

 PRIMARY KEY (`ag_id`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1

8.1.4 Friend_relation  Table :-

CREATE TABLE `freind_relation` (

 `fr_id` int(255) NOT NULL AUTO_INCREMENT,

 `fr_sender_request_id` int(255) NOT NULL,

 `fr_receiver_request_id` int(255) NOT NULL,

 `fr_validate` int(10) NOT NULL,

 PRIMARY KEY (`fr_id`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1

8.1.5 Games_detail  Table :-

CREATE TABLE `games_detail` (

 `game_id` int(11) NOT NULL AUTO_INCREMENT,

 `game_name` varchar(500) NOT NULL,

 `game_image` varchar(500) NOT NULL,

 `game_code` longtext NOT NULL,

 PRIMARY KEY (`game_id`)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1

8.1.6 Job_detail  Table :-

CREATE TABLE `job_detail` (

 `jd_id` int(255) NOT NULL AUTO_INCREMENT,

 `jd_user_id` int(255) NOT NULL,

 `jd_title` varchar(500) NOT NULL,

 `jd_location` varchar(500) NOT NULL,

 `jd_detail` varchar(500) NOT NULL,

 `jd_creation_date` datetime NOT NULL,

 `del_row` int(10) NOT NULL,

 PRIMARY KEY (`jd_id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

8.1.7 like_share_comment  Table :-

CREATE TABLE `like_share_comment` (

 `lsc_id` int(255) NOT NULL AUTO_INCREMENT,

 `lsc_user_id` int(255) NOT NULL,

 `lsc_comment` longtext NOT NULL,

 `lsc_activity` int(10) NOT NULL,

 `lsc_posting_id` int(255) NOT NULL,

 `lsc_posting_type` varchar(100) NOT NULL,

 `lsc_date_time` datetime NOT NULL,

 PRIMARY KEY (`lsc_id`)

) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1

8.1.8 News  Table :-

CREATE TABLE `news` (

 `id` int(11) NOT NULL AUTO_INCREMENT,

 `title_news` text NOT NULL,

 `detail_news` longtext NOT NULL,

 `visible` varchar(10) NOT NULL,

 `date` datetime NOT NULL,

 PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1

8.1.9 Photo_gallery  Table :-

CREATE TABLE `photo_gallery` (

 `pg_id` int(255) NOT NULL AUTO_INCREMENT,

 `pg_gallery_id` int(255) NOT NULL,

 `pg_image_name` varchar(500) NOT NULL,

 `pg_creation_date` datetime NOT NULL,

 `del_row` int(10) NOT NULL,

 PRIMARY KEY (`pg_id`)

) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1

8.1.10 Posting_detail  Table :-

CREATE TABLE `posting_detail` (

 `pd_id` int(255) NOT NULL AUTO_INCREMENT,

 `pd_user_id` int(255) NOT NULL,

 `pd_post_detail` longtext NOT NULL,

 `pd_post_image` varchar(500) NOT NULL,

 `pd_admin_validate` int(10) NOT NULL,

 `pd_user_validate` int(10) NOT NULL,

 `pd_creation_date` datetime NOT NULL,

 `del_row` int(10) NOT NULL,

 PRIMARY KEY (`pd_id`)

) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1

8.1.11 Product_detail  Table :-

CREATE TABLE `product_detail` (

 `pd_id` int(255) NOT NULL AUTO_INCREMENT,

 `pd_user_id` int(255) NOT NULL,

 `pd_product_name` varchar(500) NOT NULL,

 `pd_product_price` varchar(100) NOT NULL,

 `pd_product_detail` varchar(500) NOT NULL,

 `pd_product_image` varchar(200) NOT NULL,

 `pd_product_type` varchar(200) NOT NULL,

 `pd_creation_date` datetime NOT NULL,

 `del_row` int(10) NOT NULL,

 PRIMARY KEY (`pd_id`)

) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1

              Video_detail Table :-

CREATE TABLE `video_detail` (

 `vd_id` int(255) NOT NULL AUTO_INCREMENT,

 `vd_user_id` int(255) NOT NULL,

 `vd_video_name` varchar(500) NOT NULL,

 `vd_video_youtube_link` text NOT NULL,

 `vd_admin_validate` int(10) NOT NULL,

 `vd_creation_date` datetime NOT NULL,

 `del_row` int(10) NOT NULL,

 PRIMARY KEY (`vd_id`)

) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1

8.2     Relationship Between Tables

CHAPTER 10 :  SCREEN LAYOUT

Registration/Login Page

When a user visit Friends Media social networking website for the first time the below form will be appeared where user have to enter the personal details and then click on a Sign-up button. First name, email, re-entered email, password, birthday, gender are mandatory fields. User has to fill all these fields, otherwise error message will prompt and advice the user to fill the fields. Here Email entry in our database is a unique id and is primary key. If a user enters email which is already in the database then the system will prompt “Email already exist”.

Registration (contd.)

When user fills all the entries the following page will appear showing that “Successfully Registered. Please Check Your Email Id.”

Confirmation email from Friends Media

On click Sign-Up button , after filling the required entries of the registration form, a confirmation email form Friends Media will be sent immediately along with an activation link to proceed further to the user’s registered email .

Registration (further details)

When user’s validation is made successfully the a following page will appear asking for user’s further details and also user can upload their photo as a profile picture.

User’s Profile Page :-

Edit Profile :-

Home page (video upload)

Home page (video uploaded)

Home page (games)

Home page (candy crush saga game):-

login page – Forget Password:-

Forget Password (contd.)

Login page:-

On log-in page, if username/email id and password matches then allow that user to go his/her home page. Otherwise a message will prompt showing “Invalid Username or Password, Please Try Again”.

Friend Request Send :-

Accept/Cancel Friend Request :-

Post :-

Add Jobs :-

Job added successfully :-

Photos :-

(1)   Add Gallary

(2)   Add Photo

Add Products : - (Adding product process)

Product is added successfully :-

News

Admin Login Page :-

Admin Page :-

Add News :-

CHAPTER 11 : CONCLUSION

It has been a great experience for us while working on this project. We learnt a lot in the field of social networking technologies and various applications. We have been successful in planning, designing and implementing Friends Media social networking website for engaging your social life more active and stimulating. It provides online platform for interacting with friends, exchange views, send pictures, search jobs, and play games etc. It can help you maintain existing relationships with pictures and messages, and establish new ones by reaching out to people you’ve never met before. It helps you create and share ideas and information instantly, without barriers. We successfully learnt how to deploy online web services on small scale as well as on large scale like Facebook, LinkedIn etc.

Friends Media makes it easy to find people who share your hobbies and interests, look for romantic connections or establish new business contacts .You can create and join a wide variety of online communities to discuss current events, reconnect with old school mates or even exchange your thoughts.

It is our mission to help you create a closer, more intimate network of friends. We hope to put you on the path to social bliss soon.

CHAPTER 9 :- TESTING

Testing Used :-

 Testing is the process of running a system with the intention of finding errors. Testing enhances the integrity of a system by detecting deviations in design and errors in the system. Testing aims at detecting error-prone areas. This helps in the prevention of errors in a system. Testing also adds value to the product by conforming to the user requirements. Testing must be thorough and well-planned. A partially tested system is as bad as an untested system. And the price of an untested and under-tested system is high. The user tests the system and changes are made according to their needs. The testing involves the testing of the developed system using various kinds of data. While testing, errors are noted and corrections are made. 

The various types of testing on the system are:

1. Unit Testing.

2. Integration Testing

     3. System testing

     4. User Acceptance Testing

9.1 Unit Testing :-

Unit testing focuses efforts on the smallest unit of software design. This is known as module testing. The modules are tested separately. The test is carried out during programming stage itself. In this step, each module is found to be working satisfactory as regards to the expected output from the module.

9.2 Integration Testing :-

Data can be lost across an interface. One module can have an adverse effect on another, sub functions, when combined, may not be linked in desired manner in major functions. When the development of all the units or modules is completed and integrated the integrity test phase is started. In this phase the interface between the modules are tested. This phase basically verifies whether inter module exchange of information and events are as per required system behavior. All the modules are combined and tested as a whole.

9.3 System Testing :-

System testing is the stage of implementation. This is to check whether the system works accurately and efficiently before live operation commences. Testing is vital to the success of the system. The candidate system is subject to a variety of tests: on line response, volume, stress, recovery, security and usability tests. A series of tests are performed for the proposed system is ready for user acceptance testing.

9.4  User Acceptance Testing :-

User acceptance of a system is the key factor for the success of any system. The system under consideration is tested for the user acceptance by constantly keeping in touch with the prospective system users at the time of developing and making changes whenever required.

9.5 Validation :-

At the culmination of the integration testing, Software is completely assembled as a package. Interfacing errors have been uncovered and corrected and a final series of software test begin in validation testing. Validation testing can be defined in many ways, but a simple definition is that the validation succeeds when the software functions in a manner that is expected by the customer. Tests were performed to find conformity with the requirements. Plans and procedures were designed to ensure that all functional requirements are satisfied. There are two goals in preparing test plans. Firstly, a properly detailed test plan demonstrates that the program specifications are understood completely. Secondly, the test plan is used during program testing to prove the correctness of the program.

This system has some common validation just like other social networking sites. For example it has following validation:-

1.      On first step when user creates his/her account and choose a email. Email entry in our database is a unique id and is primary key. If a user enters email which is already in the database then the system will prompt “Email already exist”.

2.      First name, email, re-entered email, password, birthday, gender are mandatory fields. User has to fill all these fields, otherwise error message will prompt and advice the user to fill the fields.

3.      On sign up page email and re-entered email must be same , otherwise the system will not allow to proceed .

4.      On Sign-Up page password must be of minimum 8 characters.

5.      On click Sign-Up button , after filling the required entries of the registration form, a confirmation email form Friends Media will be sent immediately along with an activation link to proceed further to the user’s registered email .

6.      On log-in page, if username/email id and password matches then allow that user to go his/her home page. Otherwise a message will prompt showing “Invalid Username or Password, Please Try Again”.

7.      A user can’t upload another file except .gif, .jpeg , .png .

8.      User can’t add post without entering “Post Details”. A message will prompt showing “Please fill in this field”.

9.      User can’t add jobs without entering the fields like “Job Title”, “Job Location”, and “Job Detail”. A message will prompt showing “Please fill in this field”.

9.6 Output Testing :-

After performing the validation testing, the next step is output testing of the proposed system, since no system could be useful if it does not produce the required output in a specific format. The output format on the screen is found to be correct; the format was designed in the system design time according to the user needs. For the hard copy also; the output comes as per the specified requirements by the user. Hence output testing did not result in any correction for the system.

9.7  Test Cases & Results :-

Login :-

S.No.	Input Values	Test case	Conditional being checked	Result
1	Email	Empty	Please fill in this field	Successful
2	Password	Empty	Please fill in this field	Successful
3	Password	If  Password mismatched	Invalid Username or Password. Please Try Again	Successful

Registration :-

S.No.	Input Values	Test case	Conditional being checked	Result
1.	First Name *	Empty	Please fill in this field	Successful
2	Last Name	Empty	Please fill in this field	Successful
3	Email *	Empty	Please fill in this field	Successful
4	Email *	Already Exists or not	Email id already exist	Successful
5	Re-enter Email *	Empty	Please fill in this field	Successful
6	Email &   Re-enter Email *	Not matched	Email id is not matched, please confirm again your email id	Successful
7	Password *	Empty	Please fill in this field	Successful
8	Password *	Length	Minimum 8 characters required	Successful
9	Birthday *	Empty	Please select an item in the list	Successful
10	Birthday *	Invalid date	Invalid patient date of birth	Successful
11	Gender	By default male	Select appropriate Option	Successful

Profile Information :-

S.No.	Input Values	Test case	Conditional being checked	Result
1.	Mobile	Empty/Filled	Optional	Successful
2	I live in *	Empty	Please select an item in the list	Successful
3	City *	Empty	Please fill in this field	Successful
4	Address *	Empty	Please fill in this field	Successful
5	Pin code	Empty/Filled	Optional	Successful
6	College/University	Empty/Filled	Optional	Successful
7	School	Empty/Filled	Optional	Successful
8	Occupation	Empty/Filled	Optional	Successful
9	Upload Picture	Empty	Permitted File extension only .jpeg , .png ,  .jpg	Successful

Forget Password :-

S.No.	Input Values	Test case	Conditional being checked	Result
1	Please enter your User Name/Email id *	Empty	Please fill in this field	Successful
2	Please enter your User Name/Email id *	Wrong	Email Id not Exist	Successful
3	Please enter your User Name/Email id *	Correct	Password is successfully sent to your email id , please check your email	Successful

Photos :-

(1)   Add Gallary :-

S.No.	Input Values	Test case	Conditional being checked	Result
1.	Gallery Name *	Empty	Please fill in this field	Successful

(2)   Add Photos :-

S.No.	Input Values	Test case	Conditional being checked	Result
1.	Image *	BROWSE	Please select a file	Successful
2	Select Gallery *	Empty	Please select an item in the list	Successful

Add Videos :-

S.No.	Input Values	Test case	Conditional being checked	Result
1	VideoName *	Empty	Please fill in the field	Successful
2	Video Link *	Empty	Please fill in the field	Successful

Add Job :-

S.No.	Input Values	Test case	Conditional being checked	Result
1	Job Title *	Empty	Please fill in this field	Successful
2	Job Location *	Empty	Please fill in this field	Successful
3	Job Detail *	Empty	Please fill in this field	Successful

Add Post :-

S.No.	Input Values	Test case	Conditional being checked	Result
1	Image	Choose File	Optional	Successful
2	Post Detail	Empty	Please fill in this field	Successful

Sale/Purchase :-  Add Product

S.No.	Input Values	Test case	Conditional being checked	Result
1	Product Image	BROWSE	Please select a file	Successful
2	Product Name *	Empty	Please fill in this field	Successful
3	Product Price *	Empty	Please fill in this field	Successful
4	Product Type *	Empty	Please fill in this field	Successful
5	Product Detail *	Empty	Please fill in this field	Successful

Admin Login :-

S.No.	Input Values	Test case	Conditional being checked	Result
1	User ID	Empty	Please enter your user  name	Successful
2	Password	Empty	Please enter password	Successful