SEMINAR ON INDUSTRIAL TRAINING

(June-July, 2013)


COLLEGE MANAGEMENT SYSTEM

Submitted by
EKTA BANSAL
Registration Number: 11002916

Under the Guidance of
MR AMAN SINGH
MANAGING DIRECTOR
NETMAX TECHNOLOGIES
BATHINDA

Discipline of CSE/IT
Lovely Professional University, Phagwara
June-July, 2013.



SEMINAR ON INDUSTRIAL TRAINING
(June-July, 2013)


COLLEGE MANAGEMENT SYSTEM

Submitted by
EKTA BANSAL
Registration Number: 11002916

Under the Guidance of
MR AMAN SINGH
MANAGING DIRECTOR
NETMAX TECHNOLOGIES
BATHINDA

Discipline of CSE/IT
Lovely Professional University, Phagwara
June-July, 2013.



DECLARATION
I hereby declare that I have completed my six weeks summer training at Netmax
Technologies Bathinda from June 13 to July 13 under the guidance of MR Aman
Singh, M.D of institute. I have worked with full dedication during these six weeks
and my learning outcomes fulfill the requirements of training.



(Signature of Student)
Name of Student: Ekta Bansal
Registration Number: 11002916



Date: ___________________








ACKNOWLEDGEMENT
Apart from my efforts, the success of my project depends largely on the
encouragement and guidelines of many others. I take this opportunity to express
my gratitude to the people who have been instrumental in the successful
completion of this project.
We are gratefully in debited to our esteemed guide for the project Mr. Aman Singh
of the for his sincere guidance encouragement and priceless support without which
it would have been impossible for us to complete the system study, coding and
designing of this project.
Last but certainly not the least; we are extremely thankful to all of the staff
of NETMAX Bathinda for having generously provided us with necessary
guidance, encouragement and moral support during the course of the project.












INDEX
1) ORGANIZATION OVERWIEW
2) PROFILE OF THE PROBLEM
3) EXISTING SYSTEM
4) PROBLEM ANALYSIS
a) PRODUCT DEFINATION
b) FEASIBILITY ANALYSIS
i) HARDWARE FEASIBILTY
ii) OPERATIONAL FEASIBILITY
iii) TECHNICAL FEASIBILITY
iv) ECNOMICAL FEASIBILITY
5) SOFTWARE REQUIREMENT ANALYSIS
6) DESIGN
a) TABLE AND THEIR RELATIONSHIP
b) FLOWCHART
7) SOURCE CODE
8) SCREEN SHOTS
9) GANTT CHART
10) PROJECT LEGACY
a) TECHNICAL LESSON LEARNT
b) MANAGERIAL LESSON LEARNT
11) BIBLIOGRAPHY


1

1. ORGANIZATION OVERVIEW
Netmax Technologies, an ISO 9001:2008 Certified Organization was established in 2001 with an
aim to provide world class professional training and solutions in Advance Networking,
Embedded Systems Design and IT Solutions.
Mission: To provide world class professional training and solutions in advance networking,
embedded systems design and career services for IT professionals as well as electronic system
designers.
Netmax Technologies provides industrial training to B.Tech /MCA / BCA/Diploma students in
fields like
Embedded systems
Robotics
PLC and SCADA Automation Technologies,
Advance Networking Technologies(CISCO)
JAVA development
.NET development
PHP programming and Web development
Red hat (RHCE) and Unbent Administration
Microsoft System Administration( MCSE 2003 , MCITP 2008 )
Technology Focus:-
They specialized in building solution around the following key technologies:-
Microsoft
Java
C/C++
Mobile


2

Key Alliances:-
Microsoft
IBM
Oracle

2. PROFILE OF THE PROBLEM
I have to create a web based graphical user interface (platform independent and user friendly)
which can be fitted into any college system. As you know there are Thousands of college and
schools in a city, and there are lakhs of students who came around the works to learn and study.
So every college would like to collect all information of Students. The system should provide the
detail structure of the college campus and its departments. College Management
System synchronizes the working of all the departments. It should looks on all aspects of a
college, its students, Departments, marks and other co curricular activities.
College management system should include following features:-
About college itself
Courses offered
Latest updates
About placement
Student fee management
Student result management
Student batch and program management
Different type of user should include:
Student
Admin

3

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

Problems in existing system:
It was limited to a single system.
It was less user friendly.
It have lots of manual work, which also include working on spreadsheets and other
softwares.
It requires more no of employee for work
It was time consuming process.

Solution to these problems:
The development of the new system contains the following activities, which try to
automate the entire process keeping in view of the database integration approach
User friendliness is provided in the application with various controls.
The system makes the overall projects management much easier and flexible.
It can be accessed over the Internet.


4. PROBLEM ANALYSIS
Analysis is a detailed study of the various operation performed by the system and their
relationship within and outside of the system. A key question what must be done to solve the
problems during analysis data collected on the available files decision pioneers and transaction
handled by the present system.

4

PRODUCT DEFINITION
The problem is to provide the complete information about the college campus. In which the
college, students and parents can access the information and will be familiar with college
campus. It will provide interactive environment for the staff, students and parents by getting
knowledge of student, fees, exams performances etc.
The College management system is an automated version of manual Student Management
System. It can handle all details about a student. The details include college details, subject
details, student personnel details, academic details, exam details etc... In case of manual system
they need a lot of time, manpower etc.Here almost all work is computerized. So the accuracy is
maintained. Maintaining backup is very easy. It can do within a few minutes. Our system has
two type of accessing modes, administrator and user. Student management system is managed by
an administrator. It is the job of the administrator to insert update and monitor the whole process.
When a user log into the system. He would only view details of the student. He can't perform any
changes.
FEASIBILITY ANALYSIS:-
After studying all the problem solution for the College feasible solution was decided on the basis
of:
HARDWARE FEASIBILITY
This project needs one computer with core 2 duo or higher processors. The memory
requirement is 3GB RAM ,higer will also do. This is very feasible in this perspective.
SOFTWARE FEASIBILITY
This project can be loaded on any of the system having any of the Windows operating
system.


5

OPERATIONAL FEASIBILITY
The project is easy to maintain and use. So there is no need of special training for the
maintenance staff. There will be no resistance from the user side.
TECHNICAL FEASIBILITY
Points in concern with the technical feasibility of our proposed system-
The technology i.e. hardware and software which we have used is normally available.
It is easy to implement.
Our system is capable for up gradation account to users demand within the budget.
Since our system proposes all the necessary technical resources so it is technically
feasible.
The system is easy to maintain and very attractive for user.
We can strongly says that it is technically feasible, since there will not be much difficulty in
getting required resources for the development and maintaining the system as well. All the
resources needed for the development of the software as well as the maintenance of the same
is available in the organization here we are utilizing the resources which are available
already.
ECONOMICAL FEASIBILITY
Development of this application is highly economically feasible .The organization needed not
spend much money for the development of t he system already available. The only thing is to
be done is making an environment for the development with an effective supervision. I f we
are doing so , we can attain the maximum usability of the corresponding resources .Even
after the development , the organization will not be in condition to invest more in t he
organization .Therefore , the system is economically feasible.
Hardware and software cost evolved is not too costly.
The technology used for the implementing the system is not expensive

6

5. SOFTWARE REQUIREMENT ANALYIS
Minimum software requirement for project
FRONT END: PHP
BACK END: MYSQL
Core 2 duo or higher
256 Mb RAM or higher will do
Network Connections with 100 Mbps transfer rate
Server to control the database to be maintained by software.
1 Mb cache memory
My sql
6. DESIGN
The most creative and challenging face of the system life cycle is system design. The term
design describes a final system and the process by which it is developed. The first step is to
determine how the output is to be produced and in what format.
TABLE AND THEIR RELATIONSHIP:
Admin table :

Fees table:


7

Registration table:

Result table:


Relationship between Tables:






ADMIN FEES
RESULT

8









FLOWCHART:Flow chart is a graphical or symbolic representation of a process. Each step in
the process is represented by a different symbol and contains a short description of the process
step. The flow chart symbols are linked together with arrows showing the process flow direction.
FLOWCHARTS USED IN THIS PROJECT:










REGISTRATION FEES
RESULT


















ADMIN
LOGIN
IF NOT VALID
GO BACK
IF VALID
UPDATE

9










CONTEXT FLOW DIAGRAM (0 LEVEL DFD)











STUDENT
LOGIN
IF NOT VALID
GO BACK
IF VALID
FETCH ,SEE
DATA
ADMINISTRATOR
COLLEGE MANAGEMENT
SYSTEM
DATABASE
ADMINISTRATOR
LOGIN
DATABASE
STUDENT
COURSE
COURSE DETAIL

10









7. SOURCE CODE
This project is made of various different php pages which is as follow:
1. Home
2. Admin
3. About
4. Contact
5. Placement
6. Change
7. Courses
8. Logout
9. Fee
10. Rslt
11. student
12. Registration
13. Result
14. Config
15. Cpwd
16. Flog
STUDENT
REGISTER
STUDENT REGISTRATION

11

17. Fees
CSS:
Netmax
DATABASE:
Netmax


HOME.php:
<title>College Management System</title>
<link href="css/webvator.css" rel="stylesheet" type="text/css">

<style type="text/css">
<!--
#navigation a {
font:11px Arial, Helvetica, sans-serif;
color: #ffffff;
text-decoration: none;
letter-spacing:.1em;
line-height:16px;
display:block;
padding: 0px 10px;

12

border-right-width: 1px;
border-right-style: solid;
border-right-color: #ffffff;
}

#navigation a:hover {
color:#106C21;
background-image:url(images/hover-gif.gif);
font-size:12px;

}

.search_bg {
background-image: url(images/search_bg.gif);
width:292px;
height:202px;
}

.menu {
height: 33px;
width: 2px;

13

font-family: Arial, Helvetica, sans-serif;
font-size: 9px;

}


.top_nav_text_first
{
FONT-WEIGHT: normal;
FONT-SIZE: 9pt;
COLOR: #000000;
FONT-FAMILY: Verdana;
vertical-align:top;
line-height:24px;
display:block;
padding: 0px 10px;
border-right-width: 1px;
border-right-style: solid;
border-right-color: #000000;
}


14

.top_nav_text_last
{
FONT-WEIGHT: normal;
FONT-SIZE: 9pt;
COLOR: #000000;
FONT-FAMILY: Verdana;
vertical-align:top;
line-height:24px;
display:block;
padding: 0px 10px;

}


.top_nav_text_white A:link {color: #000000; font-weight:normal; text-decoration: underline}
.top_nav_text_white A:visited {color: #000000; font-weight:bold; text-decoration: underline}
.top_nav_text_white A:active {color: #000000; font-weight:bold; text-decoration: none}
.top_nav_text_white A:hover {color: #000000; font-weight:bold; text-decoration: none;}

#navigation a:hover {
color:#106C21;

15

background: #ffffff;
}
#padding {
padding:5px;
}
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.time {
color: #FFFFFF;
font-family: Arial, Helvetica, sans-serif;
font-size: 9px;
}

.textfieldLabel {
FONT-WEIGHT: 200;
FONT-SIZE: 11px;
COLOR: #ffffff;

16

FONT-FAMILY: Arial, Helvetica, sans-serif;
list-style-image: url(images/cmn/blt.gif);
word-spacing: 1px;
}
-->
</style>

<style type="text/css">

#pscroller1{
width: 280px;
height: 60px;
border: 1px solid WHITE;
font-family:Arial, Helvetica, sans-serif;
font-size:12px;
}

.someclass{ //class to apply to your scroller(s) if desired
}
</style>


17

<body>
<table align="center" border="0" cellpadding="0" cellspacing="0" height="100%"
width="100%">
<tbody><tr>
<td colspan="3" width="50%"></td>
<td>
<table align="center" border="0" cellpadding="0" cellspacing="0" height="100%"
width="100%">
<tbody><tr><td height="50%"></td></tr>
<tr>
<td align="left" valign="top">
<table align="left" border="0" cellpadding="0" cellspacing="0" height="100%" width="970">
<tbody><tr>
<td colspan="3" valign="top"><table width="970" border="0" cellpadding="0"
cellspacing="0">
<tbody><tr>
<td width="921" align="left" valign="top"><strong><img src="bfcet.jpg" width="968"
height="254" alt="webvator.com"></strong></td>
</tr>
<tr class="menu" bgcolor="#c70000">
<td colspan="2">
<div align="center">

18

<table id="navigation" align="center" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
<td class="navText" style="padding-left:195px;" align="center" nowrap="nowrap"><strong><a
href="home.php" style="font-weight:bolder;font-size:15px;" >HOME</a></strong></td>
<td class="navText" align="center" nowrap="nowrap"><strong><a
href="about.php"style="font-weight:bolder;font-size:12px;" >ABOUT US</a></strong></td>
<td class="navText" align="center" nowrap="nowrap"><strong><a href="courses.php"
style="font-weight:bolder;font-size:12px;" >COURSES</a></strong></td>
<td class="navText" align="center" nowrap="nowrap"><strong><a href="placements.php"
style="font-weight:bolder;font-size:12px;" >PLACEMENTS</a></strong></td>

<td class="navText" align="center" nowrap="nowrap"><strong><a href="flog.php" style="font-
weight:bolder;font-size:12px;" >LOGIN</a></strong></td>
<td class="navText" align="center" nowrap="nowrap"><strong><a href="contact.php"
style="font-weight:bolder;font-size:12px;" >CONTACT US</a></strong></td>
<td class="navText" align="center" nowrap="nowrap"><strong><a href="registration.php"
style="font-weight:bolder;font-size:12px;" >REGISTRATION</a></strong></td>

</tr>
</tbody></table>
</div>
</td>
</tr>

19

</tbody></table>
<strong>
<script src="js/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-3063738-10";
urchinTracker();
</script>
</strong></td>
</tr>
<tr>
<td style="border-left: 1px solid rgb(16, 108, 33);background:-webkit-gradient(linear, 80% 20%,
10% 21%, from(#FFD9D3), to(#AA0000))" align="left" background="images/rightbg.png"
valign="top" width="203">
<table align="left" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
<td>
<table align="center" border="0" cellpadding="0" cellspacing="1" width="100%">
<tbody><tr><td height="2"></td></tr>
<tr>
<td style="border: 1px solid rgb(208, 208, 198);" width="180">
<div id="calendarDiv" name="calendarDiv" style="width:180px;">

20

<table id="Table3" align="center" border="0" cellpadding="2" cellspacing="0" width="180">
<tbody><tr>
<td align="center"><p><strong>Follow us on Twitter</strong></p>
</td>
</tr>
</tbody></table>

</div></td>
</tr>
<tr><td height="2"></td></tr>
<tr>
<td style="border: 1px solid rgb(208, 208, 198);" bgcolor="white" width="180"><strong><a
href="home.php"><img src="images/webvator-slice9.jpg" width="182" height="121"
border="0"></a>
</strong>
<table align="center" border="0" cellpadding="1" cellspacing="0" width="100%">
<tbody><tr>
<td align="center"><strong>Follow us on Facebook</strong></td>
</tr>
<tr><td height="10">

</td></tr>

21

</tbody></table>
</td>
</tr>

</tbody></table>
</td>
</tr>
</tbody></table>
</td>
<td valign="top">
<strong>
<!------------- main content starts here ----------------------->
</strong>
<table align="center" border="0" cellpadding="0" cellspacing="0" width="645">
<!-- main article starts here -->
<tbody><tr>
<td class="border_left_right_box">
<table align="left" border="0" cellpadding="0" cellspacing="2">
<tbody><tr><td height="3"></td></tr>

<tr>

22

<td><strong><img src="images/webvator-slice1.jpg" style="border: 1px solid rgb(204, 204,
204);" height="197" width="260"></strong></td>
<td width="3"></td>
<td valign="top">
<table align="center" border="0" cellpadding="0" cellspacing="2">
<tbody><tr>
<td class="home_page_main_article_heading" valign="top" style="color:black">BANSAL
INSTITUTE OF ENGINEERING AND TECHNOLOGY </td>
</tr>
<tr><td height="20"></td>
</tr><tr><td class="home_page_main_article_content" valign="top">The college is proud of
having a fully computerized, centrally air conditioned and well stocked library having more than
10000 books in all relevant subjects. With subscription to national and international technical
journals, it caters to the varied need of students and staff alike. All transactions of books are done
through smart cards. The library also subscribes to all latest general and informative current
affairs magazines.</td>
</tr>
<tr>
<td class="read_more">
<strong><a class="read_more" href="#" title="Full Story">Read More
</a></strong></td>
</tr>
</tbody></table>
</td>

23

</tr>
</tbody></table>
</td>
</tr>
<!-- main article ends here -->
<tr>
<td class="border_left_right_box" bgcolor="#EAEAE0">
<table align="center" border="0" cellpadding="0" cellspacing="2">
<tbody>
<tr>
<td style="padding-top:10PX;" ><strong>

ADMIN.php:
<?php
session_start();
?>
<?php
if(isset($_POST['login']))
{
include("config.php");
$user = $_POST['user'];

24

$pass = $_POST['pass'];
$result=mysql_query("select * from admin where user='$_POST[user]' &&
pass='$_POST[pass]'");
$count = mysql_num_rows($result);
$row = mysql_fetch_array($result);
if($count==1)
{
$_SESSION['user']=$row['user'];
header('Location:fees.php');
}
else
{
print "Invalid username or password";
}
mysql_close($con);
}
?>

<form style="padding-left:190px;padding-top:30px;" action="<?php print
$_SERVER['PHP_SELF'];?>" method="post">



25

Change.php:
<?php
session_start();
?>
<?php
if (isset($_POST['submit']))
{
$user=$_SESSION['user'];
include("config.php");
$result=mysql_query("update admin set pass='$_POST[npass]' where user='$user' ");
mysql_close($con);
}
?>
<form style="padding-left:150px;padding-top:30px;" enctype="multipart/form-data"
action="<?php print $_SERVER['PHP_SELF'];?>" method="post">



Logout:
<?php
session_destroy();

26

header('Location:home.php');
?>
Fee.php:
<?php
session_start();
?>
<form style="padding-left:150px;padding-top:30px;" enctype="multipart/form-data"
action="<?php print $_SERVER['PHP_SELF'];?>" method="post">

<?php
$email = $_SESSION['email'];
include("config.php");
$result1=mysql_query("select * from registration where email='$email'");
print "<center><table border='1' cellpadding='5px' style='border-collapse:collapse;'>";
$row1 = mysql_fetch_array($result1);
$rollno = $row1['id'];
$result = mysql_query("select * from fees where rollno=$rollno");
while($row=mysql_fetch_array($result))
{
?>
<tr>

27

<th>UNI NO</th>
<td> <?php print $row['uni']; ?></td>
</tr>
<tr>
<th>ROLL NO</th>
<td><?php print $row['rollno']; ?></td>
</tr>
<tr>
<th>TOTAL FEES</th>
<td><?php print $row['total']; ?></td>
</tr>
<tr>
<th>FEES PAID</th>
<td><?php print $row['paid']; ?></td>
</tr>
<tr>
<th>BALANCE</th>
<td><?php print $row['balance']; ?></td>
</tr>
<?php
}

28

print "</table></center>";
mysql_close($con);
?>

Rslt.php:
<?php
session_start();
?>

<?php
$email = $_SESSION['email'];
include("config.php");
$result1=mysql_query("select * from registration where email='$email'");
print "<center><table border='1'cellpadding='5px' style='border-collapse:collapse;'>";
$row1 = mysql_fetch_array($result1);
$rollno = $row1['id'];
$result = mysql_query("select * from result where rollno=$rollno");
while($row=mysql_fetch_array($result))
{
?>
<tr>

29

<th>ROLL NO</th>
<td><?php print $row['rollno']; ?></td>
</tr>
<tr>
<th>TOTAL MARKS</th>
<td><?php print $row['total']; ?></td>
</tr>
<tr>
<th>MARKS OBTAINED</th>
<td><?php print $row['obtained']; ?></td>
</tr>

<?php
}
print "</table></center>";
mysql_close($con);
?>

Student.php:
<?php
session_start();

30

?>
<form style="padding-left:150px;padding-top:30px;" enctype="multipart/form-data"
action="<?php print $_SERVER['PHP_SELF'];?>" method="post">
<?php
$email = $_SESSION['email'];
include("config.php");
$result=mysql_query("select * from registration where email = '$email'");
print "<table border='1' cellpadding='5px' style='border-collapse:collapse;'>";
while($row=mysql_fetch_array($result))
{
?>
<tr>
<th>ID</th>
<td>
<?php print $row['id']; ?>
</td>
</tr>
<th>NAME</th>
<td>
<?php print $row['name'];?>
</td>

31

</tr>
<tr>
<th>E-MAIL</th>
<td>
<?php print $row['email']; ?>
</td>
</tr>
<tr>
<th>MOBILE</th>
<td>
<?php print $row['mobile'];?>
</td>
</tr>
<tr>
<th>DOB</th>
<td>
<?php print $row['dob']; ?>
</td>
</tr>
<tr>
<th>COURSE</th>

32

<td>
<?php print $row['course'];?>
</td>
</tr>
<tr>
<th>BRANCH</th>
<td>
<?php print $row['branch'];?>
</td>
</tr>
<tr>
<th>BATCH</th>
<td>
<?php print $row['batch'];?>
</td>
</tr>
<img style="float:left;padding-right:50px;" src="image/<?php print $row['Image'];?>"
height="200" width="200">
<?php
}
print "</table>";

33

mysql_close($con);
?>
Registration.php:
<?php
if (isset($_POST['register']))
{
if(isset($_FILES['image']));
{
$pic=$_FILES['image']['name'];
$random_digit=rand(0000,9999);
$new_file_name=$random_digit.$pic;
$path="image/".$new_file_name;
}
if(copy($_FILES['image']['tmp_name'],$path));
{
header('Location:flog.php');
}

include("config.php");
mysql_query("INSERT INTO
registration(name,email,pwd,mobile,dob,course,branch,batch,image)

34

values('$_POST[name]','$_POST[email]','$_POST[pwd]','$_POST[mobile]','$_POST[dob]','$_P
OST[course]','$_POST[branch]','$_POST[batch]','$new_file_name') ");

mysql_close($con);
}
?>
<center>
<form style="padding-left:190px;padding-top:30px;" enctype="multipart/form-data"
action="<?php print $_SERVER['PHP_SELF'];?>" method="post">
Result.php:
<?php
session_start();
?>
<?php
if (isset($_POST['submit']))
{
include("config.php");
mysql_query("INSERT INTO result(rollno,total,obtained)
values('$_POST[rollno]','$_POST[total]','$_POST[obtained]') ");
echo "Result Entered Successfully";
mysql_close($con);
}

35

?>
<form style="padding-left:190px;padding-top:30px;" enctype="multipart/form-data"
action="<?php print $_SERVER['PHP_SELF'];?>" method="post">

Cpwd.php:
<?php
session_start();
?>
<?php
if (isset($_POST['submit']))
{
$email=$_SESSION['email'];
include("config.php");
$result=mysql_query("update registration set pwd='$_POST[npwd]' where email='$email' ");
echo "Password Changed Successfully";
mysql_close($con);
}
?>
<form style="padding-left:150px;padding-top:30px;" enctype="multipart/form-data"
action="<?php print $_SERVER['PHP_SELF'];?>" method="post">
Flog.php:
<?php

36

session_start();
?>
<?php
if(isset($_POST['login']))
{
include("config.php");
$email = $_POST['email'];
$pwd = $_POST['pwd'];
$result=mysql_query("select * from registration where email='$_POST[email]' &&
pwd='$_POST[pwd]'");
$count = mysql_num_rows($result);
$row = mysql_fetch_array($result);
if($count==1)
{
$_SESSION['email'] = $row['email'];
header('Location:student.php');
}
else
{
print "Invalid username or password";
}

37

mysql_close($con);
}
?>

<form style="padding-left:190px;padding-top:30px;" action="<?php print
$_SERVER['PHP_SELF'];?>" method="post">

Fees.php:
<?php
if (isset($_POST['submit']))
{
include("config.php");
mysql_query("INSERT INTO fees(uni,rollno,total,paid,balance)
values('$_POST[uni]','$_POST[rollno]','$_POST[total]','$_POST[paid]','$_POST[balance]') ");
echo "Fees Entered Successfully";
mysql_close($con);
}
?>
<form style="padding-left:190px;padding-top:30px;" enctype="multipart/form-data"
action="<?php print $_SERVER['PHP_SELF'];?>" method="post">
Config.php:
<?php

38

$con = mysql_connect("localhost","root","");
if(!$con)
{
die("Could not connect".mysql_error());
}
mysql_select_db("netmax",$con);
?>
Netmax.css:
body {
margin: 0;
padding: 0;
background: #FFFFFF url(images/img01.jpg) repeat-x ;
font: 13px Georgia, "Times New Roman", Times, serif;
color: #666666;
}
dl
{
padding-top:10px;
padding-left:150px;
margin:100px;
list-style: none;

39

}
li
{
display: inline;
}
a {
padding-right:50px;
text-decoration:none;
letter-spacing: -1px;
font-size: 1.2em;
font-weight: bold;
color: #333333;
}








40

8. SCREENSHOTS:
Home.php:




41

About us
Courses offered:


42

Placements:


Student login:





43

Student Registration:

Admin Login:






44

9. GANTT CHART:
1 WEEK 2 WEEK 3 WEEK 4 WEEK 5 WEEK 6WEEK
LEARN HTML
LEARN CSS
STARTING OF
PROJECT
LEARN PHP
LEARN
MYSQL
FINAL WORK
ON PROJECT

10. PROJECT LEGACY
TECHNICAL LESSON LEARNT:
During this project I have learnt about :
Html
Css
Php
Mysql
Developing a Web Database Application Using PHP and MySQL
HTML:
HTML is a language for describing web pages.
HTML stands for Hyper Text Markup Language

45

HTML is not a programming language, it is a markup language
A markup language is a set of markup tags
HTML uses markup tags to describe web pages
When you save an HTML file, you can use either the .htm or the .html extension. We use
.htm in our examples. It is a habit from the past, when the software only allowed three letters
in file extensions.
With new software it is perfectly safe to use .html.
CSS:
Cascading style sheet enable us to precisely control the formatting of element on our
webpages.Html was designed to control the structure of our web pages, such as headings,
images, links, paragraphs and tables. Style sheets were designed to control the formatting of
these elements in far greater detail than the HTML commands allow. Styles are the rules that
define how the elements appear in web pages such as font and color.
Three types of css: -
1. Inline
2. Internal
3. External
PHP:
Hypertext Preprocessor. In its early development by a guy named Rasmus Lerdorf, it was called
Personal Home Page tools. When it developed into a full-blown language, the name was
changed to be more inline with its expanded functionality. The PHP languages is known as shell
scripting language
PHP is actually simpler than because it doesnt use some of the more difficult concepts of C.
PHP also doesnt include the low-level programming capabilities of C because PHP is designed

46

to program Web sites and doesnt require those capabilities.PHP is particularly strong in its
ability to interact with databases.
PHP support every database weve ever heard of (and some we havent). PHP handles
connecting to the database and communicating with it.
PHP is an embedded scripting language when used in Web pages. This means that PHP code is
embedded in HTML code. WE use HTML tags to enclose the PHP language that WE embed in
our HTML file the same way that WE would use other HTML tags. WE create and edit Web
pages containing PHP the same way that WE create and edit regular HTML pages.

MYSQL:
MySQL is a fast, easy-to-use RDBMS used on many Web sites. Speed was the developers main
focus from the beginning. In the interest of speed, they made the decision to offer fewer features
than their major competitors (such as Oracle and Sybase). However, even though MySQL is less
full-featured than its commercial competitors, it has all the features needed by the majority of
database developers. Its easier to install and use than its commercial competitors, and the
difference in price is strongly in MySQLs favor.
MySQL is developed, marketed, and supported by MySQL AB, which is a Swedish company.
MySQL is a popular database with Web developers. Its speed and small size make it ideal for a
Web site. Add to that the fact that its open source, which means free, and WE have the
foundation of its popularity. Here is a rundown of some of its advantages:

Its fast. The main goal of the folks who developed MySQL was speed. Thus, the
software was designed from the beginning with speed in mind.
Its inexpensive. MySQL is free under the open source GPL license, and the fee for a
commercial license is reasonable.
Its easy to use. WE can build and interact with a MySQL database by using a few
simple statements in the SQL language, which is the standard language for

47

communicating with RDBMSs. Check out Chapter 4 for the lowdown on the SQL
language.

DEVELOPING A WEB BASED APPLICATION USING PHP AND MYSQL
The PHP software works with the Web server. The Web server is the software that delivers Web
pages to the world. When we type a URL into our Web browser, we are sending a message to the
Web server at that URL, asking it to send an HTML file. The Web server responds by sending
the requested file. Web browser reads the HTML file and displays the Web page. We also
request the Web server to send web a file when we click a link in a Web page.
In addition, the Web server processes a file when WE click a Web page button that submits a
form. When PHP is installed, the Web server is configured to expect certain file extensions to
contain PHP language statements. Often the extension is .php or .phtml, but any extension can be
used. When the Web server gets a request for a file with the designated extension, it sends the
HTML statements as-it-is. But PHP statements are processed by the PHP software before theyre
sent to the requester.
When PHP language statements are processed, only the output is sent by the Web server to the
Web browser. The PHP language statements are not included in the output sent to the browser,
so the PHP code is secure and transparent to the user. users browser. The browser interprets the
statement as HTML code and displays a Web page with one paragraph hello World. The PHP
statement is not delivered to the browser, so the user never sees any PHP statements. PHP and
the Web server must work closely together.






48

MANAGERIAL LESSON LEARNT:
The College management system is an automated version of manual Student Management
System. It can handle all details about a student. The details include college details, subject
details, student personnel details, academic details, exam details etc... In case of manual system
they need a lot of time, manpower etc.Here almost all work is computerized. So the accuracy is
maintained. Maintaining backup is very easy. It can do wit in a few minutes. Our system has two
type of accessing modes, administrator and user. Student management system is managed by an
administrator. It is the job of the administrator to insert update and monitor the whole process.
When a user will login to the system. He would only view details of the student. He can't
perform any changes.
This System provides one attractive environment where you can manipulate data and information
about students and staff easily. So we can say the Core purpose of designing
College Management System is to manage the task related to the college students/employees
and to reduce time to searching of appropriate candidates in college view.
This system is an integrated web application that handles various academic and non academic
activities of a College/Academic Institute. The system can access by every students of the
institution through internet connected computers or internet enabled mobile devices with the aid
of his user name and password. Every user will have a customized home page with his/her
profile management facilities. Through links that displays in the home page the user can access
different options of the website assigned to him/her. Though the system allows access to
everyone there is a significant security risk involved in this project. To tackle this problem we
suggest a modular structure in the proposed system and a complete isolation of the financial and
administrative modules from the public portal. Only trusted IPs can access these modules. Web
services will interact to the financial and administrative modules to fetch necessary information
to display in the public portal. Although a standard password policy will be followed in the
designing of the system to prevent the possibilities of malicious activities of itching users.



49

11. BIBLIOGRAPHY
http://php.net/manual/en/tutorial.php
http://www.tutorialspoint.com/php
http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
http://www.tutorialspoint.com/mysql/
http://www.collegemanagementsoftware.com/college-
management-system.php
Database Management System by - H. Korth
An integrated approach to software engineering by Pankaj Jalote
http://www.advantainnovations.com/benefits-school-college-
management-system.aspx\
http://www.providence.edu/learn/Pages/facultytutorials.aspx