Creating a PHP User Interface for Manipulating MySQL Databases

10th International Scientific Conference Technics, Informatics and Education – TIE 2024 , str. 27-33

АУТОР(И) / AUTHOR(S): Marija Mojsilović , Goran Miodragović , Selver Pepić ,  Muzafer Saračević

Download Full Pdf  

DOI: 10.46793/TIE24.027M

САЖЕТАК /ABSTRACT:

In today’s digital environment, accessing and manipulating data are crucial aspects of various web applications. This paper explores the process of creating a PHP user interface for efficient manipulation of MySQL databases. Accessing databases through web applications requires careful planning and implementation to ensure security, performance, and practicality. Using PHP as the server-side language and MySQL as the database, we delve into methods for creating an interactive user interface that allows users to read, write, update, and delete data in the database. The focus of the paper is on the application of basic PHP functionalities and techniques such as forms, queries, and error handling to enable a user interface that is intuitive to use and reliable in operation. Through implementation examples and performance evaluation, the key aspects of the process of creating a PHP user interface for manipulating MySQL databases are highlighted, providing guidance for optimization and improving efficiency in developing similar systems. This paper contributes to understanding techniques and practices for creating secure and functional web applications that communicate with databases, with a special focus on PHP and MySQL technologies.

КЉУЧНЕ РЕЧИ / KEYWORDS: 

PHP; MySQL; Web application; User interface

ЛИТЕРАТУРА / REFERENCES:

  1. Nixon, R. (2014). Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5. “ O’Reilly Media, Inc.“.
  2. Milošević, D., Pepić, S., Saračević, M., & Tasić, M. (2016). Weighted Moore–Penrose generalized matrix inverse: MySQL vs. Cassandra database storage system. Sādhanā, 41, 837-846.
  3. Meloni, J. C. (2008). Sams teach yourself PHP, MySQL and Apache all in one. Pearson Education India.
  4. Mojsilović, M., Pepić, S., & Miodragović, G. (2022). Implementation of embedded messages using steganography in the PHP software package. Technics and Informatics in Education–TIE, 359-370.
  5. Moore, R. J., Arar, R., Ren, G. J., & Szymanski, M. H. (2017, May). Conversational UX design. In Proceedings of the 2017 CHI conference extended abstracts on human factors in computing systems (pp. 492-497).
  6. Wu, D. (2022). The application and management system of scientific research projects based on PHP and MySQL. Journal of Interconnection Networks, 22(Supp02), 2143043.
  7. Miller, D. (2021). The best practice of teach computer science students to use paper prototyping. International Journal of Technology, Innovation and Management (IJTIM), 1(2), 42-63.
  8. Mochammad Aldi Kushendriawan, M. A. K., Harry Budi Santoso, H. B. S., Putra, P. O. H., Putra, P. O. H., & Martin Schrepp, M. S. (2021). Evaluating User Experience of a Mobile Health Application Halodoc using User Experience Questionnaire and Usability Testing. Jurnal Sistem Informasi (Journal of Information System), 17(1), 58-71.
  9. Amini, M., Rahmani, A., Abedi, M., Hosseini, M., Amini, M., & Amini, M. (2021). Com as a case study for adoption of laravel framework as the best programming tools for php based web development for small and medium enterprises. Journal of Innovation & Knowledge, ISSN, 100-110.
  10. Tatroe, K., & MacIntyre, P. (2020). Programming PHP: Creating dynamic web pages. O’Reilly Media.
  11. Tasić, M. B., Stanimirović, P. S., & Pepić, S. H. (2011). Computation of generalized inverses using Php/MySql environment. International Journal of Computer Mathematics, 88(11), 2429-2446.
  12. Verma, A., Pandey, B., Gupta, C., & Tanwar, V. K. (2022). Installation of Latest Version of NodeJS, NPM, Angular, Bootstrap, jQuery, Typescript, React in Windows 7. NeuroQuantology, 20(7), 2305.
  13. Wang, J., Xu, Z., Wang, X., & Lu, J. (2022). A comparative research on usability and user experience of user interface design software. International Journal of Advanced Computer Science and Applications, 13(8).
  14. Williams, H. E., & Lane, D. (2004). Web Database Applications with PHP and MySQL: Building Effective Database-Driven Web Sites. “ O’Reilly Media, Inc.“.
  15. Agustine, L., & Seimahuira, S. (2023). Penerapan Metode SAW dalam Analisa Perbandingan Performa Web server (Apache, Nginx, Lighttpd, Iis) pada Bahasa Pemrograman PHP. REMIK: Riset dan E-Jurnal Manajemen Informatika Komputer, 7(1), 409-420.
  16. Milivojević, M., & Zeljković, Ž. (2020). Izrada prototipa u softverskom alatu adobe experience design. Zbornik radova Fakulteta tehničkih nauka u Novom Sadu, 35(02), 250-253.
  17. Shestakov, Y. (2020). Development of robust SDKs for REST APIs in PHP. How to effectively develop, maintain and release REST API SDKs.
  18. Khan, M. Z., Zaman, F. U., Adnan, M., Imroz, A., Rauf, M. A., & Phul, Z. (2023). Comparative Case Study: An Evaluation of Performance Computation Between SQL And NoSQL Database. Journal of Software Engineering, 1(2), 14-23.
  19. Islam, K., Ahsan, K., Bari, S. A. K., Saeed, M., & Ali, S. A. (2017). Huge and Real-Time Database Systems: A Comparative Study and Review for SQL Server 2016, Oracle 12c & MySQL 5.7 for Personal Computer. Journal of Basic & Applied Sciences, 13(21), 481-490.
  20. Eisenberg, A., & Melton, J. (2000). SQL standardization: the next steps. ACM SIGMOD Record, 29(1), 63-67.