ONLINE SHOPPING

INTRODUCTION

Computer plays an important role in our daily life. Anything we want we can get only in one
mouse click. Speed, reliability and accuracy of the computer make it a powerful tool for different
purposes. A very important and basic need of today‘s modern business world is the quick
availability and processing of information using computer. One can easily get the type of required
information within a fraction of a second. The project that I have taken is also in this category
which is used in our daily life whenever we want to purchase some items we can easily get them
at our home.

People had to suffer the rush of the market when they went for shopping. They used to think
hundred times to buy any thing having the sufficient money for shopping. The problem was the
rush; the quarrel at the time of buying the things. But the advancement of technology brought the
new way for shopping. The way of shopping was completely changed with the coming of Internet
Technology. People have to fill a simple form on the internet to place their order on any popular
shop or shopping-mall for the thing they want to buy. Now they can place their order from the
home.

1.1OBJECTIVE:

The objective of project on Online Shopping Portal is to developing a GUI based automated
system, which will cover all the information Related to the all products which is used in our daily
life. For example – Mobiles Phones, Laptops, Clothes, Books, Electronic Items and many more.
So by this GUI based automated system a user want to purchase something then it only a mouse
click away to purchase these ,products.

BCA IN WEB SCIENCE Page 1

 ONLINE SHOPPING

EXISTING SYSTEM

 In the existing system all transactions, dealings of products, purchasing of products were
done manually which is time consuming.

 Reports are prepared manually as and when needed. Maintaining of reports is very tedious
task.

 To buy any product user has to collect information about it either by visiting the shop or
asking people which is the better one.

 There is no computer system for handling payments. All calculations are performed manually
which may not be accurate always. Maintaining the record is really a tedious task.

 Any internet user can use this existing website to search for any kind of products, select
particular products from a wide range of products.

 Once they make of their mind to purchase any particular thing they can place an order and
make a payment throw various available payment option.

BCA IN WEB SCIENCE Page 2

 ONLINE SHOPPING

PROPOSED SYSTEM

The purpose of the online shopping is to save money, save time. Through online shopping one
can save his/her valuable time. One can watch and select things he wants to buy. Through online
shopping we can save our money because prices are less than market prices and we receive our
bought things at our home. No need to go out anywhere and do shopping we can get different
varieties of things online and we can choose which one we want.

Advantages

 In the proposed system customer need not go to the shop for buying the products.
 He can order the product he wish to buy through the application in his Smartphone.
 The shop owner will be admin of the system. Shop owner can appoint moderators who
will help owner in managing the customers and product orders.
 The system also recommends a home delivery system for the purchased products

BCA IN WEB SCIENCE Page 3

 ONLINE SHOPPING

SOFTWARE & HARDWARE REQUIREMENTS

4.1 SOFTWARE REQUIREMENTS:

• Front End : HTML, CSS

• Middle Ware : PHP

• Back End : MYSQL

• Server : XAMPP

• Connector : PHP , MYSQL

• Coding purpose : Notepad++

• Browser : Google Chrome ,Internet Explorer ,Mozilla Firefox

4.2 HARDWARE REQUIREMENTS:

• Processor : Pentium IV or above

• RAM : 256 MB and above

• Hard Disk : 5 GB HDD or above

• Mouse : Standard Mouse

• Keyboard : Standard Keyboard

BCA IN WEB SCIENCE Page 4

 ONLINE SHOPPING

INTRODUCTION TO PHP & MYSQL

5.1 PHP

PHP is a popular high-level scripting language used by a range of organizations and developers.
Originally developed as a small Perl project by Rasmus Lerdorf in late 1995,PHP was intended as
a means to assist in developing his home page, and as such he named it Personal Home Page
(PHP) Tools. When Lerdorf was contracted to work for the University of Toronto to build a dial-
up system for students to access the Internet, he had no means of connecting Web sites to
databases. To solve this problem, the enterprising Lerdorf replaced his Perl code with a C wrapper
that added the capability to connect his Web pages to a MySQL database. As his small project
grew, he gave away his changes on the Internet as an Open Source project and cordially received
improvements from other programmers with an interest in PHP.

The language was later renamed to the current recursive acronym PHP: Hypertext Pre-processor
by ZeevSuraski and AndiGutmans after they rewrote the parser in 1997. The software continued
to develop and now forms the comprehensive PHP platform we know today.PHP provides a solid
and well-defined programming language that includes support for object orientated programming,
conditions; file handling, arithmetic, and more. The language that PHP forms is similar in
semantics to that of a shell scripting language combined with the easier bits of the C language.
PHP subscribes to the batteries-included philosophy of programming languages and includes
extensive support for a huge range of needs, such as cookies, forms, sessions; include files,
network sockets, e-mail and more.

