CST 336 Week 4

CST 336 Week 4

This week we implemented an SQL database on a server to create web pages. We had to create a webpage that connected to the database through PHP using PDO's. We then retrieved the data from the database through PHP. We also learned about joining tables and conducting aggregate functions. Finally we were able to figure out how to insert, update, and delete records from a user on a website.

We also began work on our group project which consists of implementing all we have learned so far in creating a webpage that utilizes databases. We will be creating a webpage catalog that consists of pc games that different users can purchase and have access to. The database will consist of a user table and a game table. A third table linking the purchased products and users will be created as well. We have not begun work on the website but will begin starting tomorrow.