Nothing Special   »   [go: up one dir, main page]

St. Thomas' College of Engineering and Technology

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

 

          St.  Thomas’  College  of  Engineering  and  Technology


   
 

             

           

        PROJECT TITLE
Prepared by
Student  Name  :  Prateek  Bajpai                                                                                        University  Registration  No: 12200216030  

Student  Name  :  Shivam  Harsh                                                                                            University  Registration  No: 12200216012

Student  Name  :  Rishav  Pandey                                    University  Registration  No: 12200216026  

   

Under  the  guidance  of  

                           Ms.  Sanchita  Saha  Ray  

Assistant  Professor,  Information  Technology  

Project Report
Submitted  in  the  partial  fulfilment  of  the  requirement  for  the  degree  of  B.Tech  in  Information  
Technology  

Department  of  Information  Technology  

Affiliated  to  

Maulana  Abul  Kalam  Azad  University  of  Technology,  West  Bengal  

             June,  202X  

   

Department  of  Information  Technology     I  


 
            St.  Thomas’  College  of  Engineering  and  Technology
   
 

This is to certify that the work in preparing the project entitled “Project_Title” has been carried out
by Prateek Bajpai , Shivam Harsh and Rishav Pandey under my guidance during the session 2020-21
and accepted in partial fulfillment of the requirement for the degree of Bachelor Of Technology.

   

   

Signature Signature
Dr. Arindam Chakraborty Ms. Sanchita Saharay

Head, Department of Information Technology Department of Information Technology

   

Department  of  Information  Technology     II  


 
            St.  Thomas’  College  of  Engineering  and  Technology
   
 

    Acknowledgement
 

We have taken efforts in this project. However, it would not have been possible without the
kind support and help of many individuals and organizations. We would like to extend our
sincere thanks to all of them.

We are highly indebted to xxxxxx for her guidance and constant supervision as well as for
providing necessary information regarding the project & also for her support in completing
the project.

We would like to express our gratitude towards our parents & members of St. Thomas’
College Of Engineering and Technology for their kind co-operation and encouragement
which helped us in completion of this project.

Department  of  Information  Technology     III  


 
            St.  Thomas’  College  of  Engineering  and  Technology
   
 

Vision & Mission ( St. Thomas’ College of Engineering &


Technology )

Vision

To evolve itself into an industry oriented research based recognized hub of creative solutions
in various fields of engineering by establishing progressive teaching learning process with an
ultimate objective of meeting technological challenges faced by the nation and the society.

Mission

▪ To create opportunities for students and faculty members in acquiring professional


knowledge and developing social attitudes with ethical and moral values.

▪ To enhance the quality of engineering education through accessible, comprehensive,


industry and research-oriented teaching-learning process.

▪ To satisfy the ever-changing needs of the nation for evolution and absorption of
sustainable and environment friendly technologies.

Department  of  Information  Technology     IV  


 
            St.  Thomas’  College  of  Engineering  and  Technology
   
 

Vision & Mission ( Department of Information Technology )

Vision
To promote the advancement of learning in Information Technology through research
oriented dissemination of knowledge which will lead to innovative applications of
information in Industry and Society.

Mission

§ To incubate students grow into industry ready professionals, proficient research


scholars and enterprising entrepreneurs.
§ To create a learner- centric environment that motivates the students in adopting
emerging technologies of the rapidly changing information society.
§ To promote social, environmental and technological responsiveness among the
members of the faculty and students.

Program Educational Objectives (PEO)

Graduates of Information Technology Program shall

PEO1: Exhibit the skills and knowledge required to design, develop and implement IT
solutions for real life problems.

PEO2: Excel in professional career, higher education and research.

PEO3: Demonstrate professionalism, entrepreneurship, ethical behavior, communication


skills and collaborative team work to adapt the emerging trends by engaging in lifelong
learning.

Department  of  Information  Technology     V  


 
            St.  Thomas’  College  of  Engineering  and  Technology
   
 

PROGRAM  OUTCOMES  (POs)  


Engineering Graduates will be able to:
 
1. Engineering knowledge: Apply the knowledge of mathematics, science, engineering
fundamentals, and an engineering specialization to the solution of complex engineering
problems.  
 
2. Problem analysis: Identify, formulate, review research literature, and analyze complex
engineering problems reaching substantiated conclusions using first principles of
mathematics, natural sciences, and engineering sciences.  
 
3. Design/development of solutions: Design solutions for complex engineering problems
and design system components or processes that meet the specified needs with
appropriate consideration for the public health and safety, and the cultural, societal, and
environmental considerations.  
 
4. Conduct investigations of complex problems: Use research-based knowledge and
research methods including design of experiments, analysis and interpretation of data, and
synthesis of the information to provide valid conclusions.  
 
5. Modern tool usage: Create, select, and apply appropriate techniques, resources, and
modern engineering and IT tools including prediction and modeling to complex
engineering activities with an understanding of the limitations.  
 
6. The engineer and society: Apply reasoning informed by the contextual knowledge to
assess societal, health, safety, legal and cultural issues and the consequent responsibilities
relevant to the professional engineering practice.  
 
7. Environment and sustainability: Understand the impact of the professional engineering
solutions in societal and environmental contexts, and demonstrate the knowledge of, and
need for sustainable development.  
 
8. Ethics: Apply ethical principles and commit to professional ethics and responsibilities
and norms of the engineering practice.  
 

Department  of  Information  Technology     VI  


 
            St.  Thomas’  College  of  Engineering  and  Technology
   
 

9. Individual and team work: Function effectively as an individual, and as a member or


leader in diverse teams, and in multidisciplinary settings.  
 
10. Communication: Communicate effectively on complex engineering activities with the
engineering community and with society at large, such as, being able to comprehend and
write effective reports and design documentation, make effective presentations, and give
and receive clear instructions.  
 
11. Project management and finance: Demonstrate knowledge and understanding of the
engineering and management principles and apply these to one’s own work, as a member
and leader in a team, to manage projects and in multidisciplinary environments.  
 
12. Life-long learning: Recognize the need for, and have the preparation and ability to
engage in independent and life-long learning in the broadest context of technological
change.  

Department  of  Information  Technology     VII  


 
            St.  Thomas’  College  of  Engineering  and  Technology
   
 

Project Mapping with Program Outcomes  


 
 

PO1   PO2   PO3   PO4   PO5   PO6   PO7   PO8   PO9   PO10   PO11   PO12  

2   3   3   3   3   1   2   3   3   2   1   2  
 
Enter correlation levels 1, 2 or 3 as defined below:  
 
1: Slight (Low) 2: Moderate (Medium) 3: Substantial (High)  
 

Justification:

PO1: This project requires abundant engineering knowledge to normalize the tables, E-R
diagram, DFD and other DBMS approach in the front end and back end application.

PO2: This project involved a lot of step-wise planning and analysing of the problem put
before us.

PO3: The entire project revolves around its design and how we plan out the final schema.
Designing the layout of the modules as well as the structure of the database was dealt with in
this project.

PO4: Unique assumptions are implied to make the problem conflict free as you can refer
from…….

PO5: We have used modern tools of Xamp, PHP, MySQL, JavaScript, HTML, CSS in our
project to make compatible with latest versions.

PO6: This project benefits the college and its users to get detailed view of student for
different departments and semester sitting at their home. It allows the user to fill various
details of students and informs students and teachers with most recent changes in it.

Department  of  Information  Technology     VIII  


 
            St.  Thomas’  College  of  Engineering  and  Technology
   
 

PO7: Understanding the impact of the professional engineering solutions in societal and
environmental contexts was also required and necessary in this project.

PO8: This work is unique in its own. we have taken references from studied surveys but at
the same time we have added our unique features to make it different from the existing ones.
In case we have also mentioned the references used.

PO9: Working on this project together definitely taught us to function effectively as an


individual, and as a member or leader in diverse teams, and in multidisciplinary settings.

PO11: We got a chance to demonstrate knowledge and understanding of the engineering and
management principles and apply these to our project.  

