Simple Bakery Shop Management System in PHP MySQL
Description
The Bakery Shop Management System is a simple web-based application platform for bakery shops that can help them to manage their stocks and day-to-day transaction with their customers.
About the System
This automated platform was developed using PHP/OOP and MySQL Database. It allows the management to store their product stocks and has a POS Feature. The following were used to develop this user-friendly features and functionalities:
- XAMPP v3.3.0 as my local webserver that has a PHP Version 8.0.7
- PHP Language
- MySQL Database
- HTML
- CSS
- JavaScript
- jQuery
- Ajax
- Bootstrap v5 Framework
This Bakery Shop Management System in PHP and MySQL Database is only accessible to the Bakery Shop’s Management. The system requires user credentials in order for the management can access the data, features, and functionalities. It has 2 types of user roles which are the Administrators and Cashiers.
The Administrator Users are the ones who can manage the products, stocks, and categories. They also have the privilege to access and manage all the features and functionalities of what the system does.
The Cashiers are only allowed to manage transactions and list the sales report of their transactions. This has a Point of Sale feature to manage the shop’s daily sales. It has also a feature that generates a printable receipt and date-wise sales report.
Features
Admin-Side
- Login Page
- Home Page
- Summary
- Inventory/Available Stocks List
- Restock Products
- Maintenance
- Add New Category
- List All Categories
- View Category Details
- Update Category Details
- Update Category Status
- Delete Category
- Manage Product
- Add New Product
- List All Products
- View Product Details
- Update Product Details
- Delete Product
- Manage Stocks
- Add New Stock
- List All Stocks
- View Stock Details
- Update Stock Details
- Delete Stock
- Point of Sale
- Generate Printable Receipt
- Generate Printable Date-wise Sales Report
- Manage User List (CRUD)
- Manage Account Credentials
System Snapshots of some Features
Login Page
Home Page
Maintenance Page
Add New Category
Product Page
Add New Product
Stocks Page
Add New Stock
Point of Sales Page
Sales Report Page
Users List Page
Account Credentials Page
How to Run
To run this system you must have downloaded and installed a local web server such as the XAMPP or WAMP on your PC or laptop.
Installation/Setup
- Open your XAMPP/WAMP’s Control Panel and start Apache and MySQL.
- Extract the downloaded source code zip file.
- If you are using XAMPP, copy the extracted source code folder and paste it into the XAMPP’s “htdocs” directory. And If you are using WAMP, paste it into the “www” directory.
- Browse the PHPMyAdmin in a browser. i.e. http://localhost/phpmyadmin
- Create a new database naming bsms_db.
- Import the provided SQL file. The file is known as bsms_db.sql located inside the database folder.
- Browse the Bakery Shop Management System in a browser. i.e. http://localhost/bsms/.
Default Admin Access
Username: admin
Password: admin123
i have failed to login into the system,what should i do to get the password
how do i fix the stocks? even when the stocks are 0, you can still sell the products
Uncaught mysqli_sql_exception: Unknown database ‘bsms_db’ in C:\xampp\htdocs\bsms\DBConnection.php:6 Stack trace: #0 C:\xampp\htdocs\bsms\DBConnection.php(6): mysqli->__construct(‘localhost’, ‘root’, Object(SensitiveParameterValue), ‘bsms_db’) #1 C:\xampp\htdocs\bsms\DBConnection.php(34): DBConnection->__construct() #2 C:\xampp\htdocs\bsms\login.php(7): require_once(‘C:\\xampp\\htdocs…’) #3 {main} thrown in C:\xampp\htdocs\bsms\DBConnection.php on line 6
Warning: mysqli::__construct(): (HY000/1049): Unknown database ‘bsms_db’ in C:\wamp64\www\bsms\DBConnection.php on line 6
Call Stack
change “bsms_db” to “bsms_db.” so u need to add the dot and don’t forget to change that also at the database in phpmyadmind , it worked for me
Nice Software.
I need sum of total amount in sales report. How do I develop that. I am new in PHP. Please help me.
Hello I can help 💯 Nord Script, Installation procedure
Banking System Tools
Social Media Account Retrieving Tools
Spam Bot Hacking Tools
My WhatsApp Cell 📲
+1(314)328-9650