Thsi is the 2nd part basic tutorial on how to connect your PHP file to databased and display data from the selected table. The 1st part of the tutorial is where we create online MySQL databases from cPanel. You should ensure have the databased ready before start this tutorial.
1st, go to cPanel home and in FILES section, select File Manager.
Ensure you are in public_html folder as this consider the root for your hosting.
In this example, I create a folder name datafromdb in an example folder. Therefore, my path will be https://dewasolutions.com/example/datafromdb
Then, click on +File button and create an php file, click Create New File button.
Check the webpage, now we have an empty blank page as below.
Next, select the php and click on Edit button. Edit popup window will appear, click on Edit button.
Write the code below;
Line 2: create the connection to databased (host , user , password, databased).
Line 4: check the connection.
Line 9: select data from databased table dataSaya.
Line 17 – 23: Looping to fetch all data from table and display it.
Click on Save Changes button and refresh your webpage.
We should now get the data form table displayed on our webpage.
That’s it. Now you should have a webpage display data from online MySQL databased. InsyaAllah in the next basic tutorial, we will create a form to insert data, edit data and removed data.
I am lecturer in Interactive Media Department, Faculty of Information and Communication Technology (FTMK), Universiti Teknikal Malaysia Melaka (UTeM), Melaka, Malaysia. Currently on study leave doing PhD research study at University of Southampton, United Kingdom. My research relate to MOOC, analytic data and web observatory. I also interest on technopreneur , research and innovation activities in multidisciplinary fields.