Book Store Management Using PHP and MySQL

• Admin login and logout in this final year project
• Admin dashboard with total users, books, orders, low-stock titles, and unresolved contacts
• Recent orders table
• Brand / publisher CRUD management
• Add publisher or brand
• Edit publisher details
• Delete unused publisher records
• Deactivate publishers when books are linked
• Search publisher list
• View book count per publisher
• Category CRUD management
• Add category
• Edit category
• Delete unused category
• Deactivate category when books are linked
• Search category list
• Book CRUD management
• Add book details
• Edit book details
• Delete book records
• Manage title, author, ISBN, description, category, publisher, price, discount, and stock
• Upload book cover image
• Set book active/inactive status
• Set featured book flag
• Search books by title, author, or ISBN
• Paginate book records
• Manual stock adjustment
• User management
• View registered users
• Search users
• View user order count
• Block/unblock user accounts
• Reset user password manually
• Order management
• View all orders
• Search orders by order ID, customer name, or email
• Filter orders by status
• View order detail
• Update order status
• Update payment status
• Cancel orders when applicable
• Restore stock after eligible cancellation
• Generate printable HTML invoice
• Review management
• View all reviews with user and book context
• Hide reviews
• Show reviews
• Delete reviews
• Contact message management
• View contact form messages
• Mark messages as resolved/unresolved
• Delete contact messages
• FAQ management
• Add FAQ
• Edit FAQ
• Manage FAQ sort order
• Activate/deactivate FAQ
• Delete FAQ
• Store settings management
• Update store name
• Update footer text
• Update low-stock threshold
• Admin audit logs
• View admin action logs
• Filter logs by date range
• Change admin password

• Customer registration in this final year project
• Customer login and logout
• Forgot password using email OTP
• Six-digit OTP verification
• OTP validity for password reset
• Change password after login
• Profile view and update
• Update display name
• Update mobile number
• View read-only email
• Address management
• Add delivery address
• Delete delivery address
• Set default delivery address
• Browse homepage
• View featured books
• View latest books
• Search books from header
• Browse all books
• Search books by title, author, or ISBN
• Filter books by category
• Filter books by brand/publisher
• Filter books by minimum and maximum price
• Filter in-stock and out-of-stock books
• Sort books by newest
• Sort books by price low to high
• Sort books by price high to low
• Sort books by title A to Z
• Browse categories
• Browse publishers
• View book detail page
• View book title, author, ISBN, description, category, publisher, price, discount, sale price, stock, and cover image
• View average rating and review list
• Add book to cart
• Update cart quantity
• Remove cart items
• View subtotal, discount amount, and grand total
• Cart quantity validation against live stock
• Checkout with saved delivery address
• Place order using Cash on Delivery
• Place order using manual / Pay Later mode
• View order history
• Filter orders by status
• View order details
• Cancel orders while allowed
• Inventory restored after eligible cancellation
• Add books to wishlist
• Remove books from wishlist
• Move wishlist item to cart
• Submit review for purchased books
• Edit own review
• Delete own review
• View About page
• Submit Contact form
• View FAQs

• Public homepage
• Hero section
• Featured books section
• Latest arrivals section
• Header search box
• Categories page
• Publishers / brands page
• Book listing page
• Book detail page
• Customer login page
• Customer signup page
• Forgot password page
• About page
• Contact page
• FAQ page
• Footer with admin login link
• Responsive storefront layout
• Book cover images
• Active review display
• Store name setting support
• Public homepage
• Hero section
• Featured books section
• Latest arrivals section
• Header search box
• Categories page
• Publishers / brands page
• Book listing page
• Book detail page
• Customer login page
• Customer signup page
• Forgot password page
• About page
• Contact page
• FAQ page
• Footer with admin login link
• Responsive storefront layout
• Book cover images
• Active review display
• Store name setting support
• Complete online book store source code
• Suitable for final year project, major project, and minor project
• Project report content can be prepared from included modules
• Customer Storefront and Admin Panel included
• Book catalog management
• Cart and checkout workflow
• COD and manual payment mode support
• Order status management
• Payment status management
• Wishlist management
• Review system linked to purchased books
• Admin-side review moderation
• OTP-based forgot password system
• Gmail SMTP support for OTP email
• Contact form stored in database
• FAQ content managed from admin
• Admin audit trail
• Printable invoice support
• Book stock decreases after order
• Stock restores after eligible order cancellation
• Cart persisted in database for logged-in users
• Book cover upload support under uploads/books/
• Password hashing using password_hash() and password_verify()
• PHP native sessions for users and admins
• MySQLi database queries
• No Composer required
• No frontend build step required
• Runs on typical shared hosting
• Useful for viva, source code review, project report writing, and project demonstration

1. Import database schema:

   mysql -u root -p < database/schema.sql

2. Database name:

   online_book_store

3. Edit database configuration:

   config/database.php

4. Set database details:

   DB_HOST
   DB_USER
   DB_PASS
   DB_NAME
   BASE_URL

5. If using Gmail OTP, edit:

   config/email_config.php

6. Set Gmail SMTP details:

   SMTP_USER
   SMTP_PASS

7. Run seed data:

   php database/seed.php

8. If only admin password needs reset, run:

   php database/init_admin.php

9. Start PHP built-in server from project root:

   php -S localhost:8000

10. Open:

http://localhost:8000

11. For XAMPP/WAMP, copy the project into:

htdocs/Online Book Store/

12. Set BASE_URL to:

/Online Book Store

13. Open:

http://localhost/Online%20Book%20Store/

14. Ensure upload folder is writable:

uploads/books/

Admin Account after seed/init script

• Username: admin
• Password: admin123

Admin Account after fresh schema only

• Username: admin
• Password: password

Demo Customer Account

• Email: [email protected]
• Password: demo123