INTRODUCTION:
Online shopping is the process whereby consumers directly buy goods, services etc.from a
seller interactively in real-time without an intermediary service over the internet.Online
shopping is the process of buying goods and services from merchants who sellon the Internet.
Since the emergence of the World Wide Web, merchants have sought to selltheir books to
people who surf the Internet. Shoppers can visit web stores from the comfort oftheir homes
and shop as they sit in front of the computer. Consumers buy a variety of itemsfrom online
stores. In fact, people can purchase just about anything from companies thatprovide
their books online. Books, clothing, household appliances, toys, hardware, software,and health
insurance are just some of the hundreds of books consumers can buy from an onlinestore.Many
people choose to conduct shopping online because of the convenience. Forexample,
when a person shops at a brick-and-mortar store, she has to drive to the store, find aparking
place, and walk throughout the store until she locates the books she needs.
Afterfinding the items she wants to purchase, she may often need to stand in long lines at the
cashregister.
1.EXISTING SYSTEM:
The current system for book shoping in people have to physically visit the
bookshops or vendors for purchasing books of their need and have to make payment through
cash mode most of the times due to unawareness of advanced technologies at certain places.
In this method time as well as physical work is required, among which time is something that
no one has an ample amount. The traditional book purchasing procedure is not efficient enough
for shopkeepers as well as customers, as they have to deal with the crowd, in their shops. The
old methods are classified into two ways where the most popular one was you need to go to
the shop and ask the shopkeeper for the book.
pg. 1
If he has that book then he will give you and demand money, which could be more than you
thought for. The other one is if you know any retailer or shopkeepers you can directly contact
him on phone and ask him to give you that books at your place and take the money and extra
convenience charges of transportation.
These both the methods are slow and cost you more sometimes if you are a novice in marketing
or purchasing any new thing.
2.LIMITATION OF EXISTING SYSTEM:
• It is less user-friendly.
• It is difficult to identify the required product.
• Description of the product limited.
• This process is so much time-consuming and does not provide trust in
retailer.
• Not in reach of distance users.
pg. 2
PROPOSED SYSTEM
1.INTRODUCTION :
Online Book store is an online web application where the customer can purchase books online.
Through a web browser the customers can search for a book by its title can add to the shopping cart and
finally purchase using credit card,cash,paytm transaction. The user can login using his account details or
new customers can set up an account very quickly. They should give the details of their name, contact
number and shipping address. The user can also give feedback to a book by giving ratings on a score of
five.
The Online Book Store Website provides customers with online shopping through a web browser. A
customer can, create, sign in to his account, place items into a shopping cart and purchase using his credit
card details.
The Administrator will have additional functionalities when compared to the common user. He can add,
delete and update the book details, member information and also confirm a placed order.
This application is developed using :- HTML
CSS
,JQUERY
PHP
2.Project Profile
This website contain two mainstream:- USER
ADMIN
USER has the following functionalities:
pg. 3
• Home page:
This is the page where the user will be navigated after a successful
login. It will display all the books and will have a search keyword
option to search for the required book. It also includes some special
sections like about,shop,contact,order,cart,search.
• About page:
This is the page if the user wants to give rating according to his
opinion for a book. And this page show the great author.and detail
related organsior of the website.
• Contact page:
This is the page in users can intract with administrator.user can send
book and website related message to administrators.
• Order page:
If the user wants to purchase a book then he can place an order by
selecting the add to shopping cart button and entering the quantity
required under the book description.
• Search page:
A user can search for a book of his choice by selecting title. Then a
select query is used to retrieve data from the database and display
the selected information.
• Shopping cart:
pg. 4
The user can manage a shopping cart which will include all the
books he selected. The user can edit, delete and update his shopping
cart. A final shopping cart summary is which includes all the items
the user selected and the final total cost.
• Register:
If the user doesn’t have an account then he will be asked to register.
After registration the user will be directed to the login page.
• Login:
If the user wants to get access to all the functionalities of Online
Book Store he should login using his username and password.
• Logout:
If the user wants to end his session and sign out of the website then
he can use the logout option.
ADMIN has the following functionalities:
• Login:
If the Administrator wants to get access to all the functionalities of
Online Book Store he should login using his username and
password.
• Home page:
This page in Administrator show the how many product
added,normal user,admin user,total pending,total
completed,order placed,total message,total users.
• Product page:
pg. 5
If the Administrator wants to add or delete a book then he can insert
or delete a books using his administration rights and the products
table will be updated in the database.
• Manage orders:
If the Administrator wants to update or delete an order then he can
update or delete an order using his administration rights and the
orders table will be updated in the database.
• Mange users:
If the Administrator wants to add or delete a users then he can insert
or delete a users using his administration rights and the users table
will be updated in the database.
• Mange message:
If the Administrator wants to delete a message then he can delete a
message using his administration rights and the message1 table will
be updated in the database.
2.BASIC FUNCTIONALITY OR SCOPE & OBJECTIVE :
Functionality:
• Provides the searching facilities based on various factors. Such as books.
• Online book store manage the order details,books.
• Manage the information of the books and customer.
• Manage the information of order.
• To increase efficiency of managing the books.
Scop:
pg. 6
• To provides users to purchase book online.
• Easy to understand by the user and operator.
• To provide users friendly environment.
• To provide faclitiy of user feedback
.
Objective::
The main objective of the project is to create an online book store that
allows users to search and purchase a book based on title, author and
subject. The selected books are displayed in a tabular format and the user
can order their books online through credit card payment. The
Administrator will have additional functionalities when compared to the
common user.
3.LIMITATION:
• The project does not store transaction. So the buyer will not able to make
any references to past transactions.
• Cash on deliver not present.
pg. 7
INTRODUCTION TO DEVLOPMENT ENVIRONMENT
1.WHAT IS PHP?
PHP is an open-source, interpreted, and object-oriented scripting language that can be
executed at the server-side. PHP is well suited for web development. Therefore, it is used
to develop web applications.
o PHP stands for Hypertext Preprocessor.
o PHP is an interpreted language, i.e., there is no need for compilation.
o PHP is faster than other scripting languages, for example, ASP and JSP.
o PHP is a server-side scripting language, which is used to manage the dynamic
content of the website.
o PHP can be embedded into HTML.
o PHP is an object-oriented language.
o PHP is an open-source scripting language.
o PHP is simple and easy to learn language.
2.WHAT CAN PHP DO?
o PHP can generate dynamic page content.
o PHP can collect form data.
o PHP can send and receive cookies.
o PHP can add, delete, modify data in your database.
o PHP can be used to control user-access.
o PHP can encrypt data.
o PHP runs on various platforms (Windows, Linux, Unix, Mac OS X, etc.)
o PH is compatible with almost all servers used today (Apache, IIS, etc.).
o PHP supports a wide range of databases.
o PHP is easy to learn and runs efficiently on the server side.
pg. 8
3.MYSQL SERVER
o The MySQL server works in a client and server system.
o MySQL is a database system used on the web.
o MySQL is a database system that runs on server.
o MySQL is ideal for both small and large applications.
o MySQL is very fast, reliable, and easy to use.
o MySQL uses standard SQL.
o The data in a MySQL database are stored in tables. A table is a collection
of related data, and it consists of columns and rows.
o PHP combined with MYSQL are cross-platform.
o PHP connect to MySQL by using mysqli_connect().
o The MySQL server works in a client and server system.
pg. 9
SYSTEM DESIGN:
1.TASK DEPENDENCY DIAGRAM
pg. 10
2.DATA FLOW DIAGRAM:
pg. 11
pg. 12
ENTITY RELATIONSHIP MODEL
pg. 13
3.DATA TABLE:
• Users
Column Type Size Default
id int 100 Primary-key
name varchar 100
email varchar 100
password varchar 50
user_type varchar 20 user
pg. 14
• Products
Column Type Size Default
id int 100 Primary-key
name varchar 100
price int 100
image varchar 100
• Orders
Column Type Size Default
id Int 100 Primary-key
user_id Int 100
name varchar 100
number varchar 12
email varchar 100
method varchar 50
address varchar 500
total_products varchar 1000
total_price Int 100
placed_on Varchar 50
payment_status varchar 20 pending
pg. 15
• Cart
Column Type Null Default
id Int 100 Primary-key
user_id int 100
name varchar 100
price int 100
quantity int 100
image varchar 100
• Message1
Column Type Null Default
id int 100 Primary-key
user_id int 100
name varchar 100
email varchar 100
number varchar 12
message varchar 500
USER INTERFACE
pg. 16
Registration page
Login page
pg. 17
Home page
pg. 18
About
pg. 19
Shop
pg. 20
Contact
pg. 21
Cart
pg. 22
Checkout
pg. 23
Order
pg. 24
Search
pg. 25
Logout
Admin home
pg. 26
Product
pg. 27
Order
Users
pg. 28
Message/logout
BIBLIOGRAPHY :- Youtube , W3school
pg. 29