C.S.

I COLLEGE OF COMMERCE
DHARWAD

DEPARTMENT OF B.C.A (BACHELOR OF

COMPUTER APPLICATIONS)
2019-2020

PROJECT REPORT ON
“ONLINEBOOK STORE”

UNDER THE GUIDANCE OF

Mr. Asif Koujaganur

SUBMITTED BY

ASHICA SHILABHADRA PRIYANKA G

Reg NO:17U10106 Reg No:17U10132
BCA 6th SEM BCA 6th SEM
C.S.I.,K.N.D.,B.M.H.E.S.C’S
CSI COLLEGE OF COMMERECE, DHARWAD

DEPARTMENT OF B.C.A(BACHELOR OF
COMPUTER APPLICATIONS)
2019-2020

CERTIFICATE

This is to certify that Miss. Ashica ShilabhadraAnd Miss. Priyanka

Gajipurhas Satisfactorily completed the project work entitle “ONLINE BOOK
STORE ” for the partial fulfillment of degree in Bachelor ofComputer
Applications of Karnatak University, Dharwad for the year 2018-2019.

Project associates: Project guide

ASHICA SHILABHADRA Mr. Asif Koujaganur
PRIYANKA G

Examiners Co-ordinator
1………………..
2………………..
 ACKNOWLEDGEMENT

We would like express our special gratitude to our principal Dr.Kamala

Dhawale ,C.S.I College of Commerce, Dharwad , for her support and co-
operation to take up this project.

Furthermore, we would also like to acknowledge with

much appreciation the crucial role of the staff who is also the head of the
project Mr. Asif Koujaganur, whose contribution in stimulating
suggestions and encouragement, helped us to coordinate and guiding us
throughout the project which is on “Smart Health” and especially in this
report.

We have to appreciate the guidance given by other supervisor as well as the

panels especially in our project presentation that has improved our
presentation skills thanks to their comment and advices.

We would like to express our deepest appreciation to all

the staff of BCA department who provided us the possibility to complete
this report.

Date: Signature
Place: ASHICA SHILABHADRA
PRIYANKA GAJIPUR
CONTENTS
1. INTRODUCTION……………………………………………………….1-3
1.1 Problem Definition
1.2 Project Overview
1.3 Hardware Specification
1.4 Software Specification

2. LITERATURE SURVEY……………………………………...……….4-5
2.1 Existing System
2.2 Proposed system
2.3 Feasibility Study

3. SYSTEM ANALYSIS & DESIGN……………………………........6-21

3.1 Requirement Specification
3.2 Flowcharts/DFDs and ERDs
4. Implimentation…………………………………………......................................22s-48
4.1 Languages Used
4.1.1 PHP – DETAILS
4.1.2 Usage
4.1.3 Speed optimization
4.2 Software Used (server , database Etc)
4.3 Code

5. Testing…………………………………………….…………………………49-54
5.1 Details of testing methodologies.
5.2 Sample Testing Used

6. Result / Screenshonts……………………………….………………………..…55-58
6.1 Online book store Login Form
6.2 Online book store admin Home Page
6.3Online book store admin insert page
6.4 Online book store admin view page
6.5 Online book store admin edit page
6.6 Online book store admin update page

7. Conclusion…………………………………………………………………………………59

8. References ………………………
 INTRODUCTION

An online book store is a virtual store on the Internet where customers can browse the catalog
and select books of interest. The selected books may be collected in a shopping cart. At
checkout time, the items in the shopping cart will be presented as an order. At that time, more
information will be needed to complete the transaction. Usually, the customer will be asked
to fill or select a billing address, a shipping address, a shipping option, and payment
information such as credit card number. An e- mail notification is sent to the customer as
soon as the order is placed.
. The reason why we selected online Bookstore web service is everybody walking down the
street has some idea about bookstores. The objective of this project is to develop an e- book
store where books can be bought from the comfort of home through the Internet.
Shopping for books online helps you find the best possible price for just about any book you
want. If customers in the market are for rare, collectible or autographed books, its much
cheaper and faster to search online then would be
to call up local used and independent book stores that carry these types of items.
Moreover, this system is designed for the particular need of the company to carry out
operations in a smooth and effective manner.

1.1 PROBLEM DEFINATION

Designing a web application on Online Book store using PHP for multiple users. Online
book store allows the users to register themselves and can order the books while sitting at any
part of the world.
The admin of the system is allowed to login and make changes and view the profiles of
customers and as well as manage the books also.

1.2PROJECT OVERVIEW
The project overview automates the details of the various books and as well as their authors.
The project also automates theregistered usersand even provides offers for the users.
The project is developed to help the customers to order the book online rather than going to
merchants and buy the books and it also helps to provide the home delivery services for the
customers and also provides payment system in safe and secure manner and it also provides
different offers to the customers

1.3 HARDWARE SPECIFICATIONS

Minimum Hardware Requirements on client side:

Processor :Pentium4 machine And above

RAM 128MB or More

Hard Disk 2GB or More

Monitor VGA Color

Cache Memory 256KB

Network Card TCP/IP

Minimum Requirements on server side :

.

Processor :Pentium4 machine And above

RAM 128MB or More

Hard Disk 2GB or More

Monitor VGA Color

Cache Memory 256KB

Network Card TCP/IP

2.LITERATURE SURVEY
2.1 Existing System:
In the present system the users have to visit the book stores, libraries and merchantsto buy
the books and the merchants have to do a lot of paper works to keep record of the books and
authors and also the bills.
 Lack of security of data.
 More man power.
 Needs manual calculations.

2.2 Proposed System:

The aim of proposed system is to develop a system of improved facilities. The proposed
system can overcome all the limitations of the existing system. The system provides proper
security and reduces the manual work.
 Security of data.
 Ensure data accuracies.
 Minimize manual data.

2.3 FEASIBILITY STUDY

Preliminary investigations examine project feasibility; the likelihood of how the system is
will be useful to the organization. Three tests of feasibility-all equally important are studied .
In feasibility study phase we had undergone through various steps which are describe as
under:
1. Identify the origin of the information at different level.
2. Identify the expectation of user from computerized system.
3. Analyze the drawback of existing system (manual) system.
 Technical feasibility
 Economical feasibility
 Behavior feasibility

2.4.1 TECHNICAL FEASIBILITY

It is based on technical concept such as does the proposed system have the technical capacity
to hold the data required to use the system.

 Does the necessary technology exist to do what is suggested?

 Do the proposed equipments have the technical capacity to hold the data required to

use the new system?

  Will the proposed system provide adequate response to inquiries, regardless of the

