I made a Linux, Apache 2, MySQL, PhP, (L.A.M.P.) Database Server and Website for my Network Applications class at HCCC. This was a capstone project for my major that involved building gentoo Linux from scratch, setting up Apache and MySQL on the Linux Machine and, using the PhP Language, create an active database and lookup website that would pull from said database.
Contact Information:
heronmw1@hotmail.com
These first three images showcase the first part of this project which involved following instructions to build a barebone copy of gentoo Linux OS from scratch into a functional Database server. This was, by far, the longest part of the project; involving a ton of trial and error to get the correct conditions for the OS to work correctly.
These next two images represent the coding side of the development of my website. By now, I had created the L.A.M.P. Server and had interacted with MySQL to add a database to it.
The first image depicts the building of my website using HTML and subsequently CSS, (this is not shown).
The second image depicts the use of PhP and MySQL languages to connect my database to my website; allowing it to pull information from the database when requested.
These final three images show my completed website and how it worked. My website was a simple database search site where the user could lookup one or more games in five different ways. Name or letters of the game, the year, the gaming platform it is on, the genre, and/or the publisher. One or more of these queries could used in the same search and partial searches, (Ex. 20** for the year), would work as well. The first two images are the home page of the website and the second image is what a result page would look like. Finally, there was also a password protected admin page where I could manually add a new entry to the database on the fly, (this is not shown).
Unfortunately, this website no longer exists as it was a capstone project on our local network. Which is why some images are not present anymore and why I cannot link to the actual website. However, what is provided is still a good representation of programming, networking and web design ability.