Database support covers not only MySQL but many others, including but not limited to Posture
SQL, Oracle ,MS SQL, dBase, Sybase, and DB2. This flexible database support is useful if you
ever need to port your application to a different database. In addition to PHP’s capability as a
Web scripting language, PHP also can be used as a shell scripting language. XAMPP provides a
complete PHP, Apache, and MySQL Web development environment that can be installed by
downloading, unzipping, and running the software. XAMPP makes the installation dramatically
easier, and the software also includes a raft of additions and extras that are genuinely useful,
including PHP extensions, a Web front end for MySQL (which is used throughout the book), and
more. XAMPP is freely available for Windows, Linux, MacOS X, and Solaris.

BCA IN WEB SCIENCE Page 5

 ONLINE SHOPPING

Vision provides cost-effective and customizable PHP Web Programming Services in order to
render a range of PHP Web Development Services for both new and existing websites running on
PHP / Apache/ MySQL combination which is becoming the choice of IT and non- IT industry
leaders for dynamic websites Oceanic Vision leads the world market as a quality PHP
Outsourcing Company in India through the development of PHP based websites and fast driven
applications. Oceanic Vision provides timely, efficient and affordable PHP Programming
Services. We have gain experience through a variety of PHP Projects done for customers based in
India

History

The first version of PHP, PHP/FI, was developed by RasmusLerdorf as a means of monitoring
page views for his online resume’s and slowly started making a mark in mid-1995. This version
of PHP had support for some basic functions, primarily the capability to handle form data and
support for the MySQL database. PHP/FI 1.0 was followed by PHP/FI2.0 and, in turn, quickly
supplanted in 1997 by PHP 3.0.

PHP 3.0, developed by AndiGutmans and ZeevSuraski, was where things started to get
interesting. PHP 3.0 was a complete rewrite of the original PHP/FI implementation and it
included support for a wider range of databases, including MySQL and Oracle. PHP
3.0’sextensible architecture encouraged independent developers to begin creating their own
language extensions, which served to increase the language’s popularity in the developer
community. Before long, PHP3.0 was installed on hundreds of thousands of web servers, and
more and more people were using it to build database-backed web applications.

PHP 4.0, which was released in 2003, used a new engine to deliver better performance, greater
reliability and scalability, support for web servers other than Apache, and a host of new language
features, including built-in session management and better OOP support. And, as if that wasn’t
enough, the current version of PHP, PHP 5.0, offers a completely revamped object model that

BCA IN WEB SCIENCE Page 6

 ONLINE SHOPPING

uses object handles for more consistent behavior when passing objects around, as well as abstract
classes, destructors, multiple interfaces, and class type hints.

PHP 5.0 also includes better exception handling, a more consistent XML toolkit, improved
MySQL support, and a better memory manager. So far, all these changes have conspired to make
PHP 5.0 the best PHP release in the language’s ten-year history . . . a fact amply illustrated by the
April 2004 Net craft survey, which shows PHP in use on over fifteen million web sites.

Features

As a programming language for the Web, PHP is hard to ignore. Clean syntax, object-oriented
fundamentals, an extensible architecture that encourages innovation, support for both current and
upcoming technologies and protocols, and excellent database integration are just some of the
reasons for the popularity it currently enjoys in the developer community.

Simplicity

Because PHP uses a consistent and logical syntax, and because it comes with a clearly written
manual, even novices find it easy to learn. In fact, the quickest way to learn PHP is to step
through the manual’s introductory tutorial, and then start looking at code samples off the Web.
Within a few hours, you’ll have learned the basics and will be confident enough to begin writing
your own scripts. This adherence to the KISS (Keep It Simple, Stupid)principle has made PHP
popular as a prototyping and rapid application development tool for web applications. PHP can
even access C libraries and take advantage of program code written for this language, and the
language is renowned for the tremendous flexibility it allows programmers in accomplishing
specific tasks.

Portability

With programming languages, portability—the ease with which a program can be made to work
on different platforms—is an important factor. PHP users have little to fear here, because cross

BCA IN WEB SCIENCE Page 7

 ONLINE SHOPPING

platform development has been an important design goal of PHP since PHP 3.0.Today, PHP is
available for a wide variety of platforms, including UNIX, Microsoft Windows, Mac OS, and
OS/2. Additionally, because PHP code is interpreted and not compiled, PHP scripts written on
one platform usually work as is on any other platform for which an interpreter exists. This means
that developers can code on Windows and deploy on UNIX without any major difficulties.

