Introduction:-

The 'Bus Bypass Control Machine' is a web-based system that allows bus operators to manage pass
information. A bus by-pass management device is a robotic piece of equipment that processes records
at a high pace and in a planned phase.

This technique aids bus operators in maintaining a record of bus passes.Prior to the implementation of
this programme, the procedure for removing the bus from the visitor was carried out manually. To
avoid these issues utilising the 'Bus modify gadget,' this manual solution requires human effort and
asignificant amount of time.

Problem Statement:-

This on-line bus software software will assist students

And commuters in locating on-line buses and eliminating the need to wait in lines

to by pass or collect tickets for each trip.

1.It will help students and commuters find on-line buses and eliminate the need to
wait in lines to bypass or collect tickets for each trip. 2.You can
paywithacreditcardoramaster cardonline.

3.It has a unique feature called a chat engine, which allows users to connect with
one another in case they want to exchange tickets via the server.

Project Objectives:-
The Bus By pass ManagementSystem is an internet- based technology that helps
people who wish to tour every day manage transit information supplied by
management and also offer on-line bus permits.

My goal forthis project is to improve the booking organization's ticketing project

simpler, more dependable,easiertouse,andmoreconvenient.In addition, it takes less
time than physical labour.The primary goal of all mission effort is to automate the
book ing process for everyday sports.ofthedevice library, as well as:
1
1.Ticket-related activities.
GenerateaCustomerID.

1.Assignbusticketsbasedondemandfrom customers.

1.Reservationsinadvance.

Cancellationofbustickets.

6.Feedbacks.

7.ChatSoftware

Methodology:-

Database:MySQL Frontend
Tech:
HTML,CSS
Scripting language: JavaScript
IDE:Sublime
BackendTech:PHP Web Sockets

2
REQUIREMENTSFORHARDWARE:

1.IntelP-IVprocessorbasedsystem
2.0GHzProcessorSpeed
3.RAM-1GB
4.40GBto80GBharddrive
REQUIREMENTSFORSOFTWARE

1.Databaseused-MySQL

2.Serverused-Apache

3.HTMLforFront-End

4.JavaScriptisusedasScriptinglanguage

5.IDEused-Sublime

6.Technologiesused-PHP,NodeJS

7.Web-Sockets-Socket.io

3
CHAPTER02–LITERATURESURVEY

Mayuri (Potghan), Gayatri (Shinde), Tazeen (Sheikh) and Sadaf (Sheikh),have

suggested autility to be utilized for reserving afare for locomotives and even
mainlines. Snehal(Kalbhor), Mrs. Snehal(Kulkarni), Ashwini (Mangulkar), presented
many methods for buying mainline or neighbouring locomotive tickets using their
phone system, as well as adding ticket checking..
Tushar (Dongare), Akshay (Babar) has provided numerous ticketing ways for its
cellphone software via GPS region for Android mobile so that traveler s may simply
identify the channel list and acquire Ramadevi tickets.ok, Murugan. S, Bharath.
US has evolved an android cell ticketing app where the user will obtain a price tag
within the future. and brought ticket checks. Manmohan(Swarup), Vijendra(Singh),
Chanchal(Sonkar) presented a system in which teaching bookkeeping is done via
multimedia and multimedia phones HusaniWanWanHussinand Paul Coulton
presented an application in which more purchasers are expected to engage in cell
purchasing and selling, as well as acquisitions.

4
2.1TechnologyandTools

IJISET- globaljournalofrecentSciences,Engineering and era, Vol. 1 Issued nine

November 2014.
www.ijiset.comISSN2348-7968 583

HTML stands for HyperText-MarkUp-Language. According to TimBerners-Lee,it is

acritical markup language for online sites and a component of web pages (1998). The
web browser reads HTML files and combines them into visual or audio online pages.
(lamp.Cse.Fau.Edu).
Cascading style Sheets (CSS) may also be used by web browsers to emphasise the
emergence and structure of textual content and other variables
(www.W3schools.Com)(Taylor,2013).
CSSispreferredabove clear HTML markup pages by the W3C, your source for both
HTML and CSS requirements (Debolt, 2007) JavaScript is a prominent ECMA Script
language implementation that is primarily utilised in the purchaser JavaScript
environment, where it is used as part of an internet browser to decorate user links
with various useful Web-sites (Mc-Farland, 2008). This allows for systematic access
to computer items within a certain range. A popular writing language is Hypertext
Preprocessor that was created to help the internet provide dynamic web pages. As a
result ,php code is integrated in an HTML render ingreport and translated using a php
processing module,which outputsan

5
Internet document used for Web-page (Chen,Panandothers).sq. is a language for
computers’used to hand leand retrieve statistics from databases, also known as
structured Questionnaire Language. It was created to manipulate data in relational
databases and is said tobegrounded on numerical and relational algebra (Ghosh,
2010). Nowadays, NotePad is the most widely used text editor(simplecontent).The
files that result are usually saved withthe extension. Because Txt no longer has shape
tags or patterns, this machine is suitable for creating system documents for use with
DOS or HTML (533507.Weebly.Com).InNotepad,anyleft-to-rightandleft-to- right
vertebrate is supported (Afriyie, 2012).

RequirementsonMinorProject
1.FunctionalRequirements

 Administrativefunctions
 Authentication
 Authorizationlevels
 BusinessRules
 Transactionrevisions,changes,andcancellations

2.Requirementsthataren’tfunctional

 Response-Time,Utilization,Through- Put, Static Volumetric

Performance
 Obtainability
 Authenticity
 Proficiency
 Serviceability
 Maintainability

6
CHAPTER03–Environment for System Development

Html

WHAT EXACTLY IS Html?

Forthe data inorder to locate globally, one requires a language that the university
knows ,a type of native-language publication that all robots can comprehend. The
International Publishing Language

HTML for the Internet (MarkupHyperText)

Html is used to provides Authors the Ability To

1. Use tocreateonlinedocswithtitles,tables,text,lists, also photographs and many

other things.
2. With the press of a button, Hypertext linksareusedto return information online.
ThecreationofformsforInformationsearches,
bookings,andproductordersareexamples ofdistant
trade transactions.
4. Allows youtodirectlyinsertspreadsheets,video clips, audio samples, and other apps
into documents.

SomeHTMLTags

<HTML>tag :HTML-tagtobegin

<HEAd> :Creating the head of a webpage

<TITLE> :Giving the body of a webpage

7
</HEAD> :To end the head of a webpage

</BODY> :Ending the bodyofa webpage

</HTML> :Putting an end to awebpage

<FORM> :Developing HTML forms

<INPUTTYPE=BUTTON> :The creation of but-tons

<INPUT-TYPE=’CHECKBOX’>:To create check-boxes

<INPUT-TYPE=’SUBMIT’> :To create submit-button

<INPUT-TYPE=’TEXT’>:TocreateText field

