Database Design : information gathering, online contact forms, password websites

PHP MySQL FORMS, PROGRAMS & INFORMATION GATHERING

Reasons you may need to establish a database behind your website could be:

e-commerce website or online catalogue website
visitors can download PDF files that you upload
forums and content management system
online visitor contact form
opinion poll or survey questionnaire
creating an internal search engine
password and username for certain pages

PHP is a powerful web programming language that allows dyanmic web page creation in all of the above functions. PHP is the language of choice at WIGPIP in association with MySQL for database storage.

CATALOGUE STYLE WEBSITES and E-COMMERCE

Some key features for your online catalogue website:

product admin section
easily create new categories and sub-categories
choice to display or hide a product
search products by price
wholesale and retail login
add shipping by weight or fixed cost
choice of checkout methods
many other functions

CUSTOM SEARCH ENGINE DEVELOPMENT

Do you have a large amount of information broken into smaller sections that needs to be made searchable. For example you want visitors to search for a suburb and retrieve services in that suburb, or you have a long list of plants in your nursery and you want visitors to search by trees or shrubs.

DYANMIC FORMS

Dynamic form programming allows you to send your visitor to certain pages depending on user input. The information from the form page is then emailed to you or uploaded into your database or both.

UPLOAD/DOWNLOAD

A popular function for business is to be able to upload documents that your clients can then easily access and download. For example you might create a weekly product list in PDF that you want to upload to your website so that users with the given password can access and print off.