Speed

Out of the box, PHP scripts run faster than most other scripting languages, with numerous
independent benchmarks putting the language ahead of competing alternatives like
JSP,ASP.NET, and Perl. When PHP 4.0 was first released, it raised the performance bar with its
completely new parsing engine. PHP 5.0 improves performance even further through the use of
an optimized memory manager, and the use of object handles that reduce memory consumption
and help applications run faster.

Open Source

Possibly the best thing about PHP is that it’s free—its source code is freely available on the Web,
and developers can install and use it without paying licensing fees or investing inexpensive
hardware or software. Using PHP can thus significantly reduce the development costs of a
software application, without compromising on either reliability or performance. The open-source
approach also ensures faster bug fixes and quicker integration of new technologies into the core
language, simply due to the much larger base of involved developers.

Extensible

Keeping future growth in mind, PHP’s creators built an extensible architecture that enables
developers to easily add support for new technologies to the language through modular
extensions. This extensibility keeps PHP fresh and always at the cutting edge of new technology.
To illustrate this, consider what PHP lets you do through its add-on modules :dynamically create
image, PDF, and SWF files; connect to IMAP and POP3 servers ;interface with MySQL, Oracle,
Postgre SQL, and SQLite databases; handle electronic payments; parse XML documents; and

BCA IN WEB SCIENCE Page 8

 ONLINE SHOPPING

execute Perl, Java, and COM code through a PHP script. And as if all that wasn’t enough, there’s
also an online repository of free PHP classes called PEAR, the PHP Extension and Application
Repository, which provides a source of reusable, bug-free PHP components.

XML and Database Support

Regardless of whether your web application sources its data from an XML file or a database, PHP
has you covered. PHP 5.0 comes with an improved MySQL extension that enables you to take
advantage of new features in the MySQL RDBMS (including subqueries, transactions, and
referential integrity), and the language also supports DB2, Postgre SQL, Oracle, MySQL, MS-
SQL, Informix, Sybase, and SQLite. Alternatively, if it’s XML you’re after, PHP 5.0offers a
completely redesigned XML API built around the libxml2 toolkit; this API supports SAX, DOM,
and XSLT, as well as the new Simple XML and SOAP extensions.

BCA IN WEB SCIENCE Page 9

 ONLINE SHOPPING

5.2 MySQL

MySQL is a high-performance, multiuser relational database management system that is today the
de facto standard for database-driven software applications, both on and off the Web. Designed
around three fundamental principles—speed, stability, and ease of use—and freely available
under the GNU General Public License, MySQL has been dubbed “the world’s most popular
open-source database” by its parent company. And with good reason. Official statistics reveal
over five million sites are creating, using, and deploying MySQL-based applications, with more
coming into the fold on a daily basis.

If you are planning on starting, for example, a bank or a savings and loan, MySQL probably isn’t
for you. But for the majority of people using the majority of applications, MySQL is a great
choice. It is particularly well suited for Web applications. MySQL is a powerful and
comprehensive relational database server, which was originally developed by David Axmark,
Allan Larsson, and Michael “Monty” Widenius. The commercial company they founded, MySQL
AB, develops and markets MySQL and associated products. Although the MySQL software
originated as an Open Source project, its creators were confident that they could run a business
using the product as a base. This business enables the developers to work full time on the
software, which in turn benefits both the Open Source community and commercial users of
MySQL. Both the open and commercial MySQL variants are functionally the same; the only
difference in the software is how it is licensed. MySQL also has support for a number of
programming languages to access and query the database.

This includes languages such as PHP, Python, Perl, C, C++, and Java, among others. Although
you may wish to initially use only PHP to query the database, Multilanguage support is useful if
you need to write modules and applications in different languages in the future.

History

The MySQL story hasn’t always been about rocketing growth rates and high user satisfaction
ratings, however. MySQL has an interesting history, with roots going back to 1979, when
Michael “Monty” Widenius created a database system named UNIREG for the Swedish company
TcX. UNIREG didn’t work for TcX on account of performance issues, and so TcX began a search

BCA IN WEB SCIENCE Page 10

 ONLINE SHOPPING

for alternatives. They tried MySQL, a competing DBMS created by David Hughes, but when that
attempt also failed, a new approach was called for. Thus, Widenius decided to create a new
database server customized to his specific requirements, but based on the MySQL API (to
simplify porting applications between the two).

