Journal of Engineering and Science Application
Vol. 3 No. 2 (2026): Mei-Oktober

PHP-Based Stationery Sales Information System at Ufaira Printing Sigambal, Labuhanbatu

Majidur Rahman Hasibuan (Universitas Efarina)
Farida Gultom (Universitas Efarina)
Muhammad Bobbi Kurniawan Nasution (Universitas Efarina)



Article Info

Publish Date
08 Sep 2026

Abstract

Ufaira Printing in Sigambal, Labuhanbatu previously relied on manual records to manage stationery products, inventory information, customers, and sales related administration. This practice created inconsistent stock information, risk of lost records, delayed reporting, and operational decisions based on estimates rather than verified data. This study aimed to design, implement, and functionally test a PHP based stationery sales information system supported by a MySQL database. Development followed the waterfall model through requirements analysis, system and software design, coding, testing, and maintenance planning. Requirements were obtained through observation, literature study, and examination of the store's product and sales activities. The design was documented using a registration flowchart, context diagram, data flow diagram, entity relationship diagram, database tables, and interface plans. The implemented application provides customer registration, role based authentication, product and category administration, shipping expedition data, product catalog pages, and category specific displays for stationery, ink, office automation equipment, files, and furniture. Black box testing covered registration, login, logout, and product management access. All eight nonduplicative cases reported in the thesis produced the expected responses. The findings indicate that the system can organize product information and support more consistent catalog administration. However, the current evidence does not establish complete transaction processing, automatic inventory reconciliation, payment handling, security robustness, usability across users, or long term operational impact. Future work should complete these functions and evaluate data accuracy, task completion, and user experience after deployment.

Copyrights © 2026






Journal Info

Abbrev

jesa

Publisher

Subject

Aerospace Engineering Automotive Engineering Chemical Engineering, Chemistry & Bioengineering Civil Engineering, Building, Construction & Architecture Computer Science & IT

Description

Journal of Engineering and Science Application (JESA) is published by the Institute Of Advanced Knowledge and Science in helping academics, researchers, and practitioners to disseminate their research results. JESA is a blind peer-reviewed journal dedicated to publishing quality research results in ...