number or location of users?

 Can the system be upgraded if developed?

Are there technical guarantees of accuracy, reliability, ease of access and data

security

2.4.2 ECONOMIC FEASIBILITY

It is based on the financial concept such as is the online book project has
sufficient budget to develop the proposed system or is it cost effective. The proposed system
will save lots of paper work and Facilitate magnetic record keeping thereby reducing the
costs incurred on above heads.

2.4.3 BEHAVIOUR FEASIBILITY

This test of feasibility asks if the system will work when it is developed and is
the current functional methods acceptable to the user. Since the inception of Internet, it is
continuously growing in leaps and bounds, as more people are arriving at the conclusion that
they cannot escape from it and in order to keep up, they have to participate in that.
 3. SYSTEM ANALYSIS AND DESIGN
3.1 REQUIREMENT SPECIFICATION
3.1.1 Introduction:

This specification is used to specify the requirements for the initial implementation of the
system and update the system in future. The software requirement bridges the gap between
client or the user and the system developer. This document describes the user need
accurately.

Purpose:

This Software Requirement Specification (SRS) specifies the requirements of CRM

(Customer Relationship Management) for ‘Online book store ’. This CRM is designed to
allow new online portal quick and easy to setup and perform orders acceptance and orders
payments and offers provided over the internet.

This document will outline all of the functions, capabilities and requirements for
developing an application for managing accurate billing statements to customers, managing
the orders of books and handling the customer packages and payments.

Scope:

Thissystemspecifiesthe requirementdetails likeinformation about the different books and its

authors . It helps the people to get books easily . As the customers need to approach the book
stores manually look for the payments and packages it was a very time consuming
task.Toovercome thisdrawbackthisapplicationisbuiltin away thatthebooks kscan be
placed online directlyfrom this Application to customers giving them various packages.

Definitions, Acronyms and Abbreviations:

GUI: Graphical UserInterface.

HTML: Hypertext Markup language is thepredominant markuplanguagefor web pages.

HTTP: Hyper Text Transfer Protocol.

PHP:PreHypertextProcessor/Personal Home Page

PHP Triad: PHP Triad installs a complete workingPHP/MySql server environment on
Windows /LinuxplatformsInstalls PHP, MySql, Apache.

PHPMyAdmin DHTML:DynamicHypertext Markup languageis the predominant

markuplanguage forweb pages.

SRS: SoftwareRequirement Specification.

WAMP: Windows ApacheMySQLPHP.

3.1.2Overall Description:
This section will give an overview of the whole system. The system will be explained in the
context to show how the system interacts with others and introduce the basic functionality of
it. At last, the constraints and assumptions for the system will be presented.

Product Perspective:

The application should provide quick access to the records maintained and must reveal the
important reviews about the advertisements and orders of magazines so that the growth can
be easily compared and should provide with the various reports showing the related details so
that the important decisions could be taken easily.

The transactions related to advertisement and orders are maintained manually at present along
with maintaining the accounts of the customers and distributor management. The billing
system of the advertisement and orders are maintained manually. All these are to be
automated and an application is required to relate all of them relatively and logically so that
the current system can be replaced and accepted without major changes and problems.
3.1.3 User interface:
Theuserinterfaceallowstheuserstoremotely accessthesystemviaseveral applications.
Userswillbeabletousetheservicethroughapplicationssuchas MozillaFirefox, Microsoft Internet
Explorer,etc. Allow theusertoaccessthe information fast and easilyfrom remotelocations.

 .Compatibility:

ThesoftwareiscompatiblewithWindowsXP. ItalsoworkswellwithWindows 2000orhigher.

ItrequiresMicrosoftInternetExplorer5.0(orany latestweb browser)or abovewith Wamp Server.

 Portability:
Thesoftwareisextremelyportableinthesensethatitcanberunonany machine with a web-browser.

 Acceptance criteria:

The systemmustworkwellandcompilewithallthe requirementsandconstraints

statedabove.Allconditionsdefinedby theneeduserby theenduseraretobe
satisfied.Thesystemshouldsatisfy alltherequirementandconstraintsofthe Ad-well mediaand
must work well accordingto necessity.

3.1.4 User characteristics:

Incommon the USERshouldbe familiar and musthave the knowledge ofwindows operating
system.Basic computer knowledge of using keyboard, mouse andcommonwindows
environment is required.

Theprimary useroftheapplicationistheadminwhomaintainsthesoftwareorproducthe
shouldknowaboutthedatapresentandthedatahewanttoview,sothathecanefficiently
usethefunctionoftheproposedsystem.ThesoftwareisGUI basedtoreducetheusernon-
friendliness towards thesoftware.

Therearevariouskindsofusersfortheproduct.Usuallywebproductsarevisitedby various users

fordifferent reasons.

MODULES:
Administrator:
The administrator can add the details of customers and the advertisements the customer wants
to post, different types of advertisements like the categories of the advertisements, different
type of packages, payments and also maintained the order of the magazines by the distributor.
And he is the fully authenticated person for the entire system.

Doctor:
This module is used gives detailed description about doctors and access information about
patients details and their reports.

Patient:
 This module provide details about patients and their reports accessed by the doctors
and get appointments.

SpecificRequirements
ExternalInterfaceRequirements:
UserInterface: Accomplishes via mouse and keyboard input to the GUIbased forms.

Software Interface: Theproduct requires to runtime Php environment in server machine.

3.1.5 Functional Requirements:

Functional requirementsarestatementsofthe servicesthatthesystemmustprovide orare
descriptions ofhowsomecomputations mustbecarriedout. The plan forimplementing
functionalrequirements is detailed in thesystem design.

 Admin is provided with Usernameand Passwordto avoid unauthorized access.

Basicand advanceadmin facilities like add/update/delete Milk Dairydetails areprovided.

 Manages details about thecattle’s, milk, customers and suppliers.

 Manages bills, payments and expenses details.

Non-Functional Requirements:
Anon-functionalrequirementisa requirementthatspecifiescriteriathatcanbe used to judge the
operationof asystem,rather than specific behaviours.Thisshouldbe contrasted
withfunctionalrequirementsthatdefine specificbehaviourorfunctions. Theplanfor
implementingnon-functionalrequirements is detailed in thesystemarchitecture.

 Theapplicationisavailablefromseverallocationsanditisaccessible24*7withthehelp
ofinternet.
 Thecodeiseasilyunderstoodandreadbecauseofthestructureandcodingstyleofthe
application.
 Various components are provided in order to improvethe performance at peak time.

3.2 FLOWCHARTS/DFDs and ERDs

