Week 24

 Sublime Text and HTML code for Webpage Display.

From php MyAdmin, MySQL databased are displayed and this information would be easy for a technical user to understand. However, not all users will be able to comprehend these databases. As a result of the deployment of Sublime Text and HTML, users now have access to a proper table on website. All the data is kept on the cloud, which is where the whole database will be kept.

Sublime Text  imply HTML coding for sending data program to database.

These codes need to be aligned with NodeMCU ESP8266 program and MySQL database to help the data from NodeMCU to be send to the databased. Each table of MySQL database seen on php MyAdmin will require two file of sublime text. Since there are two table of databased therefore four file of sublime text are needed. Figure above shows the first file called “post-esp-data-FYP2.php”. In this coding it summarizes the data from NodeMCU ESP8266 to be sent to MySQL databased.

coding of display MySQL data to webpage

In figure above, it shows the second filed of sublime text created. The file name is “esp-data-FYP2.php”. The summarization of the coding is to display the data that were send from NodeMCU ESP8266 program to the databased of php MyAdmin on the web page. It works as a bridge to allow the data to transmit. Once it is completed, client could access the website of databased at “http://192.168.0.195/public_html/esp-data-FYP21.php”. IP address depend on the network connected on wireless network.  

Once it is success, then users could view MySQL databased with proper table on the Webpage as figure below.

Webpage display of MySQL databased.