That system, completed and released to a small group in May 1996, became MySQL 1.0.A few
months later, MySQL 3.11 saw its first public release as a binary distribution for Solaris. Linux
source and binaries followed shortly; an enthusiastic developer community and a friendly, GPL-
based licensing policy took care of the rest. As MySQL grew in popularity, TcX became MySQL
AB, a private company that today is the sole owner of the MySQL server source code and
trademark. MySQL AB is responsible for maintenance, marketing, and further development of the
MySQL database server

Features

MySQL’s development history has always been characterized by a clear-eyed focus on the most
important attributes of a good RDBMS: speed and stability. This has resulted in a system that
outperforms most of its competitors without sacrificing reliability or ease of use, thereby gaining
it a loyal base of developers, administrators, and users worldwide. The following sections
describe MySQL’s most compelling features.

Speed

In an RDBMS, speed—the time taken to execute a query and return the results to the caller—is
everything. MySQL scores high on this parameter, with better performance than almost all its
competitors, including commercial systems like Microsoft SQL Server and IBM DB2. This
blazing performance is more the result of intelligent software design than luck: MySQL uses a
fully multithreaded architecture; special optimizers for complex tasks like joins and indexing; a
query cache, which improves performance without any special programming needed by the user;
and the capability to use different storage engines on a per-table basis, so that users can mix and
match different feature sets to squeeze the maximum performance out of the system.

BCA IN WEB SCIENCE Page 11

 ONLINE SHOPPING

Reliability

When it comes to reliability, MySQL’s creeds are impeccable. The MySQL RDBMS has been
tested and certified for use in high-volume, mission-critical applications by some of the world’s
largest organizations, including NASA, HP, and Yahoo! Because MySQL has deep roots in the
open-source community, every new release is typically “battle-tested” by users allover the world,
on different operating systems and in different operating conditions, to ensure that it is completely
bug-free before being certified for use. Further, every new release of MySQL first has to pass
MySQL’s in-house test suite, affectionately known as crash-me because its primary goal is to
attempt to crash the system.

Security

Security is an important concern when dealing with multiuser databases, and MySQL’s
developers have taken a great deal of care to ensure that MySQL is as secure as possible. MySQL
comes with a sophisticated access control and privilege system to preventing authorized users
from accessing the system. This system, implemented as a five-tiered privilege hierarchy, enables
MySQL administrators to protect access to sensitive data using a combination of user- and host-
based authentication schemes. Users can be restricted toper forming operations only on specified
databases or fields, and MySQL even makes its possible to control which types of queries a user
can run, at database, table, or field level.

Scalability and Portability

MySQL can handle extremely large and complex databases without too much of a drop in
performance. Tables of several gigabytes containing hundreds of thousands of records are not
uncommon, and the MySQL web site itself claims to use databases containing 50 million records.
And once you’ve got your tables filled with data ,you can move them from one platform to
another without any difficulty—MySQL is available for both UNIX and non-UNIX operating
systems, including Linux, Solaris, FreeBSD, OS/2, MacOS, and Windows 95, 98, Me, 2000,XP,
and NT. It runs on a range of architectures, including Intel x86, Alpha, SPARC, PowerPC.

BCA IN WEB SCIENCE Page 12

 ONLINE SHOPPING

Ease of Use

Most commercial RDBMSs are intimidating, with cryptic command-line interfaces and hundreds
of tunable parameters. Not this one, though—well aware that a complex interface adds to the total
cost of ownership of an RDBMS, the MySQL development team has taken pains to make MySQL
easy to use, administer, and optimize. A simple SQL command-line interface (SQL commands
are covered in Chapters 9 to 11) is the primary user interface to the server; users with a more
visual bent can, instead, use MySQL Control Center or MySQL Administrator, two GUI clients
developed by MySQL AB for MySQL usage and administration. A number of other browser-
based tools are also available, and the application is well supported by a detailed manual, a
knowledgeable developer community, and some excellent books and tutorials.

Compliance with Existing Standards

MySQL 4.0 supports most of the important features of the ANSI SQL-99 standard, with support
for missing features slated to be added in future versions. MySQL also extends the ANSI standard
with its own custom functions and data types designed to improve portability and provide users
with enhanced functionality. On the internationalization front, MySQL 4.0 supports a number of
important character sets (including Latin, Big5, and European character sets), with full Unicode
support scheduled for future versions.

Wide Application Support

MySQL exposes APIs to many different programming languages, thereby making it possible to
write database-driven applications in the language of your choice. This book focuses specifically
on using PHP with MySQL, but readers working with other programming languages will be
pleased to hear that MySQL AB also provides native ODBC and JDBC drivers for the Microsoft
Windows and Java platforms. Additionally, hooks to MySQL area available in C, C++, Perl,
Python, and Tcl, to offer developers maximum freedom in designing MySQL-backed
applications.

