The Blocks Project is a CRUD (Create, Read, Update, Delete) database application developed using PHP, HTML, CSS, and XAMPP. It provides role-based access control for managing products and viewing order details. Key features include adding, updating, and deleting products, as well as displaying orders and their details, making it a comprehensive tool for inventory and order management.
-
Role-Based Access Control:
- Different access levels for admins and staff.
- Admins can access all functionalities, while staff roles have limited permissions.
-
Product Management:
- Add new products to the database.
- Update existing product details.
- Delete products from inventory.
-
Order Management:
- View all orders.
- Access detailed information for each order.
-
Frontend:
- HTML
- CSS
-
Backend:
- PHP
-
Database:
- MySQL (via XAMPP)
Follow these steps to set up the project locally:
-
Clone the Repository:
git clone https://github.com/Sadab14/blocks_project.git
-
Set Up XAMPP:
- Download and install XAMPP: https://www.apachefriends.org/index.html.
- Start the Apache and MySQL services from the XAMPP Control Panel.
-
Move Project Files:
- Copy the
blocks_projectfolder to thehtdocsdirectory in your XAMPP installation (e.g.,C:\xampp\htdocs\blocks_project).
- Copy the
-
Import Database:
- Open phpMyAdmin.
- Create a new database (e.g.,
blocks_inventory). - Import the provided SQL file (
blocks_inventory.sql) located in the project folder.
-
Configure Database Connection:
- Open the
DBconnect.phpfile in the project. - Update the database credentials:
$servername = "localhost"; $username = "root"; $password = ""; $dbname = "blocks_inventory";
- Open the
-
Access the Project:
- Open your browser and go to http://localhost/blocks_project.
We extend our gratitude to the contributors of this project: