Introduction to PHPMyAdmin

 

Lab 01

 

So this is the first lab of the semester and we learned about the introduction of the PHPMyAdmin. The thing we learned about PHPMyAdmin is that it is an open-source tool written in PHP intended to handle the administration of MySQL over the World Wide Web. 

The things that PHPMyAdmin will allow you to do is: 

• Create databases 
• Create and drop tables 
• Enter Data 
• Create and manage database users 
• Perform queries 
• Manage backups etc 

The things we did in this lab were simple, our lecturer was just taking us through the basics of the program and operating it. We got an opportunity to get familiar with the interface and how to create a simple database.

This is a database I made for Students 

There were some tasks that we had to do. We had to create a table to store student data. We included data such as Student Number, Student Name and Course ID. We also made a table for Courses such as Course ID, Course Name and Commencement Date. 

These are the tables I made for Students filled with Student information. 

Here is a table I made to store different courses

This is the end result for all the data from the courses

One of the tasks was to create a user account with full permission to the courses table which I displayed here

Overall,  At the beginning of this lab, I was kind of worried about this module because of how difficult it looked from the beginning. There were terms such as PHP, Apache, SQL and Databases which threw me off a bit but when we got into the labs and the lecturer explained the tasks carefully it all started to make sense and all the interfaces and functions weren't a problem. I think this first lab went well and I can't wait for the next one to see what it's like.