BCA IN WEB SCIENCE Page 13

 ONLINE SHOPPING

Easy Licensing Policy

The MySQL RDBMS is licensed under the GPL, and users are free to download and modify the
source code of the application to their needs, and to use it to power their applications free of cost.
This licensing policy has only fuelled MySQL’s popularity, creating an active and enthusiastic
global community of MySQL developers and users. This community plays an active role in
keeping MySQL an ahead of its competition, both by crash-testing the software for reliability on
millions of installations worldwide and by extending the core engine to stay the latest
technologies and newest developments.

BCA IN WEB SCIENCE Page 14

 ONLINE SHOPPING

5.3 APPLICATION ARCHITECTURE

In information systems, applications architecture or application architecture is one of several

architecture domains that form the pillars of an enterprise architecture (EA).Applications
architecture describes the behavior of applications used in a business, focused on how they
interact with each other and with users. It is focused on the data consumed and produced by
applications rather than their internal structure. In application portfolio management, the
applications are usually mapped to business functions and to application. The applications
architecture is specified on the basis of business and functional requirements. This involves
defining the interaction between application packages, databases, and middleware systems in
terms of functional coverage.

This helps identify any integration problems or gaps in functional coverage. A migration plan can
then be drawn up for systems which are at the end of the software life cycle or which have
inherent technological risks. Applications architecture tries to ensure the suite of applications
being used by an organization to create the composite architecture is scalable, reliable, available
and manageable. Applications architecture means managing how multiple applications are poised
to work together. It is different from software architecture, which deals with technical designs of
how a system is built. One not only needs to understand and manage the dynamics of the
functionalities the composite architecture is implementing but also help formulate the deployment
strategy and keep an eye out for technological risks that could jeopardize the growth and/or
operations of the organization.

Application modeling

Employs modeling as a framework for the development of new or enhanced applications, uses
modeling to find problems, reduce risk, improve predictability, reduce cost and time-to market,
tests various product scenarios, incorporating clients' needs/requirements, adds test design
decisions to the development process as necessary, evaluates product design problems.
Competitive intelligence, business modeling, strategic analysis understanding of the global
marketplace, consumers, industries and competition, and how global business models, strategies,
finances, operations and structures interrelate.

BCA IN WEB SCIENCE Page 15

 ONLINE SHOPPING

Understanding of the competitive environment, including current trend in the market, industry,
competition and regulatory environment, as well as understanding of how the components of
business model (i.e. strategy, finances, operations) interrelate to make organization competitive in
the marketplace. Understanding of organization's business processes, systems, tools, regulations
and structure and how they interrelate to provide products and services that create value for
customers, consumers and key stakeholders. Understanding of how the value create for
customers, consumers and key stakeholders aligns with organization's vision, business, culture,
value proposition, brand promise and strategic imperatives.

Technology

Understanding of IT strategy, development lifecycle and application/infrastructure maintenance;

Understanding of IT service and support processes to promote competitive advantage, create
efficiencies and add value to the business.

Technology standards

Demonstrates a thorough understanding of the key technologies which form the infrastructure
necessary to effectively support existing and future business requirements, ensures that all
hardware and software comply with baseline requirements and standards before being integrated
into the business environment, understands and is able to develop technical standards and
procedures to facilitate the use of new technologies, develops useful guidelines for using and
applying new technologies.

BCA IN WEB SCIENCE Page 16

 ONLINE SHOPPING

FEASIBILITY STUDY

It is both necessary and prudent to evaluate the feasibility of a project at the earliest possible time.
Months or years of effort, thousands and millions of dollars, and untold professional
embarrassment can be averted if an ill- conceived system is recognized early in the definition
phase. Feasibility and risk analysis are related in many ways. If project risk is great, the feasibility
of producing quality software is reduced. During product engineering, however, we concentrate
our attention on four primary areas of interest.

6.1 TECHNICAL FEASIBILITY

The current system has Personal Computers. All the works are done on Word Processor and
spread sheet. The company already possesses the required software. In the current working
system, it requires time to produce the reports. We have to find out whether the necessary
technology, the proposed equipment have the capacity to hold the data, which is used in the
project, should be checked to carry out this technical feasibility. The response time is high for
processing queries. This will lead to high demands on available technical resources and demands
being placed on the clients.

6.2 OPERATIONAL FEASIBILITY

