Implementation of PHP Native and MySQL for a Web-Based Hardware Inventory System at PT Prabutirta

Authors

  • M. Ridho Firmansyah✉ Department of Informatics Management, Department of Information Technology, Politeknik Negeri Lampung Author
  • Dwirgo Sahlinal Department of Informatics Management, Department of Information Technology, Politeknik Negeri Lampung Author
  • Henry Kurniawan Department of Informatics Management, Department of Information Technology, Politeknik Negeri Lampung Author
Diajukan 28 Des 2025 Diterbitkan 30 Jan 2026
DOI: https://doi.org/10.59025/42825c6d

Keywords:

web-based inventory, PHP Native, MySQL, Waterfall, User Acceptance Testing

Abstract

PT Prabutirta Jaya Lestari, a Bottled Water (AMDK) producer in Lampung, manages 152 hardware units across divisions through ledger and spreadsheet records that are prone to data duplication, document loss, and consume an average of 35 minutes per day solely for stock report recapitulation. This study designs and builds a web-based inventory application using the PHP Native 8.x, MySQL 8.0, and XAMPP stack, with a five-stage Waterfall development method. A three-tier architecture separates the presentation, business logic, and database layers, while post-INSERT MySQL triggers automatically update stock whenever incoming or outgoing transactions are recorded. System validation was performed at two levels: blackbox testing on 18 test cases across six core modules and a five-dimension User Acceptance Testing (UAT) with four internal respondents. Results show a blackbox success rate of 100% and an average UAT score of 90.0% — an increase of 40.0 percentage points compared with the manual system (50.0%). The efficiency dimension recorded the highest gain (+44.0 points) because the 35-minute daily recapitulation was successfully reduced to an automated process of less than one second. These findings provide a practical PHP Native and MySQL blueprint for digital inventory transformation in medium-scale AMDK manufacturing.

References

  1. H. Christanto dan R. Somya, "Sistem Informasi Berbasis Web Menggunakan Framework Laravel pada Rancangan Sistem Inventory Gudang," Jutisi: Jurnal Ilmiah Teknik Informatika dan Sistem Informasi, vol. 12, no. 3, hal. 1204-1214, 2023.
  2. I. Hilmi, A. Latifa, D. H. Pertiwi, Subhiyanto, dan D. Kasoni, "Sistem Informasi Stok Barang Gudang MAMA Mart Berbasis Web," Jurnal Sistem Informasi STMIK Antar Bangsa, vol. 14, no. 1, hal. 1-8, Feb. 2025.
  3. Erik, F. Putra, dan Yusran, "Rancang Bangun Sistem Informasi Inventaris Berbasis Web pada Laboratorium UNDHARI," Jurnal Akademi Teknologi, vol. 4, no. 1, 2025, doi: 10.51903/aybzsc29.
  4. F. Anggita, Mustika, dan Pujianto, "Perancangan Sistem Informasi Persediaan Barang pada One Coffee Metro Berbasis Web," Jurnal Manajemen Sistem Informasi (JMSI), vol. 7, no. 1, hal. 1-12, 2025.
  5. M. Haries, "Sistem Informasi Layanan Aduan Masyarakat Berbasis PHP MySQL pada Kantor Kepala Desa Panggoi," J-SIMTEK: Jurnal Sistem Informasi, Manajemen dan Teknologi Informasi, vol. 2, no. 2, hal. 89-98, Jul. 2024.
  6. E. Kurniawati dan A. Ikhwan, "Perancangan Sistem Informasi Manajemen Inventaris Kontrol Stok Barang Berbasis Web," Jurnal Teknologi Sistem Informasi dan Aplikasi, vol. 6, no. 3, hal. 408-415, Jul. 2023, doi: 10.32493/jtsi.v6i3.30881.
  7. T. A. Novilasari, "Penerapan Sistem Informasi Inventori Barang Berbasis Web pada Gudang Rumah Sakit Bhakti Asih Tangerang," Jurnal Sistem Informasi STMIK Antar Bangsa, vol. 13, no. 2, hal. 112-120, Agu. 2023.
  8. H. Manik, "Inventory Information System: Optimizing Inventory Management for Company Business Sustainability," Information Technology and Systems, vol. 1, no. 1, hal. 26-35, 2023, doi: 10.58777/its.v1i1.126.
  9. J. Kaushik, "An Inventory Model for Deteriorating Items with Blockchain Process: How Will It Transform Inventory Management System," Cogent Business & Management, vol. 12, no. 1, hal. 1-18, 2025.
  10. A. Carolina dan R. H. N, "Optimizing Data Input Process to Improve System Reliability in PT.BIG Warehouse Management," Business and Investment Review (BIREV), vol. 3, no. 2, hal. 25-37, 2025, doi: 10.61292/birev.160.
  11. Pujianto, Mujito, dan D. Irawan, "Rancang Bangun Sistem Informasi Manajemen Aset Berbasis Web," Jurnal Manajemen Sistem Informasi (JMSI), vol. 6, no. 2, hal. 415-428, Jun. 2025.
  12. M. Maghfiro dan A. Homaidi, "Perancangan Sistem Informasi Inventaris di Kantor Desa Sumberanyar," JUSTIFY: Jurnal Sistem Informasi Ibrahimy, vol. 3, no. 2, hal. 141-149, Jan. 2025, doi: 10.35316/justify.v3i2.5892.
  13. I. Zikri dan Y. Ramadhani, "Perancangan Sistem Informasi Inventory Stock Barang Berbasis Web di Toko Saltika Mendahara Tengah Tanjung Jabung Timur," Juktisi: Jurnal Komputer Teknik Informatika dan Sistem Informasi, vol. 4, no. 2, hal. 11227-11235, Sep. 2025, doi: 10.62712/juktisi.v4i2.614.
  14. Fauziah, "Sistem Informasi pada Persediaan Barang Berbasis Web di Frozen Food," Jurnal Sistem Informasi dan Teknologi, vol. 2, no. 2, hal. 177-181, 2022.
  15. F. Herik, Kristina, dan T. Willay, "Rancang Bangun Sistem Informasi Persediaan dan Penjualan Barang pada Toko Herik Berbasis Web," Jurnal InTekSis, vol. 12, no. 5, hal. 1-12, 2025.
  16. R. N. P. Pratama dan Tukino, "Rancang Bangun Sistem Informasi Penjualan Komputer Berbasis CodeIgniter Framework," JSiI: Jurnal Sistem Informasi, vol. 9, no. 2, hal. 150-158, Sep. 2022, doi: 10.30656/jsii.v9i2.5042.
  17. T. H. A. Hadi dan R. Kartadie, "Sistem Informasi Point of Sales Berbasis CodeIgniter," Jurnal Manajemen Informatika & Sistem Informasi (MISI), vol. 8, no. 2, hal. 1-10, Jun. 2025, doi: 10.36595/misi.v5i2.
  18. D. N. Sari, V. Amalia, dan D. Apriadi, "Penerapan Metode Waterfall dalam Perancangan Sistem Informasi Penjualan dan Persediaan Barang," Juktisi, vol. 4, no. 2, hal. 621-630, Sep. 2025, doi: 10.62712/juktisi.v4i2.489.
  19. V. Apriana dan U. Nurhasanah, "Implementasi Metode Waterfall pada Sistem Informasi Penjualan Berbasis Web," AKASIA: Artikel Ilmiah Sistem Informasi Akuntansi, vol. 1, no. 2, hal. 106-111, Okt. 2021.
  20. R. N. Yuniar dan M. Muharrom, "Rancang Sistem Informasi Inventaris Sekolah pada SMK 1 Perguruan Cikini Menggunakan Metode Prototype," JSITIK, vol. 2, no. 1, hal. 1-14, Des. 2023, doi: 10.53624/jsitik.v2i1.280.
  21. R. Aryaputra dan K. D. Hartomo, "Sistem Informasi Persediaan Suku Cadang Menggunakan Model Proses Scrum," Jurnal Teknik Informatika dan Sistem Informasi, vol. 10, no. 1, hal. 860-874, Mar. 2023.
  22. V. Mulyani dan S. Hidayatulloh, "Analisis Usability Sistem Aplikasi Kredit Digital dengan Pendekatan USE Questionnaire dan IPA," Jurnal Sistem Informasi STMIK Antar Bangsa, vol. 12, no. 1, hal. 1-10, Jan. 2023.
  23. S. A. Markov, V. V. Zinchenko, dan N. V. Kozlovtseva, "Automated Inventory Management System for a Machine-Building Enterprise," Izvestia VolGTU, no. 1 (284), hal. 46-50, 2024, doi: 10.35211/1990-5297-2024-1-284-46-50.
Cover JTDS Vol 4 No 1 (2026)

Downloads

How to Cite

Implementation of PHP Native and MySQL for a Web-Based Hardware Inventory System at PT Prabutirta. (2026). Journal of Technology and Data Science, 4(1), 270-284. https://doi.org/10.59025/42825c6d