ICS325 Homepage

ICS325 Homepage

ICS325 Homepage

This is the homepage project for my ICS325 class at Metropolitan State University.

The purpose of this page was to track my on-going PHP project for the class. Each step of the project asked us students to continue expanding on class project. Some of the items included adding SSL for our checkout process, incorporating a login process for users to create, manage and log in to our site, as well as creating our own shopping cart.

I am currently in the process of re-setting up this my class project. As the class was some time ago, it is no longer hosted by our school. Luckily I had the project files and will host it myself. Please check back if you are interested in seeing my final project.

Please note that I will not be incorporating the SSL at this point due to costs associated with this feature.

Languages used: HTML, CSS, JavaScript/jQuery, PHP, SQL and MySQL

ICS325 Subtle Clothing

Subtle Clothing Project

For my ICS325 class, my class project was to create a PHP based website that incorporated several items. Some of these items were:

  • Read/Write to a files
  • Incorporate Regular Expressions into our validation
  • Valid data correctly with our Regular Expressions
  • Allow users to create accounts and be able to administer their account
  • Authenticate users against our MySQL database
  • Manage products (create, update, delete)
  • Allow users to add items to a shopping cart
  • Once items are in the shopping cart, allow users to checkout
  • Incorporate a checkout process that updated users throughout each step of the checkout process
  • Implement SSL during the checkout process
  • Make sure every page validates against W3C HTML & CSS validation services

Unfortunately, my school removed my project from the hosted server so I no longer have a link to this page.

I recently got a copy of my files and will be working on putting them up on my website. Please check back soon for this.

Languages used: HTML, CSS, JavaScript/jQuery, PHP, SQL and MySQL

ICS311 Database Concepts

ERD Diagram for class project.

Download Files:
Project Files | Assignments

During my time in ICS311, we went through different Database Concepts, SQL queries, building Conceptional – Logical – Physical ERD’s, Query Processing and Indexing.

Throughout the course, we were given written statements and conversations from different members of a company and were asked to design their database. Starting with the conceptual ERD, we began thinking out and orchestrating the system. Once the conceptual concept was created, we then worked on building the logical concept. Keeping with database normalization, we were asked to make sure the database conformed with 3NF (third normal form). When we were certain the system was designed properly, we build out the physical database and performed queries against it to validate the concept and ensure the database was built in a useful and manageable way.

Towards the end of the course, our instructor showed us the importance of query processing to ensure our queries were built in a way that returned only the necessary information so our queries were not performing unnecessary tasks. Through relational algebra, we determined the most optimized queries for our database.

The files contain my ERD, query processing and indexing.

Technologies used: MySQL, phpMyAdmin, SQL