php / mysql business directory - search engine

• Project ID:

  455005

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

Hi,
My project is to have a little php / mysql business directory, like the yellow pages.

Please read this carefully before submitting a bid.




Features

Search engine :
- Search engine must search in a large “keyword” table that I will update by my own (or later via an admin section)
- The keyword table will be quite big (up to 10 million entries), so the search engine has to be fast
- Must be safe against any intrusion / attack
- Must record logs so I we can manage statistics (log page is detailed below)
- Ajax suggestion

Search results
- Results must be ordered like this :
1. Premium results first
2. results are ordered by popularity
3. if a keyword category is not empty, (that means to me that this keyword have different meanings), all the different categories of that keyword must appear at the top of the results as links. So the different categories are grouped (the more results the category has, the more the category is at the top)


Content of a result
- Normal result:
1. company name,
2. description
3. category
4. adress
5. Phone number
6. Fax
7. link to a company’s profile

- premium result:
1. company name
2. company logo
3. description
4. category
5. adress
6. Phone number
7. Fax
8. link to a company’s profile


Content of the company’s profile
- company name
- company logo
- description
- category
- adress
- Phone number
- Fax
- link to a company’s profile
! Must be search engine friendly: www.domain.com/company/



Log page
I will hide this page behind a protected htaccess area
The logs page is a simple php page display queries statistics, with:

- top 100 requests
- top 100 companies
- a « company » combobox so we can see all keywords requests about that company
- a keyword text field so we can see the number of times a company has been displayed when typing a certain keyword




Here is a little table structure. The goal of this table structure is to better understand how I’d like the application to work. The developer doesn’t have to stuck this description. It’s only to make my idea more clear.


Client table
- id
- client name
- company name
- description
- category_id
- tel
- fax
- email
- address (full text)
- website


keyword table
- id
- keyword (tag)
- client_id (each keayword is linked to a client)
- views (number of views)
- isPremium (boolean)
- logo


category table
- id
- category

Skills required:

AJAX, PHP

Additional Files:

Simple search engine.rtf