PHP/MySQL
I’ve taught myself to use PHP and MySQL to create dynamic content for the web. I’ve recently completed three projects using basic PHP and MySQL functions.
- Recipe Database
My brother-in-law is living away from home, and I created a recipe database to add to his WordPress blog to allow friends to share recipies with him. The module allows people to input recipies, stores them in a database, and then displayes all recipies from the database on an output page. There is also an administrative interface to delete or flag recipies in the database. - Party RSVP
A friend was planning a large gathering, and needed a way to allow people to RSVP for the event. I created a simple event RSPV application that allowed guests to sign up for the event online. When new registrations were entered into the system, the reservation was stored in a database, and an e-mail with the registration information was sent to the event coordinators. - Thesis Data Gathering
When my wife was gathering data for her master’s thesis, I created a web application that allowed her to gather her data online. Students logged in to the application using their Student ID, and were assigned to one of eight treatments. Depending on their treatment, studens were presented with similar pages in varying orders. Student responses were colleced and stored in a database.
XML/XSLT
As the semester project in my XML course, I created a DTD and an XSLT stylesheet for the previously mentioned TALL Activity Documentation. Below is a copy of the DTD, XSLT stylesheet, XML source file, and the HTML output. This was not a group project.
- TALLML.dtd (Your web browser may not display this file properly; if not, right-click on the link and save the target file to your desktop; then open it with a text editor.)
- TALL4.xsl
- Sample XML input document (Match Words)
- Sample HTML output document (Match Words)