Đã hoàn thành

164226 Search in database (PHP&MYSQL)

Hello, I am in need of a PHP script that will search a database with articles (with 2 fields : content and numb) and select senteces. I will explain below what exactly it should do :

the script recieves a keyword (using get command) and a variable nr_words.. This keyword can have 1,2...n words .

the script needs to search the database and return sentences(and id of the article from where the sentence has been created).

the sentences need to have at least n/2 words in it (words from the inputed keyword) .

the sentences that have the most words from keyword are rated best .

the sentences should be gathered until the number of words from the variable nr_words are reached or until the script searched the entire database.

after all the sentences are gathered, they should be outputed in the browser, one after another .

Let me give you an example :

keyword=internet business good

good sentences :

I think that internet business are good (3 words out of 3)

Internet is good for business (3 words out of 3)

Programming is a good business (2 words out of 3)

bad sentences

It's good that you are eating (1 word -> we need n/2 = 3/2 = 2 (rounded))

I love internet (1 word -> we need n/2 = 3/2 = 2 (rounded))

I already have the script made by me . My script searches the database for sentences that have the exact keyword :

in our case : internet business good

So it searches for sentences that have exactly this words, one after another .

I hope I explained well what I need . I am a programmer myself (C++) and I can't do this becouse I am not that advance in PHP .

Don't bid high becouse it's not hard for someone who knows how to work with PHP and mysql .

I am going to give you the script (so you will see how the output should look) so you can just modify it .

I will give you a temporary account for the ftp and also acces to the database .

!!! EACH field of the database have 2 fields :

id= autoincrement

content = this field contains articles . So each content field with the coresponding ID has an article from where the sentences should be collected .

The winner will recieve the script that I made (that works with only 2 words) and also the ftp account . PLEASE DON'T WASTE MY TIME !

IMPORTANT : The database has about 270 000 records and about 900 MB of disk space

Kĩ năng: Bất kì công việc gì, MySQL, PHP

Xem nhiều hơn: work in internet programmer, where do i get a programmer, what should i look for in a programmer, what is database programming, what is a variable in programming, what is a database programmer, what can you do with php and mysql, what can i do with php and mysql, variable in programming, programming with php, look php id, i love programming, how to get good at programming, how to get a temporary work, how to be good php programmer, how to be best php programmer, how to be a good programmer in php, how hard is programming, best php programming, best php script, search the we, php command, in need of a programmer, give me best database, advance mysql

Về Bên Thuê:
( 4 nhận xét ) TM,

ID dự án: #1910417

Được trao cho:



$30 USD trong 1 ngày
(163 Đánh Giá)