A

PROJECT REPORT
ON
ONLINE SHOPPING PORTAL
IN
ORACLE DATABASE & PHP
Under the Guidance of
Mr. Amit Bhatia

Submitted in Partial fulfillment of the requirement

Of the Award of the Degree of
Bachelor of Technology

Submitted to : Submitted By :
Mr. Vijay Choudhary Ankur Sharma
H.O.D.(Computer Engineering) IV Year VII Sem.
Dept. of Computer Engineering Computer
SMCET, Phagi, Jaipur Engineering
SMCET, Phagi, Jaipur

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 1

PREFACE

This project is based on computer underlines and tells how a specific

task is to be performed by a given computer driven by speedy developments in
the underlying hardware. It teaches that how to work as a team in the industry.
For me it is very knowledgeable and interesting as well.

Engineering is not only a theoretical study but it is a implementation of

all we study for creating something new and making things more easy and
useful through practical study. Engineering students gain theoretical
knowledge only through their books. Only theoretical knowledge is not
sufficient for absolute mastery in any field. Theoretical knowledge given in
our books is not of much use without knowing its practical implementation. It
has been experienced that theoretical knowledge is volatile in nature, however
practical make solid foundation in our mind.

I have make ONLINE SHOPPING PORTAL as my project by choosing

PHP as front end because it is a open source technology and easily connect
with database and provide secure environment and ORACLE Database as back
end tool because it is the world's most capable relational database management
system.

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 2

CONTENTS

1. INTRODUCTION
2. SOFTWARE DEVELOPMENT LIFE CYCLE
3. ABOUT THE CURRENT SYSTEM
4. HARDWARE & SOFTWARE REQUIRMENTS
5. FRONT END DETAILS
6. BACK END DETAILS
7. DATA FLOW DIAGRAMS
8. E-R DIAGRAMS
9. USER REQUIRMENT
10. FORM LAYOUTS
11. DATABASE STRUCTURE FOR ONLINE SHOPPING PORTAL
12. LIMITATIONS
13. CONCLUSIONS
14. BIBLIOGRAPHY

INTRODUCTION

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 3

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.

Objective:
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.

Need of ONLINE SHOPPING PORTAL

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 4

The “ONLINE SHOPPING PORTAL” is developed according the current need in
different Fields. This is online shopping Website which provides facility for purchasing
Mobiles, Laptops, Camera and many more items. So by using this Online Shopping Portal
users which want to purchase some products will first Register an account on this portal
then Login through their Username and Password, and then Select items which they want to
purchase and add them to cart and finally checkout by giving payment details. So by using
this portal users can easily purchase products from their home.

The project on Online Shopping Portal has following Structure:

 Before Login
 Login
 Register
 Forget Password
 Administrator Login
 About Us
 Contact Us
 After Administrator Login
 Edit Website Details
 Add Brands
 Add Category
 Add Items
 Delete Brands
 Delete Category
 Delete Items
 Manage User
• See Users
• Users Shopping
• Add Users
• Delete Users
 Logout
 After User Login
 My Profile

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 5

• Edit Profile
• Change Password
 Buy Products
• Categories (Controlled by Admin. Which can be add it dynamically
according to their needs)
 My Cart
 My Shopping’s
 Checkout
 Logout

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 6

A Database-driven Online Shopping Portal:

The shopping portal that I have build for our store makes use of several advance
features that the cart contain all the selected products until checkout and My Shopping by
which user can track their previous shopping on this portal. For doing so shopping portal
uses a Database by which all these information stored in this database and when required
then it is fetched from it. So I use Oracle Database in this project.

So this shopping portal contains dynamic effects by using this database. Some parts
of this project which use database are following:
• Firstly when user Register an account on this website the user give their information
which are stored in database.
• Then when users want to login on this website then they give their username and
password as they choose at registration time, if both are matched with database’s
username and password then user can successfully logged in the website otherwise
Access Denied.
• The Objects which users can see on homepage, after login page, buy products page are
also come from database.
• Now After login user can modify their profile and password. The modified profile
details and password details altered in the database.
• In Buy Products Section Product and Their Prices also fetched from database’s table.
When user select a product and push Add to cart then items added to database’s cart
table.
• Then in My Cart section the products displayed which are in the cart table of the
database following by user.
• Checkout section takes the carts item and their total price and then payment details are
given by the user and these details store in separate database table. After Successful
entry in this table users cart empty automatically because all items purchased by him.
• In My Shopping section the products a user purchased are displayed.

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 7

SOFTWARE DEVELOPMENT LIFE CYCLE

