Today, I decided to start and work on MySQL database again. In this moment, I am still confused about the relationship between MySQL, Cpanel, and PHPadmin. Therefore, I decided to ask Hui San about them. From her explanation, I get to know that Cpanel is page where create a database while PHPadmin is a database that created to store data. Below is the step that I followed the tutorial on how to create database:
The database has successfully created and continue to the next stage.
Now I try to apply PHP code in HTML to work on the data storing function.
I also have tried to keep testing and debugging the code. I have applied "My first PHP script" in the PHP code. But, the file failed to appear.After that,it is showed after I remove the /public HTML/ function.
Before connected to the database, I will have to make sure the PHP file also connected with MySQL server (PHPadmin ). By that, I will need to connect to my localhost, username, password and the created database. To make sure the file is connected with the server, I decided to write code as below:
echo 'connected successfully ';
The word is showed and it means the data is connected. Therefore, I started to insert data in the PHP file.
To make sure the data can be inserted into the database , I have applied code such as below:
echo ' data inserted successfully ';
The words is showed but the data failed to inserted in the database.
Besides, I also feel thankful to Hui San because she keep teaching me on how to solve the error and how to apply code in the PHP. Thank you Hui San!:)
Reference:
YouTube. (2016). MySQL Database Tutorial - 3 - Creating a Database. [online] Available at: https://www.youtube.com/watch?v=O4SIpJMH7po&index=3&list=PL32BC9C878BA72085 [Accessed 28 Dec. 2016].
YouTube. (2016). PHP MySQL Contacts Database - Setup - YouTube. [online] Available at: https://www.youtube.com/watch?v=O9HamXxGzls [Accessed 28 Dec. 2016].
YouTube. (2016). create MySQL database, tables and insert data using PHP functions. [online] Available at: https://www.youtube.com/watch?v=5QHBj4brHNM [Accessed 28 Dec. 2016].
YouTube. (2016). Creating and adding data to a database PHPMyAdmin. [online] Available at: https://www.youtube.com/watch?v=eWMTXEZGZTc [Accessed 28 Dec. 2016].