The system is expected to work smoothly when developed and installed. There has been
participation of management and the computer operators in planning and development of the
system. There will be a slight change in the format of the reports to which management agreed.
There is no disturbance in organizational structure of the company. The new application for the
system will have Graphical User Interfaces (GUI). The applications with GUI are very easy to
handle and operate. The company has to train their staff members which can easily done in one or
two days. They need to be instructed regarding using of the application software. Operational
feasibility in this project:

BCA IN WEB SCIENCE Page 17

 ONLINE SHOPPING

• The proposed system offers greater level of user friendliness.

• The proposed system produces best results and gives needful information.

• It can be implemented easily.

• So this project is operationally feasible.

6.3 ECONOMICAL FEASIBILITY

The company already possesses the required hardware and software. There is no investment in
hardware and software. The benefits of installing the application lie in the speedy processing of
data, faster retrieval of information and increasing volume of data, and all these with greater
accuracy and consistency. To sum up, the benefits are great and cost is minimal. Therefore, the
project is economically feasible. Economic Feasibility in this project:

• The cost to conduct a full system investigation is possible.

• There is no additional manpower requirement.

• There is no additional cost involved in maintaining the proposed system.

BCA IN WEB SCIENCE Page 18

 ONLINE SHOPPING

DESIGN OBJECTIVE

7.1: DATA FLOW DIAGRAM:

7.1.1 : DFD Level 0:

Registration

Account status
Customer

Online Bill Searching

Shopping

Credit Reading
Administrator

Database Bill Payment

Security

BCA IN WEB SCIENCE Page 19

 ONLINE SHOPPING

7.1.2 DFD Level 1 :

Administrator Customer

Auth. DB Registration
process

Authentication
Validation
Process
Check

For New User

Admin or Visitor
Process

Order the
User status product
and total bill

Daily Update
Payment
Process
Mode

DATABASE DATABASE

BCA IN WEB SCIENCE Page 20

 ONLINE SHOPPING

7.2 ER DIAGRAM

Login id Username
_id Password Pay id Pay desc

LOGIN
1 1 PAYMENT

Pay amt

has
Password Customer id

Admin id 1 N

ADMIN Manages CUSTOMER

Password
User address

Name
Manages

Pro no Orders

N
Pro id
PRODUCT

Pro item Pro desc

BCA IN WEB SCIENCE Page 21

 ONLINE SHOPPING

8. DATA TABLE

8.1 Admin:

S.R Field Name Data type Size Validation

1. Admin_id Integer 10 Primary key

2. Name Varchar 30

3. Email Varchar 100

4. Password Varchar 300

BCA IN WEB SCIENCE Page 22

 ONLINE SHOPPING

8.2 Login Table :

S.R Field Name Data type Size Validation

1. User_id Integer 10 Primary key

2. Name Varchar 30

3. Email Varchar 100

4. Password Varchar 300

BCA IN WEB SCIENCE Page 23

 ONLINE SHOPPING

8.3 Payment Table

S.R Field Name Data type Size Validation

1. Order_id Integer 10 Primary key

2. User_id Integer 30

3. Product_id Integer 100

4. Qty Integer 300

5. Trx_id Varchar 10

6. p_status Varchar 100

BCA IN WEB SCIENCE Page 24

 ONLINE SHOPPING

8.4 Products Table

S.R Field Name Data type Size Validation

1. Product_id Integer 10 Primary key

2. Product_cat Integer 30

3. Product_brand Integer 100

4. Product_title Varchar 300

5. Product_qty Integer 10

6. Product_desc Text 100

7. Product_image Text 10

8. Product_keyword Text 30

9. Product_Price Integer 100

BCA IN WEB SCIENCE Page 25

 ONLINE SHOPPING

8.5 Customer Table:

S.R Field Name Data type Size Validation

1. User_id Varchar 10 Primary key

2. First_name Varchar 30

3. Last_name Varchar 100

4. Email Varchar 300

5. Password Varchar 10

6. Mobile Varchar 100

7. Address1 Varchar 10

8. Address2 Varchar 100

BCA IN WEB SCIENCE Page 26

 ONLINE SHOPPING

MODULES DESCRIPTION

9.1 ADMIN MODULE

Admin module is mainly for the owner of the system. This module performs the work of regular
checking process. Everyone needs current information about anything. Admin module allows
system administrator to set up back-end of the system and perform basic system configuration,
mainly definition of predefined drop-down fields, definition of classes time schedule, etc

9.2 USER PAGE MODULE

User page module is for front page of this system. It is the main page of the system in which all
the links of this system are kept. The user module allows users to register, log in, and log out. ...
Each user is assigned one or more roles. By default there are three roles: anonymous (a user who
has not logged in) and authenticated (a user who is registered), and administrator (a signed
in user who will be assigned site administrator permissions).

9.3 CUSTOMER SERVICE MODULE

In the customer service module, the customer will use this website to on-line shopping. And also
the customer sends the request to the shopping. The longer version is to ensure
the customer or client is satisfied with the product or service provided, and with the sales,
delivery, installation, use, and other components of the purchasing process.

9.4 PAYMENT MODULE

In this module, the customer will pay in different mode like Paypal, or by credit card where
A payment gateway is a merchant service provided by an e-commerce application service
provider that authorizes credit card or direct payments processing

9.5 PURCHASE MODULE

In this module, the all selected item could be purchased by the customer. And will pay through
Paypal or by credit cards .The Purchasing module facilitates the creation, maintenance and
analysis of purchasing activities within your organization, such as the management of suppliers.

BCA IN WEB SCIENCE Page 27

 ONLINE SHOPPING

TEST CASES

10.1 Test scenario for admin login

Test scenario for admin id: Username

Test case description: Login positive test case

Pre-Requisite: A valid admin dashboard

Test Case ID: 101

sl Action Inputs Expected Actual Test Test

no. Output Output Result Comments
Pass
Launch the localhost/Sharma Sharma Store’s Sharma Login
1. application /admin Admin home Store’s successful
page Admin
home page

Enter the Username: Login successful Login Pass Login

2. correct admin successful successful
username Password:
and xxxxxxxx
password
and hit the
login button

BCA IN WEB SCIENCE Page 28

 ONLINE SHOPPING

BCA IN WEB SCIENCE Page 29

 ONLINE SHOPPING

10.2 Test scenario for admin login with password

Test scenario for admin id: Username

Test case description: Login negative test case

Pre-Requisite: A invalid admin dashboard

Test Case ID: 102

sl no. Action Inputs Expected Actual Test Test

Output Output Result Comments

Enter invalid Username: The The Fail Invalid

1. username and property username username login
any password Password: that you that you have attempt
and hit the xxxxx have entered is stopped
login button entered is wrong enter
wrong again ?
enter again
?

Enter the Username: Password Password Fail Invalid

2. valid admin you have you have login
username and Password: entered is entered is attempt
incorrect xxx incorrect incorrect stopped
password and
hit the login
button

BCA IN WEB SCIENCE Page 30

 ONLINE SHOPPING

BCA IN WEB SCIENCE Page 31

 ONLINE SHOPPING

10.3 Test scenario for Add Product

Test scenario for Adding product

Test case description: Register positive test case

Pre-Requisite: A valid Add property home page

Test Case ID: 103

sl Action Inputs Expected Actual Test Test

no. Output Output Result Comments

1. Open Localhost/ Sharma Add Add Pass Add Property

Product Store’s /admin/ product product page open
page and Products/add product page will page will successfully
add open we open we
product. can add can add
product. product.

2. Enter the Product Name:Iphone Details Details Pass Add Product

details Brand Name: Apple you have you have successfully
Name, Category Name: entered is entered is
Brand, Mobile correct correct
Category, Product desc: about and based and based
description, product on on
Quantity , Product Qty: 30 category category
Price, Price: Rs 50000 product product
Keyword, Keyword: Best phone will be will be
Image, Image: image.jpg displayed. displayed.

BCA IN WEB SCIENCE Page 32

 ONLINE SHOPPING

BCA IN WEB SCIENCE Page 33

 ONLINE SHOPPING

10.4 Test scenario for Add Product

Test scenario for Adding product

Test case description: Register negative test case

Pre-Requisite: A invalid Add product home page

Test Case ID: 104

sl Action Inputs Expected Actual Test Test

no. Output Output Result Comments

1. Enter the Product Name: Details you Details Fail Add Product
details Iphone have entered you have unsuccessfully
Name, Brand Name: is incorrect entered is
Brand, Apple try again. incorrect
Category, Category Name: try again.
description:, Mobile
Quantity , Product desc:
Price, about product
Keyword, Product Qty: 30
Image Price:Rs 50000
Keyword: Best
phone

BCA IN WEB SCIENCE Page 34

 ONLINE SHOPPING

BCA IN WEB SCIENCE Page 35

 ONLINE SHOPPING

10.5 Test scenario for Registration of Customer

Test scenario for Registration

Test case description: Registration positive test case

Pre-Requisite: A valid Registration

Test Case ID: 105