3.2.1 data flow diagram
Data Flow Diagrams are a graphical tool used to describe and analyze the
movement of data through a system. DFD’s are used to capture the essential feature of
both existing real system and future physical implementation of the system.
The DFD is a graphical technique that depicts the information flow and the
transforms that are applies as data move from input to the output .The DFD is also
known as Bubble Chart or Data Flow Graphs or Context diagram.
The data flow diagram may be used to present a system or software at any level of
abstraction. A fundamental system model or a context model represents the entire
software elements as a single bubble with input and output data indicated by incoming
and outgoing arrows respectively.
Data flow diagrams are constructed from four basic building blocks.
 Processes
 Data flow
 Store
 Terminator

THE PROCESS:

Processes

 Also called bubble, function, and transformation.

 Shows part of the system that transforms inputs to outputs.
 Represented graphically as a circle.
 Named with single word, phrase, or sentence.

DATA FLOW:

Input flow : Output flowTwo data packers:

Represented graphically by an arrow into/out of a process.

  Describes movements of information in the system “data in motion”.
 A flow shows direction.
 Double-headed arrow stands for dialogue-convenient packaging of two data
packers.
 Data flows can diverge or converge in a DFD

3.2.1.1 Our Project DFD is classified into Three Levels as follows

 ZERO Level DFD.
 FIRST Level DFD
 SECOND Level DFD.

DATA FlOW DIAGRAM FOR PROJECT MODULE

  3.2.1.2 Zero Level DFD

Admin

Online book store

logins user

3.2.1.4 Second Level DFD

Admin:

ADD
login Online book
ADMIN store BOOKS
VIEW

ADD

CATEGORY
VIEW

ADD
CUSTOMER
VIEW

PURCHASE ADD

VIEW
user:

MEDIKART
USER SYSTEM

ADD

PRODUCT

BUY

ADD

PURCHASE

UPDATE

CATEGORIES VIEW
3.2.2 ER DIAGRAM
An entity-relationship diagram is a data modeling technique that creates a graphical
representation of the entities, and the relationships between entities, within an information
system. An entity-relationship model (ERM) is an abstract and conceptual representation
of data. Entity-relationship modeling is a database modeling method, used to produce a type
of conceptual schema or semantic data model of a system, often a relational database, and its
requirements in a top-down fashion. Diagrams created by this process are called entity-
relationship diagrams, ER diagrams, or ERDs.

The first stage of information system design uses these models during the requirements
analysis to describe information needs or the type of information that is to be stored in
a database. The data modeling technique can be used to describe any ontology (i.e. an
overview and classifications of used terms and their relationships) for a certain area of
interest.

In the case of the design of an information system that is based on a database, the conceptual
data model is, at a later stage (usually called logical design), mapped to a logical data model,
such as the relational model; this in turn is mapped to a physical model during physical
design. Sometimes, both of these phases are referred to as "physical design".

The three main components of an E-R Diagram are:

 The entity is a person, object, place or event for which data is collected. For example,
if you consider the information system for a business, entities would include not only
customers, but the customer’s address, and orders as well. The entity is represented by
a rectangle and labeled with a singular noun.
 The relationship is the interaction between the entities. In the example above, the
customer places an order, so the word “places” defines the relationship between that
instance of a customer and the order or orders that they place. A relationship may be
represented by a diamond shape, or more simply, by the line connecting the entities.
In either case, verbs are used to label the relationships.
 The cardinality defines the relationship between the entities in terms of numbers. An
entity may be optional: for example, a sales representative could have no customers or
 could have one or many customers; or mandatory: for example, there must be at least
one product listed in an order. There are several different types of
cardinality notations; The three main cardinal relationships are: one-to-one, expressed
as 1:1; one-to-many, expressed as 1: M; and many-to-many, expressed as M: N.

Entity Relationship Diagram Notations:

Peter Chen developed E-RDiagram’s in 1976. Since then Charles Bachman and James
Martin have added some sleigh refinements to the basic ERD principles.

Entity:
An entity is an object or concept about which you want to store information.An entity is a
real-world item or concept that exists on its own. The set of all possible values for an entity,
such as all possible customers, is the entity type. In an ER model, we diagram an entity type
as a rectangle containing the type name.

Weak Entity:
A weak entity is an entity that must defined by a foreign key relationship with another
entity as it cannot be uniquely identified by its own attributes alone.

Attribute:

Each entity has attributes, or particular properties that describe the entity. Most of the data in
a database consists of values of attributes. The set of all possible values of an attribute is
the attribute domain.In an ER model, an attribute name appears in an oval that has a line to
the corresponding entity box.

Key attributes:
A key attribute is the unique, distinguishing characteristic of the entity. An attribute or
set of attributes that uniquely identifies a particular entity is a key. A key attribute in an ER
Diagram is represented by an oval that has a line inside it and a line to the corresponding
entity box. For example, an employee's social security number might be the employee's key
attribute.

Multivalued attribute:
A multivalued attribute can have more than one value. We indicate this with a double
oval. For example, an employee entity can have multiple skill values.

Derived attribute:

A derived attribute is based on another attribute. It is denoted by a oval and dotted

line within it. For example, an employee's monthly salary is based on the employee's annual
salary.
Relationships:
Relationships illustrate how two entities share information in the database structure.An
association among entities is called a relationship. An attribute can also be a property of a
relationship set. The association among the entities is described as one-to-one, one-to-many,
many-to-many. A relationship is indicated by a rhombus.

Identifying relationship:
Identifying relationship is denoted by double rhombus.

Composite Attribute:
A composite attribute has multiple components and each component is atomic or
composite. We illustrate this composite nature in the ER model by branching off the
component attributes.
1

Total Participation:
Total participation is represented by a double line.

ER DIAGRAM:
 4.IMPLIMENTATION
4.1 LANGUAGES USED
4.1.1 PHP-Details

PHP(Personal Home Page)

PHP originally stood for “Personal Home Page” and was released as a free, open
source project. Over time, the language was reworked to meet the needs of its users. In 1997,
PHP was renamed to the current “PHP: Hypertext Preprocessor.”PHP is generally used as a
server-side scripting language; it is especially well-suited for creating dynamic web pages
and client-side GUI applications. . PHP generally runs on a web server, taking PHP code as
its input and creating web pages as output. The scripting language features integrated support
for interfacing with databases such as MySQL, which makes it a prime candidate for building
all manner of web applications, from simple personal web sites to complex enterprise-level
applications.

Unlike HTML, which is parsed by a browser when a page loads, PHP is preprocessed
by the machine that serves the document (this machine is referred to as a server). All PHP
code contained with the document is processed by the server before the document is sent to
the visitor’s browser.PHP is a scripted language, which is another great advantage for PHP
programmers. PHP can be deployed on most web servers, many operating systems and
platforms, and can be used with many relational database management systems. It is available
free of charge, and the PHP Group provides the complete source code for users to build,
customize and extend for their own use.Many programming languages require that you
compile files into machine code before they can be run, which is a time-consuming process.
Bypassing the need to compile means you’re able to edit and test code much more quickly
Because PHP is a server-side language, running PHP scripts on your local machine requires
installing a server on your local machine.
 PHP is free software released under the PHP License; however it is incompatible with
the GNU General Public License (GPL), due to restrictions on the usage of the term PHP. It
is a widely-used general-purpose scripting language that is especially suited for web
development and can be embedded into HTML. It generally runs on a web server, taking
PHP code as its input and creating web pages as output. It can be deployed on most web
servers and on almost every operating system and platform free of charge. PHP is installed on
more than 20 million websites and 1 million web servers.

Example

<?php
Echo “Hello Welcome to JSS”
?>
4.1.2 Usage

PHP is a general-purpose scripting language that is especially suited forweb

development. PHP generally runs on a web server, taking PHP code as its input and creating
web pages as output. It can also be used for command-line scripting and client-side GUI
applications. PHP can be deployed on most web servers, many operating systems and
platforms, and can be used with many relational database management systems. It is available
free of charge, and the PHP Group provides the complete source code for users to build,
customize and extend for their own use.

PHP primarily acts as a filter, taking input from a file or stream containing text
and/or PHP instructions and outputs another stream of data; most commonly the output will
be HTML. It can automatically detect the language of the user. From PHP 4, the PHP parser
compiles input to produce byte code for processing by the Zend Engine, giving improved
performance over its interpreter predecessor. Originally designed to create dynamic web
pages, PHP’s principal focus is server side scripting, and it is similar to other server-side
scripting languages that provide dynamic content from a web server to a client, such as
Microsoft’s Active Server Pages, Sun Microsystems’ Java Server Pages, and mod_perl. PHP
has also attracted the development of many frameworks that provide building blocks and a
design structure to promote rapid application development (RAD). Some of these include
CakePHP, Symfony, CodeIgniter, and Zend Framework, offering features similar to other
web application frameworks.

The LAMP architecture has become popular in the web industry as a way of
deploying web applications. PHP is commonly used as the P in this bundle alongside Linux,
Apache and MySQL, although they may also refer to Python or Perl. As of April 2007, over
20 million Internet domains were hosted on servers with PHP installed, and PHP was
recorded as the most popular Apache module. Significant websites are written in PHP
including the user-facing portion of Face book, Wikipedia (Media Wiki), Yahoo!, My
Yearbook, Digg, Word press and Tagged. In addition to server-side scripting, PHP can be
used to create stand-alone, compiled applications and libraries, it can be used for shell
scripting, and the PHP binaries can be called from the command line.

4.1.3 Speed Optimization

As with many scripting languages, PHP scripts are normally kept ashuman-readable
source code, even on production web servers. In this case, PHP scripts will be compiled at
runtime by the PHP engine, which increases their execution time. PHP scripts are able to be
compiled before runtime using PHP compilers as with other programming languages such as
C (the language PHP and its extensions are written in).

Code optimizers aim to reduce the computational complexity of the compiled code by
reducing its size and making other changes that can reduce the execution time with the
overall goal of improving performance. The nature of the PHP compiler is such that there are
often opportunities for code optimization, and an example of a code optimizer is the Zend
Optimizer PHP extension. Another approach for reducing overhead for high load PHP servers
is using PHP accelerators. These can offer significant performance gains by caching the
compiled form of a PHP script in shared memory to avoid the overhead of parsing and
compiling the code every time the script runs.

4.2 SOFTWARE USED(server , database etc)

WEB PROGRAMMING MODEL

The idea of using the Web as an application environment developed over time, with
each stage of technology serving as a springboard for new ideas. The first operational model
had the Web server simply serving up documents on request. In this environment, the content
doesn’t change unless a human author supplies a new version of a document.

After HTTP protocol, the Web server came with a new specification called as
Common Gateway Interface (CGI). A CGI program is invoked by the Web server in response
to certain types of request. The program reads this and performs the application task and then
generates the HTTP response, and it is sent back to the requesting Web browser.
 A significant improvement came with JSP and its APIs. These related technologies
bring the all power of Java to the web server, with database connectivity, network access, and
multi-threaded operations and notably a different process model.

HTML

HTML means Hypertext Markup Language. HTML is a method of describing the

format of documents which allows them to be viewed on computer screens. HTML
documents are displayed by web browsers, programs which can navigate across networks and
display a wide variety of types of information. HTML pages can be developed to be simple
text or to be complex multimedia extravaganzas containing sound, moving images, virtual
reality, and Java applets.

The global publishing format of the Internet is HTML. It allows authors to use not
only text but also format that text with headings, lists, and tables, and to include still images,
video, and sound within text. Readers can access pages of information from anywhere in the
world at the click of a mouse-button. Information can be downloaded to the reader’s own PC
or workstation. HTML pages can also be used for entering data and as the front-end for
commercial transactions.

FEATURES OF HTML:

 It is not a programming language.

 It is not a data description language.

 It is simple to understand and implement.

 HTML constructs are very easy to comprehend, and can be used effectively by
anybody.

 The methodology used by HTML to mark up information is independent of its

representation on a particular hardware or software architecture.

 HTML syntax is a worldwide standard.

Example to display message using HTML tags

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<h1>Welcome To JSS college</h1>
</body>
</html>
OUTPUT
MySql
INTRODUCTION TO SQL SERVER

SQL Server is a Relational Database Management System (RDBMS) that runs exclusively
under the Windows operating system. One benefit of using Windows exclusively is that you
can send and receive E-mail messages based on SQL Server "events" and you can also let the
operating system handle login security. The data base is an organized collection of data. A
database management system (DBMS) such as Access, FileMaker Pro, Oracle or SQL Server
provides you with the software tools you need to organize that data in a flexible manner. It
includes facilities to add, modify or delete data from the database, ask questions (or queries)
about the data stored in the database and produce reports summarizing selected contents.

MySql is a multithreaded, multi-user SQL database management system (DBMS). The basic
program runs as a server providing multi-user access to a number of databases. Originally
financed in a similar fashion to the JBoss model, MySql was owned and sponsored by a
single for-profit firm, the Swedish company MySQLAB now a subsidiary of Sun Micro
system , which holds the copyright to most of the codebase.

