0% found this document useful (0 votes)
3 views66 pages

Sample

The document is a project report on the 'Online Notice Board System' submitted by Rohit Hansda for the Master of Computer Application degree at Arka Jain University. It outlines the project's objectives, implementation details, and the system's functionality aimed at facilitating information dissemination in educational institutions. The report includes sections on system design, coding, and feasibility analyses, emphasizing the need for a digital noticeboard to replace traditional paper-based systems.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
3 views66 pages

Sample

The document is a project report on the 'Online Notice Board System' submitted by Rohit Hansda for the Master of Computer Application degree at Arka Jain University. It outlines the project's objectives, implementation details, and the system's functionality aimed at facilitating information dissemination in educational institutions. The report includes sections on system design, coding, and feasibility analyses, emphasizing the need for a digital noticeboard to replace traditional paper-based systems.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

A Project Report On

ONLINE NOTICE BOARD SYSTEM


Submitted in partial fulfillment of the
MASTER OF COMPUTER APPLICATION

By

Rohit Hansda
Roll no. 12
Enrollment No. AJU/210786

Under the esteemed guidance of


Dr. Arvind Kumar Pandey
&
Ms. Alka Kumari
(Internal Guide)

DEPARTMENT OF COMPUTER SCIENCE & INFORMATION TECHNOLOGY

ARKA JAIN UNIVERSITY, JHARKHAND


JAMSHEDPUR
2021-2023

1
GUIDED BY:
PREPARED BY:
Dr. Arvind Kumar Pandey Rohit Hansda
&
Ms. Alka Singh

SUBMITTED TO
DEPARTMENT OF COMPUTER SCIENCE & IT
ARKA JAIN UNIVERSITY

SUBMITTED TO
DEPARTMENT OF COMPUTER SCIENCE & IT
i
ARKA JAIN UNIVERSITY
ARKA JAIN UNIVERSITY, JHARKHAND
DEPARTMENT OF COMPUTER SCIENCE & IT

CERTIFICATE

This is to certify that the project entitled, "ONLINE NOTICE BOARD SYSTEM", is
bonafide work of ROHIT HANSDA bearing Enrolment No. AJU/210786 submitted in partial
fulfilment of the requirements for the award of degree of MASTER OF COMPUTER
APPLICATION (MCA) from ARKA JAIN University, JHARKHAND.

Internal Guide HOD

Date: University Seal

ii
ACKNOWLEDGEMENT

It is a genuine pleasure to express my profound gratitude and deep regards to my Internal Guide
Ms. Alka Kumari and our HOD Dr. Arvind Kumar Pandey for their exemplary guidance,
monitoring and constant encouragement. I would like to express my special thanks to ARKA
JAIN UNIVERSITY who gave me the golden opportunity to do this wonderful project on the
topic Online Notice Board System, which helped me in doing a lot of Research and I came to
know about so many new things.

With Regards
Rohit Hansda (AJU/210786)
Roll no. 12 (MCA)

iii
ABSTRACT
An online notice board is a place where people can leave any types of messages and
notifications, for example, to advertise things, announce events or provide any
information.

Notice board online it can be placed on digital devices such computers, tabs, mobile
phones etc. This online notice board project is very helpful for all type of users like
existing users and new users.

So, admin can leave and erase notification for other people to read and see.
The main aim of this free online notice board project is making information dissemination
much easier in a paperless community as the world tends to interact with the online notice
board facility as a project. Online notice board admin can send the notification to the
particular students regarding fee payments, results, any new activity happen in college
campus or college fest participation, libraries dues, hostel room payments, any workshop
registrations, warnings and reminders etc for this work online notice board project is
making all work much easier and understandable to all. This online notice board work
generally intends to act as a support system for the all users. By the help of free online
notice board, users can access the notifications and articles quickly not only in the
particular premises, also wherever and whenever they need to know.

Online notice board usability is fully capable of passing relevant notices and
announcements and keeping the users update from time to time. The students are kept
updated each time with the online notice board for college is uploaded based on their
preferences with respect to the departments and categories through a notice board online.

iv
DECLARATION

I hereby declare that the project entitled, “ONLINE NOTICE BOARD SYSTEM” done at
“Arka Jain University”, has not been in any case duplicated to submit to any other university
for the award of any degree. To the best of my knowledge other than me, no one has submitted
to any other university.

The project is done in partial fulfilment of the requirements for the award of degree of
MASTER OF COMPUTER APPLICATION (MCA) to be submitted as final semester
project as part of our curriculum.

Rohit Hansda

Name of the Student and signature

v
TABLE OF CONTENTS

Chapter 1: Introduction .......................................................................................................... 1

1.1 Overview ......................................................................................................................... 1


1.2 Problem Statement ........................................................................................................... 1
1.3 Need ................................................................................................................................. 1
Chapter 2: Implementation and Testing................................................................................ 2

2.1 Primary aim ...................................................................................................................... 2


