In Progress

Search Database With Checkbox Option

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).

Skills: Apache Solr, MySQL, Oracle, PHP, SQL

See more: checkbox database search, search option checkbox php, php search database checkbox, checkbox search database, option checkbox php, php sql checkbox database, zones, website adobe dreamweaver, web search images, web development service provider, statement of work for software development project, software development service provider, service rendering, search this website, search here, search for work, screen of the mind, manufacturer search, manufacturer order, database one word or two, database development service, c# database mysql, base exception, search checkbox sql database, search database checkbox

About the Employer:
( 31 reviews ) Antioch, United States

Project ID: #656608

Awarded to:

alphaes

Hi, I have worked on similar [search based] projects, Thanks.

$100 USD in 4 days
(1 Review)
0.0

16 freelancers are bidding on average $124 for this job

tomydeveloper

Hello,we are search code expert and understood your mentioned [url removed, login to view] check [url removed, login to view]

$200 USD in 5 days
(207 Reviews)
7.4
abraham66

check pmb pls

$49 USD in 1 day
(98 Reviews)
6.8
wildlily980

check pmb please.

$70 USD in 2 days
(41 Reviews)
5.9
cygital

I can get it done.

$150 USD in 3 days
(31 Reviews)
5.9
RRStoyanov

please check your PMB

$100 USD in 0 days
(57 Reviews)
5.6
csolutionsuk

I am confident that I can do this development for you, please see PM.

$125 USD in 2 days
(13 Reviews)
5.0
nmppatel

I am an IT professional with 10 yrs experience. I have experience developing database search algorithm based on combination for keywords. I have done similar project on GAF, you can check my review for it. I will pro More

$250 USD in 5 days
(7 Reviews)
4.2
extremewebindia

Hi we are web developer from jaipur, india. we can do ur project with best of our efforts. We are team of graphics designer and developers. We do web design, developments, animations. see our website at [url removed, login to view] More

$250 USD in 7 days
(1 Review)
3.8
freddyho

Please check your PMB

$80 USD in 3 days
(3 Reviews)
3.7
phprocks

Hi, Thanks for conisdering my Bid.

$150 USD in 5 days
(1 Review)
3.5
coolog

Hi, I have dreamweaver MX, though I prefer using notepad++ for PHP. My code is clean and good. Answer this bid if you are interested. Hope to hear from you soon.

$75 USD in 3 days
(1 Review)
2.0
workwithme1

Ready to work with you on this project, please check pm for more details.

$125 USD in 2 days
(0 Reviews)
0.0
muhabbat

I will do it in 3 days

$30 USD in 3 days
(0 Reviews)
0.0
cicakemizan

Hi, I am Mizanur Islam Laskar from Bangladesh, working as a web professional on PHP/MySQL for 7 years. Please checkout your PM to learn about my offers, portfolio, etc. Thanks.

$125 USD in 2 days
(0 Reviews)
0.0
AndreyTZ

I am very interested in your project. I can start working on it right now.

$100 USD in 3 days
(0 Reviews)
0.0