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.

CST 336 Week 3

CST 336 Week 3

This week was all about learning HTML forms. We learned about the various input types of HTML forms such as buttons, text areas, radio buttons, etc. I then differentiated between GET and POST methods and how they are implemented in processing data in PHP. Finally we learned about PHP arrays and using array functions. 

This week I created web page for a geometric calculator for picking either a rectangle or triangle and then figuring the area for both as well as the perimeter of the rectangle by inputting the appropriate length and width of the objects. The calculations were done using various array functions such as array_product and array_sum.

Here is an example of the web page:

CST 336 Week 2

CST 336 Week 2

This week was all about PHP implementation in creating web pages. I learned how to use PHP variables and implement loops and conditions in PHP. I also learned the syntax of defining functions in PHP and generate randomization within PHP.

For the lab we had to generate a 10x10 table consisting of random numbers between 1 and 100. We were then tasked to color code all of the even and odd numbers differently. Finally the web page should count the number of even and odd numbers and display their corresponding percentages.

Here is a same of the web page:

Then for the next assignment we were tasked with creating our own idea to implement what we have learned this week. I decided to make a random BINGO card generator. It was fun and challenging trying to figure out how to go about solving this problem. In researching the problem I found that shuffling an array and then using array_pop() was the best way to randomize the numbers while also making sure not to use them twice. Here is an example of the program output.

CST 336 Week 1

CST 336 Week 1

This week was all about learning the basics of HTML, CSS, and creating webpages by learning how they work together. I was also able to upload the webpages to a sever to remain for web viewing. Here are examples of the webpages I created this week: