PHP with MySql experts

[sogate]

---

Hi guys,

Ask lang unta ko kon kinsa expert sa PHP with MySql? pwede magpatabang? hehehe....thanx in advance

[cold_fusion]

Pwede . Is for non-commercial site??

[weblizzer]

If it's not for commercial maybe i can help you. Or if you need references or tutorials i can share to you.

[sogate]

NON-COMMERCIAL guys. This is for my study.
thank you very much for the willingness to help. I just would like to solicit some ideas on a better way of evaluating a certain term in english then mo-return siya ug exact nga bisaya nga term by context cluing. For example naay sentence like "I will withdraw money from the bank". so kon pangitaon nimo ang meaning sa bank, iyang i-return kay "bangko" bcoz of the words "money" and/or "withdraw". dili niya i-return tanang possible visayan terms equivalent sa english word nga "bank".
Thank you in advance

[weblizzer]

mmmmmm i guess first of all you have a huge list of visayan words in equivalent on the english word.. so that when every word find on it.. it will convert into visayan word...

First you have to collect the whole words and put it in the array..
you can do this by exploding the the sentence by spaces

[cold_fusion]

There is an existing online visayan dictionary found here http://www.bohol.ph/diksyunaryo.php . You could set your FORM's "action" using GET method to point to this site.

Example:
http://www.bohol.ph/diksyunaryo.php?...&search=Search

Just replace the "bank" in "sw=bank" as a new 'GET' URI.

This is the "easy" way. No need for a huge dictionary database and far more simplier.

Also what is nice, but a bit tricky , is to parse the HTML output of this dictionary page and by AJAX or php script with html retriever (or use wget as CGI and parse in perl or awk the results) then display only the parsed words/translation.

[weblizzer]

good tips by cold_fusion...

that is very nice one.. aside from that you can you that for your getting a words. but if you don't want that site to be visible you can do a crawling or data mining techniques.. in order for you to fetch those conversion word.. and put it your site.

[sogate]

Yeah, i know about arrays, but my concern is the evaluation part--how to evaluate the specific term by context cluing. May you give at least a sample code of your idea on how to do it? Thanx again.

[cold_fusion]

Ok. This is just pseudo-code but will suffice.

First get the meaning all the meaning of "bank" (the clicked word) and put in a structure array with the meanings and score (meaning_bank).
Reset the all the scores to 0.

Then get all the meanings (meaning_rest) of all the words of rest of the sentence.
Then one by one compare each meaning_rest to each entry of meaning_bank.
If one word in meaning_rest is equal to a word in meaning_bank, add a 1 to the score in the meaning_bank structure.

After all the words are parsed (searched and score tallied), display the entry meaning_bank with the highest score.

BTW, you should change the title of this thread because this is not related to PHP and MySQL but on the algorithm for "context cluing".