Taxonomy Script 03.03.08
Taxonomy script
Case sensitiveness
Machine tags
Page 1: Static Homepage with text.
Text, images and design will be provided.
Page 2: Product tagging.
- What is it A car, a phone, a cam?
Input box (auto fill)
- Brand / Manufacturer / Company
Input Box (auto fill)
- Product name or Model
Input box (auto fill)
- TAGS
5 good things about the product (5 input boxes with auto fill (2 mandatory))
5 negative things about the product (5imput boxes with auto fill (1 mandatory))
- Comments/opinions (optional)
1 big text input box
- Product picture (optional)
Box and browse files button.
- Product Url
- Shop name
- Price
- Send button
Page 3: Searching tag database.
What are you looking for: car, a phone, a cam?
Input box (auto fill)
- TAGS
5 what do you want it to be (5 input boxes (1 mandatory))
5 what do you want to avoid (5 input boxes (0 mandatory))
- Send button
The search query:
The query will look all entries of the given product type and show the ones with more tag coincidences with the search specified.
Page 4: Results page.
Will show the 5 top coincidences and list the highest tags for this product with count().
Database:
- Product table
ID, Product name, picture, BrandID,TypeID
- Brand table
ID, Brand
- Type table
ID, Type
- Shop table
ID, Product ID, Product Url, Shop name, Price.
- Tag table
ID,tag,value*
- Relations table
TagID,ProductID
* Value is the number of the spot used for introducing the tag (from 1 to 5) but in reverse, so slot 1 gets a value of 5, spot 2 = value 4, etc.
Auto fill:
Script will search the database for words matching the user input after a character is introduced in the text box.
Example here:
http://www.dhtmlgoodies.com/scripts/ajax-dynamic-list/ajax-dynamic-list.html
Download script + detailed explanation here:
http://www.dhtmlgoodies.com/index.html?whichScript=ajax-dynamic-list
