Em Andamento

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.

Example:

"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:"[url removed, login to view]";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

Ver mais: yellow characters, time card example, text string search, string match, string data structure, search text string, search string array, search data structure, php time card, my payroll, match string, match management, mark management, loop net, lists data structure, link list data structure, john price, first 4000 words, example array data structure, data structure link list, data structure array, search string, array data structure, sql r, sql less

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

ID do Projeto: #3048537

Premiar a:

acer2004

See private message.

$55.25 USD em 14 dias
(66 Avaliações)
5.0

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

r2andme

See private message.

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

See private message.

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

See private message.

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

See private message.

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

See private message.

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