MySQL / php search

I'd like a php script written that queries a database and outputs the results.

## Deliverables

I'd like a php script written that does the following:

1. Accepts a? url parameter called keyword.


"2 days salvador bahia, 2 days rio de janeiro, 2 days iguassu falls and 2 days buenos aires"

2. Strip out all non A-Z 0-9 characters.

3. Remove all words less than 5 characters.

4. Order by keyword length (largest first)

5. Connect to MySQL

host: localhost

database: search

user: john

password: smith

6. Run the following query for each keyword.

SELECT * FROM lpb_keywords WHERE MATCH(keyword_name) AGAINST(%%% KEYWORD %%%) limit 0, 20

7. Format the results for each query into seperate lists. Mark each list with an onpage # link.

The list must must be a hyperlink.

The anchor text is keyword_name from the query.

The url comes from an array stored in keyword_data in the query.

An example of the array looks like this:

a:5:{s:11:"{%KEYWORD%}";s:62:"Time Card Numbered Days/4 Days Overtime 100 per Pack 3-1/2"x9"";s:12:"{%REDIRECT%}";s:140:"[url removed, login to view]";s:9:"{%IMAGE%}";s:50:"[url removed, login to view]";s:9:"{%PRICE%}";s:4:"5.41";s:15:"{%DESCRIPTION%}";s:479:"Weekly time cards feature a seven-day time period to record regular hours ? deductions ? gross and net pay and four days overtime. Designed for full payroll deductions with weekly numbered days. Made of extra-heavy 150 lb. manila stock printed in green on front. Designed for use in Acroprint 125R ? 150R ? ES700 ? ESP180 ? 175TR Amano NS-23600 ? 3800 ? 5400 ? 5600 ? 1000 ? 10000 Lathem 2100 ? 4000 ? 5000E ? 1000E Simplex KCF ? KCG ? JCG ? and JCP.<br>YELLOW<br>100 per Pack<br>Sold by the Pack";}

The url is "[url removed, login to view]" labeled as {%REDIRECT%}

8. Display the list of keywords from step 4, and link each to the appropriate list with an onpage # link.

* * *This broadcast message was sent to all bidders on Monday Dec 28, 2009 2:47:36 PM:

I need to change some of my requirements. In step 6 I said I want a fulltext query run for each word. But I do not want that. Rather please combine the sorted words back into a string (remove duplicate words) and run the query ONCE against the whole string. Then loop through the sorted words running a find against each returned keyword from the query result. If the word appears in the keyword then move it into the list for that word. Remove that item from the query result as I don't want duplicates. If a word does not appear in the query results remove it from the list of sorted words. Also, I will provide a SQL script with the database structure and sample data. Please let me know if this makes sense, and if you accept the changed terms.

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Veja mais: yellow characters, www payroll, time card example, the first 4000 words, text string search, string search in c, string match, string in data structure, string data structure, s. r. smith, some search string, search text string, search string in c, search string in array, search string c, search string, search data structure, search c string, sample of payroll, sample of a payroll, php time card, my payroll, match string, match management, mark 3 management

Acerca do Empregador:
( 9 comentários ) South Africa

ID do Projeto: #3048537

Concedido a:


See private message.

$55.25 USD em 14 dias
(66 Comentários)

5 freelancers estão ofertando em média $79 para esse trabalho


See private message.

$34 USD in 14 dias
(50 Comentários)

See private message.

$51 USD in 14 dias
(22 Comentários)

See private message.

$42.5 USD in 14 dias
(22 Comentários)

See private message.

$42.5 USD in 14 dias
(17 Comentários)

See private message.

$212.5 USD in 14 dias
(2 Comentários)