SYNOPSIS

The project is entitled as “College Admission Management System“is a web

application. Traditional college admission is a hectic process, which involves students
visiting off-site campus, taking application, filling it and then submission is another hectic
story. On the day of admission, the flow of candidates is very high and it requires both
manual processing and record keeping at the same time that makes the process lengthy and
difficult to keep track of the admission status of a candidate in multiple departments. At
present admission process is done manually with pen and paper which is very inefficient and
utilizes much efforts and time. This college admission management system helps to make the
admission process much easier and helps in maintaining database in an efficient way. In this
system college admin can add the college details and the department details. College can
register admissions of new students and also remove the students who deny the admission.
The frontend is HTML, CSS and PHP as language. The backend is MySQL.
 CHAPTER I

INTRODUCTION

1.1 OVERVIEW

This application consists of two users one is admin and another one is student. Admin can
add the new admission student details in the system and admin can add the department
details. Admin also have the option to search the student based on their community wise.
Admin can add the fees details of all the course and departments. Student must login into the
system and they can see the list course available, vacancy details and fees details. Student s
has an option to apply the college for their admission and admin get the applied student’s
notification. Once student applied admin will have an option to reject or accept the
application. Admin will add the admission detail, fees detail of all the accepted application
and they can also add the joining date of the students.

1.2 OBJECTIVES OF THE PROJECT

In this system college admin can add the college details and the stream details. We can
get the previous year’s cut off marks for all the streams. College can create the cut off list for
the current year and the students are expected to register on the website and apply for the
desired stream. College can register admissions of new students and also remove the student
who denies the admission. College can make 3 list of cut off and the final list of students can
be viewed. There are 2 modules in this system namely admin (college) and user (students).
Admin can add college details and cut off list, they can select students, register and remove
students, and can also view the final list of students. Users (Students) can login and view the
college details and cut off marks list of various streams, they can also apply to the respective
college and get notification if they are selected.

 Online Admission System is aimed at developing an online admission application for a

college. This system is an online system that can be accessed throughout the organization and
outside as well with proper login provided. Our system has two type of accessing modes,
administrator and user. Student management system is managed by an administrator. It is the
job of the administrator to admit and monitor the whole process. When a user log in to the
system. He would only view details of the student. He can't perform any changes.
1.3 BACKGROUND STUDY

1.3.1 STUDY ON THE EXISTING SYSTEM

EXISTING METHOD

Today in college’s student details are entered manually. The student details in separate
records are tedious task. Referring to all these records and updating is needed. There is a
chance for more manual errors.

DISADVANTAGES

Drawbacks of the existing system are as follows

 Require much man power i.e. much efforts, much cost and hard to operate and
maintain.
 Since, all the work is done in papers so it is very hard to locate a particular
student record when it is required.

CHAPTER II
 SYSTEM ANALYSIS

2.1 STUDY ON THE PROPOSED METHOD

PROPOSED METHOD

The main goal of the system is to automate the process carried out in the organization
with improved performance and realize the vision of paperless admission. Some of the goals
of the system are listed below:

 Manage large number of student details.

 Manage all details of student who registered for the course.
 Create student accounts and maintain the data’s effectively.
 View all the details of the students.
 Reduce the work load in interview the students for selection.
 Activities like updating, modification, deletion of records should be easier.

ADVANTAGES

 One of the important objectives of the admission system is communicate with

all the students scattered geographically.
 Reduce the time taken process the applications of students, admitting a
student, conducting the online examination, verify student marks, and send
call letters to selected students.

 Transfer the data smoothly to all the departments involved and handle the data
centralized way.

 2.2 SYSTEM SPECIFICATION

2.2.1 HARDWARE SPECIFICATION

 Processor : Intel Dual Core

RAM Capacity : 2 GB

Hard Disk : 10 GB

Mouse : Logical Optical Mouse

Keyboard : 104 Keys

Monitor : 16 inch

Mother Board : Intel

Speed : 2GHZ

Floppy Disk Drive : 100 MB

2.2.2 SOFTWARE SPECIFICATION

Operating System : Windows 7

Front End : HTML, CSS

Backend : MySQL

Language : PHP

2.3 SOFTWARE ENVIRONMENT

FRONT END: HTML, CSS

HTML

Hypertext Markup Language (HTML) is the standard markup language for documents

designed to be displayed in a web browser. It can be assisted by technologies such
as Cascading Style Sheets (CSS) and scripting languages such as JavaScript.

HTML is a markup language that web browsers use to interpret and compose text,

images, and other material into visual or audible web pages. Default characteristics for every
item of HTML markup are defined in the browser, and these characteristics can be altered or
enhanced by the web page designer's additional use of CSS. Many of the text elements are
found in the ISO technical report techniques for using SGML, which in turn covers the
features of early text formatting languages such as that used by the RUNOFF
command developed in the early for the CTSS (Compatible Time-Sharing System) operating
system: these formatting commands were derived from the commands used by typesetters to
manually format documents. However, the SGML concept of generalized markup is based on
elements (nested annotated ranges with attributes) rather than merely print effects, with also
the separation of structure and markup, HTML has been progressively moved in this direction
with CSS.

Features of HTML

 It is easy to learn and easy to use.

 It is platform independent.
 Images, video and audio can be added to a web page.
 Hypertext can be added to text.
 It is a markup language.

HTML DOCUMENTS

All HTML documents must start with a document type declaration <!DOCTYPE
html>. The HTML document itself begins with <html> and ends with<html>. The visible
part of the HTML document is between <body> and </body>.
ATTRIBUTES

Most of the attributes of an element are name-value pairs, separated by  =  and written
within the start tag of an element after the element's name. The value may be enclosed in
single or double quotes, although values consisting of certain characters can be left unquoted
in HTML (but not XHTML). Leaving attribute values unquoted is considered unsafe. In
contrast with name-value pair attributes, there are some attributes that affect the element

simply by their presence in the start tag of the element, like the  ismap  attribute for

the  img  element.

CSS

Cascading Style Sheets (CSS) is a style sheet language used for describing

the presentation of a document written in a markup language such as HTML. CSS is a
cornerstone technology of the World Wide Web, alongside HTML and JavaScript.

CSS is designed to enable the separation of presentation and content,

including layout, colors, and fonts. This separation can improve content accessibility, provide
more flexibility and control in the specification of presentation characteristics, enable
multiple web pages to share formatting by specifying the relevant CSS in a separate .css file
which reduces complexity and repetition in the structural content as well as enabling the .css
file to be cached to improve the page load speed between the pages that share the file and its
formatting.

Separation of formatting and content also makes it feasible to present the same
markup page in different styles for different rendering methods, such as on-screen, in print,
by voice (via speech-based browser or screen reader), and on Braille-based tactile devices.
CSS also has rules for alternate formatting if the content is accessed on a mobile device.

Overview of New Features

 Box Shadow: One of the CSS3 new features is the box-shadow property that
adds a shadow to an element.
 Opacity: One of the CSS3 properties called opacity makes elements see-
through or completely transparent.
  Rounded Corners.
 Attribute Selectors.
 More than Web-Safe Fonts.

Using CSS

CSS can be added to HTML documents in 3 ways:

 Inline - by using the style attribute inside HTML elements

 Internal - by using a <style> element in the <head> section
 External - by using a <link> element to link to an external CSS file

The most common way to add CSS is to keep the styles in external CSS files.
However, in this tutorial we will use inline and internal styles, because this is easier to
demonstrate, and easier for you to try it yourself.

CSS Colors, Fonts and Sizes

Here, we will demonstrate some commonly used CSS properties. You will learn more
about them later. The CSS color property defines the text color to be used. The CSS font-
family property defines the font to be used. The CSS font-size property defines the text size
to be used.

PHP

PHP was originally an acronym for Personal Home Pages, but is now a recursive
acronym for PHP Hypertext Pre-processor. PHP was originally developed by the Danish
Greenlander Rasmus Lerdorf, and was subsequently developed as open source. PHP is not a
proper web standard but an open-source technology. PHP is neither real programming
language but PHP lets you use so called scripting in your documents. To describe a PHP
page, we could say that it is a file with the extension. PHP that contains a combination of
HTML tags and scripts that run on a web server.

Architecture of PHP

