Services Offered - Development Using php & MySQL

In the realm of the internet, relational databases like MySQL can be powerful tools.  When paired with a procedural software language like php, databases can be used to serve content, update and store information collected through a webpage, or a combination of both to create a robust application. 

Database Served Content

Link to Visionary Fusion Glass Works Gallery page Click on the screen image taken from the Visionary Fusion Glass Works site shown on the left and take a quick peek at their image gallery.  Click on a few of the thumbnail images, or select an entirely different category from the dropdown menu and see what happens.  Did you notice that the web page address, or url, doesn't change?  That is because the image gallery is a single page that is written in php and allows the imagery and content of the page to be driven by information stored on a MySQL database.  The thumbnail links, the category drop-downs, the images and their captions are all driven by data stored in a MySQL database. 

Link to Graywolf Designs Sample Work page You can see another example of database driven content by clicking on the image from the Graywolf Designs shown on the right.  The Graywolf Designs Samples page is also a single page written in php.  It was designed so that all of the text, images, links, as well as the menus, are all generated based on information stored in a MySQL database. 

This particular page can be used to display a list of sub-categories, or details on a single item with that item able to be displayed in one of several different formats.  For instance, the Graywolf Designs Promotional Materials sample page shows a list of Promotional sub-categories.  If you click on one of the sub-categories such as Direct Mail Postcards, then that same webpage is used to display information in a different format.  Similarly, the Multi-page Menus also have their own specific format. 

The advantage of driving the content from a database using one or more pages written in php is that when either Visionary Fusion Glass Works or Graywolf Designs wants to update images of their work, change text, or even add a whole new category of images; it's simply a matter of uploading the images and adding the associated information in the database.  No new pages to create, or menus to alter.  Quick, Simple, Timely, and Cost Effective. 

Link to Chippy The Clown's Contact FormData Collection

A database coupled with php can also be used to store data collected provided by visitors to your website.  A simple example would be the contact page for the Chippy the Clown website.  Whenever anybody sends a message using Chippy's contact page, basic editing is done to insure that the page isn't blank and that some contact information has been provided.  If it passes these edit checks, in addition to sending the email, the php code also writes the information collected to a database.  This information can then be used with several password protected webpages for promotion tracking and performance scheduling purposes. 

Taking this one step further, this feature allows applications to be developed where the client can update the content directly. Think of how easy this makes it to update your portfolio of work, the products you offer, or your on-line listing of upcoming events and promotions.