Closed

Search Database With Checkbox Option

This project was awarded to alphaes for $100 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30-$250 USD
Total Bids
16
Project Description

Search Database With Checkbox Option

SOFTWARE USED Adobe Dreamweaver CS4 (prefer if it's done with DW but not required)

DATABASE MySQL client version: [url removed, login to view] DB Type MyISAM

LANGUAGE PHP Version 5

WEB PAGES:
[url removed, login to view]
[url removed, login to view]

SCREEN SHOTS
[url removed, login to view]
[url removed, login to view]
[url removed, login to view]
[url removed, login to view]
---------------------------------------------------------------------------------------------------

GOAL ONE:
Create a SQL Statement to search in the "products" table for any word or words in the "producttitle" column and return the results back according to relevance of the request.

EXAMPLE A:
If the user types "bird dog cat" in the keywordfield and submits the keywordform:
Relevance of the request....
3 word combinations should come 1st in search results. rendering any "bird dog cat" "bird cat dog" "dog bird cat" combination
2 word combinations should come 2nd in search results. rendering any "bird dog" "dog cat" "bird cat" combination
1 word results should come 3rd in search results. rendering "bird" or "dog" or "cat"

EXAMPLE B:
If the user types "bird" in the keywordfield and submits the keywordform:
Relevance of the request....
1 word combination should come 1st in search results. rendering "bird"
2 or 3 word combinations should come 2nd in search results. rendering any "bird dog" "bird cat" "bird dog cat" "bird cat dog" "dog bird cat" combination
LIMIT results of 900 for any given search.

GOAL TWO:
With use of this checkbox called "searchcheckbox" on the bottom of the search form, ....create a SQL statement (script) to search for any word or words in the following 7 columns in this order: "producttitle, productnumber, manufacturer, upcstocknumber, details1, details2, details3". Return results back according to relevance of the request (as stated above). It is important that producttitle should have the highest column of relevance.
LIMIT results of 1200 for any given search.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

INFORMATION PROVIDED:
Above, I have provided what I believe is all the information regarding this project with exception to login information to the FTP & database. Please base your bid on this but I will be happy to answer questions and exchange correspondence through this website's personal message board during the development of this work. Try to keep in mind of time zones differences if responses aren't immediate.

SELECTION PROCESS:
Not required but it is very helpful when the service provider explains in very short detail the results of your work in completing this project here. Let me know which version of Dreamweaver you use (if any).

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online