Lukket

Search engine needed for my online catalog

**I have built an online catalog in PHP/MySQL that I need to be able to search from the front end of my site.**

**First, here is the breakdown of the catalog:**

There are many products (`product` table).

Each product has a description and title.

Each product belongs to a merchant (`merchant` table)

Each merchant has a ZIP code and a LOCATION_ID (based on the metro area they're located in)

Each product is associated with either 1, 2 or 3 categories.

the product-category association is made in the table `product_category`

There are about 800 categories in my tree with a maximum depth of 7. (`category` table)

**How I need to be able to query data from this catalog:

**1. I want to be able to keyword search product titles and descriptions

2. I want to be able to browse the catalog by category_id

3. I want to be able to keyword search within a category (and its sub categories)

4. Whether I am searching or browsing, I need to be able to filter the results based on the merchant's ZIP code or LOCATION_ID at all times.

*This needs to be done efficiently so queries do not take too long to return results.

The system should be dyamic, so it reflects changes I make to the catalog.

I am open to using 3rd party GPL software.*

***In your bid to me, outline how you plan on solving this problem for me. IE: with 3rd party software or with regular PHP/MySQL. If you ignore this part your bid will not be considered. Thank you.***

## 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

I run a Linux server with MySQL [url removed, login to view] and PHP 4.x

Evner: Ingeniørarbejde, Linux, MySQL, PHP, Software Arkitektur, Software Testning, Web Hosting, Hjemmeside Management, Hjemmeside Testning

Se mere: tree searching, tree query, search in tree, searching tree, searching problem, searching for coder, search for work online, search for a place online, search a tree, run a c++ program online, re code online, php and mysql search engine, online linux server, metro on hire, metro one, how to make a product catalog, how to make a catalog of my products, hire me online, hire an online program, engine front end

Om arbejdsgiveren:
( 137 bedømmelser ) San Francisco, United States

Projekt ID: #3318105

22 freelancere byder i gennemsnit $100 på dette job

progwriter

See private message.

$119 USD in 7 dage
(623 bedømmelser)
7.7
prabhatsaini

See private message.

$85 USD in 7 dage
(147 bedømmelser)
6.9
CodingExpertz

See private message.

$93.5 USD in 7 dage
(107 bedømmelser)
6.3
netcruiser

See private message.

$85 USD in 7 dage
(102 bedømmelser)
5.4
priyankjainvw

See private message.

$85 USD in 7 dage
(41 bedømmelser)
5.4
bushibytes

See private message.

$97.75 USD in 7 dage
(11 bedømmelser)
4.2
webactive

See private message.

$127.5 USD in 7 dage
(2 bedømmelser)
4.1
softforcevw

See private message.

$85 USD in 7 dage
(10 bedømmelser)
3.7
mrunwal

See private message.

$85.85 USD in 7 dage
(12 bedømmelser)
3.4
swetaneha

See private message.

$85 USD in 7 dage
(10 bedømmelser)
2.7
marcobaldinivw

See private message.

$127.5 USD in 7 dage
(2 bedømmelser)
0.0
phplifevw

See private message.

$123.25 USD in 7 dage
(0 bedømmelser)
0.0
foror

See private message.

$119 USD in 7 dage
(0 bedømmelser)
0.0
vitavarc

See private message.

$85 USD in 7 dage
(0 bedømmelser)
0.0
thepr0filer

See private message.

$85 USD in 7 dage
(0 bedømmelser)
0.0
osmosisideaz

See private message.

$127.5 USD in 7 dage
(0 bedømmelser)
0.0
trustsolutions1

See private message.

$85 USD in 7 dage
(1 bedømmelse)
1.2
cromanvw

See private message.

$85 USD in 7 dage
(1 bedømmelse)
0.4
shizzilla

See private message.

$100.3 USD in 7 dage
(0 bedømmelser)
0.0
khaqan

See private message.

$85 USD in 7 dage
(0 bedømmelser)
0.0