Implementation of a Database Security System to Prevent SQL Injection in CRUD Applications Using Laravel
DOI:
https://doi.org/10.62671/gaset.v2i1.322Keywords:
Laravel; SQL Injection; Web Application Security; Eloquent ORM, Input Validation; Authentication; Audit LogAbstract
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.