Database Evolution

SQL was invented back in the 1960's by E.F. Cod of IBM. in order to increase data integrity
and reduce repetitive data. RDBMS systems didn't appear until the late 70's when Sybase and
Oracle introduced systems. These systems existed on mainframes at the time.

ANSI-SQL came to be in the 1980's. This was important because it meant that disparate
systems could communicate through an agreed set of standards. There are different levels of
ANSI-SQL compliance. Almost every major RDBMS today is entry level compliant,
including SQL Server 2000. Every RDBMS has its own flavour of SQL that complements
ANSI-SQL with proprietary elements. SQL Server's flavour of SQL is known as Transact
SQL (T-SQL).
 SQL Server was originally a Sybase product. Microsoft bought the product
outright from Sybase and by version 7.0, the version prior to 2000, all the code had been
rewritten by Microsoft's programming gurus.

FEATURES OF SQL
 It is simple English like language and uses simple commands such as SELECT,
CREATE, DROP etc.
 It is not having condition loops, variables and most of the commands are single line
commands.
 To implement application logics, SQL has got extension language popularly called
as PL/SQL (Procedural language of sql).
 One of the key features of sql server is the XML support. XML has
Grown to be standard technology for organizations that share data on the web.
 Now with sql server 2000 XML documents can be retrieved directly from the
database and it provides various ways to retrieve data in XML format.
 The entire SQL has been divided into 4 major categories.
1. Data Manipulation Language.
2. Data Definition Language.
3. Transaction Control language.
4. Data Control Language.

Security

View are basically used as a part of security, means in many organizations ,the end user will
never be given original tables & all data entry will be done with the help of views only. But
the data base administrator will be able to see everything because all the operations done by
the different users will come to the same table.

Queries
A query is a question or a request. With MySql, we can query a database for specific
information and have a record set returned.

Create a connection to a database

Before you can access data in a database, you must create a connection to the database. In
PHP, this is done with the mysql_connect() function.

Syntax: Mysql connect (server name, username, password);

Server name: Optional Specifies the Server to connect .Default values is localhost: 3306

Example

In the following example we store the connection in a variable ($con) for

later use in the script. The “die” part will be executed if the connection fails:

Closing a Connection

The connection will be closed automatically when the script ends. To close
the connection before, use the mysql_close() function.
MySql Functions

What is a database? Quite simply, it’s an organized collection of data. A database

management system (DBMS) such as Access, FileMaker Pro, Oracle or SQL Server provides
you with the software tools you need to organize that data in a flexible manner. It includes
facilities to add, modify or delete data from the database, ask questions (or queries) about the
data stored in the database and produce reports summarizing selected contents.

MySql is a multithreaded,multi-user SQL database management system (DBMS). The

basic program runs as a server providing multi-user access to a number of databases.
Originally financed in a similar fashion to the JBoss model, MySql was owned and sponsored
by a single for-profit firm, the Swedish company MySQLAB now a subsidiary of Sun Micro
system , which holds the copyright to most of the codebase. The project’s source code is
available under terms of the GNU General Public License, as well as under a variety of
proprietary agreements. MySql is a database. The data in MySql is stored in database objects
called tables. A table is a collection of related data entries and it consists of columns and
rows. Databases are useful when storing information categorically.

Steps to create a database in PHPMyAdmin

1) The following figure shows your PHPMyAdmin interface, just enter your database name
and click the 'Create' button to create your database.

2) Now to create a new table enter your table name and the number of fields in the table, then
click the 'Go' Button.
3) The next step is to create the fields, just enter values for each field name, type, length of
the field, null option and mention whether it is a primary key or not. Then click the 'Save'
button to complete your table creation.

4) The following figure is displayed upon successful creation of your table.

Steps to Drop Table in PHPMyAdmin

Login to phpmyadmin.Click 'databases'
A list of your databases will appear. Click the one that is your WordPress database.

Note the size of the 'wp_bad_behaviour_log' table - this is one to be emptied in this example.

Now tick the box to the left of the table you wish to empty.
Note: your table may well have a different name, and unless you have been told otherwise, do
NOT empty a table that is used by the Word Press core.
From the drop-down menu, highlight and click the 'Empty' option.
You will now get a confirmation screen.
This is your last chance to check - there is no 'UNDO' function here !

Click 'Yes' and you will be returned to viewing all the tables in your install.

And your table has been cleared out.

If you needed to Drop a table, follow exactly the same, but select 'Drop' from the menu.

WAMP SERVER

WAMP Server

AMP is an acronym for Apache (an HTTP Server), MySQL (a relational database) and PHP
(a server-side programming platform). These are industrial-strength, open-source software
that collectively can be used to develop, deploy and run web applications. Depending on the
operating platform, we have:

 WAMP: Windows-Apache-MySQL-PHP
 LAMP: Linux-Apache-MySQL-PHP
 MAMP: Mac-Apache-MySQL-PHP

Setting Up WampServer
WampServer bundles Apache, MySQL and PHP for Winodws in a single package. It also
includes tools such as PhpMyAdmin (a MySQL database administration tool), SQL Buddy
(an alternative to PhpMyAdmin), XDebug (a PHP Debugging Tool), WebGrind (a PHP
Profiling Tool).

Installing WampServer

To install the WAMPServer, simply run the downloaded installation file. Choose your
installation directory. I shall assume that WampServer is installed in "d:\WampServer",
denoted as <WAMPSERVER_HOME>, in this article.

Starting WampServer

To start the WampServer, choose "start WampServer" from the "Start" menu; or run
"wampmanager.exe" from the WampServer installed directory. An icon will appear on the
icon tray. "Green" icon indicates that all the services have started. "Red" indicates that all the
services have stopped. You can put the server online (so that user can access the server over
the Internet) by selecting the option "Put Online". Alternatively, you could put the server
"Offline", such that it is accessible only within the localhost.

Verifying the Installation:

By default, a directory called "www" was created under the WampServer installed directory,
which serves as the root directory of the Apache Server. A welcome page called "index.php"
was also created in the "www" directory.

To verify the installation:

1. Start the WampServer. Wait for the icon to appear green (indicates that all services
have started). Otherwise, click the icon and select "Start All Services". For testing, put
the server "offline" to disable external access (i.e., it can be accessed only in
localhost).

2. Start a browser and issue URL http://localhost. This will in turn request for
"index.php". Observe the output and compare with "index.php" source.

How to run Php script in wamp server?

