WEB-BASED SALES INFORMATION SYSTEM AT ERLANGGA FURNITURE STORE USING PHP AND MYSQL WITH AN OBJECT ORIENTED PROGRAMMING APPROACH

Abstract

The rapid development of information technology demands that business actors optimize sales processes through computerized systems. Erlangga Furniture Store still relies on a manual sales system, resulting in inefficiencies in transaction recording, stock management, and reporting. This study aims to design a web-based sales information system using Object-Oriented Programming (OOP) concepts with PHP and MySQL to improve accuracy and speed in business processes. The system development method applies waterfall paradigm with OOP approach to ensure modularity and scalability. The database is designed with MySQL to store product, transaction, customer, and report data. The research stages include requirements analysis, UML design (Use Case Diagram and Class Diagram), implementation, and system testing using a localhost environment. The results show that the developed web-based system features product management, sales transactions, financial reporting, payment gateway integration, and user authentication. Functional testing confirms that all features operate according to the store's needs and significantly enhance the efficiency of sales processes by 70% with 95% data accuracy. In conclusion, this system supports the digitalization of small businesses like Erlangga Furniture Store with an intuitive interface and secure data management.