In other words, the idea is that the system will generate a huge database table that contains information about the most common words found in web pages of different TLD's. The common word matching is, of course, not case sensitive. A word is defined as a string that has 2-100 characters, only characters from A to Z.
The table must contain information how many times any of the words have been found, and when last time (i.e. date).
So, the fields of the table could be:
id - integer - auto increment
word - varchar(100)
hits - integer (number of times this word has been found in different web pages)
last_hit - date (the date when this word was last found)
country - varchar(2) - the two letter ISO code of the country from which this web page containing this word was found).
The hits value gets increased every time the same word is found from different pages. In other words, if a web page contains word "foobar" 10 times, it is still added to the table with a hit count of 1. When the word "foobar" is found from some other web page of the same country, the hits counter is increased by one.
I will use the hits and last_hit data to prune the database table so it does not grow too big. I want to build a table of all the most common words found online, not all words. The job must be implemented using object oriented design using PHP classes. For database, use MySQL. You must develop the script in your own server, you are not given any server access to the production use server.
There is an error in the database table fields: the last field should be "tld - varchar(20)", not "country". Sorry!
6 freelancers estão ofertando em média $245 nesse trabalho
Hi, i understood what you want and i have 1 question: "build a table of all the most common words found online, not all words", so do you you have list of word ? please talk to me. I'm fast and expert. Thank you !