PO12: Through this project we got a life long leaning of the modern tools we used along
with it way we can solve the complex problem to simple ones also counts in the life long
learning.

 
   
   
   
   
   
   
   
   

Department  of  Information  Technology     IX  


 
            St.  Thomas’  College  of  Engineering  and  Technology
   
 

Program Specific Outcomes (PSOs)  


 
At the end of the program the students will be able to  

PSO1 ( Programming ) : Apply the programming knowledge to build an efficient and


effective solution of the problem with an error free , well documented and reusable code,
user friendly interface and well organized database.  

PSO2 ( Multimedia Authoring ) : Create a multimedia product using proper metaphor,


designing effective navigation following human computer interface rules with proper
interactivity, which will be useful for educational , social and business purpose.  

PSO3 ( Software Engineering ) : Understand and analyze a big complex problem and
decompose it into relatively smaller and independent modules either algorithmically or in an
object oriented way choosing correct life cycle model and using effective test cases.  

Project Mapping with Program Specific Outcomes  

PSO1   PSO2   PSO3  

3   1   3  
 

Enter correlation levels 1, 2 or 3 as defined below:  


1: Slight (Low) 2: Moderate (Medium) 3: Substantial (High)
 

Justification:

PSO1: This project gave us a chance to apply the programming knowledge to build an efficient and
effective solution of the problem with an error free, well documented and reusable code.
The user interface was made as user friendly as it could be and the databases where designed so as to
reduce the complexity to the farthest level.

PSO2: This Project is designed to in such a way so that the users find it very friendly and can easily
interact with the software. The designs, texts and pictures are simple and easily identifiable. We
have not used a large amount of Multimedia in this web based project since it is an information
system but we strive to fulfil that in future.

PSO3: The very implementation of the project started by dividing the entire problem into various
smaller blocks. Starting from designing the database to implementing proper user interface,
everything was done in a procedural way by taking one small problem at a time.
 
     

Department  of  Information  Technology     X  


 
            St.  Thomas’  College  of  Engineering  and  Technology
   
 

Index
 

 Topic                                                                                                                                                                                                                                                                                  Page  No    


 Introduction.    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .      .    .    .    1  

Chapter  1                                                                                                                                                                                                                                      

1.1 Problem  Statement.    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .  .    2  


1.2 Problem  Definition    and  Assumption.    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    2  
1.3 Objective  .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    2  
1.4 Tools  and  Platform  .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .  .    .    .    .    .    3    
1.5 Brief  Discussion  on  Problem,  Background  Study  and  Timeline.    .    .    .    .    .    .    .    .    .    5    

Chapter  2  

         2.1  Statement.    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .  .  .  .    .  .  .  .  .  .  .  .  7    
         2.2 Proble.    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .  .  .  .    .  .  .  .  .  .  .  .    .  .  .  8  

Chapter  3    

         3.1  Statement.    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .  .  .  .    .  .  .  .  .  .  .  .  9  
         3.2 Problem.    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .  .  .  .    .  .  .  .  .  .  .  .  .  .  10  
         3.2  Design  and  Methodology.    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .  .  .  .  .  .  .  .  .  11  
 

Chapter  4    

         4.1  Sample  Codes.    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .  .  .  .  .  .  .  .  .  .    12  

Chapter  5    

             5.1  Testing,  Results,  Discussion  on  Results.    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .      .    .    .    .    .    18  


             5.2  Statement.    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .  .  .  .    .  .  .  .  .  .  .  .  19  
             5.3 Problem.    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .  .  .  .    .  .  .  .  .  .  .  .  .  .  20  
 
Chapter  6    

             6.1  Scope  for  future  improvement.    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .      .    .    .  23  

             6.2  Conclusion.    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .      .    .    .    .    .    24    

Annexure    

                           References  /Bibliography.    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .    .  25  

Department  of  Information  Technology     XI  


 
            St.  Thomas’  College  of  Engineering  and  Technology
   
 

Department  of  Information  Technology     XII  


 
 

Introduction