The software development life cycle, as outlined by Edward Yourdon in his book
Modern Structured Analysis (1989) has been followed in this project with minor
modifications. The modified life cycle is shown overleaf:-

The activities in the life cycle are explained in brief below:

1) SURVEY PROJECT SCOPE AND FEASIBILITY

This activity is also known as the feasibility study. It begins with a request from the
user for a new system. It involves the following:
• Identify the responsible user for a new system
• Clarify the user request
• Identify deficiencies in the current system
• Establish goals and objectives for the new system
• Determine the feasibility for the new system
• Prepare a project charter that will be used to guide the remainder of the Project

2) SYSTEMS ANALYSIS
The objective of the system analysis activity is to develop structured system
specification for the proposed system. The structured system specification should describe
what the proposed system would do; independent of the technology, which will be used to
implement these requirements. The structured system specification will be used to
implement these requirements. The structured system specification will be called the
essential model (also know as logical model).
The essential model may itself consist of multiple models, modeling different aspect
of the system. The data flow diagrams may model the data and there relationships and the
state transition diagram may model time dependent behavior of the system. The essential
model thus consists of the following.
• Context diagram
• Leveled data flow diagrams
• Process specification for elementary bubbles
• Data dictionary for the flow and stores on the DFDs.

3) PRELIMINARY DESIGN
The activity deals with certain design issues, which are to be finalized in
consultation with the user. The two most important design issues of relevance to the user are
the automation boundary and the human –machine interface. The output of the activity is
the user implementation model. The major part of the user implementation model is the

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 8

specification for the user interface of the proposed system. The user implementation model
is also referred to as the physical model of the proposed system. The user implementation
model is also referred to as the physical model of the proposed system. The model, in
addition to the essential model, defines the following for the proposed system:
• Automation boundary
• Report layouts
• Layouts of the source documents
• Screen layouts for the data entry forms
• Menu

4) SYSTEM DESIGN
System design involves transformation of the user implementation model into
software design. The design specification of the proposed system consists of the following:

• Database scheme
• Structure charts
• Pseudo codes for the modules in structure charts

5) IMPLEMENTATION
This activity includes programming, testing and integration of modules into a
progressively more complete system. Implementation is the process of collect all the
required parts and assembles them into a major product.

6) TEST GENERATION
This activity generates a set of test data, which can be used to test the new system
before accepting it. In the test generation phase all the parts are come which are to be tested
to ensure that system does not produce any error. If there are some errors then we remove
them and further it goes for accepting.

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 9

ABOUT THE CURRENT SYSTEM

Advantages of the Current System:

The project Online Shopping Portal System is GUI based system so that it is easy to
handle. It also increases the efficiency of the end user, because it will reduce the redundant
job, which is tedious to complete. The Online System also has automated capability to
complete job, so it reduces the work manually.

Advantage of Online Shopping Portal:

1. This online program will take less time and gives better results.
2. It reduces the tedious jobs Like (Redundant work, long procedures, Up to Date
Information).
3. It will improve the online shopping system, since all the information is available
whenever required.
4. It provides quick processing thus helps in transaction and updating in
Edit personal view can perform in few seconds.
5. It provides accurate Output.
6. It gives fast answer of queries.
7. The amount of paper work is reduced.
8. Better Control.

Deficiencies of the manual system:

1) Lack of immediate retrieval of information

In manual system, lot of time is wasted in retrieving information. Much searching is
required before required information is found. This wastes a lot of time of the user as well
as the person.

2) Lack of immediate information storage

In manual system, it is difficult to store information at proper place at that
very moment. This is because the person is unable to quickly locate the place where the
information is to be stored.

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 10

3) Prompts updating not possible
Changes are quite natural in all walks of life. Information and stored data also
changes from time to time. These changes should be incorporated in the working also to
keep the information up to date. However, bringing about changes through the manual
system is a slow and tedious process because of which inaccurate information storage
occurs.

4) Unplanned working
The manual system lacks the element of planned working. Records are not
properly maintained. This creates a lot of problems at times like during information retrieval
and storage.

5) Insignificant generation of managerial and Strategic reports.

In manual system, reports for management are difficult to be generated and
strategic reports are almost impossible. This is because for these reports proper storage of
information, its retrieval and it’s filtering (i.e. choosing information that meets criteria are
very important and are very tough in manual system.

6) Accuracy
The manual system lacks accuracy in working and a number of operations
may be performed incorrectly. The computations that are done in the organization may be
incorrect and whatever are generated in the system may be inaccurate.

7) Reliability
The reliability of a manual system is considered to be low because of the
above given reasons including the fact that ‘To error is human’. Any task that is performed
by men, always contain the risk of errors.

