Online Book Store using PHP and MySQL
The main aim of the project is to create an online book store Management that allows users to search and purchase a book online 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. Using this Website the user can purchase a book online instead of going out to a book store and wasting time.
Online Book store Management System 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 or author, later can add to the shopping cart and finally purchase using various payment methods. 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 books are divided into many categories based on subject like fiction, nonfiction, Biography, Historical Fiction etc.
Project Requirments
Project Name | Online Book Store Management Project in PHP |
---|---|
Language Used | PHP5.6, PHP7.x |
Database | MySQL 5.x |
User Interface Design | HTML, AJAX,JQUERY,JAVASCRIPT |
Web Browser | Mozilla, Google Chrome, IE8, OPERA |
Software | XAMPP / Wamp / Mamp/ Lamp (anyone) |
Project Modules
This project contains two modules, those are
- Admin
- User
MODULES DESCRIPTION:
Admin Modules
This module provides administrator-related functionalities. The administrator manages the entire application.
Dashboard: In this section, admin can briefly view the total orders, total new orders, total packed orders, total dispatched orders, total in transit orders, total out-for-delivery orders, total delivered, total canceled and total registered users.
Category: In this section, admin can manage the category of books(add/update/delete).
Subcategory: In this section, admin can manage subcategory of books (add/update/delete).
Books: In this section, admin can manage books(add/update/delete).
About us: In this section, admin can update about us of the webpage.
Contact us: In this section, admin can update the contact us of the webpage.
Orders: In this section, admin can view the order details and they have also the right to change order status according to the current status.
Search Order: In this section, admin can search particular order with the help of the order number.
Reports: In this section admin can view order details and sales reports according to dates.
Registered Users: In this section, the admin can view registered users.
Admin can also update his profile, change the password and recover the password.
User Module
1. Book Shop: In this section, users can view which books are available on the website
2.My Accounts: In this section, users can his/her password, view and update his/her profile and log out from their accounts.
3. My orders: In this section, users can view order history after login.
4. Cart: In this section, the user can add the books which he/she wants to order.
5. Wishlist: In this section, the user can add books to the Wishlist.
6. The user has also a facility to download his/her invoice and cancel orders if he/she wants to cancel.
Brief Information about the Homepage
On this page, guest users (users who are not registered) can view the books, and search for books according to name. Guest users can also sign up and the registered users can sign in.
Some of the Project Screens
Home Page
User Sign up
User Cart
Admin Dashboard
Add Book
How to run the Online Book Store Management using PHP and MySQL
1. Download the project zip file
2. Extract the file and copy obsms
folder
3.Paste inside root directory(for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/Html)
4.Open PHPMyAdmin (http://localhost/phpmyadmin)
5. Create a database with the name obsmsdb
6. Import obsmsdb.sql
file(given inside the zip package in SQL file folder)
7. Run the script http://localhost/obsms
Admin Credential
Username: admin
Password: Test@123
Credential for User panel :
Username: jhndoe@t.com
Password: Test@123
or Register a new user.