Module 3 Overview

---

MySQL

The third module in this course introduced SQL and MySQL databases. I learned how to use SQL to create tables in a MySQL database, add information to those tables, and retrieve the information meeting certain criteria. With MySQL, I learned how to create a new database and users to that could be added. We used phpMyAdmin to manage the databases and the information stored in them. MySQL also relied on using PHP for connecting to the databases from the HTML files. I found the the textbook to be the most helpful when it came to MySQL. The chapters included example code for registering users to a database and then displaying them elsewhere. The MySQL portion was a very important part of this course. Much of what we learned was not only used in this class, but in many other courses of our major.

Learning Artifact

---

Textbook Example Code

There were three chapters that we looked at for learning MySQL. The text went over a lot of the basics of setting up a new database and connecting to it. There was also code that would create a webpage where users could register and the information would be displayed on a seperate page. I liked this assignment the most because it brings together everything we have learned so far. It uses HTML and CSS to create the webpage, while PHP is used to get the information from the user, stores it, and accesses it later using SQL commands. The MySQL database is used to house the information the user entered.

Here is a picture of the register page with new user info added:

Here is the new user listed in the database:

And here is the new user displayed at the bottom of the webpage:

Here is a link to the textbook readings page of our assignment portfolio with the working code.