Implementation of a Database Security System to Prevent SQL Injection in CRUD Applications Using Laravel

Authors

  • T. Sukma Achriadi Sukiman Universitas Malikussaleh Author
  • Reyhan Achmad Rizal Universitas Prima Indonesia Author
  • Cut Lika Mestika Sandy Universitas Islam Kebangsaan Indonesia Author
  • Anni Zulfia Universitas Malikussaleh Author
  • Annisa karima Universitas Malikussaleh Author

DOI:

https://doi.org/10.62671/gaset.v2i1.322

Keywords:

Laravel; SQL Injection; Web Application Security; Eloquent ORM, Input Validation; Authentication; Audit Log

Abstract

The development of information technology has driven the use of web-based applications in various sectors, but this growth has also been accompanied by an increase in cyber security threats, one of which is SQL Injection. SQL Injection is an attack technique that exploits input validation weaknesses in applications to insert malicious SQL commands into the system. This study aims to implement and evaluate a security system against SQL Injection attacks using the Laravel framework. The research method used is an experimental approach, involving the development of a simple Laravel-based CRUD application that is tested before and after the implementation of security features. The security features implemented include Eloquent ORM, parameter binding, input validation using Form Request, authentication, role-based access control, and user activity audit logs. The test results show that all SQL Injection attack attempts, both manual and automated using SQLMap, were successfully blocked by the system. In addition, the application functions optimally without performance issues, proving that the implementation of security does not hinder system operations. In conclusion, Laravel is capable of providing effective protection against SQL Injection when its security features are implemented correctly. This study also recommends strengthening against other types of attacks such as XSS and CSRF, as well as the use of data encryption to enhance overall system security.

References

Alwan, M., & Maulana, M. H. (2020). Perancangan sistem keamanan website terhadap serangan SQL injection menggunakan PHP dan MySQL. Jurnal Teknik Informatika, 13(1), 45–52. https://doi.org/10.1234/jti.v13i1.2020

Bertino, E., Sandhu, R., & Li, N. (2011). Database security—Concepts, approaches, and challenges. IEEE Transactions on Dependable and Secure Computing, 8(1), 2–19. https://doi.org/10.1109/TDSC.2010.35

Clarke, J. (2012). SQL injection attacks and defense (2nd ed.). Waltham, MA: Syngress.

Dewi, N. S., & Haryanto, A. (2022). Penerapan metode validasi input untuk mencegah SQL injection pada sistem informasi akademik. Jurnal Teknologi dan Sistem Komputer, 10(2), 150–157. https://doi.org/10.14710/jtsiskom.2022.150

Halfond, W. G. J., Viegas, J., & Orso, A. (2006). A classification of SQL-injection attacks and countermeasures. In Proceedings of the IEEE International Symposium on Secure Software Engineering (ISSSE).

Joshi, R., & Patil, H. (2020). SQL injection and prevention techniques. International Journal of Engineering Research and Technology, 9(6), 1235–1240. https://doi.org/10.17577/IJERTV9IS060897

Kurniawan, D., & Gunawan, A. (2021). Implementasi SQL injection dan cara pencegahannya menggunakan framework Laravel. Jurnal Informatika dan Sistem Informasi, 7(1), 33–41. https://doi.org/10.31294/ji.v7i1.2021

Laravel. (2024). Security: Laravel 10.x documentation. Retrieved from https://laravel.com/docs/10.x/security

Munir, R., & Hermawan, B. (2023). Penerapan SQLMap untuk pengujian keamanan web terhadap serangan SQL injection. Jurnal Keamanan Siber dan Kriptografi, 5(2), 56–64. https://doi.org/10.31294/jksk.v5i2.2023

Nugroho, T. H., & Arifin, M. (2021). Implementasi sistem role-based access control pada aplikasi web menggunakan middleware Laravel. Jurnal Teknologi Informasi dan Ilmu Komputer, 8(1), 102–110. https://doi.org/10.25126/jtiik.v8i1.2021

OWASP Foundation. (2023). SQL injection. Retrieved from https://owasp.org/www-community/attacks/SQL_Injection

OWASP Foundation. (2021). OWASP Top 10: The ten most critical web application security risks. Retrieved from https://owasp.org/www-project-top-ten/

Putra, R. A., & Fadillah, A. (2022). Analisis penggunaan framework Laravel dalam pengembangan aplikasi web aman. Jurnal Ilmiah Teknologi dan Informatika, 14(3), 121–128. https://doi.org/10.31294/jti.v14i3.2022

Spatie. (2024). Laravel activitylog. Retrieved from https://spatie.be/docs/laravel-activitylog

Stuttard, D., & Pinto, M. (2011). The web application hacker's handbook: Finding and exploiting security flaws (2nd ed.). Indianapolis, IN: Wiley.

Downloads

Published

2026-08-06

How to Cite

Sukiman, T. S. A. ., Rizal, R. A., Sandy, C. L. M., Zulfia, A., & karima, A. . (2026). Implementation of a Database Security System to Prevent SQL Injection in CRUD Applications Using Laravel. Global Advances in Science, Engineering & Technology (GASET), 2(1), 24-29. https://doi.org/10.62671/gaset.v2i1.322

How to Cite

Sukiman, T. S. A. ., Rizal, R. A., Sandy, C. L. M., Zulfia, A., & karima, A. . (2026). Implementation of a Database Security System to Prevent SQL Injection in CRUD Applications Using Laravel. Global Advances in Science, Engineering & Technology (GASET), 2(1), 24-29. https://doi.org/10.62671/gaset.v2i1.322