Design ERP system using PHP and MySQL to insert, update, delete and search system data.
Assumptions:
- Web Server: Assumes you have a web server installed locally.
- PHP and MySQL: Assumes PHP and MySQL are installed on your local machine.
- Database: Assumes a MySQL database named 'erp_system' is created.
- Composer: Assumes you have Composer installed for managing PHP dependencies.
Setup Instructions:
- Clone the repository.
- Create a MySQL database named erp_system.
- Import the SQL script to create the necessary tables and relationships
- Update the 'conn.php' file with your database connection details.
- Run a local server from the project root.
- Access the application in your browser.
How to Use:
- Open the browser and navigate to the project.
- Complete the forms for customer and item data, ensuring form validation is implemented.
- View lists of customers and items.
- Generate invoice reports and item reports based on specified date ranges.
- Explore the provided reports with detailed information.
Project Video Link: https://www.loom.com/share/94691ccc61be41b7934b1aa7272e3018?sid=86e52769-86ac-42f6-a6ef-f82c94ce7c94