Srms Project Report 2

Download as pdf or txt
Download as pdf or txt
You are on page 1of 112

STUDENT RESULT MANAGEMENT SYSTEM

BCA506P
Title of the Project

Student Result Management System

By
Indushree M S

Enrollment No:
R2015815

Bengaluru North University


Sri Devaraj Urs Extension
Tamaka, Kolar-563 103
Karnataka, India

DEPT OF BCA, HKBKDC Page 1


STUDENT RESULT MANAGEMENT SYSTEM

HKBK DEGREE COLLEGE


Permanently Affiliated to Bangalore North University
#22/1, Opp Manyata Tech Park, Govindpura,
Nagawara, Bengaluru-560045

A Project Report
On
“Student Result Management System”
Submitted to the Bengaluru North University, Kolar
in partial fulfillment of the requirements
for the award of the degree
Bachelor of Computer Applications
year of Submission
2023

Submitted by
Indushree M S

Under the Guidance of


Dr. Safira Begum
Assistant Professor, Department of Computer Application
2020-2023

DEPT OF BCA, HKBKDC Page 2


STUDENT RESULT MANAGEMENT SYSTEM

HKBK DEGREE COLLEGE


Permanently Affiliated to Bangalore North University
#22/1, Opp Manyata Tech Park, Govindpura,
Nagawara, Bengaluru-560045

Certificate of Completion
This is to certify that the project work entitled on Student Result Management
System is a bonafide work carried out by Mr./Miss./Mrs. Indushree M S bearing
Reg.No. R2015815 in partial fulfillment for the award of Bachelor of Computer
Applications of Bangalore North University, during the year 2022-2023. The
project report has been approved as it satisfies the academic requirements in respect
of Project Work prescribed for the said Degree.

Signature of the Guide Signature of the HOD Signature of the Principal

Name of the Examiners Signature with Date

DEPT OF BCA, HKBKDC Page 3


STUDENT RESULT MANAGEMENT SYSTEM

DECLARATION
I Indushree MS, bearing University Register number R2015815, student of 6th semester BCA,
HKBK Degree College, Bangalore, hereby declare that the project work entitled Student Result
Management System submitted to the Bangalore North University during the academic year 2022-
2023, is a record of an original work done by me under the guidance of Dr.Safira Begum,
Department of Computer Applications, HKBK Degree College, Bangalore.

This project work is submitted in partial fulfillment of the requirements for the award of the degree
of Bachelor of Computer Application’s. The matter embodied in this project is genuine work done
by me and has not been submitted whether to this University or to any other University / Institute
for the fulfillment of the requirements of any course of study.

Date: Indushree MS.


Place: Bengaluru R2015815

DEPT OF BCA, HKBKDC Page 4


STUDENT RESULT MANAGEMENT SYSTEM

ACKNOWLEDGEMENT
I take this opportunity to express my deep gratitude to our Founder chairman Mr. C M Ibrahim
Sahib

We take this opportunity to express our sincere thanks and wholehearted gratitude to our beloved
Principal Dr. Ashok MV

We also thank this opportunity to express our gratitude to our respected HOD, Prof. Nasrulla
Khan K for his constant cooperation for developing this project.

The satisfaction and successful completion of any task would be incomplete without the mention
of people whose ceaseless cooperation made it possible, whose constant guidance and
encouragement crown all efforts with success.

I am grateful to my project guide Dr. Safira Begum for the guidance, inspiration and constructive
suggestions that helped me in the preparation of this project.

I would also like to extend our thanks to all the concerned staff members of department of
Computer science for their kind cooperation.

I would like to thank our parents and our friends for their encouragement in completing our project
in a successful manner.

DEPT OF BCA, HKBKDC Page 5


STUDENT RESULT MANAGEMENT SYSTEM

INDEX

SL.NO TABLE OF CONTENTS PAGE NO

1. INTRODUCTION 1-4

1.1 STUDENT RESULT MANAGEMENT SYSTEM 1

1.2 OBJECTIVES 1-2

1.3 ADVANTAGES 2

1.4 GOAL 3

1.6 MODULES 3-4

2. EXISTING SYSTEM 5-6

3. NEED FOR NEW SYSTEM 7-8

4. REQUIREMENT ANALYSIS 9-11

4.1 INTRODUCTION 9

4.2 FUNCTIONAL REQUIREMENTS 9-10

4.3 NON FUNCTIONAL REQUIREMENTS 10-11

5. SYSTEM ANALYSIS 12-13

5.1 FEASIBILITY STUDY 12

