New PHP/MYSQL Application - Foreign Language Dictionary

I have an XML that contains vocabulary words for learning a foreign language. I want an online application similar to this site: It should provide a similar search

but also a search where you can type in an English word and show all the matching foreign language words. Also, one of the combo-boxes should be "part of speech", where they can select noun, adjective, verb, adverb, particle, etc...

The XML dictionary could contain Spanish, French, or Hebrew.

For Hebrew especially, it's important to use a server-based graphics program to generate a .gif to render the font and show the letters so that the user does not require any Hebrew fonts on his computer. Whether to use server-side graphics will be a flag in xml file.

I want this to be done in PHP (not Flash).

If in your bid, please analyze whether we should just use the XML file as input, or whether or not it should be loaded into SQL database. Your analysis will help me determine if you are right for this project.

Sample XML:

<?xml version="1.0"?>

<dictionary SourceLanguage="English" SourceFont="Arial" SourceFontSize="12" TargetLanguage="Hebrew" TargetFont="Hebrew1" TargetFontSize="18" RenderTargetFontOnServer="true">

<word lookup="7077" Trans="shel" Hebrew="שֶׁל" Class="pronoun" Root="0" English="of, belonging to"/>

<word lookup="7130" Trans="raa" Hebrew="רָאָה" Class="verb" Root="0" English="(he)saw"/>

<word lookup="7155" Trans="shaal" Hebrew="שָׁאַל" Class="verb" Root="0" English="(he)asked"/>

<word lookup="7129" Trans="chipes" Hebrew="חִיפֵּשׂ" Class="verb" Root="0" English="was looking for"/>

<word lookup="7164" Trans="amar" Hebrew="אָמַר" Class="verb" Root="0" English="said(m.,s.)"/>

<word lookup="7004" Trans="kadur" Hebrew="כָּדוּר" Class="noun" Root="0" English="ball"/>


Note: Root is when one vocabulary word is based on another. The results of the query should lookup the root and display the root word as well. The "lookup" element is a unique number assigneed to each word (and the root cross references to it).

The website need only support one dictionary file (should be a config parm that defines the .xml file to use as dicstionary). In other words, I will have a different site for Spanish, a different site for French, and a different site for Hebrew.

My search will not focus so much on verbs forms as much as the sample site above, but more on simple translations.

Languages that use non-Latin fonts (such as Hebrew, Chinese) will have a "transliteration". For example, "SHALOM" is the Hebrew transliteration for the letters SHIN-LAMED-MEM. This shows non-Hebrew speakers how to pronounce the Hebrew word, even if you cannot read the Hebrew letters. The transliteration should also be searchable and displayable on results. This is the element "trans" in the above XML file.

Taidot: PHP, XML

Näytä lisää: php mysql hebrew, mysql foreign language, mysql hebrew php, www online computer language, true results, side language, server side application, search for the application, php online learning, php new version, php mysql online help, php help online, online learning php, online dictionary english, letters example, learning how to program, learning english online, learning english language, learning c language online, languages online french

Tietoa työnantajasta:
( 59 arvostelua ) Rockwall, United States

Projektin tunnus: #120298

Myönnetty käyttäjälle:


I can do it.

$100 USD 7 päivässä
(13 Arvostelua)

6 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Please check the PM.

$150 USD 2 päivässä
(27 arvostelua)

Please check PMB. Thanks.

$300 USD 7 päivässä
(45 arvostelua)

Hi Yes it is perfectly doable using XML file only, no need to store things in database. Lets start

$250 USD 7 päivässä
(3 arvostelua)

icq 5266320 [login to view URL] at [login to view URL]

$120 USD 2 päivässä
(0 arvostelua)

I can do it using XSLT extention for PHP

$200 USD 5 päivässä
(0 arvostelua)