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
|