8) Redundancy of information
In manual system, particular information may be stored at a number of
places, lending to redundancy. Redundancy of data or information creates a number of
problems storage space is wasted; changes at one place are to be made at a number of places
and so on.

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 11

GOALS OF THE PROPOSED SYSTEM:

1) Immediate retrieval of information

The main objective of the new system is to provide for quick and efficient retrieval
of information. Any type of information would be available to the user whenever he
requires. Facility would be provided for online query to cut down on the response time
greatly.

2) Immediate storage of information

In the proposed system, it will be easy to store information at any given time at the
correct places. The location of storage would be easily available and user will face no
difficulty.

3) Prompt updating of information

In the proposed system, the information will always remain up to date as the
updating will be prompt and without any efforts. This factor will be of great importance in
the proposed system as it determines the integrity of the information stored.

4) Fast computation of information

The computation of information will be quite fast in the proposed system. Not only
mathematical calculations, but also logical comparisons will be quick in the new system.

5) Planned approach toward working

The working in the service center information system will be well planned and
organized. The data will be stored properly in the data store, which will help in retrieval of
information as well as in its storage.

6) Generation of managerial and strategic reports

The new system would provide for regular generation of reports, which would help
the management in decisions making work and in controlling the overall working of the
organization. The generation, of these reports would be possible only if the system is
organized such that retrieval of information can be made on conditions.

7) Accuracy
The level of accuracy in the new proposed system would be higher. All operations
and computations would be done correctly and this will ensure that whatever information is
coming from the center, it is accurate.

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 12

8) Reliability
The reliability of the proposed system would be high due to the above stated
reasons. The reason for the increased reliability of the system is that now there would be
proper storage of information, its maintenance would be well managed and retrieval would
be possible in the desired manner.

9) Non Redundant Information

In the new system, utmost care would be taken that no information is repeated, any
usage of storage or otherwise. This would assure economic usage of storage or space and
consistency in the data stored. This will also help make those changes easily as the change
would have to be made only at that very place and no where else.

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 13

HARDWARE & SOFTWARE REQUIRMENTS

At Developer Side
During system development, i have to design both static and dynamic website
interfaces, create website functions and a database system, edit photos and pictures, so its
has a set of software and hardware requirements.
Hardware Used Software Used
• Intel Dual Core Processor • WAMP SERVER
• 160 GB Hard Disk Drive. • ORACLE 10g Database
• 1GB RAM. • NOTEPAD
• O.S. – Windows XP SP2 • MS PAINT

At System Users Side

The following is the requirements for the system users including members and
administrators.

Hardware Requirements Software Requirements