8
Html4.0

Html 4.0 also improves accessibility For individuals with impairments by expanding
style styles, writing, embedding frames, greater right-to-left guide text support, rich
tables, and other enhancements.

INTRODUCINGJAVA-SCRIPT

WHAT EXACTLYIS JAVA-SCRIPT?

JavaScript, which was originally supported by Netscape Navigator, is the most

widely used web language today.
JavaScript allows you to embed and execute programmes directlyonyourwebsite.
The applications basically are included in the Script> section. If you want the content
to be written directly on a Web page, put it in the BODY> section.

EX:<Html>

<Head>

9
<Title></Title>

</Head>

<Body>

<ScriptLanguage=”JavaScript”>

</Script>

</Body></Html>

JAVASCRIPTSOBJECTS

An object-oriented language is JavaScript.Java Script comes with a number of preset objects.

ObjectsoftheJavaScript

1.document: Compliant with the body of the current Web page. This tool displays the page's
HTML, which includes all of the links, pictures, and anchors.
2.form: Contains information about HTML forms on the current page.

3.frame: The frameofthebrowserwindow.

4.history: Keep strack of those web sites you visited before

10
Arrivingat the present page on your web browser.

1. Location: This field contains related data of the current location of the web
page.
2. navigator: This relates to the browser itself ,and it allows you to identify the
browser used by the user.
3.window: This refers to the current browser window.

JAVASCRIPTSEVENTS

EventsofJava-Script

1.Inswitch: Whenthedata is incontrol, likethetext field,the in switch is triggered.

2.onClick: Whenanobject isclicked,itappears.

3.inFocus :Whenanelementobtainsfocus,thisoccurs.

4.inMouseDown: appears mainlywhenthe mouse-buttonis pressed down.

5.inReset: Userpressestheresetbutton,this appears.

JAVA-SCRIPTFUNCTIONS

Declaration of function

Syntax:functionfunction
name()

}
11
Write these functions in
<SCRIPT>tag.

INTRODUCINGWEBSOCKETS

Web socket protocol supports real-time two-way communication. Conversation

The engine uses WebSocket to establish communication for conversion just once
Publish the message anddistribute it to your subscribers.It also uses the same websocket connection to
send and receive messages as well as forward messages

12
 DifferencebetweenWebSocketandHTTPConnection

WebSocketconnection HTTPconnection
Web-Socketisadual-orientedwhich by HTTP Protocol is an indirect protocol that
reusing the default connection channel, this works on top of the TCP protocol based on
communication protocol may transport data the Connection, we can create a connection
from client to server or from server to using HTTP request methods after
client.. The connection is kept alive until discovering that the
disconnected as a client or HTTPresponseconnectionisclosed.
server.

To receive data on a single AsimpleRESTfulapplication leverages the

communication channel, almost all real- stateless HTTP protocol.
timeapplicationsemployWeb-
Sockets.

WEbSocket is used by all regularly When we don't want to keep a connection

updatedappssinceitisquickerthan HTTP open for an extended
Connection. periodoftime,HTTPisslowerthan
WebSocket.

DDBMSCONCEPTS
R

1.DATA ABSTRACTION

The data base gad get's main goal is to offer users with an on-

13
obtrusive view of the records. This programme conceals certain information about
how records are saved and maintained. However, for the system to function, the
statistics must have been properly downloaded. Hence performance culminates inthe
productionofa complex-data visualisation shape on a website. Customers of the
database gadget must be kept in the dark about something complicated. This is done
by specifying a number of output phases through which the website may be viewed.

1. CATEGORIZATION OF DATABASE
Below are three different database approaches:

Hierarchical-Database:

In this style of design, data is represented by a simple tree. A record having more
than three dependents is called Root. Root can have any number of dependents.There
is a minimum number of dependents and a maximum number of levels for each of
them. This method has the following drawbacks:

a.NetworkDatabase:
Data is represented by Network configuration on

Network Websites.A saresult,the occurrence of a record can be immediately

communicated to a large

14
number of managers and dependents, allowing for more direct contact than the
classification system. The Networkmodel's fundamental flaw is that data
representation is so complicated that it leads to a DML (Data Fraud Language)
problem.

a.RelationalDatabase:

For each set of tables containing a number of columns with distinct

names, the relationship model depicts the data and the relationship between the data.

THE SQL (LANGUAGE)

A relational database language is SQL. SQL is a non- procedural language,which

means we specify what we want done rather than how.

SQL FEATURES

1.SQL is mainly a query language for working to gether.

2.The website management language is SQL.

3.The language of web siteeditingis SQL.

4.SQL is the server/client programming Language.

15
1.SQL is a programming language used to create distributed
Web sites.

2.SQLisawebsite gatewaylanguage.

SQL Commands-Basics

✔Data definition language(DDL)

✔Data deception (DML) Commands

✔Transactional Control (TCL)languageinstructions

✔DataManagement language Commands(DCL)

PHP

 The acronym PHP actually stands in this manner"PHP: Hypertext

Preprocessor."

 It is a popular open source script.

 On the server,PHP scripts are used.

 It is free to download and therebytouse.

What exactly is a PHP File?

 PHP file scan include text,HTML,CSS,JavaScript,andPHP

16
  code.

 PHP code is said to run on the server, and the output is displayed in the
browser as plain HTML.

 PHP File send with".php"

What does PHP Do?

PHP can create dynamic content for web pages.
On a server,PHP may createread,open,write,delete,andare also used for closing files.
Form data may be collected by PHP.
PHP is capable of sending and receiving cookies.
PHP may add,delete,and edit information on your website. PHP may be used to
control user access.
PHP is capable of encrypting data.
You are not limitedto extracting HTML with PHP.You may save images, To your
PC, you may save PDF files and even Flash films. Any text may be extracted,
including XHTML and XML.

Design Document,Models and Dataflow

17
Diagrams

 The complete system is represented by a physical graphic that depicts the

exact physical limits that any website must fulfil in order to be saved on disc.
This graphic represents the overall picture of the current systems.

 The ER-Diagram concept shapes device integration because it not only

identifies existing companies but also the basic gadget relationships that exist
and the important elements required to maintain machine condition.
 The DFD content level is presented to provide an overview of the active
features and implications of the system.The device displays the input and
output phases at the highest level possible within existing structures.

The DFD does not present the steps inorder. The DFD only illustrates how the process differs
from the system and how data flows throughit. The following are some of the DFD symbols
used in the project.

External-Entities

18
DATAFLOWS

RULES FOR DFD:

 Adjust the system width using context diagrams.

 Set the DFD to read the main action sequence from left to right and up and down.

 Create list of every input and output.

 Using circular objects,Each process in a system should be identified and labelled.

 A method is required for any data conversion and transfer. As a result, never link a