sl Action Inputs Expected Actual Test Test

no. Output Output Result Comments

1. Open Localhost/Sharma Register Register Pass Register

registration Store’s/ Register page will page will successful
page and be opened be opened
enter the and and
details customer customer
can register can register
fill their fill their
details details

2. Enter the First_name: Gautham Details Details Pass Register

valid details Last_name: Sharma what we what we successful
and fill the Email: have have
form for [email protected] entered is entered is
register Password: ******* correct and correct and
Mobile: 9632303898 customer customer
Address 1: #96 has been has been
Tennis court registered registered
Address 2:Bengaluru
Karnataka

BCA IN WEB SCIENCE Page 36

 ONLINE SHOPPING

BCA IN WEB SCIENCE Page 37

 ONLINE SHOPPING

10.6 Test scenario for Registration of Customer

Test scenario for Registration

Test case description: Registration negative test case

Pre-Requisite: A invalid Registration

Test Case ID: 106

sl Action Inputs Expected Actual Test Test

no. Output Output Result Comments

1. Enter the Email id : Register Register Fail Register

user name , [email protected] page will page will unsuccessful
mobile is Mobile: 963230898 show a show a
valid but the message as message as
email id is please please
incorrect enter valid enter valid
email email

2. Enter the Email id : Register Register Fail Register

user name [email protected] page will page will unsuccessful
is valid but Mobile: 9632898 show a show a
the mobile message as message as
number is please please
incorrect enter valid enter valid
mobile mobile
number number

BCA IN WEB SCIENCE Page 38

 ONLINE SHOPPING

BCA IN WEB SCIENCE Page 39

 ONLINE SHOPPING

REPORT GENERATION

11.1 HOME PAGE

The home page is the main web page of a website. The term can also refer to one or
more pages always shown in a web browser when the application starts up. The home page is
used to facilitate navigation to other pages on the site by providing links to prioritized and recent
pages.

BCA IN WEB SCIENCE Page 40

 ONLINE SHOPPING

11.2 CUSTOMER LOGIN & REGISTRATION PAGE

The Customer login is a set of credentials used to authenticate a user. Most often, these consist of
a username and password. The process is fairly simple; users input their credentials on the
website's login form. If the user is new then he/she can register as new user

Customer Login

Register New Customer

BCA IN WEB SCIENCE Page 41

 ONLINE SHOPPING

11.3 ADMIN LOGIN & REGISTRATION PAGE

Here the admin can login if he is already a user or else he/she can register by giving the details
that is required

Admin Login Page

Admin Registration Page

BCA IN WEB SCIENCE Page 42

 ONLINE SHOPPING

11.4 Cart Checkout

Add to Cart is a way to create a temporary list of items by adding them to your cart, which will
keep track of the items until you leave our website. You can export items in your cart by saving
the list to a file or sending it to an email address. You can also place the items on hold
or add them to your wish list.

BCA IN WEB SCIENCE Page 43

 ONLINE SHOPPING

11.5 ADDING PRODUCT

Here the Admin will add the products which is available and those products will be visible for
the customer to purchase .

BCA IN WEB SCIENCE Page 44

 ONLINE SHOPPING

CONCLUSION

Technology has made significant progress over the years to provide consumers a better online
shopping experience and will continue to do so for years to come. With the rapid growth of
products and brands, people have speculated that online shopping will overtake in-store
shopping. While this has been the case in some areas, there is still demand for brick and mortar
stores in market areas where the consumer feels more comfortable seeing and touching the
product being bought.
However, the availability of online shopping has produced a more educated consumer that can
shop around with relative ease without having to spend a large amount of time. In exchange,
online shopping has opened up doors to many small retailers that would never be in business if
they had to incur the high cost of owning a brick and mortar store. At the end, it has been a win-
win situation for both consumer and sellers

BCA IN WEB SCIENCE Page 45

 ONLINE SHOPPING

FUTURE SCOPE

On-Line Shopping is a web-based project which is made for remote-shopping or shopping

through Internet. As the technology is being advanced the way of life is changing accordance.
Now a day’s we can place the order for anything from our home. There is no need to go the shop
of the things we want. The order can be placed online through Internet.

The payment, the confirmation of purchasing; we can do everything we want. Now we can think
that how the days have been changed with time. People had to stand in rows to wait there terms to
buy a particular thing from a popular shop. But what is happening now a day’s; we can extremely
surprise that those things can be available on the door-step in few hours. In future we will try to
make this website which work so flexible and beneficial for the customer and also try to make
smooth service.

BCA IN WEB SCIENCE Page 46