Book Store Using PHP and MySQL Source Code ( Final Year)

Admin Features

• In the Online Book Store project developed using PHP and MySQL, the admin panel likely includes the following core features for managing the online store:

• 1. Admin Login:

• Secure Access: Admins can log in using credentials (admin_user_name and admin_password). This limits access to authorized users only.
• Session Management: Admins remain logged in until they choose to log out or the session expires.

• 2. Dashboard:

• Overview: Displays key metrics, such as the number of books, authors, and categories available in the store.
• Admin Shortcuts: Quick links to the main admin functions for efficient navigation.

• 3. Manage Books:

• Add Books: Admins can add new books to the store by filling out details like title, author, category, price, and description.
• Edit Books: Update details of existing books (title, price, author, description).
• Delete Books: Remove books from the store if they are no longer available.
• Search Books: Search for specific books by title or other criteria.

• 4. Manage Authors:

• Add Authors: Add new authors to the store database, which will be associated with books.
• Edit Authors: Modify existing author details (e.g., name, biography).
• Delete Authors: Remove an author from the system, potentially with a check to ensure no books are dependent on them.

• 5. Manage Categories:

• Add Categories: Create new categories for books (e.g., Fiction, Science, History) to help users navigate the store.
• Edit Categories: Change existing category details like names.
• Delete Categories: Remove categories that are no longer needed or consolidate similar categories.

• 6. Search Functionality:

• Search Books: Allows searching for books based on title, category, or author.
• Filter Results: Admins can filter search results based on various parameters (e.g., category, price range).

• 7. Logout:

• Session Termination: Safely ends the admin's session, ensuring that unauthorized users cannot access the admin panel.

User Features

• The Online Book Store project, developed using PHP and MySQL, allows users and administrators to interact with the system. Below are the key features for users in this project:

• User Features:

• User Registration and Login:
• Users can register a new account and log in to access the book store's features.
• Passwords are validated during login for security.
• Book Browsing and Search:
• Users can browse through the available books in different categories.
• Users can search for books by title, author, or category using the search functionality.
• View Book Details:
• Users can view detailed information about each book, such as the author, description.

Other Features

• Not Available

How to run Book Store Using PHP and MySQL

• To run the Online Book Store - PHP & MySQL Project from the repository, follow these steps:

• Prerequisites:

• Web Server: Install a local server like XAMPP or WAMP.
• PHP: Ensure you have PHP installed (XAMPP/WAMP includes PHP).
• MySQL: Ensure MySQL is running (comes with XAMPP/WAMP)

• Move the Project to the Web Server:

• If you are using XAMPP, move the downloaded or cloned project folder to C:\xampp\htdocs\.
• For WAMP, move it to C:\wamp\www\
•  

• 3. Import the Database:

• Open phpMyAdmin by going to http://localhost/phpmyadmin in your browser.
• Create a new database, e.g., online_book_store.
• Import the SQL file into this database:
• In phpMyAdmin, go to the Import tab.
• Choose the file online_book_store_db.sql (located in the project folder).
• Click on Go to import.

• Start Apache and MySQL:

• Open XAMPP or WAMP and start Apache and MySQL services.
• In XAMPP, click "Start" next to Apache and MySQL.

Credentials

• Admin Username: [email protected]
• Admin Password: 12345

License

Book Store Using PHP and MySQL Source Code Tags