data store to a data source, destination, or other data store via a data flow arrow.

 Ignoreallcontrolinformationandhideany hardware..

 Makesuretheterminologyappropriatelyconveyswhat is being done.

19
  There should be no ambiguous procedures.

 Recognize outside sources,data centres,andsquares.

 Each international tradeevent's number is repeated.

 Except for easy record retrieval, identify all data flow for each step of the
operation.

 Label the data-flow in every arrow.

 The in formation flow in each arrow should be used.

 The data flow arrow to show how the data is moving,should be used.

 Unspecified data cannot be flowed.

 Data transmission between two external organisationsisn ot possible.

VARIOUSDFD LEVELS:

Because of the complications of a device, the requirement of depiction of

performance of a any one records drift system. A context analysis diagram is used to
depict an outline of the various structure sinside the employer at the
highestlevel.while the DFD blew up

There presentation of thevariousDFDlevelsisasfollows

● LEVEL-0INPUT/OUTPUTOFTHESYSTEM

20
  LEVEL-1DATAFLOWFUNCTIONALLEVELOFTHE SUBSYSTEM

 LEVEL-2DETAILDATAFLOWAT THE FILELEVEL

From one level to the next,the input and output data should be consistent.

LEVEL 0 INPUT/OUTPUT OF THE SYSTEM

Degree zero DFD manages inputs and outputs from the main machine and tactics,
defining massive machine parameters. This graphic is similar to a context diagram at
the consumer level.

LEVEL1 DATA FLOW FUNCTIONAL LEVEL OF THE SUBSYSTEM

level 1 DFD defines the next level of data within the device, defining the flow of data
between sub-structures that makes up the entire thing.

LEVEL2 DETAIL DATA FLOW AT THE FILE LEVEL

If infinite resources are available and time is restricted, all undertakings are viable. It
is critical and sensible to assess the feasibility of a problem as soon as possible. There
are several impacts of feasibility and danger analysis.. Ifthe danger to undertake is
too great.

21
LEVEL FIRST OF THE DATA FLOW FIGURE

Level2 OF THE DFDs

26
 2.Unified-Modeling-Language-Diagrams(UML):

These associated programming languages use a model approach controlled by a

set of syntactic, semantic, and pragmatic principles the software engineer
canconstruct an analytical version.

The UML device is represented by fived istinct ideas that define the device froma
unique viewpoint. Each view is described in the following drawing set.

Model View of User

The view depicts the whole from the observation of a single person.
The analytical presentation describes the utilisation situation from the perspective
of clients who have given up.

Structural model view

There cord sand over all performance in this version follow the flow of the gadget.
Vertical systemsare represented in this model view.

27
BehavioralModelView

Represents behavioural fluctuation sasa component of a gadget, reflecting the

group's interaction with the various structural aspects indicated in the user model and
the shape version's perspective.

Implementation-Model-View

This example includes order and behaviour as part of the plan since it can be
constructed.

Environmental-Model-View

Mainly structural and behavioural characteristics of respective system could be expressed in this
scenario.

UML is madeup entirely fun usual domain names.

UML analytical version, which specializes in user version and system
structure examination?

Behavioral modelling, implementation modelling, and

environmental model views are all covered by UML layout modelling.

28
Use Case Diagrams: Admin

pg.

29
Use Case Diagrams: User

Entity Relationship Diagrams

An E-R(Entity-Relationship) Diagram depicts the relationship between the table's

entities.

The symbols used in E-R diagrams are:

SYMBOL PURPOSE

RepresentsEntity sets.

Representing attributes.

30
Representing Relationship Sets.

line representing

Systematic analysis refers to a collection of tools and techniques for analysing data.

Developing a New System Type: The conventional method focuseson cost-benefit and
feasibility analysis, project management, and the selection of hardware and software. for
private challenges.

31
32
DatabaseDesign

The website's gadget statistics should be preserved and downloaded. The layout of
the system includes website design. The analysis segment recognises statistical
additives and data systems to be kept. built and assembled to create a data storage
and healing device
A website is a collection of connected statistics saved with the least amount ofwaste
so that numerous clients mayaccess them quicklyandeffectively.The
maingoalistomakegainingaccess tothewebsiteeasier, faster, less expensive, and less
challenging for the consumer. Relationships between information items are
established, and irrelevant data is deleted. The goal of orientation is to achieve
internal statistical consistency, as well as less volatilityandgreaterstability.This result
sinfewer records being retained, a lowerriskofdata breach, and more frequent updates.
The MS gain access to website has been chosen to improve the relevant database.

Curfew E-Pass Management System Project (CPMS) contains 3

MySQL tables :

admin table Structure : This database keeps track of the administrator's login
and personal informatio

33
 Tbl category tableStructure: The table encapsulates the category of pass.

Tbl pass table Structure:The table encapsulates the pass information of person.

tblpage: This table encapsulates the detail for ‘about us ’and ‘contact us’ page.

tblcontact: This table encapsulates the enquiry information of users.

34
Diagram used for Class:
The class diagram depicts a set of classes ,interfaces , collaborations, and their interactions.

35
 SAMPLE CODING:
Admin:
Dbconnection:
<?php
// DB credentials.
define('DB_HOST','localhost');
define('DB_USER','root');
define('DB_PASS','');
define('DB_NAME','buspassdb');
// Establish database connection.
try
{
$dbh = new PDO("mysql:host=".DB_HOST.";dbname=".DB_NAME,DB_USER,
DB_PASS,array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"));
}
catch (PDOException $e)
{
exit("Error: " . $e->getMessage());
}
?>
HEADER:
<nav class="navbar navbar-default navbar-fixed-top" role="navigation" id="navbar">
<!-- navbar-header -->
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".sidebar-
collapse">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="dashboard.php">
<strong style="color: white;font-size: 30px">Bus Pass MS</strong>
</a>

36
 </div>
<!-- end navbar-header -->
<!-- navbar-top-links -->
<ul class="nav navbar-top-links navbar-right">
<!-- main dropdown -->
<li class="dropdown">
<a class="dropdown-toggle" data-toggle="dropdown" href="#">
<i class="fa fa-user fa-3x"></i>
</a>
<!-- dropdown user-->
<ul class="dropdown-menu dropdown-user">
<li><a href="admin-profile.php"><i class="fa fa-user fa-fw"></i>User Profile</a>
</li>
<li><a href="change-password.php"><i class="fa fa-gear fa-fw"></i>Settings</a>
</li>
<li class="divider"></li>
<li><a href="logout.php"><i class="fa fa-sign-out fa-fw"></i>Logout</a>
</li>
</ul>
<!-- end dropdown-user -->
</li>
<!-- end main dropdown -->
</ul>
<!-- end navbar-top-links -->
</nav>
SIDE BAR:
<?php
error_reporting(0);
include('includes/dbconnection.php');
?>
<nav class="navbar-default navbar-static-side" role="navigation">
<!-- sidebar-collapse -->
<div class="sidebar-collapse">
37
 <!-- side-menu -->
<ul class="nav" id="side-menu">
<li>
<!-- user image section-->
<div class="user-section">
<div class="user-section-inner">
<img src="assets/img/user.jpg" alt="">
</div>
<div class="user-info">
<?php
$aid=$_SESSION['bpmsaid'];
$sql="SELECT AdminName from tbladmin where ID=:aid";
$query = $dbh -> prepare($sql);
$query->bindParam(':aid',$aid,PDO::PARAM_STR);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $row)
{ ?>
<div><strong><?php echo $row->AdminName;?></strong></div>
<div class="user-text-online">
<span class="user-circle-online btn btn-success btn-circle
"></span>&nbsp;Online
</div>
</div>
<?php $cnt=$cnt+1;}} ?>
</div>
<!--end user image section-->
</li>
<li class="selected">
<a href="dashboard.php"><i class="fa fa-dashboard fa-fw"></i>Dashboard</a>
38
 </li>