2.2 Objectives ......................................................................................................................... 2
2.3 Preliminary Requirements Estimate ................................................................................. 2
2.4 Suggested Deliverables .................................................................................................... 3
2.5 Process Model .................................................................................................................. 3
2.6 Visibility Plan ................................................................................................................... 3
2.7 Schedule Feasibility ......................................................................................................... 3
2.8 Legal Feasibility ............................................................................................................... 3
2.9 Religious- Cultural Feasibility ......................................................................................... 4
2.10 Economic Feasibility ...................................................................................................... 4
2.11 Technical Feasibility ...................................................................................................... 4
2.12 Operational Feasibility ................................................................................................... 4
2.13 Background Theory ........................................................................................................ 4
2.14 Application Area ............................................................................................................ 5
2.15 Major functional requirements ....................................................................................... 5
2.16 External Interface Requirements .................................................................................... 5
User interfaces ................................................................................................................ 5
Hardware Interfaces ........................................................................................................ 5
Software Interfaces ......................................................................................................... 5
2.17 System Actors and User ................................................................................................. 6
2.18 Language used to develop Online Notice Board ............................................................ 6
Chapter 3: System Design ....................................................................................................... 7

3.1 Data Flow Diagram .......................................................................................................... 7


3.1.1 Context level dfd: - .................................................................................................... 7
3.1.2 First level dfd: - ......................................................................................................... 8
3.1.3 Second level dfd: - ..................................................................................................... 9
3.2 Er - Diagram: - ............................................................................................................... 10

vi
3.3 Normalization ................................................................................................................. 11
3.3.1 1st Normal Form: - .................................................................................................. 11
3.3.2 2nd Normal Form: - .................................................................................................. 11
3.3.3 3rd Normal Form: - ................................................................................................... 12
[Link] Student Table .................................................................................................... 12
[Link] Subject Table .................................................................................................... 12
[Link] Score Table ....................................................................................................... 12
3.3.4 Boyce – Codd Normal Form ................................................................................... 13
[Link] Student Table .................................................................................................... 13
[Link] Professor Table ................................................................................................. 13
Chapter 4: Coding.................................................................................................................. 14

4.1 Admin Dashboard .......................................................................................................... 14


4.2 Create notice ................................................................................................................. 19
4.3 Edit profile...................................................................................................................... 21
4.4 Index ............................................................................................................................... 23
4.5 Logout ............................................................................................................................ 26
4.6 Register........................................................................................................................... 26
4.7 View all notices .............................................................................................................. 29
4.8 Edit profile...................................................................................................................... 31
4.9 Index ............................................................................................................................... 34
4.10 Register......................................................................................................................... 37
4.11 User Dashboard ............................................................................................................ 41
4.12 View Notice.................................................................................................................. 44
Chapter 5: Screenshot ........................................................................................................... 46

5.1 Admin Registration Form............................................................................................... 46


5.2 Admin Login .................................................................................................................. 47
5.3 Admin Dashboard .......................................................................................................... 48
5.4 Admin Profile ................................................................................................................. 49
5.5 Admin Send Notice Form .............................................................................................. 50
5.6 All Notice ....................................................................................................................... 51
5.7 Registration Form ........................................................................................................... 52
5.8 Student Login ................................................................................................................. 53
5.9 Students Profile .............................................................................................................. 54
5.10 Students Dashboard ...................................................................................................... 55

vii
5.11 Students Notice ............................................................................................................ 56
Chapter 6: Conclusion ........................................................................................................... 57

6.1 Benefits of Online Notice Board System ....................................................................... 57


Advantages: .......................................................................................................................... 57
6.2 Future Look .................................................................................................................... 57
6.3 Conclusion ...................................................................................................................... 57

viii
Chapter 1: Introduction

Overview
The Online Notice Board System is intented for colleges and institutions where information
and file sharing on regular basis plays vital role in the performance. The proposed system will
act as an online notice board which will make use of the modern communication methodologies
and tecniques for information flow. The system is planned to consist of various useful features
for the said purpose.

The proposed system aims to create a platform for issuing notice, sharing information and files
between the members of the institutions. Different users shall have different level of access to
the content. In the context of a college, there shall be four users of the software—administrator,
student, teacher and guest. The administrator shall be able to issue notice, upload files, and
view students’ activities on the software. The teacher shall be able to issue notice, upload files
(on a general basis or to a particular classroom), and view result and students’ result. A guest
will simply be able to view public notices.

Problem Statement
In today’s world, everything is digitalized and paper is being used less and less everyday. How
often has it happened that we miss some important notice because we have to go to a wall and
read the notice there? There has dedicated file hosting sites and clouds used by some
institutions, but there is a definite need for a dedicated notice board system. The proposed
system is such a systsm.

Need
Almost all leading institutions, expecting a few, currently lack an electronic noticeboard
system. Though some have taken the aid of third-party websites like facebook to interact, it
comes the cost of mixing one’s social life with professional. Keeping this in mind, educational
institutes will find the software extremely useful.

The “Online Notice Board System “is a web-based software, with supplementary application
software, with supplementary application software, that aims to aid the institutes by providing
such digital notice board.

1
Chapter 2: Implementation and Testing

Primary aim
The primary aim of the Online notice board software project is to create a fully functional
digital noticeboard system which will efficiently handle all assigned tasks.

