project report on student information management system in php

8/17/2019 Project Report on Student Information Management System in php

1/95

A

PROJECT REPORT

ON

“Student Information Management System”

Submitted in partial fulfillment for the

Award of degree of

Bachelor of Technology in nformation Technology

Submitted by:

!apil !au"hi#An#ur Agarwal

Tu"har Somani

Submitted to:

$ead of %epartment Academic $ead Pro&ect 'uide

()r* N* P* S$R+ASTA+A, ()r* %-P '.PTA, ()r* R/0AN !$AN,

PRNCPA-()r* N* !* !$AN%E-0A-,

%epartment of nforma tion

Technology

)a

ha

ri


2/95

"hi


3/95

Ar1indn"titute of Engineering and

Technology 2343544

PRE6ACE

This project 7Student nformation )anagement Sy"tem8 provides us a simple

interface for maintainance of student information.It can be used by educational

institutes or colleges to maintain the records of students easily. Achieving this

objective is difficult using a manual system as the information is scattered can be

redundant and collecting relevant information may be very time consuming. All these

problems are solved using this project.

Throughout the project the focus has been on presenting information in an easy and

intelligible manner. The project is very useful for those !ho !ant to "no! about

Student Information Management Systems and !ant to develop soft!ares#!ebsites

based on the same concept.

The project provides facilities li"e online registration and profile creation of students

thus reducing paper!or" and automating the record genreration process in an

educational institution.


4/95

AC!NO0-E%'E)ENT

$e ta"e this opportunity to e%press our sincere gratitude to all those !ho helped us

in various capacities in underta"ing this project and devising the report.

$e are privileged to e%press our sense of gratitude to our respected teacher )r*

Ri9wan !han !hose unparalleled "no!ledge moral fiber and judgment along !ith

his "no!&ho! !as an immense support in completing the project.

$e are also grateful to )r* Neera& Shri1a"ta1the 'ead of (epartment Information

Technology for the brain!ave and encouragement given.

$e ta"e this opportunity also to than" our friends and contemporaries for their co&operation and compliance.

)apil )aushi"

An"ur Agar!al

Tushar Somani


5/95


6/95

TAB-E O6 CONTENTS

1. (eclaration

2. Synopsis of project

3. System *e+uirement Specification

4. Technology overvie!

5. ,roject description

6. Snapshots

7. Scope of project

8. -ontribution in project

9. ibliography


7/95

%EC-ARATON

Ar 1ind

)

ahar i"

h

i

n"tituteofEngineer ing andTechnology2343544

%EPART)ENTO6N6OR)ATONTEC$NO-O':

CERT6CA

TEThis is to certify thatthe project titled

7ST.%ENT

N6O

R)A

TON

)AN

A'E

)EN

T

S:ST

E)8

r

"

c

a

r

r

i

e

d

o

u

t

b


8/95

y

follo!i

ng

InformationTechnologystudents:

1.

2.

3.

/

n

d

e

r

o

u

r

g

u

i

d

a

n

c

e

t fillme

nt of

the

*e+ui

reme

nts

for

the

degre

e of

the

ach

elor

of

Techn

ology

by

*T/

"ota

durin

g theacad

emic

year

of

0121&

0122


9/95


10/95

'.%E $EA% O6

()r* Ri9wan !han, ()r* N*P*


11/95

S:NOPSS

Ab"tract

Student Information Management System can be used by education institutes to

maintain the records of students easily. Achieving this objective is difficult using a

manual system as the information is scattered can be redundant and collecting

relevant information may be very time consuming. All these problems are solved

using this project.

Name of the Pro&ect: Student Information Management System

Ob&ecti1e":

3nline registration of students

Maintenance of student records

Searching student records

."er" +iew":

Administrator

Student

Platform

Operating Sy"tem": Microsoft $indo!s

Technologie" ."ed:

4ront 5nd: 'TM6 and 7avascript

$eb designing language: ,',


12/95

