We are looking for a professional php-developer for two tasks. You must be clever and know about algorithms and regular expressions. If you only programmed database queries and don't know about algorithms, please do not bid. Do not waste my and your time. You will be given some snippets for task #1 where 50% of the work is already done - so you have to change, refactor and optimize there - this should speed up your development time. Task #2 is very simple and for testing purposes. We are interested in future cooperation and have more work to do if you are the right one for us. We will start with task #2.
---------------------------------------------
REQUIREMENTS:
---------------------------------------------
- regular expressions
- PHP
- MySQL Database
- Algorithmics
- Skype contact
- work independently
---------------------------------------------
Optional:
---------------------------------------------
Ideally, for task #1, you could setup a quick and dirty form-webpage where I can enter the keyphrase and get all matching products with score and gravity and the best matching product. This is really completely optional and only, if you have a working web-server where you can quickly setup a simple page with a single form. We think, this could speed up development time for both of us and avoid unnecessary testing.
---------------------------------------------
Checklist:
---------------------------------------------
- do you fulfill each requirement?
- did you fully understand the specification?
- do you really speak good English?
---------------------------------------------
Payments:
---------------------------------------------
via escrow. No payments in advance. We will start with task #2 (matter of max. 15 minutes to complete) and when you succeed, we put the money of your bid onto the escrow.
---------------------------------------------
Project description:
---------------------------------------------
TASK #1:
1. Aim is to find a related clickbank product to one or more keyphrases. You will have a mysql-table of the clickbank-market feed (t_clickbank) and a table containing urls and keywords (t_url). Check $_SERVER, get the corresponding url from the url-table, get the keywords and try to match them with the clickbank-products table. Just print out the found product (see below). You have to write a working algorithm to match keyphrases and clickbank product, this is the actual and most important thing. We already implemented some stuff and you will just have to extend that. You should have knowledge about regular expressions for that sake. You will also have to take into consideration english stopwords ([login to view URL]) - find a good list of english stopwords and hardcode them into your source. Those words have to be stripped out from the keyphrases on runtime - so no need to change the table, just check and remove with search and replace. Clickbank product description is in two columns: title and description - in CDATA format, both columns matter. Your mysql search query has to take that into consideration.
- matching takes place in the following order of importance:
1. provided keyphrases from t_url (nothing found? then 2)
2. provided url from t_url (extract keyphrases by separating the url with '/') (nothing found? then 3)
3. take an arbitrary product of the first 100 clickbank products (order by gravity, so this is the list of the 100 products with most gravity - simple SQL query)
* it can happen, that t_url does not contain keyphrases. in that case, start with step 2
* we want to have the best product for the keyphrase, therefore order by gravity (this column in t_clickbank indicates how 'popular' the product is)
* do not write a silly algorithm, this is once again most important thing. It will happen, that you get multiple keyphrases like
"sports, water sports, diving". In that case you have to find the best matching product for all three phrases. If nothing found, make your search broader and so on.
* you will also have a certain gravity threshold. If the gravity of the product you found is below the specified threshold, then take a different product which does not match so well in terms of the keyphrases, but has a higher gravity
To summarize: you will need a data structure which contains clickbank products which match the given keyphrases. You will have to score the resulting products depending on how well they match the provided keyphrases. Think about an algorithm. Most points for exact and/or multiple matching products (if the product matches sports and water sports and diving, this is perfect score), zero points for the products you found in step 3. Then you make choice on the best scoring product which has a gravity above the specified threshold.
What you get:
- Clickbank market feed in sql-format (t_clickbank); just import into your mysql database
- Sample url table (t_url); just import into your mysql database
- some snippets for Task #1: many technical things are already implemented.
TASK #2:
Aim is to print out content depending on the url. The content database (t_content) contains the url and content where there can be multiple rows for a single url, e.g.
[login to view URL], content1
[login to view URL], content2
Check $_SERVER for the url, when you find matching entries in t_content, just print out all content.
What you get:
- sample content table; just import into your mysql database
Hello, I am intresting in your project and ready to start work. I have experience in algorithms, in school and as a student I took part in programming contests and sometimes I won.
Hello, I have been programming with C, C++ on Linux/Unix platforms for more than 12 years before moulding myself as a web programmer with PHP, mySQL using CodeIgniter and jQeury frameworks for that last 4 or so years. Please check out PMB to find out my previous projects completed information etc. and contact me if you think that I am one of the suitable candidates for your job. Thank you for the opportunity to bid on your project, Sunil.
I thought You want google autosearch facility just take care for fetching data from database, we set priority as per you say in your description. We are provide this facility in PHP/MySql scripting language , just provide script for that.