How to run Php script in wamp server. Php Stands for Hypertext Preprocessor. To run php
script we need server (tomcat) as php is server side programming language. This post will
demonstrate running php script on wamp server. So before getting started with it, we need to
install wamp server on your computer. Now let us make a very basic php script, to print
hello world. This script is as shown below. ‘Echo’ prints the statement.

How to run Php script in wamp server:

<html>
<head>
<title>PHP sript</title>
</head>
<body>
<?php echo 'Hello World'; ?>
</body>
</html>

save it as hello.php or with any name that you want to save it with.

Note: The directory you need to chose to save a php file in c:\\wamp\www\ or in the
directory where you have installed wamp server in root directory.

Now startwamp server, by running start wamp server application, and right click on the icon
present in the system tray, as shown below and click on start services.

How to run Php script in wamp server

Now click on Localhost, which will run a default browser, and if every thing goes correct, it
willopen the web page as shown below .

How to run Php script in wamp server

On the urltype :http://localhost/hello.php, and it will show up the output as :

FLASH
• Macromedia Flash is a multimedia graphics program especially for use on the Web.
• Flash enables you to create interactive "movies" on the Web.
• Flash uses vector graphics, which means that the graphics can be scaled to any size
without Losing clarity/quality.
• Flash does not require programming skills and is easy to learn

The advantages of Flash are

• Flash loads much faster than animated images.

• Flash allows interactivity, animated images do not.
• Flash does not require programming skills, java applets do.
4.3 CODE
SOURCE CODE
TO CREATE A TABLE BOOK:

<?php include('metatags.php'); ?>

<body class="hold-transition sidebar-mini layout-fixed">

<div class="wrapper">

<?php include('nav.php'); ?>

<!-- Main Sidebar Container -->

<?php include('sidebar.php'); ?>

<!-- Content Wrapper. Contains page content -->

<div class="content-wrapper">
<!-- Content Header (Page header) -->
<div class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="col-sm-6">
<h1 class="m-0 text-dark">Online Book Store</h1>
</div><!-- /.col -->
<div class="col-sm-6">
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item"><a href="bookinfo.php">Home</a></li>
<li class="breadcrumb-item active">Dashboard v1</li>
</ol>
</div><!-- /.col -->
</div><!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<!-- /.content-header -->
<section class="content">
<div class="row">
<div class="col-12">

<div class="card">
<div class="card-header">
<h3 class="card-title">DataTable with default features</h3>
</div>
<!-- /.card-header -->
<div class="card-body">

<?php include('val.php');?>
<form name="form1" method="post" action="bookinsert.php" id="formID">
<p>&nbsp;</p>
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<td width="81">Book ISBN</td>
<td width="350"><input name="b_isbn" type="text" id="b_isbn"
class="validate[required],custom[onlyNumber]"></td>
</tr>
<tr>
<td>Book Name</td>
<td><input name="book_n" type="text" id="book_n"
class="validate[required],custom[onlyLetter]"></td>
</tr>
<tr>
<td>Book Author</td>
<td><input name="b_author" type="text" id="b_author"
class="validate[required],custom[onlyLetter]"></td>
</tr>
<tr>
<td>Book_Type</td>
<td><input name="book_type" type="text" id="book_type"
class="validate[required],custom[onlyLetter]"></td>
</tr>
<tr>
<td>Book Publication</td>
<td><input name="b_publication" type="text" id="b_publication"
class="validate[required],custom[onlyLetter]"></td>
</tr>
<tr>
<td>Book Edition</td>
<td><input name="b_edition" type="text" id="b_edition"
class="validate[required],custom[onlyNumber]"></td>
</tr>
<tr>
<td>Book Photo</td>
<td><input name="b_photo" type="text" id="b_photo" class="validate[required]"></td>
</tr>
<tr>
<td>Book Price</td>
<td><input name="b_price" type="text" id="b_price"
class="validate[required],custom[onlyNumber]"></td>
</tr>
<tr>
<td>Book Gst</td>
<td><input name="b_gst" type="text" id="b_gst"
class="validate[required],custom[onlyNumber]">%</td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="Submit" value="Submit">
<input type="reset" name="Reset" value="Reset">
</td>
 </tr>
</thead>
</table>
</form>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>

</div>
<!-- /.content-wrapper -->

<?php include('footer.php'); ?>

TO INSERT THE VALUES IN THE TABLE BOOK:

<?php

