Database Website Development

MySQL Database Driven Websites

Database Driven websites using the strength of dynamic data develop a highly functional and easily maintained website. Changes made to the database are reflected immediately on the website. Web pages do not need to be reloaded to the server to be viewed with changes. The bottom line is a cost efficient website keeping your ongoing maintenance costs down.

Database Vs. Standard HTML Website

Scenario:

You have a website with 50 widgets. You are expanding your product line so you need to add 50 more products and split them into two departments. Current Widgets are Standard Widgets, new products are Deluxe Widgets.

Updating the Website - Standard HTML

Open product page, add the word Standard to the product title, save and close - do this 49 more times.

Create 50 new pages for the Deluxe Widgets.

Upload 100 pages to the server.

Conservatively, even an experienced developer would take approximately 2 minutes for each title update and 10 minutes for each new page. Then 10 minutes to upload all new pages to the server.

Approximate developement time 10.25 hours

Updating the Website - Dynamic Website

The product page is dynamic, meaning there is only one page that views any one product. The information is retrieved in by the data stored in the database for each item. The data is exported from the database as a text or CSV file. Using Find and Replace, search for Widgets, change all instances to Standard Widgets. Cut and paste all product information for the Deluxe Widgets to the file. Product information is the updated in the database.

The most intensive part of this method would be to input all the data for the 50 new products. This should take no longer than two hours to input and review.

Exporting the data form the database updating the title of each product, adding the new product information and uploading the new data to the database should be less than an hour.

Approximate dev elopement time 3 hours

Let's Compare the Bottom Line

Your developer charges $35.00/hour

Your savings are an incredible 350%