The best way to explain how PHP works is by comparing it with standard HTML.
Imagine you type the address of an HTML document (e.g.
http://www.mysite.com/page.htm) in the address line of the browser. This way you request
an HTML page.

The server first reads the PHP file carefully to see if there are any tasks that need to be
executed. Only when the server has done what it is supposed to do, the result is then sent to
the client. It is important to understand that the client only sees the result of the server's
work, not the actual instructions. This means that if you click "view source" on a PHP page,
you do not see the PHP codes only basic HTML tags.

Comments in PHP

A comment in PHP code is a line that is not read/executed as part of the program. Its
only purpose is to be read by someone who is editing the code.

Comments are useful for

Comments let other programmers understand what you were doing in each step.Most
programmers have experienced coming back to their own work a year or two later and having
to re-figure out what they did. Comments can remind you of what you were thinking when
you wrote the code.

Unique Features of PHP

PHP language has support features of other languages like c, Perl and etc. It also has
some unique features of it’s own. Some of them are listed below..
  In PHP there is no need to specify data type for variable declaration. Rather, it
can be determined at the time of execution depends on the value of the
variable. So that, PHP is called as loosely typed language.
 PHP provides cross platform compatibility, unlike some other server side
scripting language.
 PHP has set of pre defined variables called superglobals which will be start by.
Some of the examples are, $_GET, $_POST, $_COOKIE, $_SESSION,
$_SERVER and etc. So, any variable except superglobals, that are start with
will cause error.
 PHP programming structure includes variable variables; that is, the name of
the variable can be change dynamically.
 This language contains access monitoring capability to create logs as the
summary of recent accesses.
 And then, it includes several magic methods that begins with character which
will be defined and called at appropriate instance. For example, clone() will be
called, when the clone keyword is used.
 Predefined error reporting constants are available to generate a warning or
error notice. For example, when E_STRICT is enabled, a warning about
deprecated methods will be generated.
 PHP supports extended regular expression that leads extensive pattern
matching with remarkable speed.
 And then, properties like, nowdocs and heredocs are used to delimit some
block of context which should not be sent for parsing.
 Since PHP is a single inheritance language, the parent class methods can be
derived by only one directly inherited sub class.

Advantages of PHP
  Open source: It is developed and maintained by a large group of PHP
developers, this will helps in creating a support community, abundant
extension library.
 Speed: It is relative fast since it uses much system resource.
 Easy to use: It uses C like syntax, so for those who are familiar with C, it’s
very easy for them to pick up and it is very easy to create website scripts.
 Stable: Since it is maintained by many developers, so when bugs are found, it
can be quickly fixed.
 Powerful library support: You can easily find functional modules you need
such as PDF, Graph etc.
 Built-in database connection modules: You can connect to database easily
using PHP, since many websites are data/content driven, so we will use
database frequently, this will largely reduce the development time of web
apps.

 Can be run on many platforms, including Windows, Linux and Mac, it’s easy
for users to find hosting service providers.

BACKEND: MySQL 4.7

Database
 A database management (DBMS) is computer software designed for the purpose of
managing databases, a large set of structured data and run operations on the data requested by
numerous users. Typical examples of DBMSs include Oracle, DB2, Microsoft SQL Server,
Microsoft Access, Firebird, MySQL, FileMaker and Sybase Adaptive Server Enterprise.
DBMSs are typically used by Database administrators in the creation of Database systems.
Typical examples of DBMS use include accounting, human resources and customer support
systems.

Originally found only in large companies with the computer hardware needed to
support large data sets, DBMSs have more recently emerged as a fairly standard part of any
company back office.

Description

A DBMS is a complex set of software programs that controls the organization,

storage, management, and retrieval of data in a database. A modelling language to define the
schema of each database hosted in the DBMS, according to the DBMS data model. The four
most common types of organizations are the hierarchical, network, relational and object
models. Inverted lists and other methods are also used.

The dominant model in use today is the adhoc one embedded in sql, despite the
objections of purists who believe this model is a corruption of the relational model, since it
violates several of its fundamental principles for the sake of practicality and performance.
Many DBMSs also support the Open Database Connectivity API that supports a standard
way for programmers to access the DBMS. Data structures optimized to deal with very large
amounts of data stored on a permanent data storage device

A database query language and report writer to allow users to interactively interrogate
the database, analyze its data and update it according to the users privileges on data. It also
controls the security of the database.

Data security prevents unauthorized users from viewing or updating the database.
Using passwords, users are allowed access to the entire database or subsets of it called sub-
schemas. For example, an employee database can contain all the data about an individual
employee, but one group of users may be authorized to view only payroll data, while others
are allowed access to only work history and medical data. If the dbms provides a way to
interactively enter and update the database, as well as interrogate it, this capability allows for
managing personal databases. However, it may not leave an audit trail of actions or provide
the kinds of controls necessary in a multi-user organization. These controls are only available
when a set of application programs are customized for each data entry and updating function.

The DBMS can maintain the integrity of the database by not allowing more than one
user to update the same record at the same time, The DBMS can help prevent duplicate
records via unique index constraints; for example, no two customers with the same customer
numbers can be entered into the database. See ACID properties for more information.

The DBMS accepts requests for data from the application program and instructs the
operating system to transfer the appropriate data.

MySQL 5.6

MySQL is a database computer language designed for the retrieval and management
of data in relational database. SQL stands for Structured Query Language. In the relational
model, data is stored in structures called relations or tables. SQL, statements are issued for
the purpose of:

Data Definition:

Defining tables and structures in the database

Data Manipulation:

Used to manipulate the data within those schema objects.

List of SQL statements that can be issued against an Oracle database schema are:

 ALTER – Change an existing table, view or index definition

 AUDIT – Track the changes made to a table
  COMMENT –Create new database objects such as tables or views
 DELETE – Delete rows from a database tables
 DROP – Drop a database object such as table, view or index
 GRANT – Allow another user to access database objects such as tables or
views
 INSERT – Insert new data into a database table
 NO AUDIT – Turn off the auditing function
 REVOKE – Disallow a user access to database objects such as tables and
views
 ROLLBACK – Undo any recent changes to the database
 SELECT – Retrieve data from a database table
 TRUNCATE- Delete all rows from a database table

Configuring SSL Library Support

An SSL library is required for support of encrypted connections, entropy for random
number generation, and other encryption-related operations. Your system must support either
OpenSSL or yaSSL:

• MySQL Enterprise Edition binary distributions are compiled using OpenSSL. It is

not possible to use yaSSL with MySQL Enterprise Edition.

• MySQL Community Edition binary distributions are compiled using yaSSL.

• MySQL Community Edition source distributions can be compiled using either

OpenSSL or yaSSL.

Features

 Version 5.0 beta from March 2005, production release October 2005 (cursors, stored
procedures, triggers, views, XA transactions).
  The developer of the Federated Storage Engine states that "The Federated Storage
Engine is a proof-of-concept storage engine", but the main distributions of MySQL
version 5.0 included it and turned it on by default. Documentation of some of the
short-comings appears in "MySQL Federated Tables: The Missing Manual".
 Sun Microsystems acquired MySQL AB in 2008.
 Version 5.1: production release 27 November 2008 (event scheduler, partitioning,
plugin API, row-based replication, server log tables)
 Version 5.1 contained 20 known crashing and wrong result bugs in addition to the 35
present in version 5.0 (almost all fixed as of release 5.1.51).
 MySQL 5.1 and 6.0-alpha showed poor performance when used for data warehousing
partly due to its inability to utilize multiple CPU cores for processing a single query.
 Oracle acquired Sun Microsystems on 27 January 2010.
 The day Oracle announced the purchase of Sun, Michael "Monty" Widenius forked
MySQL, launching MariaDB, and took a swath of MySQL developers with him.
 MySQL Server 5.5 was generally available (as of December 2010). Enhancements
and features include:
• The default storage engine is InnoDB, which supports
transactions and referential integrity constraints.
• Improved InnoDB I/O subsystem
• Improved SMP support
• Semisynchronous replication.
• SIGNAL and RESIGNAL statement in compliance with the
SQL standard.
• Support for supplementary Unicode character sets utf16, utf32,
and utf8mb4.
• New options for user-defined partitioning.

High availability software

Oracle MySQL offers a high availability solution with a mix of tools including the
MySQL router and the MySQL shell. They are based on Group Replication, open source
tools. MariaDB offers a similar offer in terms of products.
Cloud deployment

MySQL can also be run on cloud computing platforms such as Microsoft

Azure, Amazon EC2, Oracle Cloud Infrastructure. Some common deployment models for
MySQL on the cloud.

Virtual machine image

In this implementation, cloud users can upload a machine image of their own with
MySQL installed, or use a ready-made machine image with an optimized installation of
MySQL on it, such as the one provided by Amazon EC2.
MySQL as a service
Some cloud platforms offer MySQL "as a service". In this configuration, application
owners do not have to install and maintain the MySQL database on their own. Instead, the
database service provider takes responsibility for installing and maintaining the database, and
application owners pay according to their usage. Notable cloud-based MySQL services are
the Amazon Relational Database Service Oracle MySQL Cloud Service, Azure Database for
MySQL, Rackspace, HP Converged Cloud, Heroku and Jelastic. In this model the database
service provider takes responsibility for maintaining the host and database.

CHAPTER III
SYSTEM DESIGN AND DEVELOPMENT
3.1 DESIGN PROCESS

3.1.1 DATA FLOW DIAGRAM

A data flow diagram is graphical tool used to describe and analyze movement of data
through a system. These are the central tool and the basis from which the other components
are developed. The transformation of data from input to output, through processed, may be
described logically and independently of physical components associated with the system.
These are known as the logical data flow diagrams.

The physical data flow diagrams show the actual implements and movement of data
between people, departments and workstations.

Larry Constantine first developed the DFD as a way of expressing system

requirements in a graphical from, this lead to the modular design. A DFD is also known as a
“bubble Chart” has the purpose of clarifying system requirements and identifying major
transformations that will become programs in system design. So it is the starting point of the
design to the lowest level of detail. A DFD consists of a series of bubbles joined by data
flows in the system.

CONSTRUCTING A DFD

Several rules of thumb are used in drawing DFD’S

 Process should be named and numbered for an easy reference. Each name should
be representative of the process.
 The direction of flow is from top to bottom and from left to right. Data
traditionally flow from source to the destination although they may flow back to
the source. One way to indicate this is to draw long flow line back to a source.
An alternative way is to repeat the source symbol as a destination. Since it is used
more than once in the DFD, it is marked with a short diagonal.

Process

Source or Destination of data

Data Flow
 Data Table

Database

CONTEXT DIAGRAM

LEVEL 0

Request for username

Online Admission
And password Management System - Request Send
Admin/ User Interface
Student Database

Retrieve Response
LEVEL 1

Username, Password Request

Admin Login Login
Module Table

Retrieve Response

Login Management Authenticated data

Dept name, Department

vacancy
Department profile Table

Fees details

Student name,Student
reg no,
Student Student details Table
dept Module

Year, percentage etc,.

Admin table carries student data for online admission

View Course and fee Admin

Company details
details Table

Student details
View Admission
details
 Details of joining

3.2 TABLE STRUCTURE

LOGIN TABLE

S. NO. FIELD NAME DATA TYPE SIZE CONSTRAINT

Primary Key,
1 Username CharField 10
Not null
2 Password CharField 40 Not null

STUDENT REGISTER TABLE

S. NO. FIELD NAME DATA TYPE SIZE CONSTRAINT

1 Student name CharField 30 Primary Key

2 Email MailField 30 Not Null

3 Username CharField 30 Not Null

4 Password CharField 30 Not Null

5 DOB Date - Not Null

6 Phone number Int 10 Not Null

7 Gender CharField 50 Not Null

8 City CharField 30 Not Null

 9 Address CharField 100 Not Null

ADMISSION TABLE

S. NO. FIELD NAME DATA TYPE SIZE CONSTRAINT

1 Student name CharField 30 Primary Key

Foreign Key
2 Student Register Number Int 30
Not Null

3 Student image - - Not Null

4 Father name CharField 30 Not Null

5 Mother name CharField 30 Not Null

6 Age Int 10 Not Null

7 DOB Date - Not Null

8 Course name CharField 50 Not Null

9 Department CharField 100 Not Null

10 Semester fee Int 100 Not Null

11 Academic year Date - Not Null

12 Community CharField 50 Not Null

13 Emergency number int 10 Not Null

 14 Address CharField 1000 Not Null

COURSE TABLE

S. NO. FIELD NAME DATA TYPE SIZE CONSTRAINT

1 College name CharField 30 Primary Key

2 College image - 1000 Not Null

Foreign Key
3 Course Name CharField 30
Not Null

4 Department CharField 100 Not Null

5 Fees int - Not Null

6 Number of vacancy CharField 60 Not Null

3.3FILE DESIGN

The file design is one of the important features which mainly depend on the
performance of the system. The file design deals with the two important elements. They are
the size of the files and the redundancy of the data. At the same time all the files are design to
incorporate all relevant information regarding each module. A single database with
information about all the modules will make the system complex. The design base files are
the most important of the system. The performance of the system depends on how the system
is designed. It has been given at most attention to reduce the size of files and redundancy. At
the same time all the files are design to incorporate all relevant information regarding each
entity. A single database with information about all the entities will make the system more
complicated.

Home

It is used to set an index page.

Dashboard

It is used to set a template in the web page

Admin File

It includes Department name, course, vacancies, fees details, college address, contact
number, college name and address.

Student Admission File

It includes student name, DOB, Cut-off marks, percentage, father and mother name,
image of student, academic year, department, age, community, emergency contact, course
details and address.

Course File

It includes college name, college image, course name, department, fees, number of
vacancies.

3.4INPUT DESIGN

Input is any data or instructions entered into the memory of a computer. Two
types of input are data and instructions. Data is a collection of unorganized items that can
include words, numbers, pictures, sounds, and video. A computer processes data into
information, which is organized, meaningful, and useful. Instructions can be in the form of
programs, commands, or user responses. A program is a series of instructions that tells a
computer how to perform the tasks necessary to process data into information. A command is
an instruction given to a computer program.

Admin _details
 It includes Department name, course, vacancies, fees details, college address, contact
number, college name and address.

Student Admission _details

It includes student name, DOB, Cut-off marks, percentage, father and mother name,
image of student, academic year, department, age, community, emergency contact, course
details and address.

Course _details

It includes college name, college image, course name, department, fees, number of
vacancies.

3.5OUTPUT DESIGN

Output design will be done through reports in the system. The system’s output will be
generated either through reports or through system prompted messages. The system will be
designed in such a way that output forms will be designed for displaying outputs to the user.
Output will be generally displayed to the user through monitor as visual display. Output can
also be an attached email or bill from the printer. Some of the outputs can be audio which
will be delivered by the system. In the web based auction project, outputs are designed in
such a way that, it will be displayed to the user through monitor. Some of the major outputs
which will be designed in the project are as follows:

View_Admin _details

It includes Department name, course, vacancies, fees details, college address, contact
number, college name and address.

View_Student Admission _details

It includes student name, DOB, Cut-off marks, percentage, father and mother name,
image of student, academic year, department, age, community, emergency contact, course
details and address.

View_Course _details
 It includes college name, college image, course name, department, fees and number of
vacancies.

3.6DATABASE DESIGN

A database is a collection of interrelated data stored with minimum redundancy to

serve many users quickly and effectively. After designing the input and output, the analyst
must concentrate on database design or how data should be organized around user
requirements. The general objective is to make information access, easy, quick, inexpensive
and flexible for other users. Database is designed in such a way that it is used for efficiently
storing and maintaining the bidding and users details, hence to provide proper service and to
maintain auctions effectively.

Admin _details_table

It includes Department name, course, vacancies, fees details, college address, contact
number, college name and address.

Student Admission _details_table

It includes student name, DOB, Cut-off marks, percentage, father and mother name,
image of student, academic year, department, age, community, emergency contact, course
details and address.

Course _details_table

It includes college name, college image, course name, department, fees, number of
vacancies.
3.7SYSTEM DEVELOPMENT

3.7.1 DESCRIPTION OF MODULES

Proposed project has various modules. They are as follows:

 Admin
• Add Course and Department Details
• Add Department wise Vacancy and Fees Detail
• Applied Notification
• Accept or Reject Application
• Search Application based on Community
• Add Admission Student Detail
• Announce Joining Date
 Student
• Register/Login
• View Course and Fee Details
• Apply to the College
• Get Selected Notification
• View Admission Detail
• Get Joining Date

Admin

Add Course and Department Details

 In this module admin will add what are the courses college having and also they will
add the department details according to the courses. So that student can easily know the
details about courses and corresponding departments.

Add Department wise Vacancy and Fees Detail

In this module admin will add the department wise vacancy details for example BE
(Computer Science) department having 10 seats like admin will add the vacancy and
semester wise fees details for those particular seats.

Applied Notification

Admin will receive the dashboard notification like who are all the students applied for
the courses and what is their cut off mark, mark details and their certificates.

Accept or Reject Application

Once the students applied the admin have an option to accept or reject their
application based on their mark and certificate details.

Search Application based on Community

Admin have an option to filter the applied students list based on their community so
that admin can easily check whether this community have a scholarship or not.

Add Admission Student Detail

Admin will generate the admission form detail for all accepted students. This form
will contain their name, email id, marks, certificate to be submitted details, department,
course, fees etc.,

Announce Joining Date

Once the students joined after filling the admission form and paid the semester fee,
the admin will announce when the student will come and join to the college.

Student

Register/Login
 Students those who are looking to join the college first of all they need to fill register
form of this application, it will contain name, email id, mobile number, username, password,
mark, certificates etc., once they register using this details they need to waiting for admin
approval once admin will approved they can login into the application using username and
password.

View Course and Fee Details

Once the students login into the system they can view what are the courses and
department available in particular college and how much fees have to pay the semester and
all.

Apply to the College

Once the student viewed all course details they can apply to the particular course
using this application by submitted their mark, certificate etc.,

Get Selected Notification

Once they submitted the application the student need to wait for the admin approval.
Admin will check their mark and certificate once all details checked admin will approve the
application and student will get the notification on their dashboard.

View Admission Detail

After the students application selected the student get the admission form details like
whether they paid the admission fee or not , which department they joined etc.,
 CHAPTER IV

TESTING AND IMPLEMENTATION

The common view of testing held by users is that it is performed to prove that there
are no errors in a program. This is extremely difficult since designer cannot prove to be one
hundred percent accurate. Therefore, the most useful and practical approach is with the
understanding that testing is the process of executing a program with explicit intention of
finding errors.

Testing has its own cycle. The testing process begins with the product requirements
phase and from there parallels the entire development process. In other words, for each phase
of the development process there is an important testing activity. Successful testing requires a
methodical approach. It requires focusing on basic critical factors:

 Planning
 Project and process control
 Risk management
 Inspections
 Measurement tools
 Country and professionalism

TEST PLAN

Before going for testing, first we have to decide upon the type of testing to be
carried out. The following factors are taken into consideration:

 To ensure that information properly flows into and out of program

  To find out whether the local data structures maintains its integrity during all steps
in an algorithm execution
 To ensure that the module operate properly at boundaries established to limit or
restrict processing
 To find out whether error - handling paths are working correctly or not
 To find out whether the values are correctly updated or not
 Check for validations

4.1 UNIT TESTING

Unit or module testing is the process of testing the individual components

(subprograms or procedures) of a program. The purpose is to discover discrepancies between
the modules interface specification and its actual behavior. In our system each module
namely is tested independently for validation.

Login Module

If entered login details matches with the database, then admin home page should be
displayed, else message box should be displayed. This condition is being tested in admin
Login Module.

4.2 VALIDATION TESTING

Validation testing provides the final assurance that software meets all functional,
behavioural and performance requirement. The software once validated must be combined
with other system elements. System testing verifies that as elements combine properly and
that overall system function and performance is achieved. Every form in the system is
validated and tested for validation by giving different test cases.

4.3 INTEGRATION TESTING

Integration testing is the process of combining and testing multiple components

together. The primary objective of integration testing is to discover errors in the interfaces
between the components. In our system each of the modules mentioned above, are tested for
checking the integration between them, after each of them are tested individually.Mostly test
data is used for testing. When modules are executed, backend SQLite is online database is
simultaneously verified whether updating of records is made in the database and for avoiding
duplicate records.

4.4 USER ACCEPTANCE TESTING

User Acceptance Testing (UAT) is one of the last stages of the software development
life cycle. It is sometimes known as End User Testing.

Description: As the name suggests, UAT is conducted on a product by the

end users of the product for approval for production release.

The main Purpose of UAT is to validate end to end business flow. It does not focus on
cosmetic errors, spelling mistakes or system testing. User Acceptance Testing is carried out
in a separate testing environment with production-like data setup. It is kind of black box
testing where two or more end-users will be involved.
4.4TEST CASES

LOGIN TABLE

TEST DESCRIPTIO ACTUAL EXPECTED

TEST ID RESULT
DATA N VALUE VALUE
Enter the Enter the
values in values in
To test the field
TC-01 Username character character True
username
number and number and
symbols. symbols.
Enter the
values in
To test the field No values
TC-02 Username character False
username entered
number and
symbols.
Enter the Enter the
values in values in
To test the field
TC-03 Password character character True
password
number and number and
symbols. symbols.
Enter the
values in
To test the field No values
TC-04 Password character False
password entered
number and
symbols.
To test the Login
TC-05 Login(button) Click enter Click enter True
button
ADMISSION TABLE

TEST TEST ACTUAL EXPECTED

DESCRIPTION RESULT
ID DATA VALUE VALUE
To test the field
TC-01 Register no Enter Numbers Enter Numbers True
Register no
To test the field
TC-02 Register no Enter Characters Enter Numbers False
Register no
Father To test the field Enter only Enter only
TC-03 True
Name Father Name Characters Characters
Father To test the field Enter only
TC-04 Enter Numbers False
Name Father Name Characters
Mother To test the field Enter only Enter only
TC-05 True
Name Mother Name Characters Characters
Mother To test the field Enter only
TC-06 Enter Numbers False
Name Mother Name Characters
To test the field
TC-07 DOB Enter Date Enter Date True
DOB
Enter characters,
To test the field
TC-08 DOB Numbers, without Enter Date False
DOB
@.com

To test the field

TC-09 Age Enter Number Enter number True
Age

To test the field

TC-10 Age No values entered Enter number False
Age

Course To test the field Enter the values in Enter the values in
TC-11 True
name Course name character. character.
 Course To test the field Enter the values in
TC-12 No values entered False
name Course name character.

Semester To test the field Enter only Enter only

TC-13 True
fee Semester fee Numbers Numbers
Semester To test the field Enter only
TC-14 Enter characters False
fee Semester fee Numbers
To test the
TC-15 Department Enter characters Enter characters True
Department
To test the
TC-16 Department Enter numbers Enter characters False
Department
Academic To test the field
TC-17 Enter numbers Enter numbers True
year Academic year
Academic To test the field
TC-18 Enter character Enter numbers False
year Academic year

To test the
TC-19 Community Enter Character Enter Character True
Community

To test the
TC-20 Community Enter number Enter Character False
Community

To test the
Emergency
TC-21 Emergency Enter number Enter number True
Number
Number
To test the
Emergency
TC-22 Emergency Enter characters Enter number False
Number
Number
Enter all the fields Enter all the fields
Register To test the
TC-23 correctly and correctly and Click True
Button Register button
Click enter enter
Enter all the fields
Register To test the Address field is
TC-24 correctly and Click False
Button Register button empty
enter
4.5 SYSTEM IMPLEMENTATION

System implementation is the important stage of project when the theoretical design is
tunes into practical system. The main stages in the implementation are as follows:

 Planning
 Training
 System testing and
 Changeover planning

Planning is the first task in the system implementation. Planning is deciding on the
method and the time scale to be adapted. At the time of implementation of any system people
from different departments and system analysis involve. They are confirmed to practical
problem of controlling various activities of people outside their own data processing
departments. The line manager controlled through an implementation co-ordinate committee.
The committee consists of ideas, Problems and complaints of user department. It must also
consider,

 The implementation of system environment.

 Self selection and allocation for implementation tasks.
 Consultation with unions and resources available.
 Standby facilities and channels of communication.

SYSTEM TESTING

Functions PHP file

The functions.php file defines the Db Functions class. The Db Functions class defines
methods for database operations which are called from the based on the value of the tag
parameter in the HTTP request. The figure below shows the class diagram for the class.
PHP Classes/Files

Three PHP files were created to handle the logical and data management operations.
The main PHP file is the index.php file which handles the HTTP requests from the
application. The other files are the functions.php file, which contains the declaration of the
functions used in the index.php file, and the connect.php file which contains the login details
for authorized access to the database. These files were stored in my student account on the
cc.puv.fi server.

Connect PHP file

The connect.php file contains the administrative configuration of the MySQL

database required to do operations on it. Due to the administrative rights granted by this file,
the user application may make changes to the content of the database.

SERVER-SIDE DESIGN AND IMPLEMENTATION

This chapter deals with data retrieval and storage from the database, initiated by
HTTP request from the client-side application. PHP is used to handle the request from the
application and performs appropriate tasks on the MYSQL database. It also informs the
application of success or failure of the application.

Development Overview

The PHP development was done in the Notepad++ software, which is a free and open
Windows multi-language editor. It provides colored support for native functions, as well as
code indentation. It displays the edited files in tabs for ease of accessing and editing multiple
files simultaneously.

The server database was managed by a free PHP-based GUI tool named php My
Admin which was readily available on the server.
 CHAPTER V

CONCLUSION

The increasing numbers of students seeking admission in the academic institutes

(School, Colleges, and Universities) are causing tremendous pressure on the administrative
body of the institutes to manage and arrange the admission process manually. It is difficult
now to conduct the process accurately and in a timely manner. Hence, the need for online
admission is inevitable.

The goal of the 'Online Admission System' is to automate the academic institute’s
admission structure and its related operation and functionality. The objective of the initiative
is to provide support to the administration and admission seeking candidates by providing a
faster, transparent, and easy way of keeping records and use them for reference and further
proceedings.

CHAPTER VI

SCOPE FOR FURTHER ENHANCEMENT

 The actual user of the system is very much pleased by its efficient performance and
the user of the package have extremely reduces duplication of words. Since the requirements
may increase in future, the system can be easily modified accordingly, as the system has been
modularized.

The online admission management system is fully configurable. The system has the
ability to calculate based on the reservation of seats as per Government of India norms. The
ERP software has the ability to set up criteria (home student/outside students, etc.) and
calculate registration fees on its basis. Safe & secure online fee payment & collection
provision

BIBLIOGRAPHY

REFERENCE BOOKS

[1] Boyer, J. M. (2008). Interactive Office Documents A New Face for Web 2.0 Applications,
Proceedings of the 2008 ACM Symposium on Document Engineering.

[2] Relaxing the homogeneity assumption in usability testing. Behaviour & Information
Technology, 20 1–7.

[3] Caulton, D. A. (2001Cavana, R., Delahaye, B., & Sekaran, U. (2001). Applied Business
Research Qualitative and Quantitative Methods, John Wiley & Sons, Milton, Queens land.

[4] An Online Evolutionary Approach to Developing Internet Services, HOTOS'03

Proceedings of the 9th conference on Topics in Operating Systems. M.C & Boyle R. D.,
(2003).

REFERENCE WEBSITES

 www.codeproject.com
 www.w3schools.com
 www.learnprogramming.com
 ANNEXURES

A.SAMPLE INPUT

B.SAMPLE OUTPUT

C.SAMPLE CODING

SAMPLE INPUT
Student Register Page

Login Page
Add Course

Admission Form
OUTPUT DESIGN

Course detail

Update Course
Apply Course
Approve Student

Admission Detail
Publish Joining Date
Sample Coding

Register.php

<?php

ob_start();

include("config.php");

include('header.php');

$msg="";

if(isset($_POST['submit']))

$sel="select * from user where username='".$_POST['username']."'";

$re=mysqli_query($con,$sel);

$fe=mysqli_fetch_array($re);

if($fe)

$msg="Username Already Exit";

else

$sql="insert into
user(student_name,username,email,password,address,phone,dob,gender,city,mark1,mark2,cu
toffmark)

values('".$_POST['s_name']."','".$_POST['username']."','".$_POST['email']."','".
$_POST['password']."','".$_POST['address']."',

'".$_POST['phone']."','".$_POST['dob']."','".$_POST['gender']."','".$_POST['city']."','".
$_POST['mark1']."','".$_POST['mark2']."','".$_POST['cutoffmark']."')";

$res=mysqli_query($con,$sql) or die(mysqli_error($con));

if($res)

$msg="Registered Successfully";
 }

ob_end_flush();

?>

<div class="modal-content news-w3l">

<div class="modal-header">

<h4 style="margin-top:60px;">STUDENT REGISTER HERE</h4>

<div class="login-main wthree">

<div class="msg"><?php echo $msg;?></div>

<form action="" method="post">

<input type="text" placeholder="Student Name"

name="s_name" required>

<input type="email" placeholder="Email" name="email"

required>

<input type="text" placeholder="Username"

name="username" required>

<input type="password" placeholder="Password"

name="password" required>

<label>DOB</label><br>

<input type="date" placeholder="Date of birth" name="dob"

required style="width:100%;border:2px solid black;">

<input type="text" name="phone" placeholder="Phone No">

<label>Gender</label><br>
 <input type="radio" name="gender" value="Male">Male
&nbsp;&nbsp;

<input type="radio"
name="gender"value="female">Female<br>

<input type="text" placeholder="Enter 10th Mark"

name="mark1" required>

<input type="text" placeholder="Enter 12th Mark"

name="mark2" required>

<input type="text" placeholder="Enter Cut off Mark"

name="cutoffmark" required>

<input type="text" name="city" placeholder="City">

<textarea name="address" placeholder="Address" rows="5"

cols="70" style="width:100%;border:2px solid black;margin-top:10px;"></textarea>

<input type="submit" value="REGISTER" name="submit">

</form>

</div>

</div>

</div>

<?php include('footer.php');?>

Login.php

<?php

ob_start();

include("config.php");

include('header.php');

$msg="";

if(isset($_POST['signup']))

{
 $check = "SELECT * FROM user where username='".$_POST['name']."' AND
password='".$_POST['password']."'";

$login = mysqli_query($con,$check) or die(mysql_error());

$res = mysqli_fetch_array($login);

if($res)

$_SESSION['username']=$_POST['name'];

$_SESSION['userid']=$res['id'];

header("Location:dashboard.php");

else

$msg="<script>alert('Invalid Username or Password');</script>";

ob_end_flush();

?>

<!-- Modal content-->

<div class="modal-content news-w3l container"

style="padding-top:100px;padding-bottom:50px;">

<div class="modal-header"
style="width:70%;margin:0 auto;">

<h4>Login Your Account</h4>

 <!--newsletter-->

<div class="login-main wthree">

<form action="" method="post">

<input type="text"
placeholder="Name" required="" name="name">

<input type="password"
placeholder="Password" name="password">

<input type="submit"
value="Login" name="signup">

</form>

</div>

<!--//newsletter-->

</div>

</div>

<?php include('footer.php');?>

Add_course.php

<?php

include("../config.php");

$msg="";

if(isset($_POST['submit']))

$allowedExts = array("jpg", "jpeg", "png","gif");

$temp = explode(".", $_FILES['image']['name']);

 $extension = end($temp);

if (in_array($extension, $allowedExts))

$name = rand(10000,99999)."_".$_FILES["image"]["name"];

move_uploaded_file($_FILES["image"]["tmp_name"], "images/".$name);

if(!$name)

$error="Invalid file type";

$sql="insert into course(course,dept,fee,vacancy,date,college_name,image)

values('".$_POST['course']."','".$_POST['dept']."','".$_POST['fee']."','".
$_POST['vacancy']."',curdate(),'".$_POST['college_name']."','".$name."')";

$res=mysqli_query($con,$sql) or die(mysqli_error($con));

if($res)

$msg="Course Detail Added Successfully";

include("../header.php");

?>

<div class="modal-content news-w3l">

<div class="modal-header">

<h4 style="margin-top:60px;">ADD Course Detail</h4>

 <div class="login-main wthree">

<div class="msg"><?php echo $msg;?></div>

<form action="" method="post" enctype="multipart/form-data">

<input type="text" placeholder="College Name"

name="college_name" required>

<label>College Image</label>

<input type="file" name="image" required>

<input type="text" placeholder="Course Name"

name="course" required>

<input type="text" placeholder="Department" name="dept"

required>

<input type="text" placeholder="Fees" name="fee" required>

<input type="text" placeholder="No of Vacancy"

name="vacancy" required >

<input type="submit" value="ADD COURSE"

name="submit">

</form>

</div>

</div>

</div>

<?php

include("../footer.php");

?>

Applied_student.php

<?php

include("../config.php");

$msg="";
if(isset($_POST['submit']))

$allowedExts = array("jpg", "jpeg", "png","gif");

$temp = explode(".", $_FILES['image']['name']);

$extension = end($temp);

if (in_array($extension, $allowedExts))

$name = rand(10000,99999)."_".$_FILES["image"]["name"];

move_uploaded_file($_FILES["image"]["tmp_name"], "images/".$name);

if(!$name)

$error="Invalid file type";

$sql="insert into course(course,dept,fee,vacancy,date,college_name,image)

values('".$_POST['course']."','".$_POST['dept']."','".$_POST['fee']."','".
$_POST['vacancy']."',curdate(),'".$_POST['college_name']."','".$name."')";

$res=mysqli_query($con,$sql) or die(mysqli_error($con));

if($res)

$msg="Course Detail Added Successfully";

include("../header.php");

?>
<div class="modal-content news-w3l">

<div class="modal-header">

<h4 style="margin-top:60px;">ADD Course Detail</h4>

<div class="login-main wthree">

<div class="msg"><?php echo $msg;?></div>

<form action="" method="post" enctype="multipart/form-data">

<input type="text" placeholder="College Name"

name="college_name" required>

<label>College Image</label>

<input type="file" name="image" required>

<input type="text" placeholder="Course Name"

name="course" required>

<input type="text" placeholder="Department" name="dept"

required>

<input type="text" placeholder="Fees" name="fee" required>

<input type="text" placeholder="No of Vacancy"

name="vacancy" required >

<input type="submit" value="ADD COURSE"

name="submit">

</form>

</div>

</div>

</div>

<?php

include("../footer.php");

?>
View_course.php

<?php

include("config.php");

include("header.php");

?>

<div class="modal-content news-w3l">

<div class="modal-header">

<h4 style="margin-top:70px;margin-bottom:40px;">ALL COURSE

DETAILS</h4>

<div class="container">

<div class="row">

<?php

$check = "SELECT * FROM course";

$login = mysqli_query($con,$check) or
die(mysqli_error($con));

while($res = mysqli_fetch_array($login))

?>

<div class="col-md-4">

<h3>College Name: <?php echo $res['college_name'];?></h3>

<img src="admin/images/<?php echo $res['image'];?>">

<h4>Course: <?php echo $res['college_name'];?></h4>

<h4>Dept: <?php echo $res['dept'];?></h4>

<h4 style="color:green;">Fees: <?php echo $res['fee'];?> Rs</h4>

<h4>No of Vacancy</h4>

<center><p style="font-weight:bold;font-size:15px;"><?php echo

$res['vacancy'];?></p>

<a href="apply.php?id=<?php echo $res['id'];?>" class="btn btn-

info">Apply Now</a></center>
 </div>

<?php } ?>

</div>

</div>

</div>

</div>

<?php

include("footer.php");

?>

Add_admission.php

<?php

include("../config.php");

$msg="";

if(isset($_POST['submit']))

$sel="select * from admission where rno='".$_POST['rno']."'";

$re=mysqli_query($con,$sel);

$fe=mysqli_fetch_array($re);

if($fe)

$msg="Student Register No Already Exit";

else

$allowedExts = array("jpg", "jpeg", "png","gif");

$temp = explode(".", $_FILES['image']['name']);

 $extension = end($temp);

if (in_array($extension, $allowedExts))

$name = rand(10000,99999)."_".$_FILES["image"]["name"];

move_uploaded_file($_FILES["image"]["tmp_name"], "images/".$name);

if(!$name)

$error="Invalid file type";

$sql="insert into
admission(rno,name,image,fname,mname,age,dob,course,dept,fee,year,community,enum,pad
dr,preaddr,marks,date,student_ids,payment)

values('".$_POST['rno']."','".$_POST['name']."','".$name."','".$_POST['fname']."','".
$_POST['mname']."','".$_POST['age']."',

'".$_POST['dob']."','".$_POST['course']."','".$_POST['dept']."','".$_POST['fee']."','".
$_POST['year']."','".$_POST['community']."',

'".$_POST['enum']."','".$_POST['paddr']."','".$_POST['preaddr']."','".
$_POST['marks']."',curdate(),'".$_POST['stud_id']."','Pending')";

$res=mysqli_query($con,$sql) or die(mysqli_error($con));

if($res)

$msg="Admission Detail Added Successfully.";

?>

<?php
include("../header.php");

?>

Joining_date.php

<?php

include("config.php");

include("header.php");

if(isset($_SESSION['userid'])) {

?>

<br>

<br>

<br>

<br><br>

<br><br>

<br>

<?php $check = "SELECT * FROM admission where student_ids='".

$_SESSION['userid']."'";

$login = mysqli_query($con,$check) or die(mysqli_error($con));

$res = mysqli_fetch_array($login);

?>

<div class="container">

<?php if($res['joining_date'] != '' ) { ?>

<h1 style="color:#000;font-weight:bold;margin-bottom:20px;text-align:center;">JOINING
DATE <?php

echo strtoupper($res['joining_date']);?></h1><?php } ?>

<marquee><h1 style="color:#6a67ce;font-weight:bold;margin-bottom:200px;">WELCOME
<?php

echo strtoupper($_SESSION['username']);?></h1></marquee>
</div>

<?php

else

header("location:index.php");

include("footer.php");

?>