In this Module, I learned Structured Query Language(SQL) through W3schools and how to use MySQL with PHP through Bucky Robert's video tutorials. Through the tutorials, I learned how to create a database in MySQL, create tables, update/delete tables, alter/drop tables, sort tables, and more using SQL. While following Bucky's tutorial, I created functions within a website that collected inputted data.
Bucky's tutorials were beyond helpful and it's safe to say that his tutorials worked best for me in this module. He walked me through on how to navigate to MySQL in hostgator and utilize it using PHP. With the help of his tutorials, I was able to glide through the textbook reading and create a website that can register users, let them change their password, and view other users. In the past, I have registered for countless websites. Thus, it was neat to see how everything ran in the background and now be able to create my own registration form(See below).
Selected Assignments
Using PHP, I created a form that let users register for the website. Click here to register.
With the combination of PHP and MySQL, I was able to store the users' information and also make it available to site visitors. Click here to view all users.
Learning Narrative
This module was not an introduction to SQL for me because I had already learned it in a previous database class. Though in that class, we used Microsoft Access for our database. Therefore, this module introduced me to MySQL, which I thought was very convenient because it ran on the server and not on some external software.
