Implement full-text search on 4 database fields in MySQL as per spec below. We are looking for a PHP implementation. MySQL's native boolean-full-text search would be fine, but we'll consider any reasonable alternatives. Bidders, please indicate relevant experience, and if you've done this before. Specifications -------------- 1. Generate search results from four MySQL fields (3 varchar and 1 text) based on words typed in a search box an a web page, and display them on that page. (We will provide the database with data.) 2. Results sorted by relevance, High>Low 3. Resuts sub-sorted by date (from the date field in MySQL) 4. Search-terms highlighted (in a yellow box controlled by a CSS rule) 5. When multiple search terms, "AND" is an default implied operator (changeable to "OR" in a config file) 6. When "AND", "OR, "NOT" terms are used in caps, they apply as such operators 7. Stopword list applies (from a config file) except inside a quoted expression which should be searched for an exact match as is. We will provide the list 8. Make "special" characters to be ignored in a search string so they don't break the search (look up from a config file. E.g. ",',?,! etc..) 9. Must work off mySQL FULLTEXT index or equivalent for high performance 10. Package code so search functionality/methods is in a class separate from UI functions (so it can be easily integrated into our app) 11. Desired: search results (relevancy score) weighted by field with weights applied/adjusted in a config file. (MySQL native text search may have some limitations here, but some reasonable work-arounds should be avaliable.) END
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Linux MySQL PHP