Scotts Online Portfolio of Digital Media Works |-----
www.scottswork.co.uk |-----
HOMEPAGE -> WEB DESIGN -> Current Page

Please select a sub section below:

INTRODUCTION
CLIENT TESTIMONIALS
GENERAL PORTFOLIO
VAUXHALL PORTFOLIO
WEB PROGRAMMING

VIEW GUESTBOOK ()
SIGN GUESTBOOK


WEBSITE MAP || RETURN HOME
CURRENT PAGE VIEWS: 1284
SELECT ANOTHER PAGE:
Ever since leaving University and starting employment in web design, I have not only been interested in the look of a site, but also, the "backend" of it. This basically means that a lot of sites now are run from a database, or similar, and are produced from code that integrates with this.

For Example, an eccommerce site would generally use a database of products to "drive" the pages on the online shop, and tell the customer what is available for purchase. Also, using this type of system can help the user to administer their site without having any website creation knowledge.

For example, on some sites I have created (Eternity Flowers) the owner of the site can add new categories for his shop, birthdays, christmas etc, then add or remove items under each of the created categories. Then once he has added a product, the price, description, pictures etc etc can be altered by himself. The system then goes on further to allow him to give out discount codes which reduce the price, and also includes a postage/weight system so only certain products can be posted with other products. This gives the owner total control without having to keep coming back to me for changes.

As well as shopping systems, my development knowledge has taught me to fully integrate with Flash, produce chat rooms, messageboards, and also a photo gallery based system/uploader.

SPECIALISED DEVELOPMENT SKILLS
PERL/CGI - Primarily my strongest skill in web programming, is the perl language, this is one of the cheapest languages to host, running on almost any server, and is quick and easy to update.
MYSQL / SQL / ACCESS - My experience with database driven sites, has led me to learn 3 types of datastore, SQL, ACCESS, and the most popular at the moment, is MYSQL, which is one of the easiest to administer and work with for most moderate sites.
COLDFUSION / PHP - A have worked briefly with both of these languages, and am now able to make small changes to sites, I especially would like to learn more about PHP coding too.
EXAMPLE SCREENS


Press Release Admin

A simple form based layout for editing all news articles with pictures on your own site.


Gallery Administration

Here you can see an example of how on the SussexPhotos site, its simple to add a new gallery to the system, by simply entering the details and ticking the categories you would like it to appear under.

RECOMMENDED SOLUTION:
At present I find the easiest solution to create a database driven site, is to use a combination of PERL & MySQL.


FEATURED DATABASE DRIVEN SITE 1

EternityFlowers.co.uk
Site is fully updateable via the owner, allowing to add / delete stock, amend pictures and prices and even give out discount codes to his customers.

FEATURED DATABASE DRIVEN SITE 2

TheMarriage.co.uk
Fully run by a database, this site is updateable by a simple control panel, allowing new categories / pages to be added with the simple click of a mouse.


 

 


www.scottswork.co.uk | Online Portfolio of creative works | Tel: 07970 617314
Email: scott@scottswork.co.uk | © Scott William Wright
Scotts Online Portfolio:// VIEW WEBSITE MAP | EMAIL ME | HOME PAGE | SEARCH SITE --