How to make database multilingual?

Question

Yii

I recently started using Yii2, and the task was to make the site multilingual. I've been struggling with this problem for the third day and I can not solve it. How to display content in the desired language from the database?

Answer 1

I just don't understand the principle. Here I created a database with fields id title_ru title_en text_ru text_en. So? And how do you switch between them?

Answer 2

https://github.com/LAV45/yii2-translated-behavior

Answer 3

Add a column with the language in the table, filter by the column when selecting.
Or store the record in one table, and the texts in another with a column in which the language is indicated. That is, there will be one entity, but several language versions.
If you are interested, CleverStyle CMS is out of the box and very easy to use.

Answer 4

i use json + beforeSave / afterFind internal functions
and for mapping https://github.com/codemix/yii2-localeurls

Answer 5

We have a dual system. wherever you want to insert text, a function is called that determines the current language, and searches for the text by the passed key. All short phrases are pulled from a separate file (one file for each language) where key/value pairs are stored. All long phrases (texts) are already taken from the database, where key \ value pairs + the lang parameter are also stored.