They may be able to, in due course, heavily minimize, if not eradicate, the conventional,
physical noticeboards. With the help of the supplementary applications, users will be able to
receive real-time notifications of any and all notices posted by another user with privileges as
such.

Objectives
• To develop supplementary apps for the said noticeboard.
• To create a user-friendly interface.
• To develop and manage a proper database system to ensure data safety and proper
management.
• To allocate various levels of users and have proper authentication.
• To prepare proper and detailed system documentation.

Preliminary Requirements Estimate


• Programming Languages and scripts

Web Applications: PHP and CSS

Windows 8 App: C# and HTML

Android App Java

• Operating System

Web Applications Any current OS

Windows 10 App: Windows 10

Android App: Android OS

• Database—MySQL

2
Suggested Deliverables
• A web-based online noticeboard system.
• A windows 8 App
• An Android App
• Proper system documentation

Process Model
The incremental model has been deemed the best suited for the SDLC process and shall be
followed. Using this model will have the benefit over the LSM in the sense that it will inherit
the quality of the LSM but exclude the rigidity. Furthermore, the feedback process of Process
Iteration model will also be available in the incremental model. Another contributing factor in
choosing this model is the short period of time available to make a working initial version of
the system.

Visibility Plan
• The group members will be in contact timely and will focus on one area at atime as
all are beginners.
• The phases will be followed sequentially with equal contribution of group members
in each phase.
• platforms.

Schedule Feasibility
The development process is planned to reach designing phase till the end of the semester, which
gives us a windows of roughly six months. Although this may be a tight fit for a perfect, final
system, as the incremental model is being followed in the SDLC, this is enough time to develop
a working first version of the software.

Legal Feasibility
The developers will obviously use no illegal means or methodologies in the development
process of the system. The software will be operated abiding by the cyber and other applicable
laws prevailing in the country enforced by the government of Nepal. The user will be held
responsible for only the data they enter to the system. In case of international users, they will
be subjected to the applicable laws in that country. So, the software has no legal barrages.

3
Religious- Cultural Feasibility
This system will never ask the user of their religion or cultural origin and ergo will not act in
any what so ever that may hurt the sentiments of any cultural or religious group. The product
development or operation will never undergo any process that might be3 unacceptable to a
specific religion or culture. The software itself will be generic and impartial. So, no religious
or cultural issues should disrupt the system.

Economic Feasibility
The program uses programming language whose IDE are freeware. One exception to this is the
Visual Studio 2012. Which is needed for the supplementary app development. But this software
is provided free of cost by the MIC Nepal. Further costs for this project are the costs of online
domain, space and database and registering and uploading the apps in the respective market,
which is expected to be covered by the college. The remaining cost is that of training the
developer team in the particular language and/or platform. which is minimal. So, the project is
economically feasible.

Technical Feasibility
The software is to be developed using Java, PHP, CSS, XAML and MySQL, which are all
readily available. Also, the team members have sufficient programming and related knowledge
which will enable us to learn and adapt to these specifie language and platforms easily. Thus,
we can see that the project is technically feasible.

Operational Feasibility
The software requires very little specific environment to run. Only the apps require their
environment to run. i.e., Windows 8TM and Android. As a staggering majority of the PCs in the
world are based on Windows OS and many mobile devices operate on Android, this cannot
really be considered a need. The software will be extremely user-friendly, removing the need
for specifically trained employees. Similarly, the cost of buying the rights and the maintenance
cost will not be very high for the client. So, the software is feasible for operation.

Background Theory
In today’s world, everything is digitalized and paper is being used less and less every day. How
often has it happened that we miss some important notice because we have to go to a wall and
read the notice there?

4
The Online Notice Board System is mainly intended for colleges and institutions where
information and file sharing on regular basis plays vital role in the performance. The proposed
system will act as an online notice board will make use of the modern communication
methodologies and techniques for information flow. The system is planned to consist of various
useful features for the said purpose

The Online Notice Board System is a web-based software, with supplementary application
software, that aims to aid the institutes by providing such digital noticeboard.

Application Area
The proposed system is currently mainly intended to be applied in educational institutes as an
online notice board and file sharing system. Further applications of this system may include
any type of office or business organizations where computers with working internet connection
is available.

Major functional requirements


• The system should be able to manage and store notices and files.
• The system should provide appropriate UI for notice and file upload and download.
• The system should be able to recognize and authenticate several levels of users.
• The system should be able to manage and maintain a proper database.
• The system should be easily operable and user friendly.
• The apps should be able to work scamlessly with the web server.
• The apps should be able to provide push messaging in real time, whenever available.

External Interface Requirements


User interfaces: - The system will start with a login page to identify the user level and the
features will be available accordingly. The application will have easily accessible buttons for
all major activities of the software. Key features and recent events will be highlighted to attract
user attention.

Hardware Interfaces: - The system will interact with the hardware resources of the system on
which it is running. While any system will support the core software, a device with push
messaging facility is recommended for Windows 8 or Android app.

Software Interfaces: - Only Windows 8 and Android OS will support this software’s apps. It
will have the most interaction with an external database server. It may also be integrated with
other systems like Employee Management System and/or Student Management System.

5
System Actors and User
The system has two major actors and each actor has its features to carry out as follows:

