Laravel Multi language Site Database Structure
i am in mid of a multi language website and clients requirements are he can edit any message by him self without touching the script . i tried to make several database structures but failed to get to any logical point . he want to add more languages in future the idea behind the scene is that he can edit each word on website in multiple languages eg arabic french russian chines etc . this is my table structure but i didnt get it to work as where i will store the english version of messages ? any help will be highly appreciated 
you are doing it wrong way as i think . the words are counted means if there are 500 words laying in your website and you want to convert them in multiple language then you should have three tables for example like this a language table
tlb language
id ->
language ->
status ->
second you should have a table of translation like tbl translation
id ->
third you will have a table like words tbl words
id -> primary key
transID -> tbl translation (id) FK
languageID -> tbl language (id) FK
sentence ->
下一篇: Laravel多语言网站数据库结构