<li>
<a href="#"><i class="fa fa-bar-chart-o fa-fw"></i> Category<span class="fa
arrow"></span></a>
<ul class="nav nav-second-level">
<li>
<a href="add-category.php">Add Category</a>
</li>
<li>
<a href="manage-category.php">Manage Category</a>
</li>
</ul>
<!-- second-level-items -->
</li>
<li>
<a href="#"><i class="fa fa-files-o fa-fw"></i> Passes<span class="fa
arrow"></span></a>
<ul class="nav nav-second-level">
<li>
<a href="add-pass.php">Add Pass</a>
></a> </li>
<li>
<a href="manage-pass.php">Manage Pass</a>
</li>
</ul>
<!-- second-level-items -->
</li>
<li>
<a href="#"><i class="fa fa-files-o fa-fw"></i> Pages<span class="fa
arrow"></span></a>
<ul class="nav nav-second-level">
<li>
<a href="aboutus.php">About Us</a>
39
 </li>
<li>
<a href="contactus.php">Contact Us</a>
</li>
</ul>
<!-- second-level-items -->
</li>
<li>
<a href="#"><i class="fa fa-files-o fa-fw"></i> Enquiry<span class="fa
arrow"></span></a>
<ul class="nav nav-second-level">
<li>
<a href="readenq.php">Read Enquiry</a>
</li>
<li>
<a href="unreadenq.php">Unread Enquiry</a>
</li>
</ul>
<!-- second-level-items -->
</li>
<li>
<a href="search-pass.php"><i class="fa fa-search"></i> Search<span class="fa
arrow"></span
</li>
<li>
<a href="pass-bwdates-report.php"><i class="fa fa-folder"></i> Report of Pass<span
class="fa arrow"></span></a>
</li>
</ul>
<!-- end side-menu -->
</div>
<!-- end sidebar-collapse -->
</nav>
40
ABOUT:
<?php
include('includes/dbconnection.php');
session_start();
error_reporting(0);
?>
<!DOCTYPE html>
<html lang="en">
<head>

<title>Bus Pass Management System || About Us Page</title>

<script type="application/x-javascript"> addEventListener("load", function() {
setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
<!-- Custom Theme files -->
<link href="css/bootstrap.css" type="text/css" rel="stylesheet" media="all">
<link href="css/style.css" type="text/css" rel="stylesheet" media="all">
<link href="css/font-awesome.css" rel="stylesheet"> <!-- font-awesome icons -->
<!-- //Custom Theme files -->
<!-- web-fonts -->
<link href="//fonts.googleapis.com/css?family=Oswald:200,300,400,500,600,700" rel="stylesheet">
<link
href="//fonts.googleapis.com/css?family=Roboto:100,100i,300,300i,400,400i,500,500i,700,700i,900,9
00i" rel="stylesheet">
<!-- //web-fonts -->
</head>
<body>
<!-- banner -->
<div class="agileits-banner">
<div class="bnr-agileinfo">
<!-- navigation -->
<?php include_once('includes/header.php');?>
<!-- //navigation -->
<!-- banner-text -->
<div class="banner-text agileinfo about-bnrtext">
41
 <div class="container">
<h2><a href="index.php">Home</a> / About</h2>
</div>
</div>
<!-- //banner-text -->
</div>
</div>
<!-- //banner -->
<!-- welcome -->
<div class="welcome" id="welcome">
<?php
$sql="SELECT * from tblpage where PageType='aboutus'";
$query = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $row)
{ ?>
<div class="container">
<div class="agileits-title">
<h3><?php echo $row->PageTitle;?></h3>
</div>
<div class="welcomerow-agileinfo">

<p><?php echo $row->PageDescription;?></p>

</div>
</div> <?php $cnt=$cnt+1;}} ?>
</div>
</div>
<!-- //welcome -->