The manual system was vague and many times the data got lost or misplaced. It was a hectic
job for both the administration and teachers to do the manual entry of data. This led to the
more safe, secure, fast and automatic system named as Student Information System. It allows
the users to directly put the data in the software which will be safe and secure for a prolong
time until mishandled.
………………………. system has gained huge popularity in
the educational sector because of its unique characteristics which has helped countless
schools and higher educational institutes immensely. Right from maintaining and updating
student data with proficiency to analysing and creating reports, the education management
software has helped substantially.
A ………………………….. is a management information
system for education establishments to manage student data. Student information systems
provide capabilities for registering students in courses; documenting grading, transcripts,
results of student tests and other assessment scores; building student schedules; tracking
student attendance; and managing many other student-related data needs in a school.
Educational institutions were looking for a web-based solution such as a student information
system or an intelligent student information system with an inbuilt mechanism to meet the
requirements of student-related information management as well as to serve the purpose of a
school management system.

Department  of  Information  Technology     1  


 
 

1.1 Problem Statement:

“…………………….” means a software developed for the users where the users are mainly
Administrator, Teachers and Students. The system helps in storing of all the academic data of
each students’ in a systematic manner and also making the updation process as simple as
possible for the Teacher and the Administration.

1.2 Problem Definition:


In our synopsis, we shall present a novel approach to create such a web application which will
reduce the working load of Teacher as well as department administration.
• Teacher and administration can see and update the records of each students’ easily,
• Admin can generate the report of a student in just one click.
• Student can fill their MAR details by himself/herself.
• Student can see their marks and MAR points updated by their teachers.

ASSUMPTIONS:
• The ID and Password of Admin is already with him.
• Anyone cannot register themselves as a Student or Teacher.
• No one can update the student record but their respective subject teacher.
• A student can only see his or her marks.

1.3 Objectives:

• To provide an online platform where Teacher can update the attendance easily.

• Student can see the regular update of his/her marks &attendance.

• Administration can easily monitor the update of each student.

• Teacher can also update the marks and MAR points.

• It will reduce the complexity for the teacher.

• Teacher can only update the marks or attendance of his/her subject.

Department  of  Information  Technology     2  


 
 

1.4 Tools and Platform :

• Hardware/Software Requirement:-

Ø Hardware Requirement:-

1. Client Side:-
i. Device with active Internet.
2. Server Side:-
i. Pentium Core 2 Duo Processor or above
ii. 1 GB RAM
iii. Router For Internet Connection

Ø Software Requirement:-

1. Client Side:-
i. Any Browser.
                       2.Server  Side:-­‐  
i.  Windows 7 & above
ii . XAMPP Server (Apache,Mysql )
iii. Bracket

Department  of  Information  Technology     3  


 
 

• Tools used in the project are as follows:-

Frontend
1. HTML-Hypertext Mark-up Language is the standard mark-up language for documents
designed to be displayed in a web browser.
2. CSS-Cascading Style Sheets is a style sheet language used for describing the presentation of a
document written in a mark-up language like HTML.

3. BOOTSTRAP (Framework of CSS)-It is a free and open-source CSS framework directed at


responsive, mobile-first front-end web development.

4. JAVASCRIPT-In this project we use JS specially for validating the form.

Backend
1. PHP-The PHP Hypertext Pre-processor (PHP) is a programming language that allows web
developers to create dynamic content that interacts with databases.
2. MYSQL-MySQL is a database management system that allows you to manage relational
databases.

Brief description of some of our tools:


HTML:
HTML is the standard markup language for creating Web pages.
•HTML stands for Hyper Text Markup Language
•HTML describes the structure of Web pages using markup
•HTML elements are the building blocks of HTML pages
•HTML elements are represented by tags
•HTML tags label pieces of content such as "heading", "paragraph", "table", and so on
•Browsers do not display the HTML tags, but use them to render the content of the
page.
Different tags used in HTML are:-
•The<!DOCTYPE HTML>declaration defines this document to be HTML5
•The<HTML>element is the root element of an HTML page
•The<head>element contains meta information about the document
•The<title>element specifies a title for the document
•The<body>element contains the visible page content
•The<h1>element defines a large heading
•The<p>element defines a paragraph.

Department  of  Information  Technology     4  


 
 