Admin
Admin is the person who controls, monitors and keeps the whole follow of the system. The
main functions of the admin are:

• To keep and track down the total number of users in the system.

• Can add, activate and deactivate any user.

• Add New Notice and send notice to Registered users

• Display Old Notice and Manage Old notice

• Update Password

Student
Student is a knowledge seeker, or more theoretical word, a learner. The student has to be
registered and log in into the system before he/she carries out their functions.

• Student Registration

• Login

• Check Notification sent by admin

• Update Profile

• Update Password

• Log out the whole system

Language used to develop Online Notice Board


Front end: HTML, CSS, Jquery, Bootstrap

Back end: MySQLi

Middle end: PHP

6
Chapter 3: System Design

Data Flow Diagram

3.1.1 Context level dfd: -

0.0
LogIn/LogOut
Online Login/LogOut
Admin Notice Student
Alert Display Info
Board
System

7
3.1.2 First level dfd: -

1.0

Registration/Sign Up Branch wise


Admin New D1 notice
Alerts (If already Exists) View Notice
Student

2.0
Request for Login View All Notice, new/old
Admin Existing D1 notice
Update/Delete notice
Alert
Students

3.0
Request for details
Admin Notice Existing Notices/Latest News
D2 notice
Get Some Infomations For Display Notice
Students

8
3.1.3 Second level dfd: -

3.1
Create Notice New Student Details
Student Notice D2 user
Alert
For Response
Students

3.2
Request for notice Fetching Student Details
Notice
Student D2 user
Display notice For Student Details
Students

3.3

Request for notice Notice Search Branch/Class Wise


Student For
D2 notice
Display Result Display and Download notice
Students

9
Er - Diagram: -

ID

Name

Notice
Descripti
Date
on
Notice
ID

1 M
Notice View Student/other
M

Add
Notice

BranchID

Admin Choose Branch Select

1
Email
Branch Class

Name
Name
ID
Courses

Password ClassID Stream

10
Normalization

3.1.4 1st Normal Form: -


Admin_id Principal Teacher Notice

Roll no name subject


101 Romit Java
102 Rohit DBMS
103 Deepak Account

Notice_id Notice Date Class Wise Notice Type Result

3.1.5 2nd Normal Form: -

Student_id name reg_no branch address


2001 Romit AJU/210100 MCA Adityapur
2002 Rohit AJU/210101 BCA Sakchi
2003 Deepak AJU/210102 BBA Gamharia

11
3.1.6 3rd Normal Form: -
[Link] Student Table

Student_id name reg_no branch address


2001 Romit AJU/210100 MCA Adityapur
2002 Rohit AJU/210101 BCA Sakchi
2003 Deepak AJU/210102 BBA Gamharia

[Link] Subject Table

Subject_id Subject_name Teacher

CSC201 Java Java teacher


CSC301 DBMS DBMS teacher
AC4102 Account Account teacher

[Link] Score Table

Score_id Student_id Subject_id Mark’s

4001 2001 CSC201 71


4002 2002 CSC301 84
4003 2003 AC4102 60

Score_id Student_id Subject_id Mark’s Exam_name Total


marks
4001 2001 CSC201 71 End Term 321

12
4002 2002 CSC301 84 End Term 256

4003 2003 AC4102 60 End Term 412

3.1.7 Boyce – Codd Normal Form

Student_id Subject_name Professor

2001 Java P. Java


2002 DBMS P. DBMS
2003 Account P. Account

[Link] Student Table

Student_id P_id

2001 P1
2002 P2
2003 P3

[Link] Professor Table

P_id Professor Subject_name


P1 P. Java Java

P2 P. DBMS DBMS

P3 P. Account Account

13
Chapter 4: Coding

Admin Dashboard

<?php

session_start();