5.2 OPERATIONAL FEASIBILITY `12

DEPT OF BCA, HKBKDC Page 6


STUDENT RESULT MANAGEMENT SYSTEM

5.3 TECHNICAL FEASIBILITY 12-13

5.4 ECONOMIC FEASIBILITY 13

6. SYSTEM REQUIREMENTS 14-15

6.1 HARDWARE REQUIREMENTS 14

6.2 SOFTWARE REQUIREMENTS 15

7. OVERVIEW OF TECHNOLOGY 16-19

7.1 INTRODUCTION TO XAMPP 16

7.2 HTML (Hyper Text Markup Language) 17

7.3 CSS (Cascading Style Sheet) 18

7.4 JAVASCRIPT 18-19

7.5 PHP (Hypertext Pre-Processor) 19

7.6 MySQL 19

7.7 BOOTSTRAP 21

8. SYSTEM MODELS 21-35

8.1 DATA FLOW DIAGRAM 21-27

8.2 USE CASE DIAGRAM 27-30

8.3 ER DIAGRAM 30-32

DEPT OF BCA, HKBKDC Page 7


STUDENT RESULT MANAGEMENT SYSTEM

8.4 CLASS DIAGRAM 33

8.5 TABLE STRUCTURE 34-35

9. CODING 36-59

10. SNAPSHOTS 60-66

11. SYSTEM TESTING 67-70

11.1 TESTING 67-68

11.2 BLACK BOX TESTING 68-69

11.3 WHITE BOX TESTING 69-70

12. CONCLUSION & FUTURE SCOPE 71

13. BIBLIOGRAPHY 72

DEPT OF BCA, HKBKDC Page 8


STUDENT RESULT MANAGEMENT SYSTEM

1. INTRODUCTION

1.1 STUDENT RESULT MANAGEMENT SYSTEM

The Student Result Management System is a web-based application designed to automate the
administration of semester results by tracking students grades. The system is intended to
replace manual work and optimize the result preparation preocess, providing an easy-to-
understand explaination of exam for both administrators and students. The concept to generate
the student result records and to add their records and update it. Here user can add Students
details safely and it's not time consuming and this system makes easy to store records of each
and every Student. It covers the full details of the students studies and includes the student's
register number, marks, subjects and rating.
Student Result declaration and Management are amongst the most important activities within
university or any educational instituions,since all other activities depend on it. Hence
implementing an information system can be declared a significance result.

1.2 OBJECTIVES

The main objective of the Student Result Management System is to manage the
details of Result, Progress, Student, Course and Exam.
• Objective of the Student Result Management System is to prepare command line
interface(CLI) software at college level to get the consolidated results/progress of the
students to facilitate the ease of administration in the college.
• The software is intended to allow the user to interact with the computer by entering the
roll number of the student and the computer displays the consolidated result of the
student.
• The system is intended for the students and the privileges that provided to students are
to execute his /her results by providing username and password for secure login and in
case of new student the registration is available.

DEPT OF BCA, HKBKDC Page 9


STUDENT RESULT MANAGEMENT SYSTEM

1.3 ADVANTAGES
• With student result management system teachers can create result analysis reports.
• Increases the efficiency of the teachers and records marks and result on a single database.
• The students view results of tests and exams online and can search test and exam scores with
valid roll number/ID.
• The students download report of results in PDF format and View semester results for all
subjects from anywhere using smart devices.

1.4 GOAL

The student result management system (SRMS) is primarily focuses on delivering results to
students and instructors. It is easy for students to retrieve their results through the college
website.
and to manage all the information about result, activity, exam. The project is totally built at
administrative end and thus only the administrator is guaranteed the access.

1.5 MODULES

Student Result Management System project has two modules i.e. Admin and Student.

 Admin Module
1. Admin dashboard.
2. Admin can add /update/Class and Subjects.
3. Admin can add/update/Activate/Inactive Subject combination with class.
4. Admin can register new student and also edit info of the student.
5. Admin can declare/edit result of a student.
6. Admin can add/delete the notice and also change own password
In this project user is those who have a locker in the bank. With the help of a locker,
the number users can see the details of lockers.

DEPT OF BCA, HKBKDC Page 10


STUDENT RESULT MANAGEMENT SYSTEM

Student module
1.Student can search their result using valid roll ID.
2.Student can also view the notices.

2. EXISTING SYSTEM

Existing system refers to the system that is being followed till now the existing system requires
more computational time, more manual calculations. All the wanted information need to be
provided by the administration.
If the students want to know the results of the particular subject so they should wait for long
time because work done manually. The information about their courses, results and other
information accessing is not possible.

3. NEED FOR NEW SYSTEM

PROPOSED SYSTEM
we have successfully proposed the "STUDENT RESULT MANAGEMENT SYSTEM" for
replacing the manual work of the administration. By this application student can easily access
the modules like student results and other information required to student.

This application is flexible and can easily access by the student. So the time taken for getting
the information will be reduces.

DEPT OF BCA, HKBKDC Page 11


STUDENT RESULT MANAGEMENT SYSTEM

4. REQUIREMENT ANALYSIS

4.1 INTRODUCTION

.2 FUNCTIONAL REQUIREMENT

A Functional Requirement (FR) is a description of the service that the software must offer. It
describes a software system or its component. A function is nothing but inputs to the software
system, its behavior, and outputs. It can be a calculation, data manipulation, business process,
user interaction, or any other specific functionality which defines what function a system is
likely to perform. Functional Requirements in Software Engineering are also called Functional
Specification.

Included are one or more example of all system features and enumeration its user.
The system shall incorporate mechanism to authenticate its user

The system shall verify and validate all users and should notify in case of error detection and
should help the user in error correction.
The system shall allow sharing of files in the system.
The system shall allow quick message to be exchanged without face to face interaction

Some of the other functional requirements are:


 Authorizing phases
 Administrator phases
 Booking tracking
 Maintenance of every transaction done.
 Keeping pace with the booing

4.3 NON-FUNCTIONAL REQUIREMENT

Non-Functional Requirements are the constraints or the requirements imposed on the system.
They specify the quality attribute of the software. Non-Functional Requirements deal with issues

DEPT OF BCA, HKBKDC Page 12


STUDENT RESULT MANAGEMENT SYSTEM

like scalability, maintainability, performance, portability, security, reliability and many more.
Non-Functional Requirements address vital issues of quality for software systems. If NFRs not
addressed property, the results can include:

Users, clients, and developers are unsatisfied.


 Inconsistent software.
 Time and cost overrun to fix the software which was prepared without keeping NFRs in mind.
 The system shall be user friendly and consistency.
 The system shall provide attractive graphical interface for the user.
 The system shall allow developer access to installed environment.
 The system shall target customer base.

Some of the non-functional requirement


 Fastness
 Accuracy
 User-friendly
 Attractive

Some of the other non-functional requirements are:


 Capability
 Availability
 Reliability
 Recoverability
 Maintainability
 Services
 Regularity
 Management
 Environment
 Data integrity

DEPT OF BCA, HKBKDC Page 13


STUDENT RESULT MANAGEMENT SYSTEM

5. SYSTEM ANALYSIS

The primary goal of system analysis is to improve the efficiency of the existing system. For
the study of specification of the requirement is very essential. For the development of the new
system, a preliminary survey of the existing system will be conducted. Investigation done
whether the up gradation of the system into an application program could solve the problem
and eradicate the inefficiency of the existing system.

5.1 FEASIBILITY STUDY

The initial investigation points to the question whether the project is feasible. A feasibility is
conducted to identify the best system that meets the all the requirements. This includes an
identification description, an evaluation of the proposed systems and selection of the best
system for the job the requirements of the system are specified with a set of constraints such
as system objectives and the description of the outputs. It is their duty of the analyst to evaluate
the feasibility of the proposed system to generate the above results. Three key factors are to
be considered during the feasibility study.

5.2 OPERATIONAL FEASIBILITY

An estimate should be made to determine how much effort and care will go into the developing
of the system including the training to given to the user. Usually, people are reluctant to
changes that come in their progression. The computer initialization will certainly affected the
turn over, transfer and employee job status. Hence an additional effort is to be made to train
and educate the users on the new way of the system

5.3 TECHNICAL FEASIBILITY

The main consideration is to be given to the study of available resources of the organization
where the software is to be implemented. Here the system analyst evaluates the technical
merits of the system giving emphasis on the performance, reliability, maintainability. By
taking the consideration before developing the proposed system, the resources availability of

DEPT OF BCA, HKBKDC Page 14


STUDENT RESULT MANAGEMENT SYSTEM

the organization was studied. The organization was immense computer facilities equipped
with sophisticated machines and the software hence this technically feasible.

5.4 ECONOMIC FEASIBILITY

Economic feasibility is the most important and frequently used method for evaluating the
effectiveness of the proposed system. It is very essential because the main goal of the proposed
system is to have economically better result along with increased efficiency. Cost benefit
analysis is usually performed for this purpose. It is the comparative study of the cost verses
the benefit and savings that are expected from the proposed system. Since the organization is
well equipped with the required hard ware, the project was found to be economically.

DEPT OF BCA, HKBKDC Page 15


STUDENT RESULT MANAGEMENT SYSTEM

6. SYSTEM REQUEIREMENTS

To be used efficiently, all computer software needs certain hardware components or other
software resources to be present on a computer. These prerequisites are known as (computer)
system requirements and are often used as a guideline as opposed to an absolute rule. Most
software defines two sets of system requirements minimum and recommended. With
increasing demand for higher processing power and resources in newer versions of software,
system requirements tend to increase over time. Industry analysts suggest that this trend plays
a bigger part in driving upgrades to existing computer systems than technological
advancements. A second meaning of the term of system requirements, is a generalization of
this first definition, giving the requirements to be met in the design of a system or sub-system.

Contents
 Recommended system requirements
 Hardware requirements
 Architecture
 Processing power
 Memory
 Secondary storage
 Display adapter
 Peripherals

6.1 HARDWARE REQUIREMENTS

PROCESSOR Intel(R) Pentium N5000

HARD DISK 1TB

RAM 4GB

DEPT OF BCA, HKBKDC Page 16


STUDENT RESULT MANAGEMENT SYSTEM

6.2 SOFTWARE REQUIREMENTS

FRONT END HTML (Hyper Text Markup Language)

CSS (Cascading Style Sheet)

JAVASCRIPT

JQUERY

BOOTSTRAP

BACKEND PHP, MySQL

PLATFORM Windows 10

SERVER XAMPP

DEPT OF BCA, HKBKDC Page 17


STUDENT RESULT MANAGEMENT SYSTEM

7. OVERVIEW OF TECHNOLOGY

7.1 INTRODUCTION TO XAMPP

XAMPP is a light-weight easy to install bundle that will allow you to do local development
on websites in case you don’t have a server hosted already. Also, I am being base here, because
frankly I believe in open source .Also, I like to scratch and build upwards so that in the long
run it helps me to learn better rather than just following manuals and documentation. Since
this post is for absolute beginners, it’s good to start out with XAMPP which does the basic
task of setting out the environment for you so you can start building stuff right away.
Anyway, XAMPP consists of the three main things that you need to know when starting web
development. They are:
 Apache Web Server
 PHP
 MySQL

Apache web server: It is a web server that allows you to host your websites or any other
content for that matter. Apache is available for UNIX as well as Windows. Some of the most
common server side languages supported by Apache are – PHP, Python and Perl it is free of
charge.

PHP: A server side programming language which is used to produce dynamic web pages.
PHP code can be embedded within HTML. It is also free and platform-independent which
means that it can be installed on any operating system.

MySQL: It is the world’s most popular open source database. It is a Relational Database
Management System (RDBMS) - data and its relationships are stored in the form of tables
that can be accessed by the use of MySQL queries in almost any format that the user wants.

7.2 HTML (Hypertext Markup Language)

DEPT OF BCA, HKBKDC Page 18


STUDENT RESULT MANAGEMENT SYSTEM

HTML is written in the form of HTML elements consisting of tags enclosed in angle brackets
(like <html>). HTML tags most commonly come in pairs like <h1> and </h1>, although
some tags represent empty elements and so are unpaired, for example <img>. The first tag in
a pair is the start tag, and the second tag is the end tag (they are also called opening tags and
closing tags).
The purpose of a web browser is to read HTML documents and compose them into visible or
audible web pages. The Browser does not display HTML tags, but it uses the tags to interpret
the content of the page. HTML describes the structure of a website semantically along with
cues for presentation, mark-up language rather than a programming language.
HTML elements form the building blocks of all websites. HTML allows images and object to
be embedded and can be used to create interactive forms. It provides a means to create
structure document by denoting structural semantics for text such as headings, paragraphs,
lists, links, quotes and other items. It can embed scripts written in languages such as JavaScript
which affect the behavior of HTML web pages.

7.3 CSS (Cascading Style Sheet)

Cascading style sheets are create a uniform look across several pages of a web site. Instead of
defining the style of each table and each block of text within a HTML pages, commonly used
style need to defined only once in a CSS document. Once the style is defined in cascading
style sheet, it can be used by any page that references the CSS file. Plus, CSS makes it easy
to change styles across several pages at once. For example, a Web developer may want to
increase the default text size from 10px to 12px for fifty pages of a web site. If the all pages
reference the same style sheet, the text size only needs to be changed on the style sheet and
all the pages will show the larger text.
While CSS is great for creating text styles, it is helpful for formatting other aspects of Web
page layout as well. For example, CSS can be used to define the cell padding of images or
other objects. CSS gives Web developers more exact control over how Web pages will look
than HTML does. This is why most Web pages today incorporate cascading style sheets.

DEPT OF BCA, HKBKDC Page 19


STUDENT RESULT MANAGEMENT SYSTEM

7.4 JAVASCRIPT

JavaScript is a programming language that can be included on web pages to make them more
interactive. You can use it to check or modify the contents of forms, change images, open new
windows and write dynamic page content. You can even use it with CSS to make DHTML
(Dynamic Hypertext Markup Language). This allows you to make parts of your web pages
appear or disappear or move around on the page. JavaScript only execute on the page(s) that
are on your browser window at any set time. When the user stops viewing that page, any
scripts that were running on it are immediately stopped. The only exceptions are cookies or
various client side storage APIs, which can be used by many pages to store and pass
information between them, even after the pages have been closed.
Before we go any further, let me say; JavaScript has nothing to do with Java. If we are honest,
JavaScript, originally nicknamed Livewire and then Live Script when it was created by
Netscape, should in fact be called ECMA Script as it was renamed when Netscape passed it
to the ECMA for standardization.
JavaScript is a client side, interpreted, object oriented, high level scripting language, while
Java is a client side, compiled, object oriented high level language.

7.5 PHP (Hypertext Pre-processor)

PHP is a programming language that can do all sorts of things: evaluate form data sent from
a browser, build custom web content to serve the browser, talk to a database, and even send
and receive cookies (little packets of data that your browser uses to remember things, like if
you're logged in to your Web application.
Check out the code in the editor. Looks familiar, doesn't it? That's because a lot of it is regular
old HTML! The PHP code is written in the <?php and ?> .

Things you can do with PHP:


 Talk to databases
 Send cookies
 Evaluate form data

DEPT OF BCA, HKBKDC Page 20


STUDENT RESULT MANAGEMENT SYSTEM

 Build dynamic webpages

7.6 MySQL

MySQL (pronounced My S-Q-L) is an open source relational database. It's free, and most web
hosting providers include it in their most basic packages. Both of these facts have helped to
cement its popularity among amateur and professional web designers alike.
If you only have time to learn about one database, MySQL is a safe bet. It's designed to be
easy to use, and its scalability and flexibility make it suitable for practically any application.
Its massive user base is partly thanks to its use in many popular web applications, including
WordPress, Drupal and many other open source CMS tools.

7.7 BOOTSTRAP

Bootstrap is a powerful toolkit - a collection of HTML, CSS, and JavaScript tools for creating
and building web pages and web applications. It is a free and open source project, hosted
After its open source release in 2011, Bootstrap became popular very quickly, and not without
reason. Web designers and web developers like Bootstrap because it is flexible and easy to
work with. Its main advantages are that it is responsive by design, it maintains wide browser
compatibility, it offers consistent design by using re-usable components, and it is very easy to
use and quick to learn. It offers rich extensibility using JavaScript, coming with built-in
support for jQuery plugins and a programmatic JavaScript API. Bootstrap can be used with
any IDE or editor, and any server side technology and language, from ASP.NET to PHP to
Ruby on Rails.
With Bootstrap, web developers can concentrate on the development work, without worrying
about design, and get a good looking website up and running quickly. Conversely, it gives
web designers a solid foundation for creating interesting Bootstrap themes.

DEPT OF BCA, HKBKDC Page 21


STUDENT RESULT MANAGEMENT SYSTEM

8. SYSTEM MODELS

8.1 DATA FLOW DIAGRAM

DFD Symbols
In DFD, there are four Symbols
 A square-defines a source or destination system data
 An arrow identified data flow. It is the pipeline through which the information flow
 A circle or a bubble represents a process that transforms
 Incoming data flow into outgoing data flows
 An open rectangle is a data source, data at rest or a temporary of data

Process that transforms data flow

Source or destination of the data

Flow of data

Data source (data at rest or a temporary data)

Constructing a DFD

Several rules of thumb are used in drawing DFD’s


 Process should be named and numbered for any easy reference. Each name should be
responsive of the process
 The direction of flow is top to bottom and from left to right. Data traditionally flows from
the destination although they may flow back to the source. One way to indicate this is to
draw long flow line back to the source. An alternative way is to repeat the source symbol

DEPT OF BCA, HKBKDC Page 22


STUDENT RESULT MANAGEMENT SYSTEM

as a destination. Since it is used more than once in the DFD it is marked with a short
diagonal
 When a process is exploded into lower level details, they are numbered.
 The names of data stores and destinations are written in capital letters. Process and
dataflow names have the first letter of each work capitalized.
A DFD typically shows the minimum contents of data stores. Each data store should contain
all the data elements that flow in and out.
Questionnaires should contain all the data elements that flow in and out. Missing interface
redundancies and like is than accounted for often through interviews.

Features of DFD’s

 The DFD shows flow of data, not of control loops and decision are controlled consideration
do not appear on a DFD.
 The DFD does not indicate the time factor involved in any process whether the data flows
take place daily, weekly, monthly or yearly.
 The sequence of events is not brought out in DFD.

Types of data flow diagrams

 Current Physical
 Current Logical
 New Logical
 New Physical

Current Physical
In current physical DFD process label include the name of people or their positions or the
names of computer system that might provide some of the overall system processing label
includes an identification of the technology used to process the data. Similarly data flows and
data stores are often labels with the names of the actual physical media on which data are
stored as file folders, computer files, business from or computer tapes.
Current Logical

DEPT OF BCA, HKBKDC Page 23


STUDENT RESULT MANAGEMENT SYSTEM

The physical aspects of the system are removed as much as possible so that the current system is
reduced to its essence to the data and the processors that transforms them regardless of actual
physical form.

New Logical
This is exactly like a current logical model if the user were completely happy with
functionality of the current system but had problems with how it was implemented typically
through the new logical model will differ from the current logical model while having
additional functions, absolute function removal and inefficient flaws recognized.

New Physical
The new physical represents only the physical implementation of the new system

Data Flow

 A data flow has only one destination of flow between symbols. It may flow in both
directions between a process and a data store to show a read before an update. The later is
usually indicated however by two separate arrows since these happen at a different type.
 A join DFD means that exactly the same data comes from any of the two or more different
processes data store or sink to a common location.
 A data flow cannot go directly back to the same process it leads. There must be at least
one another process that handles the data flow produce some other data flow returns the
original data into the beginning process.
 A data flow to a data store means updates (delete or change)
 A data flow from a data means retrieve or use.
 A Data Flow has a noun phrase label, more than one data flow noun phase can appear on
a single arrow as long as all of the flows on the same arrow move together as one package.

Data Flow Diagrams:

DEPT OF BCA, HKBKDC Page 24


STUDENT RESULT MANAGEMENT SYSTEM

Standard symbols for DFDs are derived from the electric circuit diagram
analysis and are shown in fig:

Circles: A circle (bubble) shows a process that transforms data inputs into data outputs.

Data Flow: A curved line shows the flow of data into or out of a process or data store.

Data Store: A set of parallel lines shows a place for the collection of data items. A data store
indicates that the data is stored which can be used at a later stage or by the other processes in a
different order. The data store can have an element or group of elements.

Zero Level DFD

DEPT OF BCA, HKBKDC Page 25


STUDENT RESULT MANAGEMENT SYSTEM

First Level DFD

DEPT OF BCA, HKBKDC Page 26


STUDENT RESULT MANAGEMENT SYSTEM

Second Level DFD

DEPT OF BCA, HKBKDC Page 27


STUDENT RESULT MANAGEMENT SYSTEM

DEPT OF BCA, HKBKDC Page 28


STUDENT RESULT MANAGEMENT SYSTEM

8.2 USE CASE DIAGRAM

DEPT OF BCA, HKBKDC Page 29


STUDENT RESULT MANAGEMENT SYSTEM

The activity diagram highlights the activities. Each activity is represented by rounded rectangle-
narrowed and more oval shaped then the icon. An arrow represents the transaction from one
activity to next. The activity diagram has a starting point represented by filled in circle and show
the overflow of control.

Admin/teacher

Student

DEPT OF BCA, HKBKDC Page 30


STUDENT RESULT MANAGEMENT SYSTEM

8.3 ER Diagram

The Entity-Relationship (ER) model was originally proposed by Peter in 1976 [Chen76] as a
way to unify the network and relational database views. Simply stated the ER model is a
conceptual data model that views the real world as entities and relationships. A basic
component of the model is the Entity-Relationship diagram which is used to visually
represent data objects. Since Chen wrote his paper the model has been extended and today it
is commonly used for database design for the database designer, the utility of the ER model
is:

 It maps well to the relational model. The constructs used in the ER model can easily be
transformed into relational tables.

DEPT OF BCA, HKBKDC Page 31


STUDENT RESULT MANAGEMENT SYSTEM

 It is simple and easy to understand with a minimum of training. Therefore, the model can be
used by the database designer to communicate the design to the end user.

 In addition, the model can be used as a design plan by the database developer to implement
a data model in specific database management software.

ER Notation
There is no standard for representing data objects in ER diagrams. Each modeling
methodology uses its own notation. The original notation used by Chen is widely used in
academics texts and journals but rarely seen in either CASE tools or publications by non-
academics. Today, there are a number of notations used; among the more common are
Bachman, crow's foot, and IDEFIX.

All notational styles represent entities as rectangular boxes and relationships as lines
connecting boxes. Each style uses a special set of symbols to represent the cardinality of a
connection. The notation used in this document is from Martin. The symbols used for the
basic ER constructs are:

 Entities are represented by labeled rectangles. The label is the name of the entity. Entity
names should be singular nouns.

 Relationships are represented by a solid line connecting two entities. The name of the
relationship is written above the line. Relationship names should be verbs

 Attributes, when included, are listed inside the entity rectangle. Attributes which are
identifiers are underlined. Attribute names should be singular nouns.

 Cardinality of many is represented by a line ending in a crow's foot. If the crow's foot is
omitted, the cardinality is one.

Existence is represented by placing a circle or a perpendicular bar on the line. Mandatory


existence is shown by the bar (looks like a 1) next to the entity for an instance is required.
Optional existence is shown by placing a circle next to the entity that is optional.

DEPT OF BCA, HKBKDC Page 32


STUDENT RESULT MANAGEMENT SYSTEM

ER Diagram

DEPT OF BCA, HKBKDC Page 33


STUDENT RESULT MANAGEMENT SYSTEM

9. CODING

index.php
<?php

error_reporting(0);

include('includes/config.php');

?>

<!DOCTYPE html>

<html lang="en">

<head>

<meta charset="utf-8" />

<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />

<meta name="description" content="" />

<meta name="author" content="" />

<title>Student Result Management System</title>

<!-- Favicon-->

<link rel="icon" type="image/x-icon" href="assets/favicon.ico" />

<!-- Core theme CSS (includes Bootstrap)-->

<link href="css/styles.css" rel="stylesheet" />

</head>

<body>

<!-- Responsive navbar-->

<nav class="navbar navbar-expand-lg navbar-white bg-white">

<div class="container">

<a class="navbar-brand" href="index.php">Student Result Management System</a>

DEPT OF BCA, HKBKDC Page 34


STUDENT RESULT MANAGEMENT SYSTEM

<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-


target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-
expanded="false" aria-label="Toggle navigation"><span class="navbar-toggler-
icon"></span></button>

<div class="collapse navbar-collapse" id="navbarSupportedContent">

<ul class="navbar-nav ms-auto mb-2 mb-lg-0">

<li class="nav-item"><a class="nav-link active" aria-current="page"


href="#!">Home</a></li>

<li class="nav-item"><a class="nav-link active" href="find-


result.php">Students</a></li>

<li class="nav-item"><a class="nav-link active" href="admin-


login.php">Admin</a></li>

</ul>

</div>

</div>

</nav>

<!-- Header - set the background image for the header in the line below-->

<header class="py-5 " style="">

</header>

<img src="images/resul.jpeg" alt="" style="margin-top: -80px; margin-left: 140px;">

<!-- Content section-->

<section class="py-5" style="margin-top: -10px;">

<div class="container my-5">

<div class="row justify-content-center">

DEPT OF BCA, HKBKDC Page 35


STUDENT RESULT MANAGEMENT SYSTEM

<div class="col-lg-6">

<h2>Notice Board</h2>

<hr color="#000" />

<marquee direction="up" onmouseover="this.stop();" onmouseout="this.start();">

<ul>

<?php $sql = "SELECT * from tblnotice";

$query = $dbh->prepare($sql);

$query->execute();

$results=$query->fetchAll(PDO::FETCH_OBJ);

$cnt=1;

if($query->rowCount() > 0)

foreach($results as $result)

{ ?>

<li><a href="notice-details.php?nid=<?php echo htmlentities($result->id);?>"


target="_blank"><?php echo htmlentities($result->noticeTitle);?></li>

<?php }} ?>

</ul>

</marquee>

</div>

</div>

</div>

</section>

DEPT OF BCA, HKBKDC Page 36


STUDENT RESULT MANAGEMENT SYSTEM

<!-- Footer-->

<footer class="py-5 bg-dark">

<div class="container"><p class="m-0 text-center text-white">Copyright &copy; Student


Result Management System <?php echo date('Y');?></p></div>

</footer>

<!-- Bootstrap core JS-->

<script
src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js"></script>

<!-- Core theme JS-->

<script src="js/scripts.js"></script>

</body>

</html>----------Index-------------------------------

<?php

session_start();

error_reporting(0);

include('includes/config.php');

if($_SESSION['alogin']!=''){

$_SESSION['alogin']='';

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

$uname=$_POST['username'];

$password=md5($_POST['password']);

DEPT OF BCA, HKBKDC Page 37


STUDENT RESULT MANAGEMENT SYSTEM

$sql ="SELECT UserName,Password FROM admin WHERE UserName=:uname and


Password=:password";

$query= $dbh -> prepare($sql);

$query-> bindParam(':uname', $uname, PDO::PARAM_STR);

$query-> bindParam(':password', $password, PDO::PARAM_STR);

$query-> execute();

$results=$query->fetchAll(PDO::FETCH_OBJ);

if($query->rowCount() > 0)

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

echo "<script type='text/javascript'> document.location = 'dashboard.php'; </script>";

} else{

echo "<script>alert('Invalid Details');</script>";

?>

<!DOCTYPE html>

<html lang="en">

<head>

<meta charset="utf-8">

DEPT OF BCA, HKBKDC Page 38


STUDENT RESULT MANAGEMENT SYSTEM

<meta http-equiv="X-UA-Compatible" content="IE=edge">

<meta name="viewport" content="width=device-width, initial-scale=1">

<title>Admin Login</title>

<link rel="stylesheet" href="css/bootstrap.min.css" media="screen" >

<link rel="stylesheet" href="css/font-awesome.min.css" media="screen" >

<link rel="stylesheet" href="css/animate-css/animate.min.css" media="screen" >

<link rel="stylesheet" href="css/prism/prism.css" media="screen" > <!-- USED FOR DEMO


HELP - YOU CAN REMOVE IT -->

<link rel="stylesheet" href="css/main.css" media="screen" >

<script src="js/modernizr/modernizr.min.js"></script>

</head>

<body class="" style="background-color: #fff;">

<div class="main-wrapper">

<div class="">

<div class="row">

<h1 align="center">Student Result Management System</h1>

<div class="col-lg-3"></div>

<div class="col-lg-6">

<section class="section">

<div class="row mt-40">

<div class="col-md-10 col-md-offset-1 pt-50">

<div class="row mt-30 ">

DEPT OF BCA, HKBKDC Page 39


STUDENT RESULT MANAGEMENT SYSTEM

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

<div class="panel">

<div class="panel-heading">

<div class="panel-title text-center">

<h4>Admin Login</h4>

</div>

</div>

<div class="panel-body p-20">

<form class="form-horizontal" method="post" style="">

<div class="form-group">

<label for="inputEmail3" class="col-sm-2 control-


label">Username</label>

<div class="col-sm-10">

<input type="text" name="username"


class="form-control" id="inputEmail3" placeholder="UserName">

</div>

</div>

<div class="form-group">

<label for="inputPassword3" class="col-sm-2


control-label">Password</label>

<div class="col-sm-10">

<input type="password" name="password"


class="form-control" id="inputPassword3" placeholder="Password">

</div>

</div>

DEPT OF BCA, HKBKDC Page 40


STUDENT RESULT MANAGEMENT SYSTEM

<div class="form-group mt-20">

<div class="col-sm-offset-2 col-sm-10">

<button type="submit" name="login"


class="btn btn-success btn-labeled pull-right">Sign in<span class="btn-label btn-label-right"><i
class="fa fa-check"></i></span></button>

</div>

</div>

</form>

</div>

</div>

<!-- /.panel -->

<p class="text-muted text-center"><small>Student Result


Management System</small></p>

</div>

<!-- /.col-md-11 -->

</div>

<!-- /.row -->

</div>

<!-- /.col-md-12 -->

</div>

DEPT OF BCA, HKBKDC Page 41


STUDENT RESULT MANAGEMENT SYSTEM

<!-- /.row -->

</section>

</div>

<!-- /.col-md-6 -->

</div>

<!-- /.row -->

</div>

<!-- /. -->

</div>

<!-- /.main-wrapper -->

<!-- ========== COMMON JS FILES ========== -->

<script src="js/jquery/jquery-2.2.4.min.js"></script>

<script src="js/jquery-ui/jquery-ui.min.js"></script>

<script src="js/bootstrap/bootstrap.min.js"></script>

<script src="js/pace/pace.min.js"></script>

<script src="js/lobipanel/lobipanel.min.js"></script>

<script src="js/iscroll/iscroll.js"></script>

<!-- ========== PAGE JS FILES ========== -->

<!-- ========== THEME JS ========== -->

<script src="js/main.js"></script>

DEPT OF BCA, HKBKDC Page 42


STUDENT RESULT MANAGEMENT SYSTEM

<script>

$(function(){

});

</script>

<!-- ========== ADD custom.js FILE BELOW WITH YOUR CHANGES ==========
-->

</body>

</html>----------------------------admin login-----------

<?php

session_start();

error_reporting(0);

include('includes/config.php');

if(strlen($_SESSION['alogin'])=="")

header("Location: index.php");

else{

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

$password=md5($_POST['password']);

$newpassword=md5($_POST['newpassword']);

$username=$_SESSION['alogin'];

DEPT OF BCA, HKBKDC Page 43


STUDENT RESULT MANAGEMENT SYSTEM

$sql ="SELECT Password FROM admin WHERE UserName=:username and


Password=:password";

$query= $dbh -> prepare($sql);

$query-> bindParam(':username', $username, PDO::PARAM_STR);

$query-> bindParam(':password', $password, PDO::PARAM_STR);

$query-> execute();

$results = $query -> fetchAll(PDO::FETCH_OBJ);

if($query -> rowCount() > 0)

$con="update admin set Password=:newpassword where UserName=:username";

$chngpwd1 = $dbh->prepare($con);

$chngpwd1-> bindParam(':username', $username, PDO::PARAM_STR);

$chngpwd1-> bindParam(':newpassword', $newpassword, PDO::PARAM_STR);

$chngpwd1->execute();

$msg="Your Password succesfully changed";

else {

$error="Your current password is wrong";

?>

<!DOCTYPE html>

<html lang="en">

<head>

<meta charset="utf-8">

DEPT OF BCA, HKBKDC Page 44


STUDENT RESULT MANAGEMENT SYSTEM

<meta http-equiv="X-UA-Compatible" content="IE=edge">

<meta name="viewport" content="width=device-width, initial-scale=1">

<title>Admin change password</title>

<link rel="stylesheet" href="css/bootstrap.css" media="screen" >

<link rel="stylesheet" href="css/font-awesome.min.css" media="screen" >

<link rel="stylesheet" href="css/animate-css/animate.min.css" media="screen" >

<link rel="stylesheet" href="css/lobipanel/lobipanel.min.css" media="screen" >

<link rel="stylesheet" href="css/prism/prism.css" media="screen" > <!-- USED FOR DEMO


HELP - YOU CAN REMOVE IT -->

<link rel="stylesheet" href="css/main.css" media="screen" >

<script src="js/modernizr/modernizr.min.js"></script>

<script type="text/javascript">

function valid()

if(document.chngpwd.newpassword.value!= document.chngpwd.confirmpassword.value)

alert("New Password and Confirm Password Field do not match !!");

document.chngpwd.confirmpassword.focus();

return false;

return true;

</script>

<style>

.errorWrap {

DEPT OF BCA, HKBKDC Page 45


STUDENT RESULT MANAGEMENT SYSTEM

padding: 10px;

margin: 0 0 20px 0;

background: #fff;

border-left: 4px solid #dd3d36;

-webkit-box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);

box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);

.succWrap{

padding: 10px;

margin: 0 0 20px 0;

background: #fff;

border-left: 4px solid #5cb85c;

-webkit-box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);

box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);

</style>

</head>

<body class="top-navbar-fixed">

<div class="main-wrapper">

<?php include('includes/topbar.php');?>

<div class="content-wrapper">

<div class="content-container">

<?php include('includes/leftbar.php');?>

<!-- /.left-sidebar -->

DEPT OF BCA, HKBKDC Page 46


STUDENT RESULT MANAGEMENT SYSTEM

<div class="main-page">

<div class="container-fluid">

<div class="row page-title-div">

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

<h2 class="title">Admin Change Password</h2>

</div>

</div>

<!-- /.row -->

<div class="row breadcrumb-div">

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

<ul class="breadcrumb">

<li><a href="dashboard.php"><i
class="fa fa-home"></i> Home</a></li>

<li class="active">Admin change


password</li>

</ul>

</div>

</div>

<!-- /.row -->

</div>

<!-- /.container-fluid -->

DEPT OF BCA, HKBKDC Page 47


STUDENT RESULT MANAGEMENT SYSTEM

<section class="section">

<div class="container-fluid">

<div class="row">

<div class="col-md-8 col-md-offset-2">

<div class="panel">

<div class="panel-heading">

<div class="panel-title">

<h5>Admin Change Password</h5>

</div>

</div>

<?php if($msg){?>

<div class="alert alert-success left-icon-alert" role="alert">

<strong>Well done!</strong><?php echo htmlentities($msg); ?>

</div><?php }

else if($error){?>

<div class="alert alert-danger left-icon-alert" role="alert">

<strong>Oh snap!</strong> <?php echo htmlentities($error); ?>

</div>

<?php } ?>

DEPT OF BCA, HKBKDC Page 48


STUDENT RESULT MANAGEMENT SYSTEM

<div class="panel-body">

<form name="chngpwd" method="post" \ onSubmit="return


valid();">

<div class="form-group has-success">

<label for="success" class="control-label">Current


Password</label>

<div class="">

<input type="password" name="password" class="form-control"


required="required" id="success">

</div>

</div>

<div class="form-group has-success">

<label for="success" class="control-label">New


Password</label>

<div class="">

<input type="password" name="newpassword"


required="required" class="form-control" id="success">

</div>

</div>

<div class="form-group has-success">

<label for="success" class="control-label">Confirm


Password</label>

<div class="">

DEPT OF BCA, HKBKDC Page 49


STUDENT RESULT MANAGEMENT SYSTEM

<input type="password" name="confirmpassword"


class="form-control" required="required" id="success">

</div>

</div>

<div class="form-group has-success">

<div class="">

<button type="submit" name="submit" class="btn btn-


success btn-labeled">Change<span class="btn-label btn-label-right"><i class="fa fa-
check"></i></span></button>

</div>

</form>

</div>

</div>

</div>

<!-- /.col-md-8 col-md-offset-2 -->

</div>

<!-- /.row -->

DEPT OF BCA, HKBKDC Page 50


STUDENT RESULT MANAGEMENT SYSTEM

</div>

<!-- /.container-fluid -->

</section>

<!-- /.section -->

</div>

<!-- /.main-page -->

</div>

<!-- /.content-container -->

</div>

<!-- /.content-wrapper -->

</div>

<!-- /.main-wrapper -->

<!-- ========== COMMON JS FILES ========== -->

<script src="js/jquery/jquery-2.2.4.min.js"></script>

<script src="js/jquery-ui/jquery-ui.min.js"></script>

<script src="js/bootstrap/bootstrap.min.js"></script>

<script src="js/pace/pace.min.js"></script>

<script src="js/lobipanel/lobipanel.min.js"></script>

<script src="js/iscroll/iscroll.js"></script>

DEPT OF BCA, HKBKDC Page 51


STUDENT RESULT MANAGEMENT SYSTEM

<!-- ========== PAGE JS FILES ========== -->

<script src="js/prism/prism.js"></script>

<!-- ========== THEME JS ========== -->

<script src="js/main.js"></script>

<!-- ========== ADD custom.js FILE BELOW WITH YOUR CHANGES ==========
-->

</body>

</html>

<?php } ?>---------------change pass-------------------------------

<?php

session_start();

error_reporting(0);

include('includes/config.php');

if(strlen($_SESSION['alogin'])=="")

{ header("Location: index.php"); }else{

?>

<!DOCTYPE html>

<html lang="en">

<head>

DEPT OF BCA, HKBKDC Page 52


STUDENT RESULT MANAGEMENT SYSTEM

<meta charset="utf-8">

<meta http-equiv="X-UA-Compatible" content="IE=edge">

<meta name="viewport" content="width=device-width, initial-scale=1">

<title>Student Result Management System | Dashboard</title>

<link rel="stylesheet" href="css/bootstrap.min.css" media="screen" >

<link rel="stylesheet" href="css/font-awesome.min.css" media="screen" >

<link rel="stylesheet" href="css/animate-css/animate.min.css" media="screen" >

<link rel="stylesheet" href="css/lobipanel/lobipanel.min.css" media="screen" >

<link rel="stylesheet" href="css/toastr/toastr.min.css" media="screen" >

<link rel="stylesheet" href="css/icheck/skins/line/blue.css" >

<link rel="stylesheet" href="css/icheck/skins/line/red.css" >

<link rel="stylesheet" href="css/icheck/skins/line/green.css" >

<link rel="stylesheet" href="css/main.css" media="screen" >

<script src="js/modernizr/modernizr.min.js"></script>

</head>

<body class="top-navbar-fixed">

<div class="main-wrapper">

<?php include('includes/topbar.php');?>

<div class="content-wrapper">

<div class="content-container">

<?php include('includes/leftbar.php');?>

<div class="main-page">

<div class="container-fluid">

DEPT OF BCA, HKBKDC Page 53


STUDENT RESULT MANAGEMENT SYSTEM

<div class="row page-title-div">

<div class="col-sm-6">

<h2 class="title">Dashboard</h2>

</div>

<!-- /.col-sm-6 -->

</div>

<!-- /.row -->

</div>

<!-- /.container-fluid -->

<section class="section">

<div class="container-fluid">

<div class="row">

<div class="col-lg-6 col-md-6 col-sm-6 col-xs-12">

<a class="dashboard-stat bg-primary" href="manage-students.php">

<?php

$sql1 ="SELECT StudentId from tblstudents ";

$query1 = $dbh -> prepare($sql1);

$query1->execute();

$results1=$query1->fetchAll(PDO::FETCH_OBJ);

$totalstudents=$query1->rowCount();

?>

DEPT OF BCA, HKBKDC Page 54


STUDENT RESULT MANAGEMENT SYSTEM

<span class="number counter"><?php echo


htmlentities($totalstudents);?></span>

<span class="name">Regd Users</span>

<span class="bg-icon"><i class="fa fa-users"></i></span>

</a>

<!-- /.dashboard-stat -->

</div>

<!-- /.col-lg-3 col-md-3 col-sm-6 col-xs-12 -->

<div class="col-lg-6 col-md-6 col-sm-6 col-xs-12" >

<a class="dashboard-stat bg-danger" href="manage-subjects.php">

<?php

$sql ="SELECT id from tblsubjects ";

$query = $dbh -> prepare($sql);

$query->execute();

$results=$query->fetchAll(PDO::FETCH_OBJ);

$totalsubjects=$query->rowCount();

?>

<span class="number counter"><?php echo


htmlentities($totalsubjects);?></span>

<span class="name">Subjects Listed</span>

<span class="bg-icon"><i class="fa fa-ticket"></i></span>

</a>

<!-- /.dashboard-stat -->

</div>

DEPT OF BCA, HKBKDC Page 55


STUDENT RESULT MANAGEMENT SYSTEM

<!-- /.col-lg-3 col-md-3 col-sm-6 col-xs-12 -->

<div class="col-lg-6 col-md-6 col-sm-6 col-xs-12" style="margin-


top:1%;">

<a class="dashboard-stat bg-warning" href="manage-classes.php">

<?php

$sql2 ="SELECT id from tblclasses ";

$query2 = $dbh -> prepare($sql2);

$query2->execute();

$results2=$query2->fetchAll(PDO::FETCH_OBJ);

$totalclasses=$query2->rowCount();

?>

<span class="number counter"><?php echo


htmlentities($totalclasses);?></span>

<span class="name">Total classes listed</span>

<span class="bg-icon"><i class="fa fa-bank"></i></span>

</a>

<!-- /.dashboard-stat -->

</div>

<!-- /.col-lg-3 col-md-3 col-sm-6 col-xs-12 -->

<div class="col-lg-6 col-md-6 col-sm-6 col-xs-12" style="margin-


top:1%">

<a class="dashboard-stat bg-success" href="manage-results.php">

<?php

$sql3="SELECT distinct StudentId from tblresult ";

DEPT OF BCA, HKBKDC Page 56


STUDENT RESULT MANAGEMENT SYSTEM

$query3 = $dbh -> prepare($sql3);

$query3->execute();

$results3=$query3->fetchAll(PDO::FETCH_OBJ);

$totalresults=$query3->rowCount();

?>

<span class="number counter"><?php echo


htmlentities($totalresults);?></span>

<span class="name">Results Declared</span>

<span class="bg-icon"><i class="fa fa-file-text"></i></span>

</a>

<!-- /.dashboard-stat -->

</div>

<!-- /.col-lg-3 col-md-3 col-sm-6 col-xs-12 -->

</div>

<!-- /.row -->

</div>

<!-- /.container-fluid -->

</section>

<!-- /.section -->

</div>

<!-- /.main-page -->

DEPT OF BCA, HKBKDC Page 57


STUDENT RESULT MANAGEMENT SYSTEM

</div>

<!-- /.content-container -->

</div>

<!-- /.content-wrapper -->

</div>

<!-- /.main-wrapper -->

<!-- ========== COMMON JS FILES ========== -->

<script src="js/jquery/jquery-2.2.4.min.js"></script>

<script src="js/jquery-ui/jquery-ui.min.js"></script>

<script src="js/bootstrap/bootstrap.min.js"></script>

<script src="js/pace/pace.min.js"></script>

<script src="js/lobipanel/lobipanel.min.js"></script>

<script src="js/iscroll/iscroll.js"></script>

<!-- ========== PAGE JS FILES ========== -->

<script src="js/prism/prism.js"></script>

<script src="js/waypoint/waypoints.min.js"></script>

<script src="js/counterUp/jquery.counterup.min.js"></script>

<script src="js/amcharts/amcharts.js"></script>

<script src="js/amcharts/serial.js"></script>

<script src="js/amcharts/plugins/export/export.min.js"></script>

DEPT OF BCA, HKBKDC Page 58


STUDENT RESULT MANAGEMENT SYSTEM

<link rel="stylesheet" href="js/amcharts/plugins/export/export.css" type="text/css"


media="all" />

<script src="js/amcharts/themes/light.js"></script>

<script src="js/toastr/toastr.min.js"></script>

<script src="js/icheck/icheck.min.js"></script>

<!-- ========== THEME JS ========== -->

<script src="js/main.js"></script>

<script src="js/production-chart.js"></script>

<script src="js/traffic-chart.js"></script>

<script src="js/task-list.js"></script>

<script>

$(function(){

// Counter for dashboard stats

$('.counter').counterUp({

delay: 10,

time: 1000

});

// Welcome notification

toastr.options = {

"closeButton": true,

"debug": false,

"newestOnTop": false,

DEPT OF BCA, HKBKDC Page 59


STUDENT RESULT MANAGEMENT SYSTEM

"progressBar": false,

"positionClass": "toast-top-right",

"preventDuplicates": false,

"onclick": null,

"showDuration": "300",

"hideDuration": "1000",

"timeOut": "5000",

"extendedTimeOut": "1000",

"showEasing": "swing",

"hideEasing": "linear",

"showMethod": "fadeIn",

"hideMethod": "fadeOut"

toastr["success"]( "Welcome to student Result Management System!");

});

</script>

</body>

</html>

<?php } ?>----------------dashboard-------------------------------

<?php

session_start();

error_reporting(0);

DEPT OF BCA, HKBKDC Page 60


STUDENT RESULT MANAGEMENT SYSTEM

include('includes/config.php');

if(strlen($_SESSION['alogin'])=="")

header("Location: index.php");

else{

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

$classname=$_POST['classname'];

$classnamenumeric=$_POST['classnamenumeric'];

$section=$_POST['section'];

$sql="INSERT INTO tblclasses(ClassName,ClassNameNumeric,Section)


VALUES(:classname,:classnamenumeric,:section)";

$query = $dbh->prepare($sql);

$query->bindParam(':classname',$classname,PDO::PARAM_STR);

$query->bindParam(':classnamenumeric',$classnamenumeric,PDO::PARAM_STR);

$query->bindParam(':section',$section,PDO::PARAM_STR);

$query->execute();

$lastInsertId = $dbh->lastInsertId();

if($lastInsertId)

$msg="Class Created successfully";

else

DEPT OF BCA, HKBKDC Page 61


STUDENT RESULT MANAGEMENT SYSTEM

$error="Something went wrong. Please try again";

?>

<!DOCTYPE html>

<html lang="en">

<head>

<meta charset="utf-8">

<meta http-equiv="X-UA-Compatible" content="IE=edge">

<meta name="viewport" content="width=device-width, initial-scale=1">

<title>SMS Admin Create Class</title>

<link rel="stylesheet" href="css/bootstrap.css" media="screen" >

<link rel="stylesheet" href="css/font-awesome.min.css" media="screen" >

<link rel="stylesheet" href="css/animate-css/animate.min.css" media="screen" >

<link rel="stylesheet" href="css/lobipanel/lobipanel.min.css" media="screen" >

<link rel="stylesheet" href="css/prism/prism.css" media="screen" > <!-- USED FOR DEMO


HELP - YOU CAN REMOVE IT -->

<link rel="stylesheet" href="css/main.css" media="screen" >

<script src="js/modernizr/modernizr.min.js"></script>

<style>

.errorWrap {

padding: 10px;

margin: 0 0 20px 0;

background: #fff;

DEPT OF BCA, HKBKDC Page 62


STUDENT RESULT MANAGEMENT SYSTEM

border-left: 4px solid #dd3d36;

-webkit-box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);

box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);

.succWrap{

padding: 10px;

margin: 0 0 20px 0;

background: #fff;

border-left: 4px solid #5cb85c;

-webkit-box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);

box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);

</style>

</head>

<body class="top-navbar-fixed">

<div class="main-wrapper">

<!-- ========== TOP NAVBAR ========== -->

<?php include('includes/topbar.php');?>

<!-----End Top bar>

<!-- ========== WRAPPER FOR BOTH SIDEBARS & MAIN CONTENT


========== -->

<div class="content-wrapper">

<div class="content-container">

DEPT OF BCA, HKBKDC Page 63


STUDENT RESULT MANAGEMENT SYSTEM

<!-- ========== LEFT SIDEBAR ========== -->

<?php include('includes/leftbar.php');?>

<!-- /.left-sidebar -->

<div class="main-page">

<div class="container-fluid">

<div class="row page-title-div">

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

<h2 class="title">Create Student Class</h2>

</div>

</div>

<!-- /.row -->

<div class="row breadcrumb-div">

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

<ul class="breadcrumb">

<li><a href="dashboard.php"><i
class="fa fa-home"></i> Home</a></li>

<li><a href="#">Classes</a></li>

<li class="active">Create Class</li>

</ul>

</div>

</div>

<!-- /.row -->

DEPT OF BCA, HKBKDC Page 64


STUDENT RESULT MANAGEMENT SYSTEM

</div>

<!-- /.container-fluid -->

<section class="section">

<div class="container-fluid">

<div class="row">

<div class="col-md-8 col-md-offset-2">

<div class="panel">

<div class="panel-heading">

<div class="panel-title">

<h5>Create Student Class</h5>

</div>

</div>

<?php if($msg){?>

<div class="alert alert-success left-icon-alert" role="alert">

<strong>Well done!</strong><?php echo htmlentities($msg); ?>

</div><?php }

else if($error){?>

<div class="alert alert-danger left-icon-alert" role="alert">

<strong>Oh snap!</strong> <?php echo htmlentities($error); ?>

</div>

<?php } ?>

<div class="panel-body">

DEPT OF BCA, HKBKDC Page 65


STUDENT RESULT MANAGEMENT SYSTEM

<form method="post">

<div class="form-group has-success">

<label for="success" class="control-label">Class


Name</label>

<div class="">

<input type="text" name="classname"


class="form-control" required="required" id="success">

<span class="help-block">Eg- Third, Fouth,Sixth


etc</span>

</div>

</div>

<div class="form-group has-success">

<label for="success" class="control-label">Class Name in


Numeric</label>

<div class="">

<input type="number" name="classnamenumeric"


required="required" class="form-control" id="success">

<span class="help-block">Eg- 1,2,4,5 etc</span>

</div>

</div>

<div class="form-group has-success">

<label for="success" class="control-label">Section</label>

<div class="">

<input type="text" name="section" class="form-control"


required="required" id="success">

DEPT OF BCA, HKBKDC Page 66


STUDENT RESULT MANAGEMENT SYSTEM

<span class="help-block">Eg- A,B,C etc</span>

</div>

</div>

<div class="form-group has-success">

<div class="">

<button type="submit" name="submit" class="btn btn-


success btn-labeled">Submit<span class="btn-label btn-label-right"><i class="fa fa-
check"></i></span></button>

</div>

</form>

</div>

</div>

</div>

<!-- /.col-md-8 col-md-offset-2 -->

</div>

<!-- /.row -->

</div>

<!-- /.container-fluid -->

</section>

<!-- /.section -->

DEPT OF BCA, HKBKDC Page 67


STUDENT RESULT MANAGEMENT SYSTEM

</div>

<!-- /.main-page -->

</div>

<!-- /.content-container -->

</div>

<!-- /.content-wrapper -->

</div>

<!-- /.main-wrapper -->

<!-- ========== COMMON JS FILES ========== -->

<script src="js/jquery/jquery-2.2.4.min.js"></script>

<script src="js/jquery-ui/jquery-ui.min.js"></script>

<script src="js/bootstrap/bootstrap.min.js"></script>

<script src="js/pace/pace.min.js"></script>

<script src="js/lobipanel/lobipanel.min.js"></script>

<script src="js/iscroll/iscroll.js"></script>

<!-- ========== PAGE JS FILES ========== -->

<script src="js/prism/prism.js"></script>

<!-- ========== THEME JS ========== -->

<script src="js/main.js"></script>

DEPT OF BCA, HKBKDC Page 68


STUDENT RESULT MANAGEMENT SYSTEM

<!-- ========== ADD custom.js FILE BELOW WITH YOUR CHANGES ==========
-->

</body>

</html>

<?php } ?>-------------------create class---------------------

<?php

session_start();

error_reporting(0);

include('includes/config.php');

if(strlen($_SESSION['alogin'])=="")

header("Location: index.php");

else{

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

$sid=intval($_GET['subjectid']);

$subjectname=$_POST['subjectname'];

$subjectcode=$_POST['subjectcode'];

$sql="update tblsubjects set SubjectName=:subjectname,SubjectCode=:subjectcode where


id=:sid";

DEPT OF BCA, HKBKDC Page 69


STUDENT RESULT MANAGEMENT SYSTEM

$query = $dbh->prepare($sql);

$query->bindParam(':subjectname',$subjectname,PDO::PARAM_STR);

$query->bindParam(':subjectcode',$subjectcode,PDO::PARAM_STR);

$query->bindParam(':sid',$sid,PDO::PARAM_STR);

$query->execute();

$msg="Subject Info updated successfully";

?>

<!DOCTYPE html>

<html lang="en">

<head>

<meta charset="utf-8">

<meta http-equiv="X-UA-Compatible" content="IE=edge">

<meta name="viewport" content="width=device-width, initial-scale=1">

<title>SMS Admin Update Subject </title>

<link rel="stylesheet" href="css/bootstrap.min.css" media="screen" >

<link rel="stylesheet" href="css/font-awesome.min.css" media="screen" >

<link rel="stylesheet" href="css/animate-css/animate.min.css" media="screen" >

<link rel="stylesheet" href="css/lobipanel/lobipanel.min.css" media="screen" >

<link rel="stylesheet" href="css/prism/prism.css" media="screen" >

<link rel="stylesheet" href="css/select2/select2.min.css" >

<link rel="stylesheet" href="css/main.css" media="screen" >

<script src="js/modernizr/modernizr.min.js"></script>

</head>

<body class="top-navbar-fixed">

DEPT OF BCA, HKBKDC Page 70


STUDENT RESULT MANAGEMENT SYSTEM

<div class="main-wrapper">

<!-- ========== TOP NAVBAR ========== -->

<?php include('includes/topbar.php');?>

<!-- ========== WRAPPER FOR BOTH SIDEBARS & MAIN CONTENT


========== -->

<div class="content-wrapper">

<div class="content-container">

<!-- ========== LEFT SIDEBAR ========== -->

<?php include('includes/leftbar.php');?>

<!-- /.left-sidebar -->

<div class="main-page">

<div class="container-fluid">

<div class="row page-title-div">

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

<h2 class="title">Update Subject</h2>

</div>

<!-- /.col-md-6 text-right -->

</div>

<!-- /.row -->

DEPT OF BCA, HKBKDC Page 71


STUDENT RESULT MANAGEMENT SYSTEM

<div class="row breadcrumb-div">

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

<ul class="breadcrumb">

<li><a href="dashboard.php"><i class="fa fa-home"></i>


Home</a></li>

<li> Subjects</li>

<li class="active">Update Subject</li>

</ul>

</div>

</div>

<!-- /.row -->

</div>

<div class="container-fluid">

<div class="row">

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

<div class="panel">

<div class="panel-heading">

<div class="panel-title">

<h5>Update Subject</h5>

</div>

</div>

<div class="panel-body">

<?php if($msg){?>

DEPT OF BCA, HKBKDC Page 72


STUDENT RESULT MANAGEMENT SYSTEM

<div class="alert alert-success left-icon-alert" role="alert">

<strong>Well done!</strong><?php echo htmlentities($msg); ?>

</div><?php }

else if($error){?>

<div class="alert alert-danger left-icon-alert" role="alert">

<strong>Oh snap!</strong> <?php echo htmlentities($error); ?>

</div>

<?php } ?>

<form class="form-horizontal" method="post">

<?php

$sid=intval($_GET['subjectid']);

$sql = "SELECT * from tblsubjects where id=:sid";

$query = $dbh->prepare($sql);

$query->bindParam(':sid',$sid,PDO::PARAM_STR);

$query->execute();

$results=$query->fetchAll(PDO::FETCH_OBJ);

$cnt=1;

if($query->rowCount() > 0)

foreach($results as $result)

{ ?>

<div class="form-group">

<label for="default" class="col-sm-2 control-label">Subject


Name</label>

DEPT OF BCA, HKBKDC Page 73


STUDENT RESULT MANAGEMENT SYSTEM

<div class="col-sm-10">

<input type="text" name="subjectname" value="<?php echo htmlentities($result-


>SubjectName);?>" class="form-control" id="default" placeholder="Subject Name"
required="required">

</div>

</div>

<div class="form-group">

<label for="default" class="col-sm-2 control-label">Subject


Code</label>

<div class="col-sm-10">

<input type="text" name="subjectcode" class="form-control" value="<?php echo


htmlentities($result->SubjectCode);?>" id="default" placeholder="Subject Code"
required="required">

</div>

</div>

<?php }} ?>

<div class="form-group">

<div class="col-sm-offset-2 col-sm-10">

<button type="submit" name="Update" class="btn btn-


primary">Update</button>

</div>

</div>

</form>

DEPT OF BCA, HKBKDC Page 74


STUDENT RESULT MANAGEMENT SYSTEM

</div>

</div>

</div>

<!-- /.col-md-12 -->

</div>

</div>

</div>

<!-- /.content-container -->

</div>

<!-- /.content-wrapper -->

</div>

<!-- /.main-wrapper -->

<script src="js/jquery/jquery-2.2.4.min.js"></script>

<script src="js/bootstrap/bootstrap.min.js"></script>

<script src="js/pace/pace.min.js"></script>

<script src="js/lobipanel/lobipanel.min.js"></script>

<script src="js/iscroll/iscroll.js"></script>

<script src="js/prism/prism.js"></script>

<script src="js/select2/select2.min.js"></script>

<script src="js/main.js"></script>

<script>

$(function($) {

$(".js-states").select2();

$(".js-states-limit").select2({

maximumSelectionLength: 2

DEPT OF BCA, HKBKDC Page 75


STUDENT RESULT MANAGEMENT SYSTEM

});

$(".js-states-hide").select2({

minimumResultsForSearch: Infinity

});

});

</script>

</body>

</html>

<?PHP } ?>------------class sub----------------------------

<?php

session_start();

error_reporting(0);

include('includes/config.php');

if(strlen($_SESSION['alogin'])=="")

header("Location: index.php");

else{

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

$sid=intval($_GET['subjectid']);

$subjectname=$_POST['subjectname'];

$subjectcode=$_POST['subjectcode'];

DEPT OF BCA, HKBKDC Page 76


STUDENT RESULT MANAGEMENT SYSTEM

$sql="update tblsubjects set SubjectName=:subjectname,SubjectCode=:subjectcode where


id=:sid";

$query = $dbh->prepare($sql);

$query->bindParam(':subjectname',$subjectname,PDO::PARAM_STR);

$query->bindParam(':subjectcode',$subjectcode,PDO::PARAM_STR);

$query->bindParam(':sid',$sid,PDO::PARAM_STR);

$query->execute();

$msg="Subject Info updated successfully";

?>

<!DOCTYPE html>

<html lang="en">

<head>

<meta charset="utf-8">

<meta http-equiv="X-UA-Compatible" content="IE=edge">

<meta name="viewport" content="width=device-width, initial-scale=1">

<title>SMS Admin Update Subject </title>

<link rel="stylesheet" href="css/bootstrap.min.css" media="screen" >

<link rel="stylesheet" href="css/font-awesome.min.css" media="screen" >

<link rel="stylesheet" href="css/animate-css/animate.min.css" media="screen" >

<link rel="stylesheet" href="css/lobipanel/lobipanel.min.css" media="screen" >

<link rel="stylesheet" href="css/prism/prism.css" media="screen" >

<link rel="stylesheet" href="css/select2/select2.min.css" >

<link rel="stylesheet" href="css/main.css" media="screen" >

<script src="js/modernizr/modernizr.min.js"></script>

DEPT OF BCA, HKBKDC Page 77


STUDENT RESULT MANAGEMENT SYSTEM

</head>

<body class="top-navbar-fixed">

<div class="main-wrapper">

<!-- ========== TOP NAVBAR ========== -->

<?php include('includes/topbar.php');?>

<!-- ========== WRAPPER FOR BOTH SIDEBARS & MAIN CONTENT


========== -->

<div class="content-wrapper">

<div class="content-container">

<!-- ========== LEFT SIDEBAR ========== -->

<?php include('includes/leftbar.php');?>

<!-- /.left-sidebar -->

<div class="main-page">

<div class="container-fluid">

<div class="row page-title-div">

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

<h2 class="title">Update Subject</h2>

</div>

<!-- /.col-md-6 text-right -->

DEPT OF BCA, HKBKDC Page 78


STUDENT RESULT MANAGEMENT SYSTEM

</div>

<!-- /.row -->

<div class="row breadcrumb-div">

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

<ul class="breadcrumb">

<li><a href="dashboard.php"><i class="fa fa-home"></i>


Home</a></li>

<li> Subjects</li>

<li class="active">Update Subject</li>

</ul>

</div>

</div>

<!-- /.row -->

</div>

<div class="container-fluid">

<div class="row">

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

<div class="panel">

<div class="panel-heading">

<div class="panel-title">

<h5>Update Subject</h5>

</div>

</div>

DEPT OF BCA, HKBKDC Page 79


STUDENT RESULT MANAGEMENT SYSTEM

<div class="panel-body">

<?php if($msg){?>

<div class="alert alert-success left-icon-alert" role="alert">

<strong>Well done!</strong><?php echo htmlentities($msg); ?>

</div><?php }

else if($error){?>

<div class="alert alert-danger left-icon-alert" role="alert">

<strong>Oh snap!</strong> <?php echo htmlentities($error); ?>

</div>

<?php } ?>

<form class="form-horizontal" method="post">

<?php

$sid=intval($_GET['subjectid']);

$sql = "SELECT * from tblsubjects where id=:sid";

$query = $dbh->prepare($sql);

$query->bindParam(':sid',$sid,PDO::PARAM_STR);

$query->execute();

$results=$query->fetchAll(PDO::FETCH_OBJ);

$cnt=1;

if($query->rowCount() > 0)

foreach($results as $result)

{ ?>

<div class="form-group">

DEPT OF BCA, HKBKDC Page 80


STUDENT RESULT MANAGEMENT SYSTEM

<label for="default" class="col-sm-2 control-label">Subject


Name</label>

<div class="col-sm-10">

<input type="text" name="subjectname" value="<?php echo htmlentities($result-


>SubjectName);?>" class="form-control" id="default" placeholder="Subject Name"
required="required">

</div>

</div>

<div class="form-group">

<label for="default" class="col-sm-2 control-label">Subject


Code</label>

<div class="col-sm-10">

<input type="text" name="subjectcode" class="form-control" value="<?php echo


htmlentities($result->SubjectCode);?>" id="default" placeholder="Subject Code"
required="required">

</div>

</div>

<?php }} ?>

<div class="form-group">

<div class="col-sm-offset-2 col-sm-10">

<button type="submit" name="Update" class="btn btn-


primary">Update</button>

</div>

</div>

DEPT OF BCA, HKBKDC Page 81


STUDENT RESULT MANAGEMENT SYSTEM

</form>

</div>

</div>

</div>

<!-- /.col-md-12 -->

</div>

</div>

</div>

<!-- /.content-container -->

</div>

<!-- /.content-wrapper -->

</div>

<!-- /.main-wrapper -->

<script src="js/jquery/jquery-2.2.4.min.js"></script>

<script src="js/bootstrap/bootstrap.min.js"></script>

<script src="js/pace/pace.min.js"></script>

<script src="js/lobipanel/lobipanel.min.js"></script>

<script src="js/iscroll/iscroll.js"></script>

<script src="js/prism/prism.js"></script>

<script src="js/select2/select2.min.js"></script>

<script src="js/main.js"></script>

<script>

$(function($) {

$(".js-states").select2();

DEPT OF BCA, HKBKDC Page 82


STUDENT RESULT MANAGEMENT SYSTEM

$(".js-states-limit").select2({

maximumSelectionLength: 2

});

$(".js-states-hide").select2({

minimumResultsForSearch: Infinity

});

});

</script>

</body>

</html>

<?PHP } ?>------------------add stud-------------------

<?php

session_start();

//error_reporting(0);

include('includes/config.php');?>

<!DOCTYPE html>

<html lang="en">

<head>

<meta charset="utf-8">

<meta http-equiv="X-UA-Compatible" content="IE=edge">

<meta name="viewport" content="width=device-width, initial-scale=1">

<title>School Result Management System</title>

<link rel="stylesheet" href="css/bootstrap.min.css" media="screen" >

<link rel="stylesheet" href="css/font-awesome.min.css" media="screen" >

DEPT OF BCA, HKBKDC Page 83


STUDENT RESULT MANAGEMENT SYSTEM

<link rel="stylesheet" href="css/animate-css/animate.min.css" media="screen" >

<link rel="stylesheet" href="css/icheck/skins/flat/blue.css" >

<link rel="stylesheet" href="css/main.css" media="screen" >

<script src="js/modernizr/modernizr.min.js"></script>

</head>

<body class="">

<div class="main-wrapper">

<div class="login-bg-color bg-black-300">

<div class="row">

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

<div class="panel login-box">

<div class="panel-heading">

<div class="panel-title text-center">

<h4>School Result Management System</h4>

</div>

</div>

<div class="panel-body p-20">

<form action="result.php" method="post">

<div class="form-group">

<label for="rollid">Enter your Roll Id</label>

DEPT OF BCA, HKBKDC Page 84


STUDENT RESULT MANAGEMENT SYSTEM

<input type="text" class="form-control" id="rollid" placeholder="Enter


Your Roll Id" autocomplete="off" name="rollid">

</div>

<div class="form-group">

<label for="default" class="col-sm-2 control-


label">Class</label>

<select name="class" class="form-control" id="default" required="required">

<option value="">Select Class</option>

<?php $sql = "SELECT * from tblclasses";

$query = $dbh->prepare($sql);

$query->execute();

$results=$query->fetchAll(PDO::FETCH_OBJ);

if($query->rowCount() > 0)

foreach($results as $result)

{ ?>

<option value="<?php echo htmlentities($result->id); ?>"><?php echo htmlentities($result-


>ClassName); ?>&nbsp; Section-<?php echo htmlentities($result->Section); ?></option>

<?php }} ?>

</select>

</div>

<div class="form-group mt-20">

<div class="">

DEPT OF BCA, HKBKDC Page 85


STUDENT RESULT MANAGEMENT SYSTEM

<button type="submit" class="btn btn-success btn-labeled pull-


right">Search<span class="btn-label btn-label-right"><i class="fa fa-
check"></i></span></button>

<div class="clearfix"></div>

</div>

</div>

<div class="col-sm-6">

<a href="index.php">Back to Home</a>

</div>

</form>

<hr>

</div>

</div>

<!-- /.panel -->

<p class="text-muted text-center"><small>Student Result Management


System</small></p>

</div>

<!-- /.col-md-6 col-md-offset-3 -->

</div>

<!-- /.row -->

</div>

<!-- /. -->

DEPT OF BCA, HKBKDC Page 86


STUDENT RESULT MANAGEMENT SYSTEM

</div>

<!-- /.main-wrapper -->

<!-- ========== COMMON JS FILES ========== -->

<script src="js/jquery/jquery-2.2.4.min.js"></script>

<script src="js/jquery-ui/jquery-ui.min.js"></script>

<script src="js/bootstrap/bootstrap.min.js"></script>

<script src="js/pace/pace.min.js"></script>

<script src="js/lobipanel/lobipanel.min.js"></script>

<script src="js/iscroll/iscroll.js"></script>

<!-- ========== PAGE JS FILES ========== -->

<script src="js/icheck/icheck.min.js"></script>

<!-- ========== THEME JS ========== -->

<script src="js/main.js"></script>

<script>

$(function(){

$('input.flat-blue-style').iCheck({

checkboxClass: 'icheckbox_flat-blue'

});

});

</script>

DEPT OF BCA, HKBKDC Page 87


STUDENT RESULT MANAGEMENT SYSTEM

<!-- ========== ADD custom.js FILE BELOW WITH YOUR CHANGES ==========
-->

</body>

</html>------------------find result-----------------

<?php

session_start();

error_reporting(0);

include('includes/config.php');

if(strlen($_SESSION['alogin'])=="")

header("Location: index.php");

else{

?>

<!DOCTYPE html>

<html lang="en">

<head>

<meta charset="utf-8">

<meta http-equiv="X-UA-Compatible" content="IE=edge">

<meta name="viewport" content="width=device-width, initial-scale=1">

<title>Admin Manage Students</title>

<link rel="stylesheet" href="css/bootstrap.min.css" media="screen" >

DEPT OF BCA, HKBKDC Page 88


STUDENT RESULT MANAGEMENT SYSTEM

<link rel="stylesheet" href="css/font-awesome.min.css" media="screen" >

<link rel="stylesheet" href="css/animate-css/animate.min.css" media="screen" >

<link rel="stylesheet" href="css/lobipanel/lobipanel.min.css" media="screen" >

<link rel="stylesheet" href="css/prism/prism.css" media="screen" > <!-- USED FOR DEMO


HELP - YOU CAN REMOVE IT -->

<link rel="stylesheet" type="text/css" href="js/DataTables/datatables.min.css"/>

<link rel="stylesheet" href="css/main.css" media="screen" >

<script src="js/modernizr/modernizr.min.js"></script>

<style>

.errorWrap {

padding: 10px;

margin: 0 0 20px 0;

background: #fff;

border-left: 4px solid #dd3d36;

-webkit-box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);

box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);

.succWrap{

padding: 10px;

margin: 0 0 20px 0;

background: #fff;

border-left: 4px solid #5cb85c;

-webkit-box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);

box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);

DEPT OF BCA, HKBKDC Page 89


STUDENT RESULT MANAGEMENT SYSTEM

</style>

</head>

<body class="top-navbar-fixed">

<div class="main-wrapper">

<!-- ========== TOP NAVBAR ========== -->

<?php include('includes/topbar.php');?>

<!-- ========== WRAPPER FOR BOTH SIDEBARS & MAIN CONTENT


========== -->

<div class="content-wrapper">

<div class="content-container">

<?php include('includes/leftbar.php');?>

<div class="main-page">

<div class="container-fluid">

<div class="row page-title-div">

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

<h2 class="title">Manage Results</h2>

</div>

<!-- /.col-md-6 text-right -->

</div>

<!-- /.row -->

<div class="row breadcrumb-div">

DEPT OF BCA, HKBKDC Page 90


STUDENT RESULT MANAGEMENT SYSTEM

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

<ul class="breadcrumb">

<li><a href="dashboard.php"><i
class="fa fa-home"></i> Home</a></li>

<li> Results</li>

<li class="active">Manage
Results</li>

</ul>

</div>

</div>

<!-- /.row -->

</div>

<!-- /.container-fluid -->

<section class="section">

<div class="container-fluid">

<div class="row">

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

<div class="panel">

<div class="panel-heading">

DEPT OF BCA, HKBKDC Page 91


STUDENT RESULT MANAGEMENT SYSTEM

<div class="panel-title">

<h5>View Students Result Info</h5>

</div>

</div>

<?php if($msg){?>

<div class="alert alert-success left-icon-alert" role="alert">

<strong>Well done!</strong><?php echo htmlentities($msg); ?>

</div><?php }

else if($error){?>

<div class="alert alert-danger left-icon-alert" role="alert">

<strong>Oh snap!</strong> <?php echo htmlentities($error); ?>

</div>

<?php } ?>

<div class="panel-body p-20">

<table id="example" class="display table table-striped table-


bordered" cellspacing="0" width="100%">

<thead>

<tr>

<th>#</th>

<th>Student Name</th>

<th>Roll Id</th>

<th>Class</th>

<th>Reg Date</th>

<th>Status</th>

DEPT OF BCA, HKBKDC Page 92


STUDENT RESULT MANAGEMENT SYSTEM

<th>Action</th>

</tr>

</thead>

<tfoot>

<tr>

<th>#</th>

<th>Student Name</th>

<th>Roll Id</th>

<th>Class</th>

<th>Reg Date</th>

<th>Status</th>

<th>Action</th>

</tr>

</tfoot>

<tbody>

<?php $sql = "SELECT distinct


tblstudents.StudentName,tblstudents.RollId,tblstudents.RegDate,tblstudents.StudentId,tblstudent
s.Status,tblclasses.ClassName,tblclasses.Section from tblresult join tblstudents on
tblstudents.StudentId=tblresult.StudentId join tblclasses on tblclasses.id=tblresult.ClassId";

$query = $dbh->prepare($sql);

$query->execute();

$results=$query->fetchAll(PDO::FETCH_OBJ);

$cnt=1;

if($query->rowCount() > 0)

foreach($results as $result)

DEPT OF BCA, HKBKDC Page 93


STUDENT RESULT MANAGEMENT SYSTEM

{ ?>

<tr>

<td><?php echo htmlentities($cnt);?></td>

<td><?php echo htmlentities($result-


>StudentName);?></td>

<td><?php echo htmlentities($result->RollId);?></td>

<td><?php echo htmlentities($result-


>ClassName);?>(<?php echo htmlentities($result->Section);?>)</td>

<td><?php echo htmlentities($result->RegDate);?></td>

<td><?php if($result->Status==1){

echo htmlentities('Active');

else{

echo htmlentities('Blocked');

?></td>

<td>

<a href="edit-result.php?stid=<?php echo htmlentities($result->StudentId);?>"><i class="fa fa-


edit" title="Edit Record"></i> </a>

</td>

</tr>

<?php $cnt=$cnt+1;}} ?>

</tbody>

DEPT OF BCA, HKBKDC Page 94


STUDENT RESULT MANAGEMENT SYSTEM

</table>

<!-- /.col-md-12 -->

</div>

</div>

</div>

<!-- /.col-md-6 -->

</div>

<!-- /.col-md-12 -->

</div>

</div>

<!-- /.panel -->

</div>

<!-- /.col-md-6 -->

</div>

<!-- /.row -->

</div>

<!-- /.container-fluid -->

</section>

<!-- /.section -->

DEPT OF BCA, HKBKDC Page 95


STUDENT RESULT MANAGEMENT SYSTEM

</div>

<!-- /.main-page -->

</div>

<!-- /.content-container -->

</div>

<!-- /.content-wrapper -->

</div>

<!-- /.main-wrapper -->

<!-- ========== COMMON JS FILES ========== -->

<script src="js/jquery/jquery-2.2.4.min.js"></script>

<script src="js/bootstrap/bootstrap.min.js"></script>

<script src="js/pace/pace.min.js"></script>

<script src="js/lobipanel/lobipanel.min.js"></script>

<script src="js/iscroll/iscroll.js"></script>

<!-- ========== PAGE JS FILES ========== -->

<script src="js/prism/prism.js"></script>

<script src="js/DataTables/datatables.min.js"></script>

<!-- ========== THEME JS ========== -->

<script src="js/main.js"></script>

DEPT OF BCA, HKBKDC Page 96


STUDENT RESULT MANAGEMENT SYSTEM

<script>

$(function($) {

$('#example').DataTable();

$('#example2').DataTable( {

"scrollY": "300px",

"scrollCollapse": true,

"paging": false

} );

$('#example3').DataTable();

});

</script>

</body>

</html>

<?php } ?>

-----------------------------manage result--------------------

<?php

error_reporting(0);

include('includes/config.php');

?>

<!DOCTYPE html>

<html lang="en">

DEPT OF BCA, HKBKDC Page 97


STUDENT RESULT MANAGEMENT SYSTEM

<head>

<meta charset="utf-8" />

<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />

<meta name="description" content="" />

<meta name="author" content="" />

<title>Student Result Management System</title>

<!-- Favicon-->

<link rel="icon" type="image/x-icon" href="assets/favicon.ico" />

<!-- Core theme CSS (includes Bootstrap)-->

<link href="css/styles.css" rel="stylesheet" />

</head>

<body>

<!-- Responsive navbar-->

<nav class="navbar navbar-expand-lg navbar-dark bg-dark">

<div class="container">

<a class="navbar-brand" href="index.php">SRMS-(Student Result Management


System)</a>

<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-


target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-
expanded="false" aria-label="Toggle navigation"><span class="navbar-toggler-
icon"></span></button>

<div class="collapse navbar-collapse" id="navbarSupportedContent">

<ul class="navbar-nav ms-auto mb-2 mb-lg-0">

<li class="nav-item"><a class="nav-link active" aria-current="page"


href="#!">Home</a></li>

DEPT OF BCA, HKBKDC Page 98


STUDENT RESULT MANAGEMENT SYSTEM

<li class="nav-item"><a class="nav-link active" href="find-


result.php">Students</a></li>

<li class="nav-item"><a class="nav-link active" href="admin-


login.php">Admin</a></li>

</ul>

</div>

</div>

</nav>

<!-- Header - set the background image for the header in the line below-->

<!-- Content section-->

<section class="py-5">

<div class="container my-5">

<div class="row justify-content-center">

<div class="col-lg-10">

<?php

$noticeid=$_GET['nid'];

$sql = "SELECT * from tblnotice where id='$noticeid'";

$query = $dbh->prepare($sql);

$query->execute();

$results=$query->fetchAll(PDO::FETCH_OBJ);

$cnt=1;

if($query->rowCount() > 0)

DEPT OF BCA, HKBKDC Page 99


STUDENT RESULT MANAGEMENT SYSTEM

foreach($results as $result)

{ ?>

<h3><?php echo htmlentities($result->noticeTitle);?></h3>

<p><strong>Notice Posting Date:</strong> <?php echo htmlentities($result-


>postingDate);?></p>

<hr color="#000" />

<p><?php echo htmlentities($result->noticeDetails);?></p>

<?php }} ?>

</div>

</div>

</div>

</section>

<!-- Footer-->

<footer class="py-5 bg-dark">

<div class="container"><p class="m-0 text-center text-white">Copyright &copy; Student


Result Management System <?php echo date('Y');?></p></div>

</footer>

<!-- Bootstrap core JS-->

<script
src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js"></script>

<!-- Core theme JS-->

<script src="js/scripts.js"></script>

</body>

</html>-----------------notices-----------------------------

DEPT OF BCA, HKBKDC Page 100


STUDENT RESULT MANAGEMENT SYSTEM

10. SNAPSHOTS
Home page

Student Result login

DEPT OF BCA, HKBKDC Page 101


STUDENT RESULT MANAGEMENT SYSTEM

Student Result Details

Student Result print

DEPT OF BCA, HKBKDC Page 102


STUDENT RESULT MANAGEMENT SYSTEM

Admin Login

Admin Dashboard

Create Student Class

DEPT OF BCA, HKBKDC Page 103


STUDENT RESULT MANAGEMENT SYSTEM

Manage classes

Admission Of New Student

DEPT OF BCA, HKBKDC Page 104


STUDENT RESULT MANAGEMENT SYSTEM

Manage Students

Declaring Result

DEPT OF BCA, HKBKDC Page 105


STUDENT RESULT MANAGEMENT SYSTEM

Manage Results

DEPT OF BCA, HKBKDC Page 106


STUDENT RESULT MANAGEMENT SYSTEM

11. SYSTEM TESTING

11.1 TESTING

Testing is the process of validation of evaluation a software item to detect difference between
given input & expected output. Also to access the feature of a software item. Testing assesses
the quality of the product. Software testing is a process that should be done during the
development process. In other words software testing is a verification & validation process.

System Testing is an important stage in any system development lifecycle. Testing is a process
of executing a program with the intention of finding errors. The importance of software testing
and its implications with respect to software quality cannot be over emphasized. Software
testing is a critical element of software quality assurance and represents the ultimate review
of specification, design and coding. A good test case is one that has a high probability of
finding a yet undiscovered error. Testing is set of activities that can be planned in advance
and conducted systematically Different test conditions should be thoroughly checked and the
bugs detected should be fixed. The testing strategies formed by the user are performed to
prove that the software is free and clear from errors.

Types of Testing:
 Unit Testing
 Integration Testing
 Functional Testing
 System Testing
 Performance Testing
 Acceptance Testing

Unit Testing:

DEPT OF BCA, HKBKDC Page 107


STUDENT RESULT MANAGEMENT SYSTEM

Unit testing is the testing of an individual unit or group of related units. It falls under the class
of white box testing. It is often done by the programmer to test that the unit he/she has
implemented is producing expected output against given input.
Integration Testing:
Integration testing is a testing in which a group of components are combined to produce
output. Also, the interaction between software & hardware is tested in integration testing if
software & hardware components have any relation. It may fall under both white box & black
box testing.

Functional Testing:
Functional testing is the testing to ensure that the specified functionality required in the system
requirements works. It falls under the class of black box testing.

System Testing:
System testing is the testing to ensure that by putting the software in different environments
(e.g. Operating Systems) it still works. System testing is done with full system
implementations & environment. It falls under the class of black box testing.

Performance Testing:
Performance testing is the testing to assess the speed & effectiveness of the system & to make
sure it is generating results within a specified time as in performance requirements. It falls
under the class of black box testing.

Acceptance Testing:
Acceptance testing is often done by the customer to ensure that the delivered product meets
the requirements & works as the customer expected. It falls under the class of black box
testing.

11.2 BLACK BOX TESTING

DEPT OF BCA, HKBKDC Page 108


STUDENT RESULT MANAGEMENT SYSTEM

Black Box testing, also known as Behavioral Testing, is a software testing method in which
the internal structure/design/implementations of the item being tested is not known to the
tester. These tests can be functional or non-functional, through usually functional.

This method is named so because the software program, in the eyes of the tester, is like a black
box, inside which one cannot see.

Black box testing is contrasted with white box testing. View differences between black box
& white box testing.
 Incorrect or missing functions.
 Interfaces errors.
 Errors in data structures or external database access.
 Behavior or performance errors.
 Initialization & termination errors.

Advantages:

 Tests are done from user's point of view & will help in exposing discrepancies in the
specifications
 Tester need not know programming languages or how the software has been implemented.
 Tests can be conducted by a body independent from the developers, allowing for an
objective perspective & the avoidance of developer bias.
 Test cases can be designed as soon as the specifications are complete.

Disadvantages:

 Only a small number of possible inputs can be tested & many program paths will be left
untested.
 Without a clear specification which is the situation in many projects, test cases will be
difficult to design.
 Tests can be redundant if the software designer/developer has already run a test case.

DEPT OF BCA, HKBKDC Page 109


STUDENT RESULT MANAGEMENT SYSTEM

11.3 WHITE BOX TESTING

White Box Testing also known as clear box testing, open box testing, is a software testing
method in which the internal structure/design/implementation of the item being tested is
known to the tester.

The tester chooses inputs to exercise paths through the code & determines the appropriate
outputs. Programming knows how & the implementation knowledge is essential. White box
testing is testing beyond the user interfaces & into the nitty-gritty of a system.

The method is named so because the software program, in the eyes of the tester, is like a
white/transparent box, inside which one clearly sees.

Advantages:

 Testing can be commenced at an earlier stage. One need not wait for the GUI to be
available.
 Testing is more through, with the possibility of covering most paths.

Disadvantages:

 Since tests can be very complex, highly skilled resources are required, with through
knowledge of programming & implementation.
 It is like the work of a mechanic who examines the engine to see why the car is not moving.

DEPT OF BCA, HKBKDC Page 110


STUDENT RESULT MANAGEMENT SYSTEM

11. FUTURE ENHANCEMENT


The current application developed is in accordance with the need that has been studied. On
regarding the future enhancement, the application can further expanded in accordance with
changing scenario. Since the change in testing and user needs arises frequently in certain
short intervals of time, the application can be further upgraded to meet the requirements that
may arise in the far or near future. With regarding to the needs that arises, more and more
features can be included by adding it as separate modules and integrate it with the existing
system.

One of PHP's strengths is its richness in terms of functionality. Indeed, it has at the origin of
more than 3,000 native features ready-guaranteeing developers to overcome additional
development time and sometimes tedious. These functions among others to treat strings, to
operate mathematically on numbers, convert dates to connect to a database system,
manipulate files present on the server...
So the scope of future enhancement is absolutely clear with the concept that is incorporated
in the today that was made used to build the application.

12. CONCLUSION
The Student Result Management System is an online website and can be used at any place,
any time and by any student or faculty. This application will avoid the calculation and simplify
the process of visualizing results by students as well as faculty.

The processing of the proposed system is simple and is in regular order. The various plans
employed in the project are user friendly and easy to understand. The system was effective
and efficient in the estimate generation process.

DEPT OF BCA, HKBKDC Page 111


STUDENT RESULT MANAGEMENT SYSTEM

13. BIBLIOGRAPH
WEBSITES:

 http://www.php.net/

 https://www.guru99.com/php-tutorials.html

 http://www.java2s.com

 http://www.tutorialtpoint.com

DEPT OF BCA, HKBKDC Page 112

You might also like