42
<?php include_once('includes/footer.php');?>
<!-- js -->
<script src="js/jquery-2.2.3.min.js"></script>
<script src="js/SmoothScroll.min.js"></script>
<script src="js/jarallax.js"></script>
<script type="text/javascript">
/* init Jarallax */
$('.jarallax').jarallax({
speed: 0.5,
imgWidth: 1366,
imgHeight: 768
})
</script>
<!-- //js -->
<!-- Progressive-Effects-Animation-JavaScript -->
<script type="text/javascript" src="js/numscroller-1.0.js"></script>
<!-- //Progressive-Effects-Animation-JavaScript -->
<!-- start-smooth-scrolling -->
<script type="text/javascript" src="js/move-top.js"></script>
<script type="text/javascript" src="js/easing.js"></script>
<script type="text/javascript">
jQuery(document).ready(function($) {
$(".scroll").click(function(event){
event.preventDefault();
$('html,body').animate({scrollTop:$(this.hash).offset().top},1000);
});
});
</script>
<!-- //end-smooth-scrolling -->
<!-- smooth-scrolling-of-move-up -->
<script type="text/javascript">
$(document).ready(function() {
/*
43
 var defaults = {
containerID: 'toTop', // fading element id
containerHoverID: 'toTopHover', // fading element hover id
scrollSpeed: 1200,
easingType: 'linear'
};
*/
$().UItoTop({ easingType: 'easeOutQuart' });
});
</script>
<!-- //smooth-scrolling-of-move-up -->
<!-- Bootstrap core JavaScript
================================================== -->
<!-- Placed at the end of the document so the pages load faster -->
<script src="js/bootstrap.js"></script>
</body>
</html>
CONTACT:
<?php
include('includes/dbconnection.php');
session_start();
error_reporting(0);
if(isset($_POST['submit']))
{
$name=$_POST['name'];
$email=$_POST['email'];
$message=$_POST['message'];
$sql="insert into tblcontact(Name,Email,Message)values(:name,:email,:message)";
$query=$dbh->prepare($sql);
$query->bindParam(':name',$name,PDO::PARAM_STR);
$query->bindParam(':email',$email,PDO::PARAM_STR);
$query->bindParam(':message',$message,PDO::PARAM_STR);
$query->execute();

44
 $LastInsertId=$dbh->lastInsertId();
if ($LastInsertId>0) {
echo "<script>alert('Your message was sent successfully!.');</script>";
echo "<script>window.location.href ='contact.php'</script>";
}
else
{
echo '<script>alert("Something Went Wrong. Please try again")</script>';
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Bus Pass Management System || Contact Us Page</title>
<script type="application/x-javascript"> addEventListener("load", function() {
setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
<!-- Custom Theme files -->
<link href="css/bootstrap.css" type="text/css" rel="stylesheet" media="all">
<link href="css/style.css" type="text/css" rel="stylesheet" media="all">
<link href="css/font-awesome.css" rel="stylesheet"> <!-- font-awesome icons -->
<!-- //Custom Theme files -->
<!-- web-fonts -->
<link href="//fonts.googleapis.com/css?family=Oswald:200,300,400,500,600,700" rel="stylesheet">
<link
href="//fonts.googleapis.com/css?family=Roboto:100,100i,300,300i,400,400i,500,500i,700,700i,900,9
00i" rel="stylesheet">
<!-- //web-fonts -->
</head>
<body>
<!-- banner -->
<div class="agileits-banner">
<div class="bnr-agileinfo">
45
 <!-- navigation -->
<?php include_once('includes/header.php');?>
<!-- //navigation -->
<!-- banner-text -->
<div class="banner-text agileinfo about-bnrtext">
<div class="container">
<h2><a href="index.php">Home</a> / Contact</h2>
</div>
</div>
<!-- //banner-text -->
</div>
</div>
<!-- //banner -->
<!-- contact -->
<div class="contact agileits">
<div class="container">
<div class="agileits-title">
<h3>Contact Us</h3>
</div>
<div class="contact-agileinfo">
<div class="col-md-7 contact-form wthree">
<form action="#" method="post">
<input type="text" name="name" placeholder="Name"
required="">
<input class="email" type="email" name="email"
placeholder="Email" required="">
<textarea placeholder="Message" name="message"
required=""></textarea>
<input type="submit" name="submit" value="SUBMIT">
</form>
</div>
<div class="col-md-4 contact-right wthree">
<div class="contact-text w3-agileits">
46
 <h4>GET IN TOUCH :</h4>
<?php
$sql="SELECT * from tblpage where PageType='contactus'";
$query = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $row)
{ ?>
<p><i class="fa fa-map-marker"></i> <?php echo
htmlentities($row->PageDescription);?> </p>
<p><i class="fa fa-phone"></i> Mobile Number : <?php
echo htmlentities($row->MobileNumber);?></p>
<p><i class="fa fa-envelope-o"></i> Email : <?php echo
htmlentities($row->Email);?></p> <?php $cnt=$cnt+1;}} ?>
</div>
</div>
<div class="clearfix"> </div>
</div>
</div>
</div>
<!-- //contact -->
<?php include_once('includes/footer.php');?>
<!-- js -->
<script src="js/jquery-2.2.3.min.js"></script>
<script src="js/SmoothScroll.min.js"></script>
<script src="js/jarallax.js"></script>
<script type="text/javascript">
/* init Jarallax */
$('.jarallax').jarallax({
speed: 0.5,
47
 imgWidth: 1366,
imgHeight: 768
})
</script>
<!-- //js -->
<!-- start-smooth-scrolling -->
<script type="text/javascript" src="js/move-top.js"></script>
<script type="text/javascript" src="js/easing.js"></script>
<script type="text/javascript">
jQuery(document).ready(function($) {
$(".scroll").click(function(event){
event.preventDefault();
$('html,body').animate({scrollTop:$(this.hash).offset().top},1000);
});
});
</script>
<!-- //end-smooth-scrolling -->
<!-- smooth-scrolling-of-move-up -->
<script type="text/javascript">
$(document).ready(function() {
/*
var defaults = {
containerID: 'toTop', // fading element id
containerHoverID: 'toTopHover', // fading element hover id
scrollSpeed: 1200,
easingType: 'linear'
};
*/
$().UItoTop({ easingType: 'easeOutQuart' });
});
</script>
<!-- //smooth-scrolling-of-move-up -->
<!-- Bootstrap core JavaScript
48
 ================================================== -->
<!-- Placed at the end of the document so the pages load faster -->
<script src="js/bootstrap.js"></script>
</body>
</html>
DOWNLOAD PASS:
<?php
include('includes/dbconnection.php');
session_start();
error_reporting(0);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Bus Pass Management System || Pass Page</title>
<script type="application/x-javascript"> addEventListener("load", function() {
setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
<!-- Custom Theme files -->
<link href="css/bootstrap.css" type="text/css" rel="stylesheet" media="all">
<link href="css/style.css" type="text/css" rel="stylesheet" media="all">
<link href="css/font-awesome.css" rel="stylesheet"> <!-- font-awesome icons -->
<!-- //Custom Theme files -->
<!-- web-fonts -->
<link href="//fonts.googleapis.com/css?family=Oswald:200,300,400,500,600,700" rel="stylesheet">
<link
href="//fonts.googleapis.com/css?family=Roboto:100,100i,300,300i,400,400i,500,500i,700,700i,900,9
00i" rel="stylesheet">
<!-- //web-fonts -->
</head>
<body>
<!-- banner -->
<div class="agileits-banner">
<div class="bnr-agileinfo">

49
 <!-- navigation -->
<?php include_once('includes/header.php');?>
<!-- //navigation -->
<!-- banner-text -->
<div class="banner-text agileinfo about-bnrtext">
<div class="container">
<h2><a href="index.php">Home</a> / View Pass</h2>
</div>
</div>
<!-- //banner-text -->
</div>
</div>
<!-- //banner -->
<!-- contact -->
<div class="contact agileits">
<div class="container">
<div class="agileits-title">
<h3>View Pass</h3>
</div>
<div class="contact-agileinfo">
<div class="col-md-7 contact-form wthree">
<form action="#" method="post">
<input id="searchdata" type="text" name="searchdata"
placeholder="Search by Pass Number" required="true">
<button style="padding-top: 14px;" type="submit" class="btn
btn-primary" name="search" id="submit">Search</button>
</form>
</div>
<div class="clearfix"> </div>
<div class="table-responsive">
<?php
if(isset($_POST['search']))
{
50
$sdata=$_POST['searchdata'];
?>
<h4 style="padding-bottom: 20px;">Result against "<?php echo $sdata;?>" keyword </h4>
<table border="2" class="table table-bordered" style="font-size: 18px;">
<thead>
<tr>
<th>S.NO</th>
<th>Pass Number</th>
<th>Full Name</th>
<th>Contact Number</th>
<th>Email</th>
<th>Creation Date</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$sql="SELECT * from tblpass where PassNumber like '$sdata%'";
$query = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $row)
{ ?>
<tr>
<td><?php echo htmlentities($cnt);?></td>
<td><?php echo htmlentities($row->PassNumber);?></td>
<td><?php echo htmlentities($row->FullName);?></td>
<td><?php echo htmlentities($row->ContactNumber);?></td>
<td><?php echo htmlentities($row->Email);?></td>
<td><?php echo htmlentities($row->PasscreationDate);?></td>
51
 <td><a href="view-pass-detail.php?viewid=<?php echo htmlentities ($row->ID);?>"
class="btn btn-primary">View </a></td>
</tr>
<?php
$cnt=$cnt+1;
} } else { ?>
<tr>
<td colspan="8"> No record found against this search</td>
</tr>
<?php } }?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- //contact -->
<?php include_once('includes/footer.php');?>
<!-- js -->
<script src="js/jquery-2.2.3.min.js"></script>
<script src="js/SmoothScroll.min.js"></script>
<script src="js/jarallax.js"></script>
<script type="text/javascript">
/* init Jarallax */
$('.jarallax').jarallax({
speed: 0.5,
imgWidth: 1366,
imgHeight: 768
})
</script>
<!-- //js -->
<!-- start-smooth-scrolling -->
<script type="text/javascript" src="js/move-top.js"></script>
52
 <script type="text/javascript" src="js/easing.js"></script>
<script type="text/javascript">
jQuery(document).ready(function($) {
$(".scroll").click(function(event){
event.preventDefault();
$('html,body').animate({scrollTop:$(this.hash).offset().top},1000);
});
});
</script>
<!-- //end-smooth-scrolling -->
<!-- smooth-scrolling-of-move-up -->
<script type="text/javascript">
$(document).ready(function() {
/*
var defaults = {
containerID: 'toTop', // fading element id
containerHoverID: 'toTopHover', // fading element hover id
scrollSpeed: 1200,
easingType: 'linear'
};
*/
$().UItoTop({ easingType: 'easeOutQuart' });
});
</script>
<!-- //smooth-scrolling-of-move-up -->
<!-- Bootstrap core JavaScript
================================================== -->
<!-- Placed at the end of the document so the pages load faster -->
<script src="js/bootstrap.js"></script>
</body>
</html>
INDEX:
<?php
53
session_start();
error_reporting(0);
include('includes/dbconnection.php');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Bus Pass Management System || Home Page</title>
<script type="application/x-javascript"> addEventListener("load", function() {
setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
<!-- Custom Theme files -->
<link href="css/bootstrap.css" type="text/css" rel="stylesheet" media="all">
<link href="css/style.css" type="text/css" rel="stylesheet" media="all">
<link rel="stylesheet" href="css/flexslider.css" type="text/css" media="screen" /> <!-- flexslider-CSS
-->
<link href="css/font-awesome.css" rel="stylesheet"> <!-- font-awesome icons -->
<!-- //Custom Theme files -->
<!-- web-fonts -->
<link href="//fonts.googleapis.com/css?family=Oswald:200,300,400,500,600,700" rel="stylesheet">
<link
href="//fonts.googleapis.com/css?family=Roboto:100,100i,300,300i,400,400i,500,500i,700,700i,900,9
00i" rel="stylesheet">
<!-- //web-fonts -->
</head>
<body>
<!-- banner -->
<div class="agileits-banner">
<div class="bnr-agileinfo">
<!-- navigation -->
<?php include_once('includes/header.php');?>
<!-- //navigation -->
<!-- banner-text -->
<div class="banner-text agileinfo">
54
 </div>
</div>
</div>
<!-- footer -->
<?php include_once('includes/footer.php');?>
<!-- js -->
<script src="js/jquery-2.2.3.min.js"></script>
<script src="js/SmoothScroll.min.js"></script>
<script src="js/jarallax.js"></script>
<script type="text/javascript">
/* init Jarallax */
$('.jarallax').jarallax({
speed: 0.5,
imgWidth: 1366,
imgHeight: 768
})
</script>
<!-- //js -->
<script src="js/bootstrap.js"></script>
</body>
</html>
VIEW PASS DETAIL:
<?php
include('includes/dbconnection.php');
session_start();
error_reporting(0);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Bus Pass Management System || View Pass Page</title>
<script type="application/x-javascript"> addEventListener("load", function() {
setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
55
<!-- Custom Theme files -->
<link href="css/bootstrap.css" type="text/css" rel="stylesheet" media="all">
<link href="css/style.css" type="text/css" rel="stylesheet" media="all">
<link href="css/font-awesome.css" rel="stylesheet"> <!-- font-awesome icons -->
<!-- //Custom Theme files -->
<!-- web-fonts -->
<link href="//fonts.googleapis.com/css?family=Oswald:200,300,400,500,600,700" rel="stylesheet">
<link
href="//fonts.googleapis.com/css?family=Roboto:100,100i,300,300i,400,400i,500,500i,700,700i,900,9
00i" rel="stylesheet">
<!-- //web-fonts -->
<script type="text/javascript">
function PrintDiv() {
var divToPrint = document.getElementById('divToPrint');
var popupWin = window.open('', '_blank', 'width=1000,height=1000');
popupWin.document.open();
popupWin.document.write('<html><body onload="window.print()">' + divToPrint.innerHTML +
'</html>');
popupWin.document.close();
}
</script>
</head>
<body>
<!-- banner -->
<div class="agileits-banner">
<div class="bnr-agileinfo">
<!-- navigation -->
<?php include_once('includes/header.php');?>
<!-- //navigation -->
<!-- banner-text -->
<div class="banner-text agileinfo about-bnrtext">
<div class="container">
<h2><a href="index.php">Home</a> / View Pass</h2>
56
 </div>
</div>
<!-- //banner-text -->
</div>
</div>
<!-- //banner -->
<!-- contact -->
<div class="contact agileits">
<div class="container">
<div class="agileits-title">
<h3>View Pass</h3>
</div>
<div class="contact-agileinfo">
<div class="clearfix"> </div>
<div class="table-responsive" id="divToPrint">
<?php
$vid=$_GET['viewid'];
$sql="SELECT * from tblpass where ID=$vid";
$query = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $row)
{ ?>
<table border="2" class="table table-bordered" style="font-size: 18px;" >
<tr align="center">
<td colspan="6" style="font-size:20px;color:blue">
Pass ID: <?php echo ($row->PassNumber);?></td></tr>
<tr>
<th scope>Category</th>
<td colspan="3"><?php echo ($row->Category);?></td>
57
 </tr>
<tr>
<th scope>Full Name</th>
<td colspan="3"><?php echo ($row->FullName);?></td>
</tr>
<tr>
<th scope>Photo</th>
<td colspan="3"><img src="admin/images/<?php echo ($row->ProfileImage);?>" width="50"
height="50"></td>
</tr>
<tr>
<th scope>Mobile Number</th>
<td><?php echo ($row->ContactNumber);?></td>
<th scope>Email</th>
<td><?php echo ($row->Email);?></td>
</tr>
<tr>
<th scope>Identity Type</th>
<td><?php echo ($row->IdentityType);?></td>
<th scope>Identity Card Number</th>
<td><?php echo ($row->IdentityCardno);?></td>
</tr>
<tr>
<th scope>Source</th>
<td><?php echo ($row->Source);?></td>
<th scope>Destination</th>
<td><?php echo ($row->Destination);?></td>
</tr>
<tr>
<th scope>From Date</th>
<td><?php echo ($row->FromDate);?></td>
<th scope>To Date</th>
<td><?php echo ($row->ToDate);?></td>
58
 </tr>
<tr>
<th scope>Cost</th>
<td><?php echo ($row->Cost);?></td>
<th scope>Pass Creation Date</th>
<td><?php echo ($row->PasscreationDate);?></td>
</tr>
<?php $cnt=$cnt+1;}} ?>
</table>
<input type="button" style="padding-right: 20px" class="btn btn-primary" value="print"
onclick="PrintDiv();" /></p>
</div>
</div>
</div>
</div>
<!-- //contact -->
<?php include_once('includes/footer.php');?>
<!-- js -->
<script src="js/jquery-2.2.3.min.js"></script>
<script src="js/SmoothScroll.min.js"></script>
<script src="js/jarallax.js"></script>
<script type="text/javascript">
/* init Jarallax */
$('.jarallax').jarallax({
speed: 0.5,
imgWidth: 1366,
imgHeight: 768
})
</script>
<!-- //js -->
<!-- start-smooth-scrolling -->
<script type="text/javascript" src="js/move-top.js"></script>
<script type="text/javascript" src="js/easing.js"></script>
59
 <script type="text/javascript">
jQuery(document).ready(function($) {
$(".scroll").click(function(event){
event.preventDefault();

$('html,body').animate({scrollTop:$(this.hash).offset().top},1000);
});
});
</script>
<!-- //end-smooth-scrolling -->
<!-- smooth-scrolling-of-move-up -->
sa

60
 Chapter04
PERFORMANCE ANALYSIS

SYSTEMTESTING

SOFTWARETESTINGTECHNIQUES:
Because it is the ultimate check ofthe specification, design, and code,software
testing is an important aspect of software quality assurance..

OBJECTIVES FORTESTING:
Checking out is the process of devising a strategy for identifying flaws. A
fantastic test case is one that is capable of detecting undetectable errors.
A successful examination is one that demonstrates a mistake that has not yet been
detected.
The a for mentioned objectives indicate a significant shift in the viewing
environment.
The examination will not reveal any flaws, rather, it will reveal that software
programme errors exist.
There are three different sorts of testing methods.
1. Unit-Test

2. Integration-Test

3. Performance-Test
UnitbasedTesting:
A small bit of software programme layout module testing
focusingonverificationactivities.Thefocusoftheunitcheckis always on the white field.
Prevalence testing is used as part of unit testing to test module interfaces, location
information systems, border situation testing, and the employment of all neutral
techniques and error detection strategies.
IntegrationbasedTesting:

Integration based testing is a scientific approach of building a

devicestructureandevaluatingitforintegrationproblemsatthe same time. The scope of
61
the test specifies which areas of operation, general performance, and internal design
will be examined.Techniques like the floor test and the floor inspection are used.
PerformanceTesting:

To verify whether machine features are being carried out in a timely manner,
Bothreadandupdateoperations musthavetheirtime aggregated.
OUTPUTSCREENOFPROJECT

HomePage

62
About Us Page

63
ContactUsPage

64
View Pass

ViewDetailofPass

65
PanelonAdmin’sSidePageforLogin

IfPasswordis forgotten

66
Dash-Board

67
ProfileforAdmin

Incaseif Passwordneedstobechanged

68
InorderfortheCategory tobeadded

ForManaging Category

69
Categoryifneedstobe updated

ToAddaPass

70
ManagingthePass

UpdatingPass

71
UpdatingImage

72
DetailsofPass

About Us

73
ContactUs

74
ViewEnquiry

ViewDetailofEnquiry

75
SearchPass

BetweenDatesReportofPass

76
ViewDetailofBetweenDatesReportsofPass

CHAT ENGINE

User provides a user name and the ticket no. that they wish to change,subsequently they enter
into the respective room. They can chat in realtime with other users in the room as well as
provide their Locationinformation.Otherusers intheroomare notifiedwhenanew userjoinsor if
someone leaves.

77
78
79
 Chapter05
Conclusions

The 'Bus Pass management system' is a strong tool that is far

morethana"basic"diagrammingtool.Its MDA (versiondriven architecture) guide is far
more geared toward people who use UML in-depth and with a few code generation
goals than it is fortrulydrawingdiagramstodocumentrequirements.However, utilising
'Bus skip control device' as a diagramming tool works well, because the utility is
developed in Delphian druns quicker than Java-based utilities, it is particularly useful
on Windows. Moderninternationalis a computerised world where tasks must be
accomplished quickly, demanding the utilisation of premier
assetsandgoldstandardways. Asaresult ofthis unpreventable condition, digitalization
of each one of the quarter within the most crucial sectors is needed for the race which
have to be held. The simplicity, accuracy, and user-friendly interface of our project
are onlya few ofits distinguishing features. Our bundle includes all ofthe features and
capabilities ofthe VisualStudio programme. The thesis has beenadvanced to manage
the entire administrativeCurfewPassoperation.Thesoftwareprogramme generates and
replicates entire human labour and paper work performed by the executive in an
extremely highly electronic environment. The result of which is, boththe consumer
and the administrativeteamisrelaxed.ThecustomergetsHejustenters in his order and is
only a click away. We'd want to offer our deepest gratitude and appreciation to
everyone who assisted us in successfully creating,formatting,andexecutingthisproject.

80
 References:-

[1]. Baid.A, Rae.I, Li.J, Doan.A, and

Naughton.J,(2010)“TowardScalableKeyword Search over Relational
Data,” Proc. VLDB Endowment, vol. 3, no. 1, pp. 140-149.

[2].Bhalotia.G,Hulgeri.A,Nakhe.C,Chakrabarti.S, and Sudarshan.S,(2002)

“Keyword Searching and Browsing in Databases Using BANKS,” Proc. 18th
Int‟l Conf. Data Eng. (ICDE ‟02), pp.
431-440.

[3]. Coffman.J and Weaver.A.C,(2010)“A Framework for Evaluating

Database Keyword Search Strategies,” Proc. 19th ACM Int‟l
Conf.InformationandKnowledge Management (CIKM ‟10), pp. 729- 738.

[4].Chen.Y,Wang.W,Liu.Z,andLin.X,(2009) “Keyword Search on Structuredand

Semi-
StructuredData,”Proc.ACM SIGMODInt‟l Conf.
ManagementofData(SIGMOD‟09),pp.1005-1010.

81
[5].Chaudhuri.SandDas.G,(2009)“KeywordQueryingand Ranking in

Databases,”Proc.VLDBEndowment,vol.2,pp.1658-1659.

[6].Ding.B,Yu.J.X,Wang.S,Qin.L,Zhang.X,and Lin.X,(2007)“FindingTop-
kMin-CostConnected Trees in Databases,” Proc. 23rd Int‟l Conf. Data Eng.
(ICDE ‟07), pp. 836-845.

[7].He.H,Wang.H,Yang.J,andYu.P.S,(2007)
“BLINKS: Ranked Keyword Searches on Graphs,” Proc. ACM
SIGMOD Int‟l Conf. ManagementofData(SIGMOD‟07),pp.305- 316.

[8]. Hristidis.V and Papakonstantinou.Y,(2002) “DISCOVER: Keyword Search

in Relational Databases,”Proc.28thInt‟lConf.VeryLargeData Base (VLDB‟02),
pp. 670-681.

[9].Li.G,Ooi.B.C,Feng.J,Wang.J,andZhou.L,(2008) “EASE: An
Effective3in-1KeywordSearchMethodforUnstructured,

82
Semi-StructuredandStructuredData,”Proc.ACM SIGMOD Int‟l Conf.
Management of Data
(SIGMOD‟08),pp.903-914.

[10].Li.G,Feng.J,Zhou.X,and
Wang.J,(2011)“Providing Built-in Keyword Search
CapabilitiesinRDBMS,”TheVLDBJ.,vol.20,pp.1- 19

83
 Appendices:-

A. BOOKS
[1] C.Easttom,LearnJavascript.Plano,TX:
Wordware Publishing, 2001.
[2] “GettingStarted,”inHavingSuccesswithNSF, Hoboken,
NJ, USA: John Wiley & Sons, Inc., 2012, pp. 1–16.
[3] T.A.Powell,Ajax:Thecompletereference.New York, NY:
Osborne/McGraw-Hill, 2008.
[4] D.Crockford,JavaScript:TheGoodParts.
Sebastopol, CA: O’Reilly Media, 2008.
[5] D. N. Roberts, A smarter way to learn
JavaScript:Thenewapproachthatuses technology to cut. Createspace,
2015.
[6] D.Flanagan,JavaScript-TheDefinitiveGuide.
Sebastopol, CA: O’Reilly Media, 2020.
[7] P.LearningandC.&.H.A.Javascript,CSS& HTML5: A
Step-by-Step Guide to Creating Dynamic Websites. .
[8] B. McLaughlin, PHP & MySQL: The Missing
Manual,2nded.Sebastopol,CA:O’ReillyMedia, 2012.
[9] R.Nixon,LearningPHP,MySQL&JavaScript 4e: With
jQuery, CSS & HTML5. Sebastopol,

84
CA:O’ReillyMedia,2014.

B. WEBSITES
[1] “PHP tutorial,” W3schools.com. [Online].
Available:https://www.w3schools.com/php/.
[2] “PHP Tutorial,” Tutorialspoint.com. [Online].
Available: https://www.tutorialspoint.com/php/index.htm.
[3] “LearnPHP-freeinteractivePHPtutorial,” Learn-
php.org. [Online]. Available: https://www.learn-php.org/.
[4] “LearnPHP-BestPHPTutorials,”Hackr.io. [Online].
Available: https://hackr.io/tutorials/learn-php.
[5] “Learn HTML,” Codecademy. [Online]. Available:
https://www.codecademy.com/learn/learn-html.
[6] “HTML for beginners the easy way: Start
learningHTML&CSStoday,”Html.com. [Online]. Available:
https://html.com/.
[7] “LearnCSS,”web.dev.[Online].Available:
https://web.dev/learn/css/.
[8] “LearnCSSwithonlinecourses,classes,& lessons,”
edX. [Online]. Available: https://www.edx.org/learn/css.
[9] “XAMPPtutorial:HowtouseXAMPPtorun

85
yourownwebserver,”UdemyBlog,18-Sep-2013. [Online]. Available:
https://blog.udemy.com/xampp-tutorial/.
[10] C.Easttom,LearnJavascript.Plano,TX:
Wordware Publishing, 2001.
[11] “The modern JavaScript tutorial,”
Javascript.info.[Online].Available: https://javascript.info/.
[12] “LearnJavaScript-freeinteractiveJavaScript tutorial,”
Learn-js.org. [Online]. Available: https://www.learn-js.org/.
[13] “AJAXintroduction,”W3schools.com.[Online].
Available: https://www.w3schools.com/xml/ajax_intro.asp.

C. ARTICLES
[1] J.P.Anto,“PHP-AdvancedTutorial,”SSRN Electron.
J., 2011.
[2] S. B. Uzayr, “Useful JavaScript libraries and tools,” in
Getting the Most out of Node.js Frameworks,BocaRaton:CRCPress,2022,pp.
133–162.
[3] C. Thompto, “Building a more sustainable and
accessibleinternet:Lightweightwebdesignwith HTML and CSS,” 2022.
[4] A.ThakurandK.Dhiman,“ChatRoomUsing HTML,
PHP, CSS, JS, AJAX,” arXiv [cs.SE],

86
2021.
[5] R. Huddleston, “Layout,” in Introduction to
HTMLandCSS,Berkeley,CA:Apress,2019.
[6] W. Cui, L. Huang, L. Liang, and J. Li, “The
researchofPHPdevelopmentframeworkbased
onMVCpattern,”in2009FourthInternational Conference on Computer Sciences
and Convergence Information Technology, 2009.
[7] B.Gamrat,“PHPandpreprocessedWebpages,” Dr.Dobb’S
Journal, vol. 31, no. 1, pp. 46–48,
2006.

[8] C.Hofmeister,R.L.Nord,andD.Soni,Applied Software

Architecture,. Addison Wesley, 2000.
[9] S. Wei, “Approach to Web application program based on
MVC and J2EE,” Hebei Journal of
IndustrialScience&Technology,vol.22,no.4,pp. 189–191, 2005.
[10] H. Hayder, J. P. Maia, and L. Gheorge, “Smarty
PHPTemplateProgrammingAndApplications,” Packt Publishing, pp. 23–33,
2006.
[11] Y. Liu, “JSOptimizer: An extensible framework for JavaScript
program optimization,” in 2019 IEEE/ACM 41st
InternationalConferenceonSoftwareEngineering:Companion

Proceedings(ICSE-Companion),2019.

87