IPT home IPT A Virtual Approach by Peter Whitehouse
Quick Links:
 
 
PHP home
Information and Intelligent Systems Social and Ethical Implications Human Computer Interaction Software and Systems Engineering eXercise Files Course Outline and Assessment A-Z of Geeky Acronyms Terrace Work Program 2004 Sillybus FAQ = Frequently Asked Questions Help
 
 

The URLb@nk

Live-to-web Favourites

An excercise in Live-to-web, database and interface design.

You can read the original spec for this project. In retrospect, it seems this is a sort of DIY Google and should provide search facilities also.

The table storage for this project is simple (one table, one column key, as follows:

Column

Data Type

Ma/Op

Key

Notes

bankid autonumber Ma Pk An ID for the entry

url

Char(200)

Ma

unique

Page address

Sitename

Char(100)

Ma

 

Stated name of site

Dateadded

Char(20)

Ma

Default=now()

When the entry occurred

Category

Char(50)

Ma

Default=unfiled

List of categorical ‘buckets’

Person

Char(50)

Op

 

Who added it (name)

Dessie

Memo

Op

 

Tell us about it

Votes

Integer

Ma

Default=1

Vote if you like it

The steps taken to develop this project may not, at first glance, seem to be most logical. The steps presented below are in the order they were brainstormed and make progress towards the desired solution. Go to the original code jotter to see how these steps were done. Alternatively go to the VISUAL GUIDE to see a more recent attempt

  • Connect to the database (used in other modules)
  • Create the table (necessary first up)
  • Allow users to trash the table (why?)
  • Get the current date (calculate it via a builtin)
  • Squirt in some sample data (coupla rows to see all is hoopy)
  • Allow the user to empty the table (why?)
  • Create a basic data display form to see what is there so far
  • Create a basic data entry form
  • Process the form data and insert it in the table
  • Populate a categories drop list (from existing categories)
  • Create a data entry form that includes a categories droplist
  • Create voting form
  • Make a search engine
  • Bind the interface up into a neater package
  • Achieve world peace

 

 

wonko@wonko.info
©Copyright t 1992..2017+. Edition 25.150117
wonkosite
Creative Commons License
This work is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 2.1 Australia License
.