if (isset($_POST['update_profile'])) {

$connection = mysqli_connect("localhost", "root", "");

$db = mysqli_select_db($connection, "online_notice_board");

$query = "update admins set


name='$_POST[name]',email='$_POST[email]',password='$_POST[password]' where
email='$_SESSION[email]'";

$query_run = mysqli_query($connection, $query);

if ($query_run) {

echo "<script type='text/javascript'>

alert('Profile Updated successfully...');

[Link] = 'admin_dashboard.php'

</script>";

} else {

echo "<script type='text/javascript'>

alert('Can't update try again...');

[Link] = 'admin_dashboard.php'

</script>";

14
if (isset($_POST['send_notice'])) {

$connection = mysqli_connect("localhost", "root", "");

$db = mysqli_select_db($connection, "online_notice_board");

$query = "insert into notice


values(null,'$_POST[post_date]','$_POST[to_whom]','$_POST[subject]','$_POST[message]')
";

$query_run = mysqli_query($connection, $query);

if ($query_run) {

echo "<script>alert('Notice Created...');

[Link] = 'admin_dashboard.php';

</script>";

} else {

echo "<script>alert('Please try again');

[Link] = 'admin_dashboard.php';

</script>";

?>

<!DOCTYPE html>

<html lang="en" dir="ltr">

<head>

<meta charset="utf-8">

<title>Admin Dashboard</title>

<!-- Bootstrap files -->

15
<script src="../bootstrap-4.4.1/js/[Link]" charset="utf-8"></script>

<link rel="stylesheet" type="text/css" href="../bootstrap-4.4.1/css/[Link]">

<!-- CSS File -->

<link rel="stylesheet" href="../css/[Link]">

<script src="../jQuery/juqery_latest.js" charset="utf-8"></script>

<script type="text/javascript">

$(document).ready(function() {

$("#edit_profile_button").click(function() {

$("#main_content").load('edit_profile.php');

});

$("#create_notice_button").click(function() {

$("#main_content").load('create_notice.php');

});

$("#view_notice_button").click(function() {

$("#main_content").load('view_all_notice.php');

});

});

</script>

</head>

<body>

16
<!-- Header section code start here -->

<div class="row" id="header">

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

</div>

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

<h3>Online Notice Board System</h3>

</div>

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

</div>

</div>

<br>

<section id="container">

<div class="row">

<div class="col-md-2" id="left_sidebar">

<img src="../images/[Link]" class="img-rounded" width="200px" height="200px">

<b><?php echo $_SESSION['email']; ?></b>

<hr>

<button type="button" class="btn btn-primary btn-block" id="edit_profile_button">Edit


Profile</button>

<button type="button" class="btn btn-secondary btn-block"


id="create_notice_button">Create a Notice</button>

<button type="button" class="btn btn-warning btn-block"


id="view_notice_button">View All Notices</button>

<button type="button" class="btn btn-primary btn-block"


id="view_reply_button">View Replies</button>

17
<a href="[Link]" type="button" class="btn btn-success btn-block">Logout</a><br>

</div>

<div class="col-md-8" id="main_content">

<h2>Welcome to Admin Dashboard</h2>

<p>

Welcome to Admin Dashboard page. Here admin can be mangage notice board system.
He create a notice, delete a notice and all the replies of the notice.</p>

<p>On Coursera, you can choose from thousands of online courses taught by faculty
from world-class universities like Yale, Stanford, and Princeton, and gain skills in fields such
as data science, finance, cloud computing, and graphic design.

<p>

You're receiving this monthly email because you turned on Location History, a Google
Account-level setting that saves where you go in your private Timeline.

Location History data also helps give you personalized information on Google,
including better restaurant recommendations, and suggestions for a faster commute. You can
view, edit, and delete this data anytime in Timeline.

</p>

</div>

</div>

</section>

</body>

</html>

18
Create notice

<!DOCTYPE html>

<html lang="en" dir="ltr">

<head>

<meta charset="utf-8">

<title>Create Notice</title>

</head>

<body>

<center>

<h3>Send Notice Form</h3>

</center>

<br>

<div>

<form action="" method="post">

<div class="form-group">

<label>To Whom:</label>

<select class="form-control" type="text" name="to_whom">

<option>To All</option>

<option>BCA</option>

<option>[Link] IT</option>

<option>[Link]</option>

19
<option>Polytechnic</option>

<option>[Link]</option>

<option>MCA</option>

</select>

</div>

<div class="form-group">

<label>Post Date:</label>

<input type="date" class="form-control" name="post_date">

</div>

<div class="form-group">

<label>Subject:</label>

<input type="text" class="form-control" name="subject" placeholder="Enter Subject">

</div>

<div class="form-group">

<label>Message:</label>

<textarea name="message" rows="8" cols="80" class="form-control" placeholder="Type


your message..."></textarea>

</div>

<button type="submit" class="btn btn-primary" name="send_notice">Send Notice</button>

</form>

</div>

</body>

</html>

20
Edit profile

<?php

session_start();

$connection = mysqli_connect("localhost", "root", "");

$db = mysqli_select_db($connection, "online_notice_board");

$name = "";

$email = "";

$password = "";

$query = "select * from admins where email = '$_SESSION[email]'";

$query_run = mysqli_query($connection, $query);

while ($row = mysqli_fetch_assoc($query_run)) {

$name = $row['name'];

$email = $row['email'];

$password = $row['password'];

?>

<!DOCTYPE html>

<html lang="en" dir="ltr">

<head>

<meta charset="utf-8">

<title></title>

</head>

21
<body>

<form action="" method="post">

<div class="form-group">

<label>Name:</label>

<input type="text" class="form-control" name="name" value="<?php echo $name; ?>">

</div>

<div class="form-group">

<label>Email:</label>

<input type="email" class="form-control" name="email" value="<?php echo $email;


?>">

</div>

<div class="form-group">

<label>Password:</label>

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


$password; ?>">

</div>

<button type="submit" name="update_profile" class="btn btn-primary">Update</button>

</form>

</body>

</html>

22
Index

<?php

session_start();

$connection = mysqli_connect("localhost", "root", "");

$db = mysqli_select_db($connection, "online_notice_board");

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

$query = "select * from admins where email = '$_POST[email]' AND password =


'$_POST[password]'";

$query_run = mysqli_query($connection, $query);

if (mysqli_num_rows($query_run)) {

$_SESSION['email'] = $_POST['email'];

while ($row = mysqli_fetch_assoc($query_run)) {

echo "<script>

[Link] = 'admin_dashboard.php';

</script>";

} else {

echo "<script>alert('Please Enter correct email id and password');

</script>";

?>

23
<!DOCTYPE html>

<html lang="en" dir="ltr">

<head>

<meta charset="utf-8">

<title>Online Notice Board System</title>

<!-- Bootstrap files -->

<link rel="stylesheet" type="text/css" href="../bootstrap-4.4.1/css/[Link]">

<script src="../bootstrap-4.4.1/js/[Link]" charset="utf-8"></script>

<!-- CSS File -->

<link rel="stylesheet" href="../css/[Link]">

</head>

<body>

<!-- Header section code start here -->

<div class="row" id="header">

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

</div>

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

<h3>Online Notice Board System</h3>

</div>

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

</div>

</div>

<!-- Admin Login from code starts here -->

24
<section id="login_form">

<div class="row">

<div class="col-md-4 m-auto block">

<center>

<h4>Admin Login</h4>

</center>

<form action="[Link]" method="post">

<div class="form-group">

<lable>Email ID:</label>

<input class="form-control" type="text" name="email" placeholder="Enter your


email">

</div>

<div class="form-group">

<lable>Passowrd:</label>

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


your Password">

</div>

<button class="btn btn-primary" type="submit" name="login">Login</button>

</form>

<a href="[Link]">Click here to register</a>

</div>

</div>

</section>

</body>

</html>

25
Logout

<?php

session_start();

session_unset();

session_destroy();

header("Location:[Link]");

?>

Register

<?php

$connection = mysqli_connect("localhost", "root", "");

$db = mysqli_select_db($connection, "online_notice_board");

if (isset($_POST['register'])) {

$query = "insert into admins


values(null,'$_POST[name]','$_POST[email]','$_POST[password]')";

$query_run = mysqli_query($connection, $query);

if ($query_run) {

echo "<script>alert('Registration successfully...You may now login.');

[Link] = '[Link]';

</script>";

} else {

echo "<script>alert('Registration failed...try again');

26
[Link] = '[Link]';

</script>";

?>

<!DOCTYPE html>

<html lang="en" dir="ltr">

<head>

<meta charset="utf-8">

<title>Online Notice Board System</title>

<!-- Bootstrap files -->

<script src="../bootstrap-4.4.1/js/[Link]" charset="utf-8"></script>

<link rel="stylesheet" type="text/css" href="../bootstrap-4.4.1/css/[Link]">

<!-- CSS File -->

<link rel="stylesheet" href="../css/[Link]">

</head>

<body>

<!-- Header section code start here -->

<div class="row" id="header">

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

</div>

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

27
<h3>Online Notice Board System</h3>

</div>

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

</div>

</div>

<!-- Login from code starts here -->

<section id="login_form">

<div class="row">

<div class="col-md-4 m-auto block">

<center>

<h4> Admin Registration form</h4>

</center>

<form action="" method="post">

<div class="form-group">

<lable>Full Name:</label>

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


your Full Name">

</div>

<div class="form-group">

<lable>Email ID:</label>

<input class="form-control" type="text" name="email" placeholder="Enter


your email">

</div>

<div class="form-group">

28
<lable>Passowrd:</label>

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


placeholder="Enter your Password">

</div>

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


name="register">Register</button>

</form>

<a href="[Link]">Click here to login</a>

</div>

</div>

</section>

</body>

</html>

View all notices

<!DOCTYPE html>

<html lang="en" dir="ltr">

<head>

<meta charset="utf-8">

<title></title>

</head>

<body>

<br>

29
<center><h3>All Notices</h3></center><br>

<?php

$connection = mysqli_connect("localhost","root","");

$db = mysqli_select_db($connection,"online_notice_board");

$query = 'select * from notice';

$query_run = mysqli_query($connection,$query);

while($row = mysqli_fetch_assoc($query_run)){

?>

<div class="card">

<div class="card-body">

<h5 class="card-title"><?php echo $row['title'];?></h5>

<p class="card-text"><?php echo $row['message'];?></p>

</div>

</div>

<?php

?>

</body>

</html>

30
Edit profile

<?php

session_start();

$connection = mysqli_connect("localhost", "root", "");

$db = mysqli_select_db($connection, "online_notice_board");

$fname = "";

$lname = "";

$email = "";

$password = "";

$class = "";

$query = "select * from users where email = '$_SESSION[email]'";

$query_run = mysqli_query($connection, $query);

while ($row = mysqli_fetch_assoc($query_run)) {

$fname = $row['fname'];

$lname = $row['lname'];

$email = $row['email'];

$password = $row['password'];

$class = $row['class'];

?>

<!DOCTYPE html>

<html lang="en" dir="ltr">

31
<head>

<meta charset="utf-8">

<title></title>

</head>

<body>

<form action="" method="post">

<div class="form-group">

<label>First Name:</label>

<input type="text" class="form-control" name="fname" value="<?php echo $fname;


?>">

</div>

<div class="form-group">

<label>Last Name:</label>

<input type="text" class="form-control" name="lname" value="<?php echo $lname;


?>">

</div>

<div class="form-group">

<label>User ID:</label>

<input type="email" class="form-control" name="email" value="<?php echo $email;


?>">

</div>

<div class="form-group">

<label>Password:</label>

32
<input type="password" class="form-control" name="password" value="<?php echo
$password; ?>">

</div>

<div class="form-group">

<label>Select Course:</label>

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

<option><?php echo $class; ?></option>

<option>BCA</option>

<option>[Link] IT</option>

<option>[Link]</option>

<option>Polytechnic</option>

<option>[Link]</option>

<option>MCA</option>

</select>

</div>

<button type="submit" name="update_profile" class="btn btn-primary">Update</button>

</form>

</body>

</html>

33
Index

<?php

session_start();

$connection = mysqli_connect("localhost", "root", "");

$db = mysqli_select_db($connection, "online_notice_board");

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

$query = "select * from users where email = '$_POST[email]' AND password =


'$_POST[password]'";

$query_run = mysqli_query($connection, $query);

if (mysqli_num_rows($query_run)) {

$_SESSION['email'] = $_POST['email'];

while ($row = mysqli_fetch_assoc($query_run)) {

$_SESSION['class'] = $row['class'];

echo "<script>

[Link] = 'user_dashboard.php';

</script>";

} else {

echo "<script>alert('Please Enter correct email id and password');

</script>";

34
?>

<!DOCTYPE html>

<html lang="en" dir="ltr">

<head>

<meta charset="utf-8">

<title>Online Notice Board System</title>

<!-- Bootstrap files -->

<link rel="stylesheet" type="text/css" href="bootstrap-4.4.1/css/[Link]">

<script src="bootstrap-4.4.1/js/[Link]" charset="utf-8"></script>

<!-- CSS File -->

<link rel="stylesheet" href="css/[Link]">

</head>

<body>

<!-- Header section code start here -->

<div class="row" id="header">

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

</div>

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

<h3>Online Notice Board System</h3>

</div>

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

</div>

35
</div>

<!-- Login from code starts here -->

<section id="login_form">

<div class="row">

<div class="col-md-4 m-auto block">

<center>

<h4>Student Login</h4>

</center>

<form action="[Link]" method="post">

<div class="form-group">

<lable>User ID:</label>

<input class="form-control" type="text" name="email" placeholder="Enter your


UserID">

</div>

<div class="form-group">

<lable>Passowrd:</label>

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


your Password">

</div>

<button class="btn btn-primary" type="submit" name="login">Login</button>

</form>

<a href="[Link]">Click here to register</a>

</div>

</div>

36
</section>

</body>

</html>

Register

<?php

$connection = mysqli_connect("localhost", "root", "");

$db = mysqli_select_db($connection, "online_notice_board");

if (isset($_POST['register'])) {

$query = "insert into users


values(null,'$_POST[fname]','$_POST[lname]','$_POST[email]','$_POST[password]','$_POS
T[class]')";

$query_run = mysqli_query($connection, $query);

if ($query_run) {

echo "<script>alert('Registration successfully...You may now login.');

[Link] = '[Link]';

</script>";

} else {

echo "<script>alert('Registration failed...try again');

[Link] = '[Link]';

</script>";

37
}

?>

<!DOCTYPE html>

<html lang="en" dir="ltr">

<head>

<meta charset="utf-8">

<title>Online Notice Board System</title>

<!-- Bootstrap files -->

<link rel="stylesheet" type="text/css" href="bootstrap-4.4.1/css/[Link]">

<script src="bootstrap-4.4.1/js/[Link]" charset="utf-8"></script>

<!-- CSS File -->

<link rel="stylesheet" href="css/[Link]">

</head>

<body>

<!-- Header section code start here -->

<div class="row" id="header">

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

</div>

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

<h3>Online Notice Board System</h3>

</div>

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

</div>

38
</div>

<!-- Login from code starts here -->

<section id="login_form">

<div class="row">

<div class="col-md-4 m-auto block">

<center>

<h4>Registration form</h4>

</center>

<form action="" method="post">

<div class="form-group">

<lable>First Name:</label>

<input class="form-control" type="text" name="fname" placeholder="Enter your


First Name">

</div>

<div class="form-group">

<lable>Last Name:</label>

<input class="form-control" type="text" name="lname" placeholder="Enter your


Last Name">

</div>

<div class="form-group">

<lable>User ID:</label>

<input class="form-control" type="text" name="email" placeholder="Enter your


UserID">

</div>

<div class="form-group">

39
<lable>Passowrd:</label>

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


your Password">

</div>

<div class="form-group">

<lable>Select Your Course:</label>

<select class="form-control" type="text" name="class">

<option>-Select-</option>

<option>BCA</option>

<option>[Link] IT</option>

<option>[Link]</option>

<option>Polytechnic</option>

<option>[Link]</option>

<option>MCA</option>

</select>

</div>

<button class="btn btn-primary" type="submit" name="register">Register</button>

</form>

<a href="[Link]">Click here to login</a>

</div>

</div>

</section>

</body>

</html>

40
User Dashboard

<?php

session_start();

if (isset($_POST['update_profile'])) {

$connection = mysqli_connect("localhost", "root", "");

$db = mysqli_select_db($connection, "online_notice_board");

$query = "update users set


fname='$_POST[fname]',lname='$_POST[lname]',email='$_POST[email]',password='$_POS
T[password]',class='$_POST[class]' where email='$_SESSION[email]'";

$query_run = mysqli_query($connection, $query);

if ($query_run) {

echo "<script type='text/javascript'>

alert('Profile Updated successfully...');

[Link] = 'user_dashboard.php'

</script>";

} else {

echo "<script type='text/javascript'>

alert('Can't update try again...');

[Link] = 'user_dashboard.php'

</script>";

?>

<!DOCTYPE html>

41
<html lang="en" dir="ltr">

<head>

<meta charset="utf-8">

<title>Student Dashboard</title>

<!-- Bootstrap files -->

<script src="bootstrap-4.4.1/js/[Link]" charset="utf-8"></script>

<link rel="stylesheet" type="text/css" href="bootstrap-4.4.1/css/[Link]">

<!-- CSS File -->

<link rel="stylesheet" href="css/[Link]">

<script src="jQuery/juqery_latest.js" charset="utf-8"></script>

<script type="text/javascript">

$(document).ready(function() {

$("#edit_profile_button").click(function() {

$("#main_content").load('edit_profile.php');

});

$("#view_notice_button").click(function() {

$("#main_content").load('view_notice.php');

});

});

</script>

</head>

<body>

<!-- Header section code start here -->

<div class="row" id="header">

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

</div>

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

<h3>Online Notice Board System</h3>

</div>

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

</div>

</div>

<br>

<section id="container">

<div class="row">

<div class="col-md-2" id="left_sidebar">

<img src="images/[Link]" class="img-rounded" width="200px" height="200px">

<b><?php echo $_SESSION['email']; ?></b>

<hr>

<button type="button" class="btn btn-primary btn-block" id="edit_profile_button">Edit


Profile</button>

<button type="button" class="btn btn-warning btn-block"


id="view_notice_button">View All Notices</button>

<a href="[Link]" type="button" class="btn btn-success btn-block">Logout</a><br>

</div>

<div class="col-md-8" id="main_content">

<h2>Welcome to Student Dashboard</h2>

<p>

43
This is the student Dashboard page. Here student cannot be manage notice board system. He
didn't create a notice, delete a notice and all the replies of the notice. </p>

<p>On Coursera, you can choose from thousands of online courses taught by faculty from
world-class universities like Yale, Stanford, and Princeton, and gain skills in fields such as data
science, finance, cloud computing, and graphic design.<p>

You're receiving this monthly email because you turned on Location History, a Google
Account-level setting that saves where you go in your private Timeline.
Location History data also helps give you personalized information on Google, including
better restaurant recommendations, and suggestions for a faster commute. You can view, edit,
and delete this data anytime in Timeline.
</p>

</div>

</div>

</section>

</body>

</html>

View Notice

<!DOCTYPE html>

<html lang="en" dir="ltr">

<head>

<meta charset="utf-8">

<title></title>

</head>

<body>

<br>

<center>

44
<h3>Notices for You</h3>

</center><br>

<?php

session_start();

$connection = mysqli_connect("localhost", "root", "");

$db = mysqli_select_db($connection, "online_notice_board");

$query = "select * from notice where to_whom = 'To All' OR to_whom = 'To Class
$_SESSION[class]'";

$query_run = mysqli_query($connection, $query,);

while ($row = mysqli_fetch_assoc($query_run)) {

?>

<div class="card">

<div class="card-body">

<h5 class="card-title"><?php echo $row['title']; ?></h5>

<p class="card-text"><?php echo $row['message']; ?></p>

</div>

</div>

<?php

?>

</body>

</html>

45
Chapter 5: Screenshot

Admin Registration Form

46
Admin Login

47
Admin Dashboard

48
Admin Profile

49
Admin Send Notice Form

50
All Notice

51
Registration Form

52
Student Login

53
Students Profile

54
Students Dashboard

55
Students Notice

56
Chapter 6: Conclusion

Benefits of Online Notice Board System


Advantages:
It saves paper. It saves time that was wasted earlier in getting the notice written or
[Link] do not need to go to the notice board and stand in a queue or crowd to read
the notice [Link] information becomes easily available for [Link] college management
can also remove the notices posted if they want to.

Future Look
Notices can be displayed in the form of word document, power point, video clips by uploading
them directly. This can be done by using a suitable operating system, program files, drivers,
players so as to make them more eye-catching. Such notices can be displayed by using a
webpage and giving an access to authorised users. The best way is the use of an INTERNET.
An IP address can be used to achieve this. The IP will enable the user to upload any notice and
from anywhere in the world. Moreover, cloud can be used to dump the past notices and keep
record of them.

Conclusion
With the day-to-day advancement in technology the Notice Boards are also evolving from a
hand- written system to a digital display and further to a Wireless Display System. The
paperreflects a Digital Notice Board System with a GSM module and raspberry pi, which
displays the desired notices in the form of a text or an image or video on the LCD screen
through a SMS. Multiple notices can be displayed simultaneously in parallel withan image or
video. Use of a password scheme before the message and for starting the notice board display
has also enhanced the security concerns.
Thus, the Online Notice Board System it is developed and executed successfully.

57

You might also like