How To Create Dictionary In Yii

Yii 1.1 General Discussion
1

HI to all ,

i want to create a online English to Hindi dictionary so i choose yii to work on that yii has many cool features so i decided to use yii . i am not new to php5 or mysql like yii . but i am facing problem to designing database for that i want to keep this simple so can some one push me in right direction or can prefer any good article to achieve the task . Thanks in advance…

2

Hi,

In dictionary, what is to translate the word with example or equal word.

So, database might be as

Words:

id

word

status

Translations

id

word_id

meaning

description

Examples

id

word_id

content

I suggest that you need to check some online dictionary script regarding its database.

thanks

3

Thank you PeRoChAk for your suggestion i want to translate word equal to other word in other table like if i want to translate tree from hindi table wich also have a word tree so that i can show the hindi conversation of tree word .

4

I think, my proposed database fits for this.

1 - Word : Tree

2 - Translation :

             1 - Boota


             2 - Paar
5

thanks for your reply PeRoChAk

but i am unable to understand what is boota paar you mean meaning of tree boota,paar isn’t it .

6

yes…

I know Hindi a bit… so I used these words which means tree, plant in English

7

ahhh thats very funny i also know hindi so i asked about boota