Website / Application Projects

Dancing Bear Creations - http://www.dancingbearcreations.com

This client is an art dealer based out of Calgary Alberta who wanted the ability to display and sell their art online. Burton Media was tasked to create a database with a web interface that allows the client to add, modify, edit or delete entries. As well as a content managed section of the site that will allow the client to make updates on their own.

The administration page is password protected linked through a database. On the administration page the client is be able to add categories (which will be instantly reflected on the home page) as well as manage their art database. The gallery will display an image, the title, description as well as have two links. One is a dynamically created 'Buy Now' button which goes to paypal and allows the customer to purchase the art via credit card or paypal account. The other button brings up an e-mail form which will be sent to the client expressing the customer's interest in the piece. This double functionality assures that both those comfortable and those uncomfortable with making purchases online have the means to purchase the art, and also allows direct contact with the artists for questioning.

The database structure (database and table names have been changed for privacy/security reasons) consists of several tables:

The Gallery Table: Contains all information about product including the Item ID, category(related to category table), Artist ID(related to artist table), Date created, price, image(URL), Description and isActive(whether or not the item should be displayed).

The Category Table: A lookup table for the categories each category has an ID which is related to the category ID in the Gallery table.

The Artist Table: This table contains artist bio’s as well as an artist ID which is related to the artist ID in the Gallery Table.

The News Table: This table contains the information that is displayed on the right news column of the site.

The functionality is all programmed in Coldfusion.