PHP:

PHP is a recursive acronym for "PHP: Hypertext processor".


•PHP is a server side scripting language that is embedded in HTML. It is used to
manage dynamic content, databases, session tracking, even build entire e-commerce
sites.
•It is integrated with a number of popular databases, including MYSQL,Informix, and
Microsoft SQL Server.
•PHP is pleasingly zippy in its execution, especially when compiled as an Apache
module on the Unix side. The My SQL server, once started, executes even very
complex queries with huge result sets in record-setting time.
•PHP supports a large number of major protocols such as POP3, IMAP, and LDAP.
PHP4 added support for Java and distributed object architectures (COM and CORBA),
making n-tier development a possibility for the first time.
•PHP is forgiving: PHP language tries to be as forgiving as possible.

1.5 Brief discussion on the problem :

“Necessity is the mother of Invention”- This great proverb has proven its value every time a new
invention is done. The Student information System is being built to solve many such problems which
occur due to redundant data and manual labour.

The problems which we are going to solve are as follows:

• Admission:
Manage the whole admission process from the registration stage all the way through to
assignment of subjects.

• Academics:

Curriculum management – proactively and flexibly manage and add new curricula, with
version control.

Student records – gain a complete view of the student, including course enrolments,
progression, etc.

Academic advising – help advisors identify at-risk students and advise alternative pathways
with degree shopping.

Department  of  Information  Technology     5  


 
 

Background Study:
We went through some websites and open source projects on GitHub.

Websites:
§ github.com
§ bitbucket.com
§ sourceforge.com

TIMELINE OF PROJECT

DEC(2
019)J (JUNE
AUG( SEPT( OCT(2 NOV( FEB(2 MAR( APR(2 MAY( (2020
2019)   2019)   019)   2019)   AN(20 020)   2020)   020)   2020)  
)  
20)  

T1   T2   T3   T4   T5   T6  

This graph shows the timeline of the project from august 2019 to June 2020

T1: Survey of existing works in database, especially hardware sorting.

T2: Design the architecture for the Information System.

T3: Implementing code for the front end of the Project

T4: Implementing code for the back end of the Project

T5: Testing and Debugging the code, Simulating it for various systems.

T6: Finally running on different systems.

Department  of  Information  Technology     6  


 
 

2. Concepts and Problem analysis

Teacher module:-
• Teacher can update the attendance online and can see the regular update of his/her
students.

• Teacher can also update the marks and mar points.

• Teacher can also see the performance of student in the other subject.

• ………………………

Student module:-
• Student can see their academic performance at any time.

• They can update their personal information.

• -----------------

Administration module:-
• Admin can generate the report card for each student.

• They will register the student and teacher in the system.

• They will verify the information of student and teacher.

Department  of  Information  Technology     7  


 
 

3. Design and Methodology

FIG 1 (LEVEL 0 DFD)


The above Level 0 Data flow diagram shows how the data is flowing from different sources to
the system and vice versa.

Department  of  Information  Technology     8  


 
 

FIG 2 Level 1 DFD


The above diagram shows level 2 Data Flow Diagram which clarifies the process included in the
Student Information System and also defines what the the outputs that can be generated using this
System.

1. Teacher Registration: The process involves storage of Teacher data into Teacher data
base.

2. Student Registration: The process involves storage of student data into student data base.

3. Attendance: The process involves entry of attendance of marks and attendance to the
system.

4. Subject Registration: The process involves registration of subjects in a semester which is


done by the ADMIN.

5. MAR Details & Marks Entry: The MAR details are submitted by the student while the
MAR points and marks are submitted by the teacher.

Department  of  Information  Technology     9  


 
 

FIG 3 Level 2 DFD


The above diagram shows how the system is taking in the data. It shows the processes involved in the
system. How the processes are making the use of Information being provided to them in technical
manner.

1.1 Student Registration: The process involves entering data of student by the Admin and then the
data is stored into the Student’s database.

1.2 Teacher’s Registration: The process involves entering data of teachers by the Admin and then
the data is stored into the Teacher’s database.

1.3 Attendance and Marks Entry: The attendance is given by the Teacher in particular class and in
their particular subject which is stored in the Attendance Database.

1.4 MAR Marks & Details: The MAR details are filled by the Students and the points are filled by
the respected Teacher. The output can be seen by the Student.

1.5 Report Generation: The report can be finally generated through different databases that the are
filled by the Admin, Teacher and Students.

Department  of  Information  Technology     10  


 
 

FIG 3 (Entity Relationship Diagram)

E-R (Entity-Relationship) Diagram is used to represents the relationship between entities in a


table. ER diagrams represent the logical structure of databases. ER Diagram represent relationship
between two database tables.  

Marks  
Attendanc
e  

Department  of  Information  Technology     11  


 
 

Table Schema

STUDENT TABLE:
1) Std_table(s_id(PK),s_name,s_e_id(PK),s_pass,mob,s_year,roll,gen)
• Std_table stores all the information of a student.
• s_id and s_e_id are the primary keys.

