Project Detail
php / mysql business directory - search engine
php / mysql business directory - search engine is project number 455005
posted at Freelancer.com. Click here to post your own project.
Bid Count: 32
Average Bid:
$ 206
07/31/2009 at 19:24 EDT
Project Creator:
boyaka
Employer Rating: 
(1 reviews)
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
- 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
Additional files submitted:
Simple search engine.rtf
Provider Rating
WHAT IS FREELANCER.COM?
Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!
We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started!
Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.
- Plendo Sweden AB © 2004-2009
- PRIVACY POLICY
- TERMS
- AFFILIATES
- API
- QUOTES
- CONTACT
Freelancer™ is a trademark of Ignition Networks Pty Limited (ACN 134 845 748)
Newly Outsourced Projects fed by 
Follow our Freelance Jobs on Twitter 
Add to your
Google search results
Software & Free Downloads * Webmaster Resources * Webmaster Forum