*(MS8ac" end9: MyS6

Software Re;uirement":

,', ;.1

A,A-'5 'TT, Server

(ream!eaver4ront,age for 4ront 5nd ,rogramming

Microsoft $indo!s or 6inu%

$ardware Re;uirement":

Intel ,entium I< processor or e+uivalent or higher

;20 M *am or 'igher

01 = '(( or 'igher

>et!or" -onnectivity


13/95

SO6T0ARE RE


14/95

Search module: Suppose there are hundreds of students and from this !e

have to search a particular student and !e "no! the name of the student .In

manual system it is a tedious tas" though !e "no! the name of the student

but using this module !e can easily search the student by specifying the

name of the student in the search criteria. Thus this module !ill help the

administrator in searching the student !ith various criteria easily.

Regi"tration )odule and Account )anagement: This module !ill help the

student get registered from any!here if internet is present .This module !ill

really simplify the tas" of on paper registration. Also after successful

registration the user can update information and change their pass!ord as

and !hen re+uired.

."er )anagement: This module !ill help the administrator in

enabling#disabling a user account and updating user information as re+uired.

,urpose of project is to maintain details of the students such as storing

information about:

Student id

Student pass!ord

Student name

Student (3

Student mailingaddress


15/95

=ender

*egistration date

Student status

-ontact no

ualification

-ity

*esume

Image

1.3 %efinition"> Acronym" and Abbre1iation" =

Per"onal detail"= (etails of student such as user id phone number

address image resume e&mail address etc.

• Contact detail"= (etails of contact associated !ith the student.

1· SRS= System re+uirement Specification

2· 000: $orld $ide $eb


16/95

1· Admini"trator= A 6ogin Id representing the user is an administrator

can access all the records details

1.4 Technologie" =

2· ,',.

3· MBS6

4· 7A


17/95


18/95

Student

2*@ Operating En1ironment =

The product can run on any bro!ser.

2.5 Con"traint" =

5very user must be comfortable using computer.

All operations are in 5nglish so user must have basic "no!ledge of

5nglish.

2.6 .SE CASE )O%E- =


19/95


20/95

2. Admini"trator= *esponsible for managing student details.

."e5ca"e= 6ogin into the !ebsite

'oal in contet= =ain access to the !ebsite

Brief %e"cription= This use case is used !hen the administrator !ants

to access the !ebsite to enable#disable#update the personal details of

the student.

Precondition"= The Administrator must be logged onto the !ebsite in

order for this use case to begin.

Ba"ic 6low=

The $ebsite prompts the administrator for the user name and pass!ord.

The Administrator enters the user name and pass!ord.

The $ebsite verifies the pass!ord and sets the user@s authori?ation.

The Administrator is given access to the $ebsite to perform his tas"s.

Alternati1e 6low=

The administrator enters invalid username and pass!ord then he

!ill not be allo!ed to enter the !ebsite*

Po"t condition"= The !ebsite state is unchanged by this use case.


21/95

."e Ca"e Report5 -ogin into the web"ite

."e Ca"e = (isplay student details

'oal in contet=


22/95

4o status


23/95

The System prompts for the student detail from one of the above "eys.

The student details are displayed on the screen.

Alternati1e 6low=

Student >ot 4ound

If in the %i"play a "tudent sub&flo!s a student !ith the specified id

number does not e%ist The system displays an error message. The

Administrator can then enter a different id number or cancel the

operation at !hich point the use case ends.

Po"t condition"=

The student details are displayed on the screen already e%isting in the

system. The state of the system remains unchanged*


24/95

."e Ca"e = 5dit student details

'oal in contet= 5dit the details of a student

Brief %e"cription= This use case is used !hen the administrator !ants

to edit the personal details of the himself#herself already e%isting in the

database.

Precondition"=

The Administrator must be logged into the system in order for this use

case to begin.

The details of the student must pre&e%ist in the databaseBa"ic6low=


25/95

The Administrator logs onto the System.

The Administrator can edit follo!ing "eys:&

1o 4irst#last name

2o =ender

3o (3

4o -ontact no

5o ualification

6o -ity

7o 5mail2

8o 5mail0

9o Address

10o(escription

The $ebsite updates the database according to edited details.

The student details are edited in the database.

Alternati1e 6low=

There is no alternative flo! of this use case diagram.

Po"t condition"=

The student details get updated in the database*


26/95

."e Ca"e Report5 Edit "tudent detail into the web"ite

2* Student

."e Ca"e = student registration

'oal in contet= *egistration of a student

Brief %e"cription= This use case is used !hen the student register

himself#herself in the database online.

Precondition"=

The Student must accessed the !ebsite in order for this use case to

begin.

The user id must be uni+ue and entered correctly.

Ba"ic 6low=

The Student enters into the !ebsite.

The student fill his#her details from the follo!ing "eys:&

1o Student id

2o pass!ord

3o 4irst#last name

4o Status

5o =ender

6o (3

7o -ontact no

8o ualification

9o -ity

10o5mail2

11o5mail0

12o Address

13o(escription


27/95

1o *esume

2o Image

The System details are added to the database.

The student details are displayed on the screen.

Alternati1e 6low=

/ser I( not uni+ue: if the user id entered is not uni+ue then it !ill sho! an error

message.

Po"t condition"=

The student get registered on the !ebsite and to login into that particular

the administrator must enable it.

."e Ca"e Report5 Regi"ter"tudent on web"ite


28/95


29/95

."e Ca"e Report5 -ogin into the "y"tem

."e Ca"e = 5dit student details

'oal in contet= 5dit the details of a student

Brief %e"cription= This use case is used !hen the student !ants to edit

the personal details of the himself#herself already e%isting in the

database.

Precondition"=

The Student must be logged into the system in order for this use case

to begin.

The details of the student must pre&e%ist in the database

The student must be enabled by administrator.

Ba"ic 6low=

The Student logs onto the System.

The Student can edit follo!ing "eys:&

1o 4irst#last name

2o =ender

3o (3

4o -ontact no


30/95

5o ualification


31/95

1o -ity

2o 5mail2

3o 5mail0

4o Address

5o (escription

The $ebsite updates the database according to edited details.

The student details are edited in the database.

Alternati1e 6low=

There is no alternative flo! of this use case diagram.

Po"t condition"=

The student details get updated in the database*


32/95

."e Ca"e Report5 Edit Student %etail" nto %ataba"e

?*2 6unctional Re;uirement" =

The Administrator !ill be given more po!ers 8enable#disable# update9 than

other users.

It !ill be ensured that the information entered is of the correct format. 4or

e%ample name cannot contain numbers. In case if incorrect form of

information is added the user !ill be as"ed to fill the information again.

The system can be accessed anytime.


33/95

?*? Non5 6unctional Re;uirement =

?*2*4* Performance Re;uirement"=

The proposed system that !e are going to develop !ill be used as the

-hief performance system for providing help to the organi?ation in

managing the !hole database of the student studying in the organisation.

Therefore it is e%pected that the database !ould perform functionally all

the re+uirements that are specified.

?*2*2* Safety Re;uirement"=

The database may get crashed at any certain time due to virus or operating

system failure. Therefore it is re+uired to ta"e the database bac"up.

?*2*?* Security Re;uirement"=

$e are going to develop a secured database. There are different

categories of users namely Administartor Student !ho !ill be vie!ing

either all or some specific information form the database.

(epending upon the category of user the access rights are decided. It

means if the user is an administrator then he can be able to modify the

data append etc. All other users only have the rights to retrieve the

information about database.

?*@ Conclu"ion =

This S*S has given all the details of the application need to be built.


34/95

%ES'N P$ASE

4* ntroduction

4*4, Scope and purpo"e

The purpose of the design phase is to develop a clear understanding of

!hat the developer !ant people to gain from his#her project. As you the

developer !or" on the project the test for every design decision should be

D(oes this feature fulfill the ultimate purpose of the projectED

A purpose statement affects the design process by e%plaining !hat the

developer !ants the project to do rather than describing the project itself.

The (esign (ocument !ill verify that the current design meets all of the

e%plicit re+uirements contained in the system model as !ell as the implicit

re+uirements desired by the customer.

4*2, O1erall Sy"tem %e"ign Ob&ecti1e"

The overall system design objective is to provide an efficient modular

design that !ill reduce the system@s comple%ity facilitate change and result

in an easy implementation. This !ill be accomplished by designing

strongly cohesion system !ith minimal coupling. In addition this document

!ill provide interface design models that are consistent user friendly and

!ill provide straight for!ard transition through the various system

functions.

4*?, Structure of %e"ign %ocument

System Architecture Design F The

System architecture section has

detailed diagram of the system serverand client architecture.


35/95

Data Design F The data (esign include an 5*( as !ell as (atabase

design.

Functional Design Description – This section has the functional

partitioning from the S*S and goes into great detail to describe each

function.

2. Sy"tem Architecture %e"ign

2*4, Sy"tem Architecture

The SIMS is a system !hich contain major part !hich include: student

(etail Student image and resume.

The user selects one of the available options as an input to the system.

According to the input by the user the system acts and the rest of the

functions are performed accordingly.The administartor can operate on any

student details.ut the normal student or users can only access their

details of all the functionalities.


36/95

G. %ata %e"ign

?*4, Entity Relation"hip %iagram =

Entity Relation"hip %iagram


37/95

4. 6unctional %e"ign %e"cription

4.1 %ata 6low %iagram =


38/95

4.2 %eci"ion Tree =


39/95

;. Conclu"ion

'ence !e can conclude that the design phase of the SIMS give us theinformation of all the processes used in the project and their relation.

TEC$NO-O': O+ER+E0

The technology selected for implementing Student Information Management System

is ,',#MBS6.Apache is used as the 'TT, server.The development !as done in a

C!indo!s@ environment using adobe dream!eaver -S;.

P$P

,', is a general&purpose scripting language that is especially suited to server&side

!eb development !here ,', generally runs on a !eb server.,', code isembedded into the 'TM6 source document.Any ,', code in a re+uested file is

e%ecuted by the ,', runtime usually to create dynamic !eb page content.It can

also be used for command&line scripting and client&side =/I applications. ,', can

be deployed on many !eb servers and operating systems and can be used !ith

many relational database management systems 8*(MS9. It is available free of

charge and the ,', =roup provides the complete source code for users to build

customi?e and e%tend for their o!n use.

)yS


40/95

database !e must create a table. A table is a section of the database for storing

related information. In a table !e !ill set up the different fields !hich !ill be used in

that table. -reating a table in phpMyAdmin is simple !e just type the name select

the number of fields and clic" the Cgo@ button. !e !ill then be ta"en to a setup screen

!here you must create the fields for the database.Another !ay of creating databases

and tables in phpMyAdmin is by e%ecuting simple S6 statements.$e have used

this method in order to create our database and tables.

Apache

The Apache 'TT, Server is a !eb server soft!are notable for playing a "ey role inthe initial gro!th of the $orld $ide $eb. In 011J it became the first !eb server

soft!are to surpass the 211 million !eb site milestone. Apache is developed and

maintained by an open community of developers under the auspices of the Apache

Soft!are 4oundation. Since April 2JJK Apache has been the most popular 'TT,

server soft!are in use. As of >ovember 0121 Apache served over ;J.GKL of all

!ebsites and over KK.;KL of the first one million busiest !ebsites.

A)PP

AM,, is a small and light Apache distribution containing the most common !eb

development technologies in a single pac"age. Its contents small si?e and

portability ma"e it the ideal tool for students developing and testing applications in

,', and MyS6. AM,, is available as a free do!nload in t!o specific pac"ages:

full and lite. $hile the full pac"age do!nload provides a !ide array of development

tools AM,, 6ite contains the necessary technologies that meet the 3ntario S"ills

-ompetition standards.The light version is a small pac"age containing Apache 'TT,

Server ,', MyS6 phpMyAdmin 3penssl and S6ite.

Obtaining and n"talling A)PP

As previously mentioned AM,, is a free

pac"age available for do!nload and use

for various !eb development tas"s. All

AM,, pac"ages and add&ons are


41/95

distributed through the Apache 4riends !ebsite at the address:

http:##!!!.apachefriends.org#. 3nce on the !ebsite navigate and find the $indo!s

version of AM,, and do!nload the self&e%tracting NI, archive. After do!nloading

the archive run and e%tract its contents into the root path of a hard dis" or /S

drive. 4or e%ample the e%tract path for a local $indo!s installation !ould simply be

-:O. If e%tracted properly !e !ill notice a ne! %ampp directory in the root of your

installation dis". In order to test that everything has been installed correctly first start

the Apache 'TT, Server by navigating to the %ampp directory and clic"ing on the

apachePstart.bat batch file.

>e%t !e !ill test if the server is running correctly by opening an internet bro!ser and

typing http:##localhost# into the address bar. If configured correctly !e !ill be

presented !ith a screen similar to that of the one belo!.

AM,, splashscreen.


42/95

In order to stop all Apache processes !e do not close the running terminal

application but instead run another batch file in the %ampplite directory called

apachePstop.bat.

Creating a %ataba"e and n"erting %ata

>o! that !e have run and tested Apache and ,', the ne%t step is running MyS6

and creating a database and table !hich !ill hold information to be used by our

!ebsite. In order to start MyS6 navigate to the %ampp directory and run the

mys+lPstart.bat batch file.The AM,, pac"age contains an application called

phpMyAdmin !hich allo!s developers to administer and maintain MyS6

databases.$e !ill be using phpMyAdmin to create a database and table and enter

test data. efore testing phpMyAdmin ma"e sure that both Apache and MyS6 are

running by opening their respective batch files: apachePstart.bat and

mys+lPstart.bat. Along !ith Apache and MyS6 running in the bac"ground !e type

http:##localhost#phpMyAdmin# into our !eb bro!ser. If successful !e !ill be

presented !ith a phpMyAdmin start page similar to the one sho!n belo!.


43/95

phpMyAdmin start page

The first step !ith phpMyAdmin running is creating a ne! database.$e create a ne!

database by directly e%ecuting S6 statements as sho!n belo!.The successful

e%ecution of the s+l +uerry creates a database Cstudent@ !ith t!o tables in it.The

tabels are adminPlogin and studentPinformation.$e also inserted values in the

admin table.The screenshot belo! sho!s the successful e%ecution of the +uery thus

creation of a database named student.

-reation of database in mys+l using phpMyadmin


44/95

Thus !e have learned to create a database in MBS6 by e%ecuting s+l statements.

After creating the database and tables !e are no! ready to use them in our !ebsite

“Student Information Management System” .

PROJECT %ESCRPTON

ntroduction



manual system as the information is scattered can be redundant and collectingrelevant information may be very time consuming. All these problems are solved

using this project

The directory structure of the project is as follo!s:


45/95

.

%e"cription of root directory content"

mage" %irectory = This directory contains the images uploaded by the

students during registration process.Supported formats are the .jpg and .gif

files.

Re"ume %irectory : This (irectory -ontains resumes of students uploaded

during registration process of students.4iles in this folder can be of .doc.t%t or

.pdf format.

AdminDEditDStudentDnfo*php : Admin page for editing information of a

student.The administrator can change details of a student in this page.Though

facility of changing the image and resume are not yet provided but !ill be

provided in future versions of the project.


46/95

AdminDEditDStudentDnfoD$andler*php : ,age handler for handling the

AdminP5ditPStudentPInfo.php file.It !rites the edited values in the database

on the server.

AdminD$eader*php : 'eader file for pages accessible to administrator only.AdminD$ome*php : 'ome page for administrator after logging in process.

AdminD-ogin*php : 6ogin page for administrator access.Sho!s appropriate

message for !rong username and#or pass!ord.

AdminD-oginDhandler*php : ,age handler for AdminP6ogin.php page.It

chec"s the values provided !ith the values in the database.

AdminDStudentD+iewDnfo*php : ,age to display student information to the

administrator.

Connect*php : ,age for database connectivity.It is used !henever database

values are re+uired on the page.

%i"playAll*php : ,age to display all registered students to the

administrator.This facility is only available to the administrator.

EnableD%i"ableDhandler*php : 'andler page for enabling#disabling of

students account facility.This functionality is only available to the

administrator.

6ooter*php : 4ooter file for all pages.

$eader*php : 'eader file for login page and homepage of the site.

nde*php : 'omepage of the !ebsite.

-ogout*php : 6ogout handler page.It (estroys all session variables thus

ending user session.

Search*php : Search page to search students.It can only be used by

administrator.Students can be searched using different fields such as user

idaccount status etc.

SearchDRe"ult*php : ,age to display search results to the administrator.


47/95

SearchD+iewDRe"ult*php : ,age to display student information for any

selected search result.

StudentDEdit*php : ,age to edit student information.It can be accessed by

students.

StudentDEditD$andler*php : ,age handler for StudentP5dit.php.

StudentD$eader*php : 'eader file for student pages.

StudentD$ome*php : 'ome page for students after they log into their

respective accounts.

StudentDlogin*php : 6ogin ,age for student login. Appropriate message is

displayed if the login is unsuccessful.

StudentDloginDhandler*php : ,age handler for StudentP6ogin.php.It chec"s

the values provided !ith that in th the database.

StudentDRegi"tration*php : Student *egistration page.The students enters

various details here for registration.

StudentDRegi"trationDhandler*php : ,age 'andler for handling the file

StudentPregistration.php.It adds value to the studentPinformation table thus

creating a ne! user.

StudentDRe"etDPa""word*php : ,age for resetting pass!ord.It can be used

only by students.Administrator pass!ord can be changed only by changing

the values in the table directly.

StudentDRe"etDPa""wordD$andler*php : ,age handler for handling page

StudentP*esetP,ass!ord.php.

StudentD+iew*php : ,age to display student profile !ith all the details of the

student.

Style*c"" : Stylesheet for the !hole site design.


48/95

+alidation*&" : 7avascript validations used for validation of form values.


49/95

1o studentPid : Stores user id of the student8s9

2o studentPpass!ord : Stores pass!ord of the student8s9

3o firstPname : Stores first name of the student8s9

4o lastPname : Stores last name of the student8s9

5o registrationPdate : Stores the registration date of the student8s9.

6o gender : Stores the gender of the student8s9.

7o datePofPbirth : Stores the date of birth of the student8s9.

8o studentPstatus : Stores the current status of the student account8s9.

9o contactPno : Stores the contact number of the student8s9.

10o +ualification : Stores student8s9 +ualification.

11ocity : Stores the city in !hich the student8s9 lives.

12o email2 : Stores primary email of the student8s9.

13o email0 : Stores secondary email of the student8s9.

14o address : Stores the address of the student8s9.

15o description : Stores description of the student8s9.

16o resume : Stores resume of students8s9.

17o image : Stores image of the student8s9.

18o lastPloginPdate : Strores last login date of the student8s9.

6eature"


50/95

The $ebsite provides follo!ing functionalities to the users :

Admini"trator :

1o 6ogin#6ogout

2o


51/95

Rbody

Rtable !idthD211LD heightD211LD

Rtr heightD2;LD

RtdREphp include W'eader.phpWUER#td

R#tr

Rtr heightDV1LD

Rtd alignDcenterD valignDbaselineDRtable !idthDX1LD

Rtr heightD21LD

Rtd alignDcenterDRa hrefDinde%.phpD classDstylelin"D styleDte%t&

decoration:noneD'omeR#aR#td

Rtd alignDrightDRa hrefDStudentPlogin.phpD classDstylelin"D

styleDte%t&decoration:noneDStudent 6oginR#a

nbspUnbspUnbspUnbspUnbspUnbspUnbspUnbspUnbspUnbspUnbspU

Ra hrefDAdminPlogin.phpD classDstylelin"D styleDte%t&

decoration:noneDAdministrator 6oginR#aR#td

R#tr

Rtr

RtdnbspUR#td

RtdnbspUR#td

R#tr

Rtr

RtdnbspUR#td

RtdnbspUR#td

R#tr

R#tableR#td

R#tr

Rtr heightD;LD

RtdREphp include W4ooter.phpWUER#td

R#tr

R#table

R#body

R#html


52/95

StudentDlogin*php

Rhtml

Rhead

Rmeta http&e+uivD-ontent&TypeD contentDte%t#htmlU charsetiso&VV;J&2D

Rtitle6ogin ,ageR#title

Rlin" relDstylesheetD hrefDStyle.cssD

typeDte%t#cssD# Rscript typeDte%t#javascriptD

function validate89

Y

if8document.form2.stPid.valueDD9

Y

alert8D,lease enter your login Id.D9U

document.form2.stPid.focus89U

return falseU

Z

if8document.form2.stPpass.valueDD9

Y

alert8D,lease enter your pass!ord.D9U

document.form2.stPpass.focus89U

return falseU

Z

Z

R#script

R#head

Rbody on6oadDjavascript:document.form2.stPid.focus89DRform nameDform2D methodDpostD actionDStudentPloginPhandler.phpD

onSubmitDreturn validate89UD


Rtr

Rtd heightD2;LDREphp include W'eader.phpWUER#td

R#tr

Rtr


53/95

Rtd !idthD211LD heightDV1LD alignDcenterD valignDbaselineDRtable

!idthDJ1LD

Rtr

Rtd !idthDVLDRa hrefDinde%.phpD classDstylelin"D

styleDte%t&decoration:noneU font&family: +uotUTimes >e!

*oman+uotU Times serifUD'omeR#aR#td

Rtd !idthDG;LD alignDcenterDnbspUR#td

Rtd !idthD0XLDnbspUR#td

Rtd !idthDG1LD alignDrightDRa

hrefDStudentP*egistration.phpD classDstylelin"D styleDte%t&

decoration:none U font&!eight: boldUD>e! Student -lic" 'ereR#aR#td

R#tr

Rtr

RtdnbspUR#td

RtdnbspUR#td

RtdnbspUR#td

RtdnbspUR#td

R#tr

Rtr

RtdnbspUR#td

RtdnbspUR#td

RtdnbspUR#td

RtdnbspUR#td

R#tr

REphp if8[P=5THWflagW DsuccessD9 Y E

Rtr

Rtd classDstylegreenD colspanD\D

alignDcenterD-ongratulations] Bou Are successfully registered. Bou can use

your 6ogin Id and ,ass!ord to login to your account.R#td

R#tr

REphp

Zelse if8[P=5THWflagW De%istsD9 Y E


54/95

Rtr

Rtd classDstyleredD colspanD\D alignDcenterDThis

6ogin Id8 RE[P=5THWstudentPidWE9 already e%ists.,lease try again !ith

another 6ogin IdR#td

R#tr

REphp

Zelse if8[P=5THWflagW DerrorD9 Y

E

Rtr

Rtd classDstyleredD colspanD\D alignDcenterD5rror

!hile inserting data. ,lease try again.R#td

R#tr

REphp

Z

E

Rtr

RtdnbspUR#td

RtdnbspUR#td

RtdnbspUR#td

RtdnbspUR#td

R#tr

Rtr

RtdnbspUR#td

RtdnbspUR#td

RtdnbspUR#td

RtdnbspUR#td

R#tr

Rtr

Rtd colspanD\DRtable !idthDG1LD borderD2D alignDcenterD

cellpaddingDGD cellspacingD1D bordercolorD^------D

bgcolorD^------D

Rtr alignDcenterD bgcolorD^JJJJJJD

Rtd colspanD0D classDstylebigDStudent 6ogin 'ereR#td

R#tr


55/95

Rtr bgcolorD^525252D classDstylesmallD

Rtd !idthDG;LD alignDleftD classDstyleXD6ogin Id : R#td

Rtd !idthDK;LD alignDleftDRinput nameDstPidD typeDte%tD

idDstPidDR#td

R#tr

Rtr bgcolorD^525252D classDstylesmallD Rtd

alignDleftD classDstyleXD,ass!ord:R#td

Rtd alignDleftDRinput nameDstPpassD typeDpass!ordD

idDstPpassDR#td

R#tr

Rtr bgcolorD^525252D

Rtd colspanD0D alignDcenterDnbspU

REphp if8[P=5THWflagW DinvalidD9 Y E

Rspan classDstyleredDInvalid 6ogin Id or ,ass!ordR#span

REphp ZE

R#td

R#tr


Rtd colspanD0D alignDcenterDRinput nameDloginD classDstyle21D

typeDsubmitD idDloginD valueD6oginD

Rinput nameDcloseD typeDbuttonD idDcloseD classDstyle21D

valueD-loseD on-lic"Dself.locationWinde%.phpWD R#td

R#tr

R#tableR#td

R#tr

R#tableR#td

R#tr

Rtr

Rtd heightD;LD alignDcenterDREphp include W4ooter.phpWUER#td

R#tr

R#table

R#form

R#body


56/95

R#html

StudentDloginDhandler

REphp

sessionPstart89U

include W-onnect.phpWU

[flag DDU

[studentPid [P,3STHWstPidWU

[stPpass [P,3STHWstPpassWU

[+uery Dselect lastPloginPdate from studentPinformation !herestudentPidW[studentPidW and studentPpass!ordW[stPpassW and

studentPstatus W5nableWDU

[result mys+lP+uery8[+uery[lin"Pid9U

if8mys+lPerror89 ] null9Y

die8mys+lPerror899U

Z

if8[date mys+lPfetchParray8[result99

Y

[lastdate [dateHWlastPloginPdateWU

[date0 date8Dd&m&B h:i ADstrtotime8[lastdate99U

[PS5SSI3>HWuseridW [P,3STHWstPidWU

[PS5SSI3>HWlastloginW [date0U

[PS5SSI3>HWtypeW DStudentDU

mys+lP+uery8Dupdate studentPinformation set

lastPloginPdateno!89 !here studentPidW[studentPidWD[lin"Pid9U


die8mys+lPerror899U

Z

header8Dlocation:StudentP'ome.phpD9U

die89U

Z

else


57/95

Y

[flag DinvalidDU

header8Dlocation:StudentPlogin.phpEflag[flagD9U

die89U

Z

E

StudentDRegi"tration*php

RhtmlRhead

Rlin" relDstylesheetD hrefDStyle.cssD typeDte%t#cssD#


RtitleStudent *egistration ,ageR#title

Rscript srcD


58/95

alert8D,lease enter your date of

birth.D9U document.form2.dob.focus89U

return falseU

Z

else

Y

var date document.form2.dob.valueU

var yes chec"(ate8date9U

if8]yes9

Y

alert8D,lease 5nter a valid date of

birth.D9U document.form2.dob.focus89U

return falseU

Z

Z

if8document.form2.email2.valueDD9

Y

alert8D,lease enter your primary email.D9U

document.form2.email2.focus89U

return falseU

Z

else

Y

var is5mail email


59/95

document.form2.address.focus89U

return falseU

Z

if8document.form2.description.value ] DD

document.form2.description.value.length 0119Y

alert8DBou can enter description upto 011 characters only.D9U

document.form2.description.focus89U

return falseU

Z

if8document.form2.stPid.valueDD9

Y

alert8D,lease enter your desired student id.D9U

document.form2.stPid.focus89U

return falseU

Z

if8document.form2.stPpass.valueDD9

Y

alert8D,lease enter your desired pass!ord.D9U

document.form2.stPpass.focus89U

return falseU

Z

if8document.form2.retype.valueDD9

Y

alert8D,lease enter retype pass!ord.D9U

document.form2.retype.focus89U

return falseU

Z

if8document.form2.stPpass.value ] document.form2.retype.value9

Y

alert8D,ass!ord and retype pass!ord are not

same.D9U document.form2.stPpass.value DDU

document.form2.retype.value DDU

document.form2.stPpass.focus89Ureturn falseU


60/95

Z

Z

R#script

R#head

Rbody on6oadDjavascript:document.form2.firstPname.focus89D

Rform nameDform2D methodDpostD

actionDStudentP*egistrationPhandler.phpD onSubmitDreturn validation89D

enctypeDmultipart#form&dataD

Rtable !idthD211LD

Rtr

Rtd !idthD211LD heightD2;LD alignDcenterDREphp include

W'eader.phpWUER#td

R#tr

Rtr

Rtd !idthD211LD heightDV1LD alignDcenterDRtable !idthDV1LD

borderD2D cellpaddingD0D cellspacingD1D bordercolorD^------D


Rtd colspanD\D alignDcenterD classDstylemediumDStudent

InformationR#td

R#tr

Rtr classDstylesmallD

Rtd4irst >ame Rspan classDstyleredD_R#span R#td

RtdRinput nameDfirstPnameD typeDte%tD idDfirstPnameD

ma%lengthD;1DR#td

Rtd6ast >ame Rspan classDstyleredD_R#span R#td

RtdRinput nameDlastPnameD typeDte%tD idDlastPnameD

ma%lengthDG1DR#td

R#tr


Rtd=enderR#td

RtdRinput nameDgenderD typeDradioD valueDMaleD

chec"ed MaleRinput nameDgenderD typeDradioDvalueD4emaleD 4emaleR#td


61/95

Rtd(ate 3f irth Rspan classDstyleredD_R#span R#td

RtdRinput nameDdobD typeDte%tD idDdobD si?eD21D

ma%lengthD21D ((&MM&

BBBBR#td

R#tr


Rtdualification Rspan classDstyleredD_R#span R#td

RtdRselect nameD+ualificationD idD+ualificationD

Roption valueDD&&&&&select&&&&&R#option

Roption valueD'igh SchoolD'igh SchoolR#option

Roption valueD=raduateD=raduateR#option

Roption valueDM-ADM-AR#option

Roption valueD-AD-AR#option

Roption valueDMaster (egreeDMaster (egreeR#option

R#selectR#td

Rtd-ontact >oR#td

RtdRinput nameDcontactPnoD typeDte%tD idDcontactPnoD

ma%lengthD01DR#td

R#tr


Rtd -ityR#td

RtdRinput nameDcityD typeDte%tD idDcityD ma%lengthDG1DR#td

RtdnbspUR#td

RtdnbspUR#td

R#tr


Rtd,rimary 5mail Rspan classDstyleredD_R#span R#td

RtdRinput nameDemail2D typeDte%tD idDemail2D

ma%lengthD211DR#td

RtdSecondary 5mailR#td

RtdRinput nameDemail0D typeDte%tD idDemail0D

ma%lengthD211DR#td


62/95

R#tr


RtdAddressR#td

Rtd colspanDGDRte%tarea nameDaddressD colsD\;D ro!sD0D

idDaddressDR#te%tareaR#td

R#tr


Rtd (escriptionR#td

Rtd colspanDGDRte%tarea nameDdescriptionD colsD\;D ro!sDGD

idDdescriptionDR#te%tareaR#td

R#tr


Rtd colspanD\D alignDcenterD classDstylemediumD6ogin

InformationR#td

R#tr

Rtr

Rtd colspanD\DnbspUR#td

R#tr


Rtd(esired I( Rspan classDstyleredD_R#span R#td

RtdRinput nameDstPidD typeDte%tD idDstPidD ma%lengthD01DR#td

RtdnbspUR#td

RtdnbspUR#td

R#tr


Rtd,ass!ord Rspan classDstyleredD_R#span R#td

RtdRinput nameDstPpassD typeDpass!ordD idDstPpassD

ma%lengthD01DR#td

Rtd alignDrightD*etype ,ass!ordRspan classDstyleredD _R#span

R#td

RtdRinput nameDretypeD typeDpass!ordD idDretypeD

ma%lengthD01DR#td

R#trRtr


63/95

RtdnbspUR#td

RtdnbspUR#td

RtdnbspUR#td

RtdnbspUR#td

R#tr


Rtd colspanD\D alignDcenterD classDstylemediumD *esume

InformationR#td

R#tr


Rtd/pload *esume R#td

Rtd colspanDGDRinput nameDresumeD typeDfileD

nbspUnbspUnbspUnbspUnbspUnbspUnbspUnbspURspan

classDstyleredD.doc .t%t .pdf file onlyR#spanR#td

R#tr

Rtr


R#tr

Rtr alignDcenterD classDstylemediumD bgcolorD^555555D

Rtd colspanD\DImage InformationR#td

R#tr


Rtd/pload Image R#td

Rtd colspanDGDRinput typeDfileD nameDimageD

nbspUnbspUnbspUnbspUnbspUnbspUnbspUnbspURspan

classDstyleredDRspan classDstyleredD.jpg file And .gif file

onlyR#spanR#td

R#tr

Rtr

Rtd colspanD\DRspan classDstyleredD_ Remmeans fields

are compulsoryR#em R#spanR#td

R#tr

Rtr


64/95

Rtd colspanD\D alignDcenterDRinput nameDregisterD typeDsubmitD

idDregisterD valueD*egisterD

Rinput nameDresetD typeDresetD idDresetD valueD*esetD

Rinput nameDcloseD typeDbuttonD idDcloseD valueD-loseD

on-lic"Dself.locationWStudentPlogin.phpWDR#td

R#tr

R#tableR#td

R#tr

Rtr

Rtd !idthD211LD heightD;LD alignDcenterDREphp include

W4ooter.phpWUER#td

R#tr

R#table

R#form

R#body

R#html

StudentDRegi"trationDhandler*php

REphp


[flag DsuccessDU

function rollbac"(ata89Y

mys+lP+uery8D *366A-) D9U

global [flagU

[flag DerrorDU


die8mys+lPerror899U

Z

Z

[studentPid [P,3STHWstPidWU

[studentPpass [P,3STHWstPpassWU

[firstPname [P,3STHWfirstPnameWU


65/95

[lastPname [P,3STHWlastPnameWU

[gender [P,3STHWgenderWU

[contactPno [P,3STHWcontactPnoWU

[+ualification [P,3STHW+ualificationWU

[city [P,3STHWcityWU

[email2 [P,3STHWemail2WU [email0

[P,3STHWemail0WU [address

[P,3STHWaddressWU [description

[P,3STHWdescriptionWU [resumename

DDU

[imagename DDU

[dobdate date8DB&m&dDstrtotime8[P,3STHWdobW99U

#_

This bloc" is used to chec" !hether the studentPid already e%its

in database.

_#

[selectP+ueryDselect studentPid from studentPinformation !here

studentPid W[studentPidWDU

[resultPset mys+lP+uery8[selectP+uery[lin"Pid9U

if8[ro! mys+lPfetchParray8[resultPset99

Y [flagDe%istsDU

header8Dlocation:StudentPlogin.phpE

flag[flagstudentPid[studentPidD9U

die89U

Z

elseY

#_

This bloc" is used to insert the student record in database

if the studentPid is already not present in the database.

_#

mys+lP+uery8DS5T A/T3-3MMIT 1 D9U

if8mys+lPerror89 ] null9Ydie8mys+lPerror899U


66/95

Z

[+uery Dinsert into

studentPinformation8studentPidstudentPpass!ordfirstPnamelastPnameregis

trationPdategenderdatePofPbirthDU

[+uery .

DstudentPstatuscontactPno+ualificationcityemail2email0addressdescriptio

n9DU

[+uery . D

values8W[studentPidWW[studentPpassWW[firstPnameWW[lastPnameWno!89W[gender

WW[dobdateWW(isableWW[contactPnoWDU

[+uery .

DW[+ualificationWW[cityWW[email2WW[email0WW[addressWW[descriptionW9DU

[result mys+lP+uery8[+uery[lin"Pid9U


die8mys+lPerror899U

Z

if8[result9Y

if8[P4I65SHWresumeWHWnameW ] DD9Y

[filename [P4I65SHWresumeWHWnameWU

[e%t strrchr8[filenameD.D9U

[resumename [studentPidU

[resumename . DPD.[filenameU

if8[e%t D.t%tD `` [e%t D.docD `` [e%t D.TTD ``

[e%t D.(3-D `` [e%t D.pdfD `` [e%t D.,(4D9Y

[si?e [P4I65SHWresumeWHWsi?eWU

if8[si?e 1 [si?e R 21111119Y

[archivePdir DresumesDU

[userfilePtmpPname

[P4I65SHWresumeWHWtmpPnameWU

if8movePuploadedPfile8[userfilePtmpPname D[archivePdir#[resumenameD99Y


67/95


68/95

[si?e [P4I65SHWimageWHWsi?eWU

if8[si?e 1 [si?e R 21111119Y

[archivePdir DimagesDU

[userfilePtmpPname

[P4I65SHWimageWHWtmpPnameWU

if8movePuploadedPfile8[userfilePtmpPname D[archivePdir#

[imagenameD99Y

#_

if image is successfully

uploaded then imagename is stored in database. _#

mys+lP+uery8Dupdate

studentPinformation set imageW[imagenameW !here

studentPidW[studentPidWD [lin"Pid9U

[flag DsuccessDU

if8mys+lPerror89]null9Y

die8mys+lPerror899U

Z

Z

elseY

if8filePe%ists8Wresumes#W .

[resumename99 Y

unlin"8Wresumes#W .

[resumename9U

Z

rollbac"(ata89U

Z

Z

elseY

if8filePe%ists8Wresumes#W .

[resumename99 Y

unlin"8Wresumes#W .[resumename9U


69/95

Z

rollbac"(ata89U

die8DBou can upload image of 2 M

si?e only. ,lease try again.D9U

Z

Z

elseY

if8filePe%ists8Wresumes#W . [resumename99 Y

unlin"8Wresumes#W . [resumename9U

Z

rollbac"(ata89U

die8DBou can upload images of .jpg .jpeg

.gif e%tensions only. ,lease try again. D9U

Z

Z

Z

elseY

[flagDerrorDU

Z

if8[flag DsuccessD9

Y mys+lP+uery8D -3MMIT

D9U [flagDsuccessDU


die8mys+lPerror899U

Z

#_

This bloc" is used to send email to the

successfully registered users.

_#

#_

[to [email2U

[subject W-ongratulationsWU

[message W-ongratulations you are registered in our site.OrOnOrOnWU


70/95

[message . DBour 6ogin Id : [studentPid OrOn ,ass!ord :

[studentPpassDU

[headers D4rom: infosims.comOrOnDU

[headers . W&Mailer: ,',W . phpversion89U

mail8[to [subject [message [headers9U

_#

Z

header8Dlocation:StudentPlogin.phpEflag[flagD9U

die89U

Z

E

AdminDEditDStudentDnfo*php

REphp

sessionPstart89U

[sessionPid [PS5SSI3>HWuseridWU

if8[sessionPid null9Y

header8Dlocation:inde%.phpD9Udie89U

Z


[studentPid [P*5/5STHWstudentPidWU

[+uery Dselect _ from studentPinformation !here

studentPidW[studentPidWDU[result mys+lP+uery8[+uery [lin"Pid9U

[data mys+lPfetchParray8[result9U

E

Rhtml

Rhead

Rlin" relDstylesheetD hrefDStyle.cssD typeDte%t#cssD#


Rtitle5dit Student Information y AdminR#title


71/95

Rscript srcD


72/95

Y

alert8D,lease enter your primary email.D9U

document.form2.email2.focus89U

return falseU

Z

else

Y

var is5mail email


73/95

document.form2.description.focus89U

return falseU

Z

Z

function SetAll89

Y

document.form2.+ualification.valueDREphp echo [dataHW+ualificationWUE

DU var gen DREphp echo [dataHWgenderWUEDU

var gend document.form2.gender.lengthU

for8var i 1U iRgendU i9

Y

if8document.form2.genderHi.value gen9

document.form2.genderHi.chec"edtrueU

Z

Z

R#script

R#head

Rbody on6oadDjavascript:SetAll89D

Rform nameDform2D methodDpostD

actionDAdminP5ditPStudentPInfoP'andler.phpD onSubmitDreturn

validation89D

Rinput typeDhiddenD nameDstudentPidD valueDREphp echo

[studentPidU E UD



Rtd !idthD211LD heightD2;LD alignDcenterDREphp include

WAdminP'eader.phpWUER#td

R#tr

Rtr

Rtd !idthD211LD heightDV1LD alignDcenterDRtable !idthDV1LD

borderD2D cellpaddingD0D cellspacingD1D bordercolorD^555555DRtr


74/95

Rtd colspanD\D alignDcenterD bgcolorD^555555D

classDstylebigD5dit Student InformationR#td

R#tr

Rtr

Rtd colspanD\D alignDcenterDnbspU

REphp if8[P=5THWflagW DsuccessD9 Y E

Rspan classDstyleredDStudent Information updated

successfully.R#span

REphp Z else if8[P=5THWflagW DerrorD9 Y E

Rspan classDstyleredD5rror !hile updating student

information.,lease try againR#span

REphp Z E R#td R#tr


Rtd !idthD2JLD alignDleftD4irst >ame : R#td

Rtd !idthDG1LD alignDleftDRinput nameDfirstPnameD

typeDte%tD idDfirstPnameD valueDREphp echo [dataHWfirstPnameWU ED

si?eD0;Dma%lengthD;1DR#td

Rtd !idthD2XLD alignDleftD6ast nameR#td

Rtd !idthDG\LD alignDleftDRinput nameDlastPnameD typeDte%tD

idDlastPnameD valueDREphp echo [dataHWlastPnameWUED si?eD0;D

ma%lengthDG1DR#td

R#tr


Rtd heightD0JD alignDleftD=ender : R#td

Rtd alignDleftDRinput nameDgenderD typeDradioD valueDMaleD

MaleRinput nameDgenderD typeDradioD valueD4emaleD

4emaleR#td

Rtd alignDleftD(ate 3f irthR#td

Rtd alignDleftDRinput nameDdobD typeDte%tD idDdobD si?eD21D

ma%lengthD21D valueDREphp echo date8Dd&m&

BDstrtotime8[dataHWdatePofPbirthW99UED

((&MM&BBBBR#td

R#tr


75/95


Rtd alignDleftDualification : R#td

Rtd alignDleftDRselect nameD+ualificationD idD+ualificationD

Roption valueD'igh SchoolD'igh SchoolR#option

Roption valueD=raduateD=raduateR#option

Roption valueDM-ADM-AR#option

Roption valueD-AD-AR#option

Roption valueDMaster (egreeDMaster

(egreeR#option R#selectR#td

Rtd alignDleftD-ontact >oR#td

Rtd alignDleftDRinput nameDcontactPnoD typeDte%tD idDcontactPnoD

valueDREphp echo [dataH[contactPnoUED si?eD0;D ma%lengthD01DR#td

R#tr


Rtd alignDleftD,rimary 5mail : R#td

Rtd alignDleftDRinput nameDemail2D typeDte%tD idDemail2D

valueDREphp echo [dataHWemail2WUED si?eD0;D ma%lengthD211DR#td

Rtd alignDleftDSecondary 5mailR#td

Rtd alignDleftDRinput nameDemail0D typeDte%tD idDemail0D

valueDREphp echo [dataHWemail0WUED si?eD0;D ma%lengthD211DR#td

R#tr


Rtd alignDleftD-ity : R#td

Rtd colspanDGD alignDleftDRinput nameDcityD typeDte%tD idDcityD

valueDREphp echo [dataHWcityWUED si?eD0;D ma%lengthDG1DR#td

R#tr


Rtd alignDleftDAddress : R#td

Rtd colspanDGD alignDleftDRte%tarea nameDaddressD

ro!sD0D colsD\1DREphp echo [dataHWaddressWUER#te%tareaR#td

R#tr

Rtr classDstylesmallD Rtd

alignDleftD(escription : R#td


76/95

Rtd colspanDGD alignDleftDRte%tarea nameDdescriptionD ro!sDGD

colsD\1DREphp echo [dataHWdescriptionWUER#te%tareaR#td

R#tr

Rtr


R#tr

Rtr

Rtd colspanD\D alignDcenterDRinput nameDupdateD

typeDsubmitD idDupdateD valueD/pdateD

Rinput nameDcloseD typeDbuttonD idDcloseD valueD-loseD

on-lic"Dself.locationW(isplayAll.phpWDR#td

R#tr

R#tableR#td

R#tr


Rtd !idthD211LD heightD;LD alignDcenterDREphp include

W4ooter.phpWUER#td

R#tr

R#table

R#form

R#body

R#html

AdminDEditDStudentDnfoD$andler

REphp

sessionPstart89U

[sessionPid [PS5SSI3>HWuseridWU

if8[sessionPid null9Y

header8Dlocation:inde%.phpD9U

die89U

Z


77/95


[studentPid [P,3STHWstudentPidWU

[firstPname [P,3STHWfirstPnameWU

[lastPname [P,3STHWlastPnameWU

[gender [P,3STHWgenderWU

[contactPno [P,3STHWcontactPnoWU

[+ualification [P,3STHW+ualificationWU

[city [P,3STHWcityWU

[email2 [P,3STHWemail2WU [email0

[P,3STHWemail0WU [address

[P,3STHWaddressWU [description

[P,3STHWdescriptionWU

[dateofbirth date8DB&m&dDstrtotime8[P,3STHWdobW99U

[flag DDU

[+uery Dupdate studentPinformation set

firstPnameW[firstPnameWlastPnameW[lastPnameWgenderW[genderWdatePofP

birthW[dateofbirthWDU

[+uery .

D+ualificationW[+ualificationWcontactPnoW[contactPnoWemail2W[email2Wemail

0W[email0WcityW[cityWaddressW[addressWdescriptionW[descriptionW DU

[+uery . D !here studentPidW[studentPidWDU

[result mys+lP+uery8[+uery [lin"Pid9U


die8mys+lPerror899U

Z

if8[result9

Y

[flag DsuccessDU

Z

else

Y

[flag DerrorDU

Z


78/95

header8Dlocation:AdminP5ditPStudentPInfo.phpE

flag[flagstudentPid[studentPidD9U

E

+alidation*&"

function chec"(ate8dobStr9

Y

var arr dobStr.split8#U

if8arr.length ] G9Y

return falseUZ

var ddStr arrH1U

var mmStr arrH2U

var yyStr arrH0U

if8is>a>8ddStr99Y

return falseU

Zif8is>a>8mmStr99

Y return

falseU

Z

if8is>a>8yyStr99

Y return

falseU

Z

ddparseInt8ddStr219U

mmparseInt8mmStr219U

yyparseInt8yyStr219U

if8dd R 2 `` dd G29Y

return falseU


79/95

Z

if8mm R 2 `` mm 209Y


80/95

return falseU

Z

if8yy R 2J119

Y return

falseU

Z

if8yy G1119

Y return

falseU

Z

s!itch 8mm9

Y case 2:

case G:

case ;:

case X:

case V:

case 21:

case 20:

return trueU

case \:

case K:

case J:

case 22:

if8ddRG19

return trueU

else

return falseU

case 0: if8yy

L21119

Y if8yyL\1119

Y

if8ddR0J9

return trueUelse


81/95

return falseU

Z


82/95

Z

else

Y if8yyL\19Y

if8ddR0J9

return trueU

else

return falseU

Z

Z

if8ddR0V9

Y return trueU

Z

else

Y return falseU

Z

default :

return falseU

Z

Z

function email


83/95

body Y

margin&left: 1p%U

margin&top: 1p%Umargin&right: 1p%U

margin&bottom: 1p%U

Z

.stylebig Y

font&si?e: 2Vp%U

font&family: DTimes >e! *omanD Times serifU

font&!eight: boldUZ

.stylemedium Y font&

si?e: 2\p%U


font&!eight: boldU

Z

.stylesmall Y


font&si?e: 20p%U

font&!eight: boldU

Z

.stylegreen Yfont&family: DTimes >e! *omanD Times serifU font&si?e: 20p%U

font&!eight: boldU color: ^11X411U Z

.stylered Y

font&si?e: 20p%U


color: ̂ 441111U

font&!eight: boldU

Z

.stylegrey Yfont&family: DTimes >e! *omanD Times serifU font&si?e: 20p%U

font&!eight: boldU color: ^;;11;;U Z


84/95

.stylegreyre Yfont&family: DTimes >e! *omanD Times serifU font&si?e: 20p%U

font&!eight: boldU color: ^---U Z

.stylelin" Yfont&family: DTimes >e! *omanD Times serifU font&si?e: 20p%U font&

!eight: boldU color: ^AA1111U Z

.stylelin"0 Yfont&family: DTimes >e! *omanD Times serifU font&si?e: 20p%U

font&!eight: boldU color: ^JJJU Z

Connect*php

REphp

[host DlocalhostDU

[dbusername DrootDU

[dbpass!ord DDU

[dbname DstudentDU

[lin"Pid mys+lPconnect8[host [dbusername [dbpass!ord9U

if8][lin"Pid9Y

die8mys+lPerror8D-anQt -onnect To databaseD99U

Z

elseY

[db mys+lPselectPdb8[dbname [lin"Pid9U

Z

if8][db9Y

die8mys+lPerror8D-anQt select databaseD99U

Z

returnUE

SNAPS$OTS


85/95

This is the homepage#inde%page of the site.

This is the student loginpage.


86/95

This is the registration page !here students can register online.

After successful

registration the user account needs to be first

enabled by the administrator.The

students can then login into their

accounts !ith the id and pass!ord

they choose during registration.Theabove page sho!s student login

page.


87/95

After logging in the student home page is opened as sho!n above.

The student can vie! their

profile.The above pagesho!s the user profile.The

lin" to the resume is sho!n if a

resume !as uploaded during

registration other!ise its not sho!n.


88/95

Students can edit their profiles by using the edit profile option on their homepage.the

above page is used for editing student information.

The students have the option to changetheir pass!ord.They need their old

pass!ord in order to change the

pass!ord.


89/95


90/95

This is the homepage of administrator.

This is the

displayallpage

!herein the administrator

can see all the registered

students.'e can

enable#disable their accounts as !ell as

vie!#edit students

information.


91/95

This page sho!s the change in account status.after successful change a message is

displayed to the administrator.

This is the search page and it providessearch function to the administrator.here

!e search for all the students !ith theirs

accounts enabled.


92/95

This is the search result display page.the administrator can vie! profile of any of the

searched students from here.If there are no results then an appropriate message is

displayed.


93/95

SCOPE O6 T$E PROJECT

The Student Information Management System8SIMS9 can be enhanced to

include some other functionality li"e mar"sattendance management.

Talent management of students based on their performance evaluation

can be added.

Social net!or"ing can also be added !herein students can interact !ith

each other.

3nline class functionality can be added.

-an evolve as an online institution.

4unctionality of chat and messages can beadded. 3nline e%am functionality can be added.

3nline resume builder functionality can also be added.


94/95

CONTRB.TON N T$E PROJECT

Student information management system lead to a better organi?ation structure

since the information management of the students is !ell structured and also lead to

better as !ell as efficient utili?ation of resources.



manual system as the information is scattered can be redundant and collecting

relevant information may be very time consuming. All these problems are solved

using this project

3ur project Student Information Management System !as developed by all three of

us.$e a team of three persons too" a step by step approach in order to reach our

goal.$e applied the "no!ledge !e gained during our training period at EN

Technologie" P1t* -td* and developed this project 7ST.%ENT N6OR)ATON

)ANA'E)ENT S:STE)8.


95/95

Bibliography

1· ,', boo" by

project report on student information management system in php

Documents