NAME TYPE REMARKS


s_id int This is used as primary key to store
student id.
S_name char Used for store students’ name
s_e_id char Storing email
This is also the primary key.
S_pass char Password for student login
mob int Phone number
s_year int Current year of student in college
roll int Roll no. of the student
gen char Gender of Student
Table  1(Structural  representation  of  Student  Data)  

TEACHER TABLE:
2) Teacher_table(t_id(PK),name,email,Password,phone,t_post,gen,uid(PK))
• Teacher_table stores all the information of a teacher.
• T_id and uid are the Primary Keys

NAME TYPE REMARKS


t_id int
This is used as primary key to
store teacher id.
Name char Used for store teacher name.
email char Storing email
Password char Password for teacher login
phone int Phone number.
T_post char Designation of Teacher
gen char Gender of Teacher
uid int Serial number. Along with t_id
it is used as primary key
Table 2(Structural representation of Teacher Database)

Department  of  Information  Technology     12  


 
 

ADMIN LOGIN:
3) Admin_table(admin_id,admin_pass)
• Admin_table consists of the information of the admin which is mainly the ID and
Password of the Admin.
• Admin_id is the Primary Key

NAME TYPE REMARKS


admin_id char Admin Id which is primary key.
Admin_pass char Admin login password
         

Table 3(Structural representation of Admin Database)

Department  of  Information  Technology     13  


 
 

4. Sample Codes

Code for the Login module :

<!DOCTYPE html>
<html>
<head>
<?php

if(isset($_POST[‘s’]))
{
session_start();

$con=mysqli_connect(‘localhost’,’root’,’’,’s_i_s’);
if(!$con)
{
die(“could not connect”);
}
mysqli_select_db($con,’s_i_s’);

if($_SERVER[“REQUEST_METHOD”]==”POST”)
{
$name=$_POST[‘email’];
$pass=$_POST[‘password’];
$result=mysqli_query($con,”SELECT s_e_id,s_pass FROM student where s_e_id=’$name’ and
s_pass=’$pass’ “);

// $s_e_id=$_POST[‘email’];
// $_SESSION[‘s_e_id’]=$s_e_id;

if(mysqli_num_rows($result)==0)
{
$message = “Id or Password not Matched.”;
echo “<script type=’text/javascript’>alert(‘$message’);</script>”;
}
else
{
$_SESSION[‘email’]=$name;
$_SESSION[‘logout’]=$name;
header(“location:student_home.php”);
echo “<script type=’text/javascript’>alert(‘$message’);</script>”;
}
}
}
?>
<link rel=”stylesheet” type=”text/css”
href=”https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css”> [Taken from Bootstrap.com]
<link rel=”stylesheet” type=”text/css” href=”https://maxcdn.bootstrapcdn.com/font-awesome/4.4.0/css/font-
awesome.min.css”> [Taken from Bootstrap.com]
<link href=”http://fonts.googleapis.com/css?family=Lato:300,400,700,300italic,400italic,700italic”
rel=”stylesheet” type=”text/css”>

<script>
function f1()
{

Department  of  Information  Technology     14  


 
 

var sta2=document.getElementById(“exampleInputEmail1”).value;
var sta3=document.getElementById(“exampleInputPassword1”).value;
var x2=sta2.indexOf(‘ ‘);
var x3=sta3.indexOf(‘ ‘);
if(sta2!=”” && x2>=0){
document.getElementById(“exampleInputEmail1”).value=””;
document.getElementById(“exampleInputEmail1”).focus();
alert(“Space Not Allowed”);
}
else if(sta3!=”” && x3>=0){
document.getElementById(“exampleInputPassword1”).value=””;
document.getElementById(“exampleInputPassword1”).focus();
alert(“Space Not Allowed”);
}

}
</script>

<title>Student Login</title>
</head>
<body style=”background-size: cover;
background-image: url(regi_bg.jpeg);
background-position: center;”>
<nav class=”navbar navbar-default navbar-fixed-top” style=”height: 60px;”>
<div class=”container”>
<div class=”navbar-header”>

<a class=”navbar-brand” href=”home.php” style=”margin-top: 5%;”><b>S.T.C.E.T</b></a>


</div>
<div id=”navbar” class=”collapse navbar-collapse”>
<ul class=”nav navbar-nav”>
<li class=”active” style=”margin-top: 5%;”><a href=”student_login.php”>Student Login</a></li>
</ul>

</div>
</div>
</nav>
<div align=”center” >
<div class=”form” style=”margin-top: 15%”>
<form method=”post”>
<div class=”form-group” style=”width: 30%”>
<label for=”exampleInputEmail1”><h1 style=”color: #fff;”>Student Id</h1></label>
<input type=”email” class=”form-control” id=”exampleInputEmail1” aria-describedby=”emailHelp”
size=”5” placeholder=”Enter Email id” required name=”email” > </div>
<div class=”form-group” style=”width:30%”>
<label for=”exampleInputPassword1”><h1 style=”color: #fff;”>Password</h1></label>
<input type=”password” class=”form-control” id=”exampleInputPassword1” placeholder=”Password”
required name=”password” > </div>

<button type=”submit” class=”btn btn-primary” name=”s” >
</form>
</div>
</div>
<div style=”position: fixed;
left: 0;
bottom: 0;
width: 100%;

Department  of  Information  Technology     15  


 
 

background-color: rgba(0,0,0,0.7);
color: white;
text-align: center;”>
<h4 style=”color: white;”>&copy <b>S.T.C.E.T</b></h4>
</div>

</body>
</html>

Code for the Home Module:

<!DOCTYPE html>
<html>
<head>

<title>S.T.C.E.T</title>
<link rel=”stylesheet” type=”text/css”
href=”https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css”>
<link rel=”stylesheet” type=”text/css” href=”https://maxcdn.bootstrapcdn.com/font-
awesome/4.4.0/css/font-awesome.min.css”>
<link href=”http://fonts.googleapis.com/css?family=Lato:300,400,700,300italic,400italic,700italic”
rel=”stylesheet” type=”text/css”>
<link rel=”stylesheet” type=”text/css” href=”home.css”>

</head>

<body>

<nav class=”navbar navbar-default navbar-fixed-top”>


<div class=”container”>
<div class=”navbar-header”>
<button type=”button” class=”navbar-toggle collapsed” data-toggle=”collapse” data-target=”#navbar” aria-
expanded=”false” aria-controls=”navbar”> [Taken from We3School.com]
<span class=”sr-only”>Toggle navigation</span>
<span class=”icon-bar”></span>
<span class=”icon-bar”></span>
<span class=”icon-bar”></span>
</button>
<a class=”navbar-brand” href=”home.php”><b>S.T.C.E.T</b></a>
</div>
<div id=”navbar” class=”collapse navbar-collapse”>
<ul class=”nav navbar-nav”>
<li class=”active”><a href=”home.php”>Home</a></li>
</ul>
<ul class=”nav navbar-nav navbar-right”>
<li><a href=”teacher_login.php”>Teacher Login <i class=”fa fa-user”></i></a></li>
<li><a href=”student_login.php”>Student Login <i class=”fa fa-user”></i></a></li>
</ul>
</div>
</div>
</nav>

<div class=”container”>
<div class=”row”>
<div class=”col-lg-12”>
<div class=”content”>
<h1>Welcome</h1>

Department  of  Information  Technology     16  


 
 

<h3>Login Below &nbsp &nbsp<i class=”fa fa-hand-o-down”


aria-hidden=”true”></i></h3>
<hr>
<a href=”teacher_login.php” class=”btn btn-default btn-lg” role=”button” aria-pressed=”true”>Teacher
Login</a> [Taken from Bootstrap.com]
<a href=”student_login.php” class=”btn btn-default btn-lg” role=”button” aria-pressed=”true”>Student
Login</a>
<a href=”admin_login.php” class=”btn btn-default btn-lg” role=”button” aria-pressed=”true”>Admin
Login</a>
</div>
</div>
</div>
</div>

<script type=”text/javascript” src=”https://code.jquery.com/jquery-2.1.4.js”></script>


<script type=”text/javascript” [Taken from jquery.com]
src=”https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js”></script>

</body>
</html>

Department  of  Information  Technology     17  


 
 

5. Testing, Results, Discussion on Results


The important modules included in this project are as follows

Figure 1
Figure 1 shows the Home Page of our project which shows us three options to Login as a teacher, a
student or the Admin.

 
Figure 2

Figure 2 shows us the page displayed once the Admin has logged into his/her profile.

Department  of  Information  Technology     18  


 
 

Figure 3
Figure 3 shows us the module where the teacher can maintain the attendance records of his/her
respective students. A unique approach is tried for maintaining the attendance records where the
teacher can simply mark/unmark the students for their attendance as shown in the figure.

Figure 4

Figure 4 simply shows the student’s Login module where the student enters his/her Student ID and the
password to login into his/her profile and check his/her provided details.

Department  of  Information  Technology     19  


 
 

Figure 5
Figure 5 shows us the Welcome page for the teacher after they have logged into their respective
profiles and hence update or view the data of students.

Figure 6 shows us the page where the details of a teacher are entered and then the teacher is registered
into the database of the system.

Department  of  Information  Technology     20  


 
Figure 6
 

Figure 7
This figure shows the data entered into the Subject Database which include the batch, semester,
subject ID, subject Teacher and marks allotted in internals.

Figure 8
This figure shows the data entered into the teacher Database which include the name, Email ID, phone
number, Password, Teachers ID, Teachers post and gender. All the details are entered into the
database by the Administrator.

Assumption: We assume the ID and Password is provided by the admin to the Teacher.

Department  of  Information  Technology     21  


 
 

Figure 9(GENERATION OF REPORT)


This figure shows us the page where the details of a student are entered and then the report of the
student is generated where he gets to see his MAR marks, MAR details, the subject teacher who put
the marks there into the database of the system.

Department  of  Information  Technology     22  


 
 

6.1 Scope for future improvement

We are further planning to add certain features in the future.


The feature can be as follows:
• Video calls between Teachers and Parents.
• Payment of fee online.
• Students can also upload details.
• A few more minor tweaks will be added that can make the system much more visually
appealing and will have Statistics, Analytics, and Tracking.
• The whole project will be made available as an Android App for far more ease and mobility.

Department  of  Information  Technology     23  


 
 

6.2 Conclusion

This system is automating the existing manual system. This is a paperless work and it reduces
the man power. It will always provide accurate information. All years together gathered
information can be saved and accessed using application at any time. This system is essential
in college. The entire administrator, HOD, faculty can get the required information without
delay. As this application is only made for the general purpose it can be generalize to big
scale such as use in colleges, university and even in other educational institutions.

Department  of  Information  Technology     24  


 
 

Annexure

References/ Bibliography

We relied on various sources for our project, which are as follows

Websites:
§ www.w3schools.com
§ www.youtube.com
§ www.GeeksforGeeks.com
§ www.jquery.com
§ www.bootstrap.com

Books:

• Head First PHP & MySQL by Michael Morrison.


• PHP cookbook by David Sklar.

Department  of  Information  Technology     25  


 

You might also like