• Intel Pentium 4 Processor • Browser (IE 7.0 or Above, Mozilla
• 20 GB Hard Disk Drive. Firefox, Google Chrome

• 256MB RAM. • Browser Must be JavaScript Enabled

• O.S. – Windows XP

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 14

Front End Details

Front End tool is used for give a Graphical user interface to system. By this we can
make a system user friendly and more capable. I have chosen PHP as front end tool.
Because it is an Open Source Technology, freely available and more familiar with any type
of database.

ABOUT PHP:
PHP: Hypertext Preprocessor is a widely used, general-purpose scripting
language that was originally designed for web development to produce dynamic web pages.
For this purpose, PHP code is embedded into the HTML source document and interpreted
by a web server with a PHP processor module, which generates the web page document. As
a general-purpose programming language, PHP code is processed by an interpreter
application in command-line mode performing desired operating system operations and
producing program output on its standard output channel. It may also function as a
graphical application. PHP is available as a processor for most modern web servers and as
standalone interpreter on most operating systems and computing platforms.
PHP stores whole numbers in a platform-dependent range. This range is typically
that of 32-bit signed integers. Unsigned integers are converted to signed values in certain
situations; this behavior is different from other programming languages. Integer variables
can be assigned using decimal (positive and negative), octal,
and hexadecimal notations. Point numbers are also stored in a platform-specific range. They
can be specified using floating point notation, or two forms of scientific notation. PHP has a
native Boolean type that is similar to the native Boolean types in Java and C++. Using the
Boolean type conversion rules, non-zero values are interpreted as true and zero as false, as
in Perl and C++. The null data type represents a variable that has no value. The only value
in the null data type is NULL. Variables of the "resource" type represent references to
resources from external sources. These are typically created by functions from a particular
extension, and can only be processed by functions from the same extension; examples
include file, image, and database resources. Arrays can contain elements of any type that
PHP can handle, including resources, objects, and even other arrays. Order is preserved in
lists of values and in hashes with both keys and values, and the two can be
intermingled. PHP also supports strings, which can be used with single quotes, double
quotes, or heredoc syntax.

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 15

Back End Details

Back end part of a system is more important because it controls all the internal
process of a system. I have choose oracle database as back end. Because it is word’s Most
Capable relational database and provide more security than others.

ABOUT ORACLE:
The Oracle Database is a relational database management system (RDBMS). An
Oracle database system—identified by an alphanumeric system identifier or SID—
comprises at least one instance of the application, along with data storage. An instance—
identified persistently by an instantiation number (or activation id:
SYS.V_$DATABASE.ACTIVATION#)—comprises a set of operating-
system processes and memory-structures that interact with the storage. Typical processes
include PMON (the process monitor) and SMON (the system monitor).
Users of the Oracle databases refer to the server-side memory-structure as the SGA
(System Global Area). The SGA typically holds cache information such as data-
buffers, SQL commands, and user information. In addition to storage, the database consists
of online redo logs (or logs), which hold transactional history. Processes can in
turn archive the online redo logs into archive logs (offline redo logs), which provide the
basis (if necessary) for data recovery and for some forms of data replication.
The Oracle DBMS can store and execute stored procedures and functions within
itself. PL/SQL (Oracle Corporation's proprietary procedural extension to SQL), or the
object-oriented language Java can invoke such code objects and/or provide the
programming structures for writing them.
The Oracle RDBMS stores data logically in the form of tablespaces and physically
in the form of data files ("datafiles").[5] Tablespaces can contain various types of memory
segments, such as Data Segments, Index Segments, etc. Segments in turn comprise one or
more extents. Extents comprise groups of contiguous data blocks. Data blocks form the
basic units of data storage.

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 16

DATA FLOW DIAGRAMS

Registration

reply Reque
st

Operation/dat
a processing
Authenticati
onn
Online
Login / Shopping Products /
Index Portal Cart /
Shopping
Database
(Approved/Reject) (Acknowledgem
ent)

(Acknowledgem Payment
ent) /
Submissi

Payment /
Checkout

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 17

( 0 level DFD)

For Registration

User
Details

Register
Form

Username Exists

Databa
se

Sucess

Login
Form

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 18

For Login

User Access
Request Denied

Not Authenticate

Databa
se
Authenticate Buy
Products

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 19

For Buying Product:

User
Request

Databa
se

User’s
Checkout
Cart

Payment
Details

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 20

E-R Diagram :

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 21

USER REQUIREMENT

The user requires these features from the proposed system:

• Quick generation of data entry forms

• Quick processing of information

• Quick retrieval of data

• Quick and correct updating of data.

• Least storage requirements

• Secured and controllable data storage

• Full backups of data

• Readable, clean, up to date and timely reports

Note: These are some of the basic requirements, which the system should provide, but

additional Requirements can be different for other online program.

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 22

FORM LAYOUTS

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 23

Database Structure for Online Shopping Portal:

Members Table:
Serial No. Field Name Data Type
1. FNAME Varchar2(25)
2. LNAME Varchar2(25)
3. EMAIL Varchar2(50)
4. CONTACT Varchar2(15)
5. USERNAME Varchar2(10)
6. PASSWORD Varchar2(45)

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 24

LIMITATIONS

Although I have tried to do the best and try to do all the things that are possible in an
online System, but still the system contains some of the limitations.
The reason of these limitations is the time constraints. Time is the major problem. I
have to deliver the project in a particular time period. That’s way I have to leave
some of the topics that actually I want to cover, I am still working on this software
and my next goal is to remove these limitations and develop a more efficient and
elegant system.

Limitations of the System:

1. This project does not give the information about the stock (quantity) present
within the shop.
2. This project does not create monthly, yearly Reports.
After removing these and other minor limitations I hope this project will very efficient and
effective.

CONCLUSION :

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 25

After completing this project I came to a conclusion that the computer
programming appears catchy if and only if the problem is difficult. I concluded that the
approach, which is predefined and presumed.

From a proper analysis of positive points and constraints on the component, it

can be safely concluded that the product is a highly efficient GUI based component. This
component can be easily plugged in many other systems. Also the component is user
friendly.

Neither the help nor the beautification of the problem says anything. It is the
common logic, which is applied with some common sense, which blends together to
develop the mental approach of person.

BIBLIOGRAPHY

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 26

This document contains provisions which, through reference in this text, constitute
provisions of the present document.

1) Google Search Engine for various searching

2) Tata McGraw Hill’s Oracle 10g Database

3) Kevs PHP- MYSQL

4) Wrox Press – Beginning PHP5

5) Online at www.w3schools.org

Ankur sharma, B.Tech IV(C.S.), Roll No. – 07ESTCS007 Page 27