$b_isbn=$_POST['b_isbn'];
$book_n=$_POST['book_n'];
$b_author=$_POST['b_author'];
$book_type=$_POST['book_type'];
$b_publication=$_POST['b_publication'];
$b_edition=$_POST['b_edition'];
$b_photo=$_POST['b_photo'];
$b_price=$_POST['b_price'];
$b_gst=$_POST['b_gst'];
$con=mysql_connect('localhost','root','');
mysql_select_db('bookp',$con);
$sql="insert into book1
values(null,'$b_isbn','$book_n','$b_author','$book_type','$b_publication','$b_edition','$b_phot
o','$b_price','$b_gst')";
mysql_query($sql);
?>
<script>
alert('thank you for inserting');
document.location="book_info_view.php";
</script>

TO EDIT THE BOOK TABLE:

<?php include('metatags.php'); ?>

<body class="hold-transition sidebar-mini layout-fixed">

<div class="wrapper">

<?php include('nav.php'); ?>

<!-- Main Sidebar Container -->

<?php include('sidebar.php'); ?>

<!-- Content Wrapper. Contains page content -->

<div class="content-wrapper">
<!-- Content Header (Page header) -->
<div class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="col-sm-6">
<h1 class="m-0 text-dark">Online Book Store</h1>
</div><!-- /.col -->
<div class="col-sm-6">
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item"><a href="bookinfo.php">Home</a></li>
<li class="breadcrumb-item active">Dashboard v1</li>
</ol>
</div><!-- /.col -->
</div><!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<!-- /.content-header -->
<section class="content">
<div class="row">
<div class="col-12">

<div class="card">
<div class="card-header">
<h3 class="card-title">DataTable with default features</h3>
</div>
<!-- /.card-header -->
<div class="card-body">
<?php
$id=$_REQUEST['id'];
$con=mysql_connect('localhost','root','');
mysql_select_db('bookp',$con);
$sql="select * from book1 where book_id='$id' ";
$res=mysql_query($sql);
$row=mysql_fetch_array($res);
?>
<?php include('val.php');?>

<form name="form1" method="post" action="bookupdate.php" id="formID">

<p>
<input name="book_id" type="hidden" id="book_id" value="<?php echo $row['book_id']; ?
>">
</p>
<table width="293" height="292" border="1">
<tr>
<td width="81">Book Isbn</td>
<td width="350"><input name="b_isbn" type="text" id="b_isbn" value="<?php echo
$row['b_isbn'];?>"></td>
</tr>
<tr>
<td>Book Name</td>
<td><input name="book_n" type="text" id="book_n" value="<?php echo $row['book_n']; ?
>"></td>
</tr>
<tr>
<td>Book Author</td>
<td><input name="b_author" type="text" id="b_author" value="<?php echo
$row['b_author']; ?>"></td>
</tr>
<tr>
<td>Book Type</td>
<td><input name="book_type" type="text" id="book_type" value="<?php echo
$row['book_type']; ?>"></td>
</tr>
<tr>
<td>Book Publication</td>
<td><input name="b_publication" type="text" id="b_publication" value="<?php echo
$row['b_publication']; ?>"></td>
</tr>
<tr>
<td>Book Edition</td>
<td><input name="b_edition" type="text" id="b_edition" value="<?php echo
$row['b_edition']; ?>"></td>
</tr>
<tr>
<td>Book Photo</td>
<td><input name="b_photo" type="text" id="b_photo" value="<?php echo
$row['b_photo']; ?>"></td>
</tr>
<tr>
<td>Book Price</td>
<td><input name="b_price" type="text" id="b_price" value="<?php echo $row['b_price']; ?
>"></td>
</tr>
<tr>
<td>Book Gst</td>
<td><input name="b_gst" type="text" id="b_gst" value="<?php echo $row['b_gst'];
?>"></td>
</tr>
</thead>
</table>
<input type="submit" name="Submit" value="Submit">
<input type="reset" name="Reset" value="Reset">
</form>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>

</div>
<!-- /.content-wrapper -->

<?php include('footer.php'); ?>

TO UPDATE THE TABLE :
<?php
$book_id=$_POST['book_id'];
$b_isbn=$_POST['b_isbn'];
$book_n=$_POST['book_n'];
$b_author=$_POST['b_author'];
$book_type=$_POST['book_type'];
$b_publication=$_POST['b_publication'];
$b_edition=$_POST['b_edition'];
$b_photo=$_POST['b_photo'];
$b_price=$_POST['b_price'];
$b_gst=$_POST['b_gst'];
$con=mysql_connect('localhost','root','');
mysql_select_db('bookp',$con);
$sql="update book1 set
b_isbn='$b_isbn',book_n='$book_n',b_author='$b_author',book_type='$book_type',b_publica
tion='$b_publication',b_edition='$b_edition',
b_photo='$b_photo',b_price='$b_price',b_gst='$b_gst' where book_id='$book_id' ";
mysql_query($sql);
?>
<script>
alert('thank you for updating');
document.location="book_info_view.php";
</script>

TO DELETE THE CONTENS OF TABLE BOOK:

<?php
$id=$_REQUEST['id'];
$con=mysql_connect('localhost','root','');
mysql_select_db('bookp',$con);
$sql="delete from book1 where book_id='$id' ";
$res=mysql_query($sql);
?>
<script>
alert('thank you for inserting');
document.location="book_info_view.php";
</script>

TO VIEW THE TABLE:

<?php include('metatags.php'); ?>

<body class="hold-transition sidebar-mini layout-fixed">

<div class="wrapper">

<?php include('nav.php'); ?>

<!-- Main Sidebar Container -->

<?php include('sidebar.php'); ?>

<!-- Content Wrapper. Contains page content -->

<div class="content-wrapper">
<!-- Content Header (Page header) -->
<div class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="col-sm-6">
<h1 class="m-0 text-dark">Dashboard</h1>
</div><!-- /.col -->
<div class="col-sm-6">
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item"><a href="#">Home</a></li>
<li class="breadcrumb-item active">Dashboard v1</li>
</ol>
</div><!-- /.col -->
</div><!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<!-- /.content-header -->

<section class="content">
<div class="row">
<div class="col-12">

<div class="card">
<div class="card-header">
<h3 class="card-title">DataTable with default features</h3>
</div>
<!-- /.card-header -->
<div class="card-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>#</th>
<th>Book ISBN</th>
<th>Book Name</th>
<th>Book Author</th>
<th>Book Type</th>
<th>Book Publication</th>
<th>Book Edition</th>
<th>Book Photo</th>
<th>Book Price</th>
<th>Book Gst</th>
 <th></th>
<th></th>
</tr>
</thead>
<tbody>
<?php
$con=mysql_connect('localhost','root','');
mysql_select_db('bookp',$con);

$sql="select *from book1";

$res=mysql_query($sql);

while($row=mysql_fetch_array($res))
{
?>
<tr>
<td height="48"><?php echo $row['book_id'];?></td>
<td><?php echo $row['b_isbn'];?></td>
<td><?php echo $row['book_n'];?></td>
<td><?php echo $row['b_author'];?></td>
<td><?php echo $row['book_type'];?></td>
<td><?php echo $row['b_publication'];?></td>
<td><?php echo $row['b_edition'];?></td>
<td><?php echo $row['b_photo'];?></td>
<td><?php echo $row['b_price'];?></td>
<td><?php echo $row['b_gst'];?></td>
<td><a href="book_delete.php?id=<?php echo $row['book_id']; ?>">delete</a></td>
<td><a href="book_edit.php?
id=<?php echo $row['book_id']; ?>">edit</a></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>

</div>
<!-- /.content-wrapper -->

<?php include('footer.php'); ?>

5.TESTING
Software Testing:
The code is tested at various levels in software testing. Unit,system and
useracceptancetesting’sareoftenperformed.Thisisagrey areaasmany differentopinionsexist
astowhatthestagesoftestingareandhowmuchifany iterationoccurs.Iterationisnot generallypart
ofthe waterfallmodel, but usuallysome occurat this stage.
Softwaretesting istheexecutionofprogramtofinditsfaults.Thetesting processfocuseson
thelogicalinternalsofthesoftware,ensuring thatallstatementshavebeentestedandonthe
functionalexternals,thatisconducting testtouncovererrorsandensurethatdefinedinputs
willproduceactualresultsagreedwithrequiredresults.Thefollowing teststrategieswere adopted
to test thesystem.

Testing objective:
Testing isprocessofexecuting aprogramwiththeintentoffindinganerror.Agoodtestcase
isonethathighprobability offindinganasyetundiscoverederror.Asuccessfultestisone
thatuncoversanasyetundiscoverederror.Theaboveobjectivesimply adramaticchangein
viewpoint.Testingcannotshowtheabsenceofdefect,itcanonly showthatsoftwareerrors
arepresent.

TESTINGSTRATEGIES:
There aretwogeneralstrategies fortestingsoftware. Theseare as follows:
Code testing:

This examinesthelogicoftheprogram.Tofollowthistest,casesare developed such thateverypath

ofprogram is tested.

Specification testing:

Specification Testing examines the specification starting what the programshoulddoandhow

itshouldperformunder variousconditions.Thentestcasesare developed foreach condition and
combinations of conditions and to be submitted forprocessing.

Testing methods used:

Hereblackboxtesting andstatisticaltesting areused.Inblackboxtesting,allpossibletypes of

inputsand seen for corresponding outputs and if not giving, code are corrected. In
statisticaltesting,checkingforallvariableswhetherthey assignedvaluesbeforeusingit,
whetherarrayboundcorrectly defined,whetherloopingstatementterminatingwithoutgoing
toinfiniteloop,whetherfunctionparameterare passedin orderandaboutnumber of parameters
etc.,are checked successfullyand found correct everythingworkingsatisfactorily.

5.1 Details of Testing Methodologies:

Unit testing:
Individualcomponentsaretestedtoensurethatthey operatecorrectly.Each component tested
independentlywithoutothersystem components.
Ex. CheckedforUsernameandPasswordwith thetable,afterthenext moduleis loaded session
allocation.

Integration testing:
Integrationtesting isasystematictechniqueforconstructing the
programstructurewhileatthesametimeconducting testtouncovererrorsassociatedwith
interfacing.Thistestingisdone usingthe bottom-upapproachtointegrate thesoftware
components of thesoftwaresystem in to functioningwhole.

Acceptance testing:
Useracceptanceofthesystemisthekeyfactorforthesuccessof
anysystem.Thisisdonebyuser.Thesystemisgiventotheuserandtheytestitwithlive
data.Acceptancetestinginvolvestheplanning andexecutionoffunctionaltest.Performance
tests,stresstestsinorder todemonstrate thatthe implemented systemsatisfiesits requirements.
Twosetsofacceptancetestcan berun,thosedevelopedby thecustomer.The system hasbeen tested
for its performance at unit level by the individuals through performancetesting
thatisdesignedtotestthe runtimeperformanceofthesoftware.The performanceof the
fullyintegrated system is tested and was foundgood.

Performance testing:
Performance Testing can serve different purpose. It can demonstrate that the system meets
the performance criteria. It can compare two systems to find which performs better, or it can
measure what parts of the system or workload cause the system to perform badly. In the
diagnostic case, software engineers use tools such as profilers to measure what parts of a
device or software contributes most to the poor performance.
It was a good idea to do our stress testing early on, because it gave us time to fix some of the
unexpected deadlocks and stability problems that only occurred when components were
exposed to very high transaction volumes.

System testing:
Systemtestingisactuallyaseriesofdifferent testswhoseprimary purposeisfully
toexercisethecomputer-basedsystem.Thesystemteststhatwhereapplied
arerecoverytestingandperformancetesting.Finallyarevieworauditisconductedwhichis
afinalevaluationthatoccursonly afteroperating thesystemlongenoughforusertohave
gainedafamiliarity withit.
Systemtestingwasdoneby theinspectionteamtoverify thatall thefunctionality
identifiedisthesoftwarerequirementspecificationhasbeenimplemented.
Defectsthatcreptinthesystemhasbeenfounddefectfreeandisworkingwell.System testing
isconcerned withinterfaces,designlogic,controlflowrecovery,procedures throughput,
capacityand timing characteristics of the entire system. For blankfield,alphabets, number and
special character validation.

5.2 SAMPLE TESTING USED

Validation Testing:
The system has been tested and implemented successfully and thus ensured that all
requirements as listed in the software requirements specification are completely fulfilled. In
case of erroneous input corresponding error messages are displayed.Black

Black Box Testing:

This method focuses on the functional requirements of the software. This testing enables to
derive set input conditions that will fully exercise all functional requirements of the program.
Black Box Testing attempts to find errors in the following category.

 Incorrect or missing functions.

 Interface errors.
 Error in external database access.
 Performance errors.
 Initialization and Termination errors
.

White Box Testing:

This is performed early in the testing process, while Black Box testing is applied during
the last stage of testing. In this test cases are generated on the logic of each module by
drawing flow graphs of that module and logical decisions are tested on all the cases.

It has been used to generate the test case in the following test cases:
  Guarantee that all independent paths have been executed.
 Execute all logical decisions from their True and False side.
 Execute all loops at their boundaries and within their operational bounds.
 Execute internal data structures to ensure their validity.
 Ensure whether all the possible validity checks and validity lookups have
been provided to validate data entry.

Functional testing:

Functional tests provide a systematic demonstration of the functions tested that are available
as specified by the business and technical requirements, system documentation, and user
manuals.

Functional Testing is centered on the following items:

Valid Input : Identified classes of valid input must be accepted.

Invalid Input : Identified classes of invalid input must be accepted.

Functions : Identified functions must be exercised.

Output : Identified classes of application outputs must be exercised.

Systems/Procedures : Interfacing systems or procedures must be invoked.

Organization and preparation of functional tests is focused on requirements, key functions, or

special test cases. In addition, systematic coverage pertaining to identify Business process
flows, data fields, predefined processes, and successive processes must be considered for
testing. Before functional testing is complete, additional tests are identified and the effective
value of the current test is determined.

TestCasesandResults:
8.4.1 Test Case 1: Login Page
Input Username and Password

Expected Output The main page for should be displayed

Actual Output The main page for admin is displayed

Result Successful
8.4.2 Test Case 2: Updating
Input Open the page for modification and make
necessary changes and press submit button

Expected Output Changes should take place user side

Actual Output Changes have taken place

Result Successful

8.4.3 Test Case 3: Forget Password

Input To check whether when we selected the
forgot password link it is directing to forgot
password link page.

Expected Input To check whether in that page it must ask

the alternative hints to send the link.

Output The user will get the old password again.

Result Successful

6. RESULTS/SCREENSHOTS
LOGIN PAGE:

Admin Module

Admin Module wit book details FORM page:

Admin module with book details insert:

VIEW PAGE OF ADMIN MODULE

EDIT PAGE:
7. CONCLUSION
Software is said to have attained its objective only when it meet all requirements of the user, further the user
himself is the person to judge the success of the system.Every attempt has been made to ensure that the system
is fully functional & works effectively &efficiently.The system has been tested with simple data to cover all
possible options & checked for al outputs. Since the system is flexible & modular, further modifications of this
package can be easily incorporated.

Importance of the system

 Less manual work.

 Increased efficiency.

 It reduces the time consumption.

 Quick (instant) result.