[go: up one dir, main page]
Scribd
Upload
89 views33 pages

College of Business Science & Technology: Project On

This document describes a student enrollment system project created by three students for their Software Engineering practical course. The project aims to design an enrollment system to easily manage student records using a web-based interface. Key aspects of the project include requirements analysis, system design diagrams, implementation details for login, student listing, adding records, and viewing student information pages using HTML, CSS, PHP and a MySQL database.

Uploaded by

Saeed Khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
89 views33 pages

College of Business Science & Technology: Project On

This document describes a student enrollment system project created by three students for their Software Engineering practical course. The project aims to design an enrollment system to easily manage student records using a web-based interface. Key aspects of the project include requirements analysis, system design diagrams, implementation details for login, student listing, adding records, and viewing student information pages using HTML, CSS, PHP and a MySQL database.

Uploaded by

Saeed Khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 33

College of Business Science & Technology

Project on
Enrolment System
Subject: Software Engineering practical
Subject Code: CSE- 322

Submitted by:
1. Ruhul Amin, ID:210005
2. MD. Sajibul Alam , ID:210019
3. Muzaharul Islam, ID: 210050

Submitted to:
Arifa Sultana Nila
Coordinator ,
Department of Computer Science & Engineering,(CBST)

Date of Submission: 17/09/2018


Objective
It is an Enrollment System of an institution. If this system is designed manually then it becomes
difficult to use. To use this system easily we design it such this way.

Requirements
User requirements description: Administration can make any query regarding a student using
search option and also adding new record, save record, update record, delete record and record
navigation.

System requirements specification:


Functional requirements:
1) There should be a web form to add a new records to database.
2) There should be a web page with all records.
3) There should be a search option that can be used to filter the students.
4) A web page should be used to edit the data of a student and a save button to update
the database.
5) There should be a delete button to remove the associated record.
Non-functional requirements:
1) Administrators should get a login page so that not just anyone is able to view/edit the
data.
2) Administrators should get a log out button in case they want to stop working with the
software and not let someone else access it.
3) The system should be organized in such a way that user errors are minimized.
4) It should not take more than 30 minutes to train the user.

System requirements:
1) Microsoft Windows 7 [Update] or later.
2) Internet Information Services.
3) XAMPP software
4) MYSQL Database
Client requirements:
1) Firefox Quantum Edition.
2) Google Chrome 68.0.3440.106
[official build].

Technology:
We have used several technology to build the project:

1. HTML
2. CSS
3. Javascript
4. PHP
5. MYSQL Database

Model
We have chosen to follow an incremental delivery model for the project as we have chosen to
make a web application that the user can use as soon as a single portion of it is ready to be
delivered and is likable to the user. Fulfilling user requirement is essential to us. This model
enables rapid delivery of the application.
Diagram
Use-case diagram

Fig: Use-case diagram of Enrolment System


ER diagram

Fig: ER diagram of Enrolment system

Dataflow diagram

Fig: Dataflow diagram of Enrolment system


Implementation
Login Page:

Source code for login page:


<!DOCTYPE html>

<html>

<head>

<link rel="stylesheet" type="text/css" href="log.css">

</head>

<body>

<h1 class="center" style="font-size: 78px;">Enrollment System</h1>

<div>

<br>

<div class="form">

<h2 class="ad">Admin Login</h2>

<br><br>

<form class="fd" action="log.php" method="POST">


<input type="text" name="username" placeholder="username"/>

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

<button>login</button>

</form>

</div>

</div>

</body>

</html>

Php script for login page:


<?php

$user=$_POST['username'];

$pass=$_POST['password'];

if($user=='admin')

if($pass=='admin')

header("Location: first.php");

else

$message = "Username and/or Password incorrect.\\nTry again.";

echo "<script type='text/javascript'>alert('$message');</script>";

}?>
Implementation of First page:

Source code for first page:


<?php

$conn=mysqli_connect('localhost','root','','sms');

$sql="SELECT *FROM student";

$result=mysqli_query($conn,$sql);

?>

<!DOCTYPE html>

<html>

<head>

<title>new page</title>

<link rel="stylesheet" type="text/css" href="style.css">


</head>

<body class="wc">

<a style="margin-left: 1131px;" class="button btn-info" href="index.php">logout</a>

<h1 style="font-size: 49px;font-style: italic;color: #6fd080;">Welcome to Student enrollment system</h1>

<br>

<br>

<div class="left">

<br>

<a class="button btn-info" href="insert.php">Add new student</a>

</div>

<div class="right">

<div class="search">

<form id="searchthis" action="search.php" method="POST">

<input id="namanyay-search-box" type="text" name="search" placeholder="search student by ID">

<input id="namanyay-search-btn" type="submit" value="search">

</form>

</div>

<h1 class="center">Student list and their info</h1>

<hr>

<div>

<table >

<thead>

<th class="sp">Name</th>

<th class="sp">ID</th>

<th class="sp">Dept</th>

<th class="sp">Birth</th>

<th class="sp">Action</th>
</thead>

<tbody>

<?php while($row=mysqli_fetch_assoc($result)){?>

<tr>

<td class="center it" style="width: 144px;"><?php echo $row['name'] ?></td>

<td class="center it"><?php echo $row['id'] ?></td>

<td class="center it"><?php echo $row['dept'] ?></td>

<td class="center it"><?php echo $row['birth']?></td>

<td class="special">

<a class="button btn-primary" href="show.php?id=<?php echo $row['id'];?>">View Full Info</a>

<a class="button btn-warning" href="update.php?id=<?php echo $row['id'];?>">update</a>

<a class="button btn-danger" onclick=" return confirm('are you sure')" href="delete.php?id=<?php echo
$row['id'];?>">delete</a>

</td>

</tr>

<?php }?>

</tbody>

</table>

</div>

</div>

</body>

</html>
Implementation of add student page:

Source code for add student page:


<!DOCTYPE html>

<html>

<head>

<title>new page</title>

<link rel="stylesheet" type="text/css" href="style.css">

</head>

<body class="inbody">

<h1 class="center">Add student Full information</h1>

<hr style="border: 2px solid #ff6464;">


<div class="left">

<br>

<a class="button btn-info" href="index.php">View student list</a>

</div>

<div class="right">

<form action="store.php" method="POST">

<div class="form-group">

<label class="it ic" for="Name">Name :</label>

<input required type="text" class="form-control" name="name" placeholder="Enter student name">

</div>

<div class="form-group">

<label class="it ic" for="ID">Student ID :</label>

<input type="text" class="form-control" name="id" placeholder="Student's ID">

</div>

<div class="form-group">

<label class="it ic" for="Dept">Department :</label>

<input type="text" class="form-control" name="dept" placeholder="student's department">

</div>

<div class="form-group">

<label class="it ic" for="Birth">Birth Year :</label>

<input type="text" class="form-control" name="birth" placeholder="Ex: 01/07/2018">

</div>

<div class="form-group">

<label class="it ic" for="Father">Father name :</label>

<input type="text" class="form-control" name="father" placeholder="student's Father name">

</div>

<div class="form-group">

<label class="it ic" for="Mother">Mother name :</label>

<input type="text" class="form-control" name="mother" placeholder="student's mother name">


</div>

<div class="form-group">

<label class="it ic" for="Mobile">Mobile :</label>

<input type="text" class="form-control" name="mobile" placeholder="student's Mobile">

</div>

<div class="form-group">

<label class="it ic" for="Address">Address: </label>

<input type="text" class="form-control" name="address" placeholder="student's Address">

</div>

<button type="submit" class="button btn-info">Submit</button>

</form>

</div>

</body>

</html>

Php script for add student page:


<?php

$name=$_POST['name'];

$id=$_POST['id'];

$dept=$_POST['dept'];

$birth=$_POST['birth'];

$father=$_POST['father'];

$mother=$_POST['mother'];

$mobile=$_POST['mobile'];

$address=$_POST['address'];

$conn=mysqli_connect('localhost','root','','sms');

$sql="INSERT INTO student VALUES('$name','$id','$dept','$birth','$father','$mother','$mobile','$address');";

if(mysqli_query($conn,$sql))
{

header("Location: first.php");

else

echo "sorry not insterted try again";

Implementation of View full info page:

Source code for View page:


<?php

$id=$_GET['id'];

$conn=mysqli_connect('localhost','root','','sms');

$sql="SELECT *FROM student WHERE id=$id";

$result=mysqli_query($conn,$sql);

$std=mysqli_fetch_assoc($result);

?>

<!DOCTYPE html>
<html>

<head>

<title>new page</title>

<link rel="stylesheet" type="text/css" href="style.css">

</head>

<body>

<div class="left">

<br>

<a class="button btn-info" href="first.php">View All student</a>

</div>

<div class="right">

<h1 class="center" style="color:#36c108"><?php echo $std['name'];?>'s Full information</h1>

<hr>

<div class="td">

<table class="tab">

<tr>

<th>Name: </th>

<td class="it"><?php echo $std['name']?> <hr></td>

</tr>

<tr>

<th>ID: </th>

<td class="it"><?php echo $std['id']?><hr></td>

</tr>

<tr>

<th>Department: </th>

<td class="it"><?php echo $std['dept']?><hr></td>


</tr>

<tr>

<th>Birth Date: </th>

<td class="it"><?php echo $std['birth']?><hr></td>

</tr>

<tr>

<th>Father's Name: </th>

<td class="it"><?php echo $std['father']?><hr></td>

</tr>

<tr>

<th>Mother's Name: </th>

<td class="it"><?php echo $std['mother']?><hr></td>

</tr>

<tr>

<th>Contact: </th>

<td class="it"><?php echo $std['mobile']?><hr></td>

</tr>

<tr>

<th>Address: </th>

<td class="it"><?php echo $std['address']?><hr>

</td>

</tr>

</table>

</div>

</div>

</body>

</html>
Implementation of Update page:

Source code for Edit page:


<?php

$id=$_GET['id'];

$conn=mysqli_connect('localhost','root','','sms');

$sql="SELECT *FROM student WHERE id=$id";

$result=mysqli_query($conn,$sql);

$std=mysqli_fetch_assoc($result);

?>
<!DOCTYPE html>

<html>

<head>

<title>new page</title>

<link rel="stylesheet" type="text/css" href="style.css">

</head>

<body style="background-color:#9fad6a;">

<div class="left">

<br>

<a class="button btn-info" href="first.php">View student list</a>

</div>

<div class="right">

<h2 class="center">Update <?php echo $std['name'];?>'s Information</h2>

<form action="edit.php?id=<?php echo $id?>" method="POST">

<div class="form-group">

<label class="it" for="Name">Name :</label>

<input required type="text" class="form-control" name="name" value="<?php echo $std['name'];?>">

</div>

<div class="form-group">

<label class="it" for="ID">Student ID :</label>

<input type="text" class="form-control" name="id" value="<?php echo $std['id'];?>">

</div>

<div class="form-group">

<label class="it" for="Dept">Department :</label>

<input type="text" class="form-control" name="dept" value="<?php echo $std['dept'];?>">

</div>

<div class="form-group">
<label class="it" for="Birth">Birth Year :</label>

<input type="text" class="form-control" name="birth" value="<?php echo $std['birth'];?>">

</div>

<div class="form-group">

<label class="it" for="Father">Father name :</label>

<input type="text" class="form-control" name="father" value="<?php echo $std['father'];?>">

</div>

<div class="form-group">

<label class="it" for="Mother">Mother name :</label>

<input type="text" class="form-control" name="mother" value="<?php echo $std['mother'];?>">

</div>

<div class="form-group">

<label class="it" for="Mobile">Mobile :</label>

<input type="text" class="form-control" name="mobile" value="<?php echo $std['mobile'];?>">

</div>

<div class="form-group">

<label class="it" for="Address">Address: </label>

<input type="text" class="form-control" name="address" value="<?php echo $std['address'];?>">

</div>

<button type="submit" class="button btn-info">Update Me</button>

</form>

</div>

</body>

</html>
Php Script for Edit page:
<?php

$id=$_POST['id'];

$name=$_POST['name'];

$dept=$_POST['dept'];

$birth=$_POST['birth'];

$father=$_POST['father'];

$mother=$_POST['mother'];

$address=$_POST['address'];

$contact=$_POST['mobile'];

$conn=mysqli_connect('localhost','root','','sms');

$sql="UPDATE student SET name='$name',id='$id',dept='$dept',birth='$birth',


father='$father',mother='$mother',father='$father',mobile='$contact',address='$address' WHERE id=$id ";

if(mysqli_query($conn,$sql))

header("Location: show.php?id=".$id);

else

echo "Update again please";

?>

Php Script for Delete page:


<?php

$id=$_GET['id'];

$conn=mysqli_connect('localhost','root','','sms');

$sql="DELETE FROM student WHERE id=$id";


if(mysqli_query($conn,$sql))

header("Location: first.php");

else

echo "Deletion is not posssible ";

?>

Php Script for Search page:


<?php

$id=$_POST['search'];

$conn=mysqli_connect('localhost','root','','sms');

$sql="SELECT *FROM student WHERE id=$id";

$result=mysqli_query($conn,$sql);

$std=mysqli_fetch_assoc($result);

if($result)

if(mysqli_num_rows($result)<1)

header("Location: not_found.php");

else

header("Location: found.php?id=".$id);

else
{

echo "query failed";

?>

Implementation of Found page:

Source code for Found page:


<?php

$id=$_GET['id'];

$conn=mysqli_connect('localhost','root','','sms');

$sql="SELECT *FROM student WHERE id=$id";

$result=mysqli_query($conn,$sql);
$std=mysqli_fetch_assoc($result);

?>

<!DOCTYPE html>

<html>

<head>

<title>new page</title>

<link rel="stylesheet" type="text/css" href="style.css">

</head>

<body class="back">

<h1 class="h" style="margin-left:557px;">Record has been successfully found!!

</h1>

<img class="img" src="image/happy.png">

<div class="left">

<br>

<a class="button btn-info " href="first.php">View student list</a>

</div>

<div class="right">

<h2 class="h" style="text-align: center; font-style: italic;">This is <?php echo $std['name']?></h2>

<br>

<h2 class="center h">Here is <?php echo $std['name']?>'s short informatin</h2>

<hr>

<div>

<table >

<thead>

<th class="sp">Name</th>

<th class="sp">ID</th>

<th class="sp">Dept</th>

<th class="sp">Birth</th>

<th class="sp">Action</th>
</thead>

<tbody>

<tr>

<td class="center h"><?php echo $std['name'] ?></td>

<td class="center h"><?php echo $std['id'] ?></td>

<td class="center h"><?php echo $std['dept'] ?></td>

<td class="center h"><?php echo $std['birth']?></td>

<td class="special">

<a class="button btn-primary" href="show.php?id=<?php echo $std['id'];?>">View Full Info</a>

<a class="button btn-warning" href="update.php?id=<?php echo $std['id'];?>">update</a>

<a class="button btn-danger" onclick=" return confirm('are you sure')" href="delete.php?id=<?php echo
$std['id'];?>">delete</a>

</td>

</tr>

</tbody>

</table>

</div>

</div>

</body>

</html>

Implementation of not found page:


Source code for Found page:
<!DOCTYPE html>

<html>

<head>

<title>not found page</title>

<link rel="stylesheet" type="text/css" href="style.css">

</head>

<body class="d">

<h1 class="center" style="font-size: 60px;">Ops The data is not found in our server</h1>

<img class="nimage" src="image/sad.png">

</body>

</html>

CSS Page for designing the project:


Log.css page:

.center{

text-align: center;

.login-page {

width: 360px;

padding: 8% 0 0;

margin: auto;

.form {

position: relative;

z-index: 1;

background: #FFFFFF;
max-width: 360px;

margin: 0 auto 100px;

padding-top: 5px;

padding-left: 26px;

padding-right: 26px;

padding-bottom: 45px;

text-align: center;

box-shadow: 0 0 20px 0 rgba(0, 0, 0, 0.2), 0 5px 5px 0 rgba(0, 0, 0, 0.24);

.form input {

font-family: "Roboto", sans-serif;

outline: 0;

background: #f2f2f2;

width: 78%;

border: 0;

margin: 0 0 15px;

padding: 15px;

box-sizing: border-box;

font-size: 14px;

.form button {

font-family: "Roboto", sans-serif;

text-transform: uppercase;

outline: 0;

background: #4CAF50;

width: 78%;

border: 0;

padding: 15px;

color: #FFFFFF;
font-size: 14px;

-webkit-transition: all 0.3 ease;

transition: all 0.3 ease;

cursor: pointer;

.form button:hover,.form button:active,.form button:focus {

background: #43A047;

.ad{

font-style: italic;

font-size: 33px;

body {

background: #7dbc5b

style.css page:
.wc{

background: #555;

font: 13px 'Lucida sans', Arial, Helvetica;

color: #eee;

text-align: center;

.inbody

background: #555;

font: 13px 'Lucida sans', Arial, Helvetica;

color: #eee;

}
.left{

float: left;

.center{

text-align: center;

.right{

float: right;

width: 75%;

.button{

display: inline-block;

font-weight: 700;

text-align: center;

border: 1px solid transparent;

padding: 0.375rem 0.75rem;

font-size: 1rem;

line-height: 1.5;

border-radius: 0.25rem;

text-decoration: none;

.btn-info {

color: #fff;

background-color: #17a2b8;

border-color: #17a2b8;

.search{
float: right;

.sp{

width: 100px;

text-align: center;

font-size: 20px;

color: #ff8aa5;

.table {

border-collapse: collapse !important;

.special{

width: 391px;

.form-group {

margin-bottom: .5rem;

.it{

font-style: italic;

font-size: 19px;

.ic{

color: #ff4343;

font-size: 19px;

.form-control {

display: block;

width: 75%;

height: calc(1.25rem + 2px);

padding: 0.375rem 0.75rem;


font-size: 1rem;

line-height: 1.5;

color: #495057;

background-color: #fff;

background-clip: padding-box;

border: 1px solid #ced4da;

border-radius: 0.25rem;

transition: border-color 0.15s ease-in-out, box-shadow 0.15s ease-in-out;

.tab{

height: 452px;

background: #b79f9f;

width: 100%;

.td{

background-color: orange;

.found{

text-align: center;

color: red;

margin-left: 14px;

.admin{

text-align: center;

margin: auto;

.btn-primary {

color: #fff;

background-color: #007bff;
border-color: #007bff;

margin-left: 33px;

.btn-warning {

color: #212529;

background-color: #ffc107;

border-color: #ffc107;

.btn-danger{

color: #fff;

background-color: #dc3545;

border-color: #dc3545;

#namanyay-search-btn {

background:#0099ff;

color:white;

font: 'trebuchet ms', trebuchet;

padding:10px 20px;

border-radius:0 10px 10px 0;

-moz-border-radius:0 10px 10px 0;

-webkit-border-radius:0 10px 10px 0;

-o-border-radius:0 10px 10px 0;

border:0 none;

font-weight:bold;

#namanyay-search-box {

background: #eee;

padding:10px;
border-radius:10px 0 0 10px;

-moz-border-radius:10px 0 0 10px;

-webkit-border-radius:10px 0 0 10px;

-o-border-radius:10px 0 0 10px;

border:0 none;

width:160px;

.img{

margin-left: 628px;

height: 113px;

width: 113px;

.c{

background: #000;

.h{

color: white;

.back{

background-color: #4c3448;

.nimage{

height: 272px;

width: 272px;

margin-left: 327px;

margin-top: 44px;

.d{

background-color: #e6adad;

You might also like