MySQL | Shahabuddin Amerudin @ UTM

Free Online Guide: Uploading a Website with PHP and MySQL Database

By Dr. Shah • August 17, 2023 • Knowledge, Public, Teaching • database, free, MySQL, online, PHP, website • 1 minute of reading

In this tutorial, the video creator will walk you through the steps of uploading your website with a database for free, without requiring any financial investment. The video creator has previously designed a signup-login website using PHP and MySQL, and now they will illustrate the process of effectively deploying it online. By meticulously adhering to the instructions provided in the video, you can ensure that your website and its associated database are accessible to a global audience. Be assured that individuals with a stable internet connection can easily access your website from various devices such as smartphones and PCs. For […]

Free Online Guide: Uploading a Website with PHP and MySQL Database Read More »

Development of A Web Map-Based Muslim Cemetery Application in Kangkar Pulai

By Dr. Shah • July 28, 2023 • Personal, Project, Public, Research, Teaching • cemetery, development, FYP, grave, Kangkar, MySQL, PHP, PSM, Pulai, website • 2 minutes of reading

Alhamdulillah… Praise be to God, and with His blessings, I am delighted to share the successful completion of another undergraduate dissertation under my supervision. Muhammad Syafiq bin Mat Tahir, a student pursuing a Bachelor of Science in Geoinformatics during the session 2022/2023, has accomplished a remarkable project titled “Development of A Web Map-Based Muslim Cemetery Application in Kangkar Pulai.” Throughout his project, Muhammad Syafiq skillfully designed a website accessible through the URL: https://kppusara.kstutm.com. This website serves as an invaluable resource for the public, enabling them to effortlessly search for grave information and precise locations within Kampung Melayu Kangkar Pulai, Johor.

Development of A Web Map-Based Muslim Cemetery Application in Kangkar Pulai Read More »

KPpusara Website: Laman Web Tanah Perkuburan Melayu Kangkar Pulai

By Dr. Shah • July 28, 2023 • Project, Research, Teaching • cemetery, FYP, grave, management, MySQL, PHP, PSM, website • 3 minutes of reading

By Shahabuddin Amerudin URL: https://kppusara.kstutm.com Presenting the remarkable and forward-thinking project developed by Muhammad Syafiq bin Mat Tahir, a final year student pursuing a Bachelor of Science in Geoinformatics during the session 2022/2023, under the expert guidance of Dr. Shahabuddin bin Amerudin. The culmination of his academic journey resulted in the creation of an ingenious web map-based Muslim Cemetery application for Kampung Melayu Kangkar Pulai, Johor. Muhammad Syafiq’s unwavering dedication to this project is evident in the two intensive semesters he spent meticulously crafting every aspect of the application. He commenced with an in-depth user requirement analysis, engaging with the

KPpusara Website: Laman Web Tanah Perkuburan Melayu Kangkar Pulai Read More »

Understanding Indexing in MySQL

By Dr. Shah • March 11, 2023 • Knowledge, Research, Teaching • automatic, indexing, MySQL • 3 minutes of reading

Here, index_name is the name of the index you want to create, table_name is the name of the table on which you want to create the index, and (column1, column2, …) specifies the column or columns on which you want to create the index. For example, to create an index on the customer_name column in the customers table, you can use the following SQL statement: This will create an index called idx_customer_name on the customer_name column in the customers table. It’s important to note that creating indexes can improve query performance, but it can also have negative effects on write

Understanding Indexing in MySQL Read More »