PHPackages yunusbek/multilingual - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Localization & i18n](/categories/localization) 4. / 5. yunusbek/multilingual ActiveLibrary[Localization & i18n](/categories/localization) yunusbek/multilingual ===================== Multilingual package for Yii2 projects v1.0.247(2mo ago)0290MITPHP Since Mar 18Pushed 2mo ago1 watchersCompare [ Source](https://github.com/yunusbek9669/multilingual)[ Packagist](https://packagist.org/packages/yunusbek/multilingual)[ RSS](/packages/yunusbek-multilingual/feed)WikiDiscussions main Synced today READMEChangelogDependencies (6)Versions (169)Used By (0) Multilingual ============ [](#multilingual) A fully featured multilingual management package for Yii2 projects. > ✅ Dynamically translate database content > ✅ Support for multiple languages with individual tables (`lang_*`) > ✅ Form-level multilingual fields > ✅ Static translations (`i18n`) integration > ✅ Excel-based bulk `import/export` of translations > ✅ You don't have to type `$model->attribute_name_{locale}` to get the translation, just `$model->attribute_name` is enough. Installation ------------ [](#installation) Either run ``` composer require yunusbek/multilingual ``` or add ``` "yunusbek/multilingual": "^1.0", ``` to the `require` section of your composer.json. Usage ----- [](#usage) Once the library is installed, add the following to your project settings: ``` # Add the following code to controllerMap [ #... 'controllerMap' => [ 'ml-migration' => 'Yunusbek\Multilingual\commands\Migrations', 'ml-extract' => 'Yunusbek\Multilingual\commands\Messages', ], #... ] ``` The next thing you need to do is updating your database schema by applying the migration of table `language_list`: ``` php yii ml-migration ``` The next important processing steps in the project settings. ``` # for yii2 basic - config/web.php # for yii2 advanced - config/main.php [ #... 'bootstrap' => ['log', 'Yunusbek\Multilingual\components\MultilingualBootstrap'], #... 'modules' => [ 'multilingual' => [ 'class' => 'Yunusbek\Multilingual\Module', ], ] #... 'components' => [ #... 'i18n' => [ 'class' => 'Yunusbek\Multilingual\components\MultilingualI18N', 'translations' => [ 'app*' => [ 'class' => 'Yunusbek\Multilingual\components\DbMessageSource', // You should apply this class to other categories as well. ], ], ], #... ] #... ] ``` Inheritance from the `BaseLanguageList` class and additional settings for the class created for the `language_list` table: Create a class (model) for the `language_list` table that extends the `BaseLanguageList` class, and add additional rules to the `rules()` method: ``` use Yunusbek\Multilingual\models\BaseLanguageList class LanguageList extends BaseLanguageList { public static function tableName() { return 'language_list'; } public function rules() { return array_merge(parent::rules(), [ #...self rules of model ]); } } ``` Then, generate CRUD for the completed model and add a new language. Add this array to the `params.php` file ``` # params.php [ #... 'language_list' => [ 'en' => [ 'name' => 'Default language', # Enter the current default language in your project. 'short_name' => 'Def', # Enter the current default language short name. 'image' => '/path/to/default/language/flag.jpg', # Enter the path to the current default language flag image. 'active' => false, ], // The list of dynamically added languages is visible from the continuation of this array. ], #... ] ``` > All added dynamic languages are stored as an array in the `Yii::$app->params['language_list']` variable. You can extract languages from this variable to use them in the navbar, and you get the current language from the `Yii::$app->params['active_language']` variable. > > To make the added languages available in the system, place the following widget in the header section of your web project. ``` echo \Yunusbek\Multilingual\widgets\MultilingualLanguageList::widget() //['options' => ['class' => '...']] if you want ``` > Here, `O‘zbekcha` is the default language; the following two are newly added languages for translation. > > [![All added dynamic languages.](https://github.com/yunusbek9669/multilingual/raw/main/dist/img/language_list.jpg)](https://github.com/yunusbek9669/multilingual/blob/main/dist/img/language_list.jpg) Translation guides: ------------------- [](#translation-guides) > ✅ The `MultilingualTrait` must be used in models that support multilingual (translatable) content. ``` use Yunusbek\Multilingual\components\traits\MultilingualTrait; class YourModel extends yii\db\ActiveRecord { use MultilingualTrait; #...model settings. } ``` --- > ✅ For query commands using `(new Query())->from('table_name')`: > > To use multilingual support, simply replace `new \yii\db\Query()` with `new \Yunusbek\Multilingual\models\MlQuery()` ``` (new MlQuery())->from('table_name')//-> then your conditions... ``` --- > ✅ If you are writing raw SQL conditions (e.g., where, select, join, etc.) instead of using Yii2's ORM syntax, you need to include the following code to ensure that the multilingual feature works properly. ``` SELECT -- Replace `your_table_name.attribute_name` with a multilingual fallback expression COALESCE(NULLIF(your_real_table_name_lang_en.value->>'attribute_name', ''), your_table_name.attribute_name) AS attribute_name FROM your_real_table_name AS your_table_name -- Add JOIN with the multilingual table to fetch translations LEFT JOIN lang_en AS your_real_table_name_lang_en ON your_real_table_name_lang_en.table_name = 'your_real_table_name' AND your_real_table_name_lang_en.table_iteration = your_table_name.id AND your_real_table_name_lang_en.is_static = false WHERE -- Add your filtering conditions here ``` --- ### Form fields: [](#form-fields) Add MlFields widget to your form — it will auto-generate inputs for newly added languages. ``` #... #... ``` ``` #... #... ``` All added languages will automatically be displayed on the form page. From here you can type in the translation of all your newly added languages. - ⭐ Default language; - and subsequent form inputs are automatically created for newly added languages; [![All added languages will be displayed on the form page.](https://github.com/yunusbek9669/multilingual/raw/main/dist/img/form.jpg)](https://github.com/yunusbek9669/multilingual/blob/main/dist/img/form.jpg) Run the following commands to extract the attributes of the models and the static information of the project to the `lang_*` table.: ### Console commands [](#console-commands) The package includes the following console commands: ``` php yii ml-extract/i18n ``` - `ml-extract/i18n` – Extracts static messages used in the app to the database. ``` php yii ml-extract/attributes ``` - `ml-extract/attributes` - It collects all the tables and columns called in the MlFields widget into a `multilingual.json` file. ``` { "where": { "status": 1 }, "tables": { "manuals_application_type": ["name"], "manuals_collateral_type": ["name"], "manuals_department_relevant_type": ["name", "short_name"], ... } } ``` `where` applies to all tables. You can extend this system to support per-table filters in future releases. ### Filling data by backend [](#filling-data-by-backend) When filling data through the backend, you can use either the {locale} notation (e.g. `name{en}`) or the `->setMlAttributes()` method for dynamic languages. By appending suffixes like `_ru`, `_en` to the base attribute, the system determines which language the value should be stored in. ``` $model->setAttributes([ 'name' => 'olma', 'name{ru}' => 'яблоко', 'name{en}' => 'apple' ]); // or with setMlAttributes $model->setAttributes([ 'name' => 'olma', ]) ->setMlAttributes([ 'name_ru' => 'яблоко', 'name_en' => 'apple' ]); ``` Necessary additions =================== [](#necessary-additions) > Not only can you translate new languages one by one on the form page, but you can also do it by translating a single Excel file in bulk. Useful buttons to install ------------------------- [](#useful-buttons-to-install) Add the following button to the top of the created CRUD "Language List" index page which will take you to the general translations view pages. ``` echo Html::a(Yii::t('multilingual', 'All columns'), ['/multilingual/language/index', 'is_static' => 0], ['target' => '_blank']); // it will take you to all dynamic translations echo Html::a(Yii::t('multilingual', 'All i18n'), ['/multilingual/language/index', 'is_static' => 1], ['target' => '_blank']); // it will take you to all static translations ``` > All columns [![This is view page for translate all dynamic data](https://github.com/yunusbek9669/multilingual/raw/main/dist/img/common-db.jpg)](https://github.com/yunusbek9669/multilingual/blob/main/dist/img/common-db.jpg) > > All i18n [![This is view page for translate all static data](https://github.com/yunusbek9669/multilingual/raw/main/dist/img/common-i18n.jpg)](https://github.com/yunusbek9669/multilingual/blob/main/dist/img/common-i18n.jpg) Instruction manual ------------------ [](#instruction-manual) ### Excel-based Translation Import [](#excel-based-translation-import) You can bulk-import translations for a new language via an Excel file. Steps: 1. Download an existing translation as Excel. 2. Translate its contents for the new language. 3. Upload the translated Excel file. 4. Set the path of this Excel file to the `import_excel` attribute of the `language_list` table. ✅ The package will automatically parse the file and save the translations to the appropriate `lang_*` table. > The image below shows the Excel format used for translating dynamic data. The original language values appear in the fields marked with a red border (column header: `value`). Only these values need to be translated. > > [![This is an Excel for translate dynamic data](https://github.com/yunusbek9669/multilingual/raw/main/dist/img/dinamic.jpg)](https://github.com/yunusbek9669/multilingual/blob/main/dist/img/dinamic.jpg) > The image below shows the Excel format used to translate static interface texts. Translate the cells marked with a red border into the desired language. > > [![This is an Excel for translate static data](https://github.com/yunusbek9669/multilingual/raw/main/dist/img/static.jpg)](https://github.com/yunusbek9669/multilingual/blob/main/dist/img/static.jpg) > 💡 As a shortcut, you can also translate the file using Google Translate's document feature. > > When adding a new language, you can save the path of the translated Excel file above to the `import_excel` attribute in the `language_list` table. > > Result: all translations for the newly added language will be saved, automatically saved from the Excel file to the new `lang_*` table. > Allows standard select statements to automatically return translated column values based on the current application locale, without requiring explicit locale suffixes in the query. ``` //Let’s assume the current system language is (en). YourModel::find() ->select([ 'name', // Returns values based on the currently selected system language. For example: 'apple' 'description' // Returns values based on the currently selected system language. For example: 'red and delicious apple' ]) ->all(); ``` Result: ------- [](#result) - When the system is set to the default language: [![before](https://github.com/yunusbek9669/multilingual/raw/main/dist/img/result1.jpg)](https://github.com/yunusbek9669/multilingual/blob/main/dist/img/result1.jpg) - When the system is set to a newly added language: [![after](https://github.com/yunusbek9669/multilingual/raw/main/dist/img/result2.jpg)](https://github.com/yunusbek9669/multilingual/blob/main/dist/img/result2.jpg) > 💡 Adds an additional capability to automatically resolve locale-suffixed database columns (e.g. `{ru}`, `{en}`) and select their translated counterparts. ``` YourModel::find() ->select([ //with associative array select syntax 'name_uz' => 'name{uz}', // 'olma' 'name_ru' => 'name{ru}', // 'яблоко' 'name_en' => 'name{en}', // 'apple' //or raw SQL alias syntax 'description{uz} as description_uz', // 'qizil va mazali olma' 'description{ru} as description_ru', // 'красное и вкусное яблоко' 'description{en} as description_en' // 'red and delicious apple' ]) ->all(); ``` ### Health Score 43 — FairBetter than 89% of packages Maintenance83 Actively maintained with recent releases Popularity13 Limited adoption so far Community7 Small or concentrated contributor base Maturity57 Maturing project, gaining track record Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~2 days Total 168 Last Release 88d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/70483ac992f0451b37284d0b2f31c76ebe7bf032fb522f42b10b40b8a240f21b?d=identicon)[yunusbek9669](/maintainers/yunusbek9669) --- Top Contributors [![yunusbek9669](https://avatars.githubusercontent.com/u/73517817?v=4)](https://github.com/yunusbek9669 "yunusbek9669 (6 commits)") ### Embed Badge ![Health badge](/badges/yunusbek-multilingual/health.svg) ``` [![Health](https://phpackages.com/badges/yunusbek-multilingual/health.svg)](https://phpackages.com/packages/yunusbek-multilingual) ``` ### Alternatives [craftcms/cms Craft CMS 3.6k3.6M3.1k](/packages/craftcms-cms)[kimai/kimai Kimai - Time Tracking 4.8k9.0k1](/packages/kimai-kimai)[civicrm/civicrm-core Open source constituent relationship management for non-profits, NGOs and advocacy organizations. 751291.4k43](/packages/civicrm-civicrm-core)[yajra/laravel-datatables-export Laravel DataTables Queued Export Plugin. 362.2M4](/packages/yajra-laravel-datatables-export)[solspace/craft-freeform The most flexible and user-friendly form building plugin! 54681.3k18](/packages/solspace-craft-freeform)[2lenet/crudit-bundle The easy like Crud'it Bundle. 1616.4k14](/packages/2lenet-crudit-bundle) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)