Alumni
Alumni
INTRODUCTION
This project has two sides (Admin and Alumni). The admin side can manage
all the list of job posted,alumni list, events, forum topics and the gallery. The Alumni
can create an account,post a job opportunity, create a forum topic and join to other
forums and commit to participate in an upcoming events.The details related to the Job
vacancies ,Career ,Subject details can be asked by the new students from the old
students. This process will need the verification in order to enlist the alumnus .
After admin verify the user as an alumnus can begin to explore the features of
the system. The admin will create the about content of the college to be displayed on
the website. This feature helps the college management to update the about content of
the system easily even without the presence of a developer.The details of the students
can be got in just one mouse click.
1
CHAPTER 2
SYSTEM ANALYSIS
2
2.3 SYSTEM REQUIREMENTS
Hardware Requirements:
Software Requirements:
3
CHAPTER 3
SYSTEM DESIGN
The System was analyzed and designed before implementation began. In this
section, Architectural Design, Database Design and GUI Design are described in
details.
4
DATA FLOW DIAGRAM
Level 0:
ADMIN ALUMNI
AOCC
Level 1:
ADMIN
EVENTS UPLOAD THE EVENTS
USER
MANAGE THE USER
DETAILS
5
Level 2:
VIEW ALUMNUS
ALUMNUS DETAILS
DETAILS
POST JOB
JOB OPPORTUNITY
6
ER - DIAGRAM
uname password
ADMIN
MANAGE
AId
Gen
Cname Date
Connect
Lname
Stat JOBS
Uid
Img Bat
Date
Add
Email Schedule
Contact Descri
Cid
J Title
C Id
VIEW
COURSE
POST
About
Course
U Id Name Uname
USER
Pword
A id
Type
7
3.2 DATABASE DESIGN
Database design is the process of producing a detailed data
model of a database. The logical data model contains all the needed logical and
physical design choices and physical storage parameters needed to generate design in
a data definition language.
A id Int Alumni id
8
3.2.2 TABLE NAME: JOB
J Id Int Job id
U id Int User id
E id Int Event id
9
3.2.5 TABLE NAME:GALLERY
I Id Varchar Image id
F Id Int Forum id
U id Int User id
U Id Int User Id
10
3.3 GRAPHICAL USER INTERFACE (GUI) DESIGN
GUI design is a type of interface that allows users to interact
with electronic devices through graphical icons and visual indicators such a
secondary notation as opposed to text based interface, typed command labels or text
navigation.
UPCOMING EVENTS
CONTACT US
ALUMNI LOGIN
LOGIN
Password
LOGIN
11
ADMIN LOGIN
USERNAME
PASSWORD
LOGIN
ALUMNI SIDE
ALUMNI PAGE
ALUMNUS LIST
JERSY V JOSHVINA
EMAIL:joshvina12@gmail.com
BATCH:2019
CURRENTLY CONNECTED:TCS
ADDRESS :Kadambathur
CONTACT:9527894163
12
GALLERY PAGE
GALLERY
JOB PAGE
JOB LIST
FILTER SEARCH
13
FORUM PAGE
FORUM LIST
FILTER SEARCH
ADMIN SIDE
ADMIN HOME PAGE
GALLERY
4 1 2
COURSE LIST ALUMNI FORUM TOPICS POSTED JOBS
ALUMNI LIST 0
UPCOMING EVENTS
JOBS
EVENTS
FORUM
USERS
SYSTEM SETTINGS
14
GALLERY PAGE
HOME UPLOAD
DELETE
ALUMNI LIST
SAVE CANCEL
JOBS
EVENTS
FORUM
USERS
SYSTEM SETTINGS
15
COURSE LIST
HOME
HOME
COURSE FORM COURSE LIST
GALLERY
COURSE SHOW 10 ENTRIES SEARCH
GALLERY
COURSE LIST
# COURSE ACTION
COURSE LIST
EDIT
ALUMNI LIST SAVE CANCEL
ALUMNI LIST
DELETE
JOBS
JOBS
EVENTS
EVENTS
FORUM
FORUM
USERS
USERS
SYSTEM SETTINGS
SYSTEM SETTINGS
16
ALUMNI LIST PAGE
GALLERY
10
SHOW ENTRIES SEARCH
GALLERY
COURSE LIST
# IMG NAME COURSE GRADUATED STATUS ACTION
COURSE LIST
ALUMNI LIST EDIT
ALUMNI LIST
DELETE
JOBS
JOBS
EVENTS
EVENTS
FORUM
FORUM
USERS
USERS
SYSTEM SETTINGS
SYSTEM SETTINGS
17
JOBS PAGE
DELETE
ALUMNI LIST
ALUMNI LIST
JOBS
JOBS
EVENTS
EVENTS
FORUM
FORUM
USERS
USERS
SYSTEM SETTINGS
SYSTEM SETTINGS
18
EVENTS PAGE
GALLERY
SHOW ENTRIES SEARCH
GALLERY 10
COURSE LIST
# SCHEDULE TITLE DESCRIPTION COMMITED TO ACTION
COURSE LIST PARTICIPATE
ALUMNI LIST
ALUMNI LIST
JOBS
JOBS
EVENTS
EVENTS
FORUM
FORUM
USERS
USERS
SYSTEM SETTINGS
SYSTEM SETTINGS
19
FORUM PAGE
ALUMNI LIST
ALUMNI LIST
JOBS
JOBS
EVENTS
EVENTS
FORUM
FORUM
USERS
USERS
SYSTEM SETTINGS
SYSTEM SETTINGS
20
USER PAGE
HOME
+ NEW
GALLERY
SHOW 10 ENTRIES SEARCH
ALUMNI LIST
JOBS
EVENTS
FORUM
USERS
SYSTEM SETTINGS
21
CHAPTER 4
PROJECT DESCRIPTION
MODULES
Alumnus Details
Job
Course
Events
Gallery
Forum
User
DESCRIPTION
ADMIN SIDE
Login Page
The page where system admin will submit their system credential to access
and manage the system data.
Home Page
The page where the admin user will be redirected by default after logging into
the alumni management system admin side. This page displays the summary
or total counts of alumni, posted jobs, forum topics, and upcoming events.
22
Gallery Page
The page where the admin user will manage the gallery images and data for
the website.
Course List
The page where all the courses are listed and managed by the admin.
Alumni List
The page where the alumni list in the system are listed .
Jobs Page
The page where all posted jobs are listed and can be managed by the admin.
Events Page
The page where an admin manages or posts an upcoming event of the college
where can alumni can participate.
Forum Page
The page where all forum topics are listed along with the count of comments
if this topic is being shown.
User Page
ALUMNI SIDE
Home Page
The default page where the user will be redirected when browsing the website
and after logging in. This page shows the list of upcoming events.
Signup Page
Login
Where the user submits their system credential in order to access and manage
the other feature or functionalities of the system.
23
Gallery Page
The page where the images posted by the college management is being
shown.
About Page
Job Page
Forum Page
The page where that forum topics are listed and the user can join or read the
comments by selecting and viewing a topic.
24
CHAPTER 5
SYSTEM DEVELOPMENT
25
sends the webpage to your visitor's web browser.
PHP VARIABLE:
A variable is a means of storing a value, such as text string "hello world!" or
the integer
value 4. A variable can then be reused throughout your code, instead of having to
type out theactual value over and over again.
In PHP you define a variable with the following form:
$variable name = value;
If you forget that dollar sign at the beginning, it will not work. This is a
common mistake fornew PHP programmers.
The Apache HTTP Server, colloquially called Apache, is the world's most
widely used web server software. Originally based on the NCSA HTTP server,
development of Apache began in early 1995 after work on the NCSA code stalled.
Apache played a key role in the initial growth of the World Wide Web, quickly
overtaking NCSA HTTP as the dominant HTTP server, and has remained the most
popular HTTP server since April 1996. In 2009, it became the first web server
software to serve more than 100 million websites.
Apache is developed and maintained by an open community of developers
under the auspices of the Apache Software Foundation. Most commonly used on a
Unix-like system (usually Linux), the software is available for a wide variety of
operating systems, including Windows, OS X, Linux, Unix, FreeBSD, Solaris,
NetWare, OS/2, TPF and OpenVMS Released under the Apache License, Apache is
free and open-source software.
26
DATABASE MySQL:
A database is a separate application that stores a collection of data. Each
database has one or more distinct APIs for creating, accessing, managing, searching
and replicating the data it holds. Other kinds of data stores can be used, such as files
on the file system or large hash tables in Memory but data fetching and writing would
not be so fast and easy with those types of systems. So nowadays, we use relational
database management systems (RDBMS) to store and manage huge volume of data.
This is called relational database because all the data is stored into different tables and
relations are established using primary keys or other keys known as foreign keys.
MySQL DATABASE:
MySQL is a fast, easy-to-use RDBMS being used for many small and big
businesses. MySQL is developed, marketed, and supported by MySQL AB, which is
a Swedish company.MySQL is becoming so popular because of many good reasons:
MySQL is released under an open-source license. So you have nothing to pay to use
it.MySQL is a very powerful program in its own right. It handles a large subset of the
Functionality of the most expensive and powerful database packages.
MySQL uses a standard form of the well-known SQL data language.
MySQL works on many operating systems and with many languages
including PHP,PERL, C, C++, JAVA, etc.
MySQL is customizable. The open-source GPL license allows programmers
to modifyThe MySQL software to fit their own specific environments.
MySQL works very quickly and works well even with large data sets.
MySQL is very friendly to PHP, the most appreciated language for web development.
27
5.2 PSEUDO CODE
ALUMNI LOGIN
<div class="container-fluid">
<div class="form-group">
</div>
<div class="form-group">
</form>
</div>
<style>
</style><script>
$('#login-frm').submit(function(e){
e.preventDefault()
if($(this).find('.alert-danger').length > 0 )
28
$(this).find('.alert-danger').remove()
if(resp == 1){
$('#login-frm button[type="submit"]').removeAttr('disabled').html('Login');
}else{
$('#login-frm button[type="submit"]').removeAttr('disabled').html('Login');
})
})
</script>
ALUMNI LIST
<?php
include 'admin/db_connect.php';
?>
<style>
#portfolio .img-fluid{
width: calc(100%);
height: 30vh;
29
z-index: -1;
position: relative;
padding: 1em;
.alumni-list{
cursor: pointer;
border: unset;
flex-direction: inherit;
.alumni-img {
width: calc(30%);
max-height: 30vh;
display: flex;
align-items: center;
justify-content: center;
.alumni-list .card-body{
width: calc(70%);
.alumni-img img {
max-height: calc(100%);
30
</style>
</div>
</header>
?>
<div>
<br>
</div>
</div>
31
CHAPTER 6
SYSTEM TESTING AND VALIDATION
The testing phase involves the testing of the developed system using various
kinds of data. An elaborated testing of data is prepared and a system is tested using
the test data. While testing, errors are noted and corrections are being done. The
objective of software testing is to uncover errors. To fulfill this objective, a series of
test are conducted. They are unit, integration, validation and system. At last UAT
(User Acceptance Testing) is conducted. Unit and integration tests concentrate on
functional verification of a module and incorporation of modules into a software
structure. Validation testing demonstrates trace ability to software requirements and
system testing validates once software has been incorporate into larger system.
Unit testing involves the design of test cases that validate that the internal
program logic is functioning properly, and that program input produces valid outputs.
All decision branches and internal code flow should be validated. It is the testing of
individual software units of the application it is done after the completion of an
individual unit before integration. This is a structural testing, that relies on knowledge
of its construction and is invasive. Unit test perform basic tests at component level
and test a specific business process, application, and/or system configuration. Unit
testing ensures that each unique path of a business process performs accurately to the
documented specifications and contains clearly defined inputs and expected results.
Unit testing is usually conducted as part of a combined code and unit test phase of
thesoftware lifecycle, although is not uncommon for coding and unit testing to be
conducted as two distinct phases.
The usage of the unit testing could be seen registration form of the project
clearly. The fields are tested in many cases and conditions.
The username and password are checked. Also, the duplicate password is
given and checked.
32
If the fields are empty and invalid data typed, the browser shows an alert
message.
If an invalid id, name, email are typed, alert message is shown to the user.
In fields like contacts number, if the text is entered the browser shows alert
message. If more than 10 digits are entered in contact field an alert message is
displayed.
Integration testing is applied to this system after attaching all programs to the
appropriate links. This checks the functionality of the system by clicking the links.
TEST RESULT: All the test cases mentioned above passed successfully. No defects
encountered.
33
6.4 TEST CASES
Unit testing and integration testing are used in my project. The following lines
are used to test login page and other pages using unit and integration testing.
1. The user selects username and types password and then clicks submit button. Web
page shows the message like "Invalid password", if the password miss matched.
2. When clicking submit button, it checks whether all mandatory fields are filled or
not. If any field is missing, then web page shows alert message to the user to fill those
fields.
6.5 VALIDATIONS
Validation testing answers the question, "Are you building the right software".
Another questions, which the entire process of validation testing in software
engineering answers is,"Is the deliverable fit for purpose". In other words, does the
software system provide the right solution to the problem? Therefore, often the
testing activities are introduced early in the software development life cycle.
The compilation of the entire project is based on the full satisfaction of the end user.
In this project, validation is made in various forms. They are
34
Required Field Validator
It checks the mandatory fields. All entries or necessary fields must be filled.
It checks the range of user input. For example, mobile number should not exceed ten
digits.
35
CHAPTER 7
USER MANUAL
The default page where the user will be redirected when browsing the website
and after logging in.
36
Where the user submits their system credential in order to access and manage
the other feature or functionalities of the system.
Where the user submits their system credential in order to access and manage
the other feature or functionalities of the system.
ADMIN LOGIN
The page where system admin will submit their system credential to access
and manage the system data.
37
ADMIN HOME PAGE
The page where the admin user will be redirected by default after logging into
the alumni management system admin side. This page displays the summary
or total counts of alumni, posted jobs, forum topics, and upcoming events.
ALUMNI SIDE
ALUMNI LIST
The page where the alumni list in the system are listed .
38
GALLERY
The page where the images posted by the college management is being
shown.
JOBS LIST
39
FORUM LIST
The page where that forum topics are listed and the user can join or read the
comments by selecting and viewing a topic.
ABOUT
40
ADMIN SIDE
GALLERY
The page where the admin user will manage the gallery images and data for
the website.
COURSE LIST
The page where all the courses are listed and managed by the admin.
41
ALUMNI LIST
The page where the alumni list in the system are listed .
JOBS
The page where all posted jobs are listed and can be managed by the admin.
42
EVENTS
The page where an admin manages or posts an upcoming event of the college
where can alumni can participate.
FORUM
The page where all forum topics are listed along with the count of comments
if this topic is being shown.
43
USER
44
CHAPTER 8
CONCLUSION
Alumni portal for any college website is very important. It has been setup to
increase interaction, Knowledge sharing and networking among the alumni students and
also focuses on bringing together all alumni students of the college. And the primary
goal of this report is to connect the alumni students with the college. The existing
college students with the help of alumni web portal can easily communicate with alumni
students to get more job opportunity .Through this system all students of college can
easily be connected with the college alumni website.
45
CHAPTER 9
FUTURE ENHANCEMENT
46
CHAPTER 10
BIBLIOGRAPHY
Reference Books:
• "PHP Objects, Patterns, and Practice" by Matt Zandstra
• "PHP 8 in Practice: Advanced Tools, Techniques, and Features" by
Martin E. Psinas
• "PHP for the Web" by Larry Ullman
• "Learning PHP, MySQL & JavaScript" by Robin Nixon
• "PHP and MySQL Web Development" by Luke Welling and Laura
Thomson
• "Programming PHP" by Kevin Tatroe, Peter MacIntyre, and Rasmus
Lerdorf
Reference Articles:
• “PHP, MySQL and Apache” by julie C.Meloni, “interacting with mysql using
php” page no. 341
• “Web Enabled commercial Application Development Using… HTML,
JavaScript, DHTML and PHP” by Ivan Bayross, “working with forms” page
no.410
Reference Websites:
• www.google.com
• www.w3school.com
• www.php.net
• www.stackoverflow